package com.dacrt.SBIABackend.security.repository;

import java.util.List;
import java.util.Optional;

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

import com.dacrt.SBIABackend.security.entity.Params;
import com.dacrt.SBIABackend.security.entity.Roles;

import com.dacrt.SBIABackend.security.entity.Users;



@Repository
public interface RolesRepository extends JpaRepository<Roles,Integer>{
	Optional<Roles> findByName(String name);
	boolean existsByName(String name);
	boolean existsById(int id);
	Optional<Roles> findById(int id);
  //  Roles findByName(String name);
	
	@Query("SELECT r.name FROM Roles r")
    List<String> findAllRoleNames();
	
	@Query("SELECT r FROM Roles r WHERE r.name =?1 ")
	Roles findByNameString(String name);
	
	
}