package com.dacrt.SBIABackend.repository;
import java.util.List;
import java.util.Optional;

import javax.transaction.Transactional;


import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.stereotype.Repository;

import com.dacrt.SBIABackend.entity.Userunits;
import com.dacrt.SBIABackend.entity.Workers;
import com.dacrt.SBIABackend.security.entity.Roles;
import com.dacrt.SBIABackend.security.entity.Users;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;


@Repository
public interface UserunitsRepository extends JpaRepository<Userunits,Integer>,JpaSpecificationExecutor<Userunits>{
	
	@Query("SELECT count(c) FROM Userunits c")
	long countRegWorkers();
	
	Optional<Userunits> findById(int id);
	
	List<Userunits> findByUserid(int userid);
	
	//Userunits findByUserid(int userid);
	

//	@Modifying/
//	@Query(value="DELETE FROM Userunits a WHERE a.userid = ?1 " , nativeQuery=true)
///	void borrarUsersUnits(int id_users);

	
	@Transactional
	@Modifying
	@Query(" DELETE FROM Userunits e where e.userid = ?1 ")
	void borrarUsersUnits(int id_canal);
			
	
	/*@Transactional
	@Modifying
	@Query(" Select count(coalesce(id,0)) FROM main.Userunits e where e.userid = ?1 and e.unitid = ?2 " )
	void borrarUsersUnits(int id_canal,int idunidad);*/

}