package com.infinite.focus.server.contents;

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;

@Repository
public interface ContentPagingAndSortingRepository extends PagingAndSortingRepository<Content, Long>{

	@Query(value = "SELECT * FROM content", nativeQuery = true)
	Page<Content> findAllContents(Pageable pageable);
	
	@Query(value = "SELECT * FROM content WHERE content_name LIKE ?1", nativeQuery = true)
	Page<Content> findByContentName(String name, Pageable pageable);
}