package com.infinite.focus.server.students;

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.springframework.stereotype.Repository;

import com.infinite.focus.server.auth.Student;

@Repository
public interface StudentPagingAndSortingRepository extends PagingAndSortingRepository<Student, Long>{

	@Query(value = "SELECT * FROM student", nativeQuery = true)
	Page<Student> findAllStudents(Pageable pageable);
	
	@Query(value = "SELECT * FROM student WHERE first_name LIKE ?1 or last_name LIKE ?1", nativeQuery = true)
	Page<Student> findByStudentByName(String name, Pageable pageable);
}