0.0.1-SNAPSHOT

portfolio/org.project.portfolio.article.domain/ArticleRepository

ArticleRepository

@Repository

interface ArticleRepository : JpaRepository<Article, Long>

Functions

abstract fun count(): Long

abstract fun <S : Article> count(example: Example<S>): Long

abstract fun delete(entity: Article)

abstract fun deleteAll()

abstract fun deleteAll(entities: MutableIterable<Article>)

abstract fun deleteAllById(ids: MutableIterable<Long>)

deleteAllByIdInBatch

abstract fun deleteAllByIdInBatch(ids: MutableIterable<Long>)

deleteAllInBatch

abstract fun deleteAllInBatch()

abstract fun deleteAllInBatch(entities: MutableIterable<Article>)

abstract fun deleteById(id: Long)

open fun ~~deleteInBatch~~(entities: MutableIterable<Article>)

abstract fun <S : Article> exists(example: Example<S>): Boolean

abstract fun existsById(id: Long): Boolean

abstract override fun <S : Article> findAll(example: Example<S>): MutableList<S>

abstract override fun <S : Article> findAll(example: Example<S>, sort: Sort): MutableList<S>

abstract override fun findAll(): MutableList<Article>

abstract override fun findAll(sort: Sort): MutableList<Article>

abstract fun findAll(pageable: Pageable): Page<Article>

abstract fun <S : Article> findAll(example: Example<S>, pageable: Pageable): Page<S>

abstract override fun findAllById(ids: MutableIterable<Long>): MutableList<Article>

abstract fun <S : Article, R : Any> findBy(example: Example<S>, queryFunction: Function<FluentQuery.FetchableFluentQuery<S>, R>): R

findByArticleTitleAndContent

@Query(value = " SELECT a FROM Article a WHERE (:title IS NULL OR a.title LIKE CONCAT('%', :title, '%')) OR (:content IS NULL OR a.content LIKE CONCAT('%', :content, '%')) ")

abstract fun findByArticleTitleAndContent(@Param(value = "title") title: String? = null, @Param(value = "content") content: String? = null, pageable: Pageable): Page<Article>

게시글 제목으로 조회하는 메소드

abstract fun findByAuthorId(authorId: Long, pageable: Pageable): Page<Article>

작성자 ID로 게시글 조회 메소드

findByCreatedAtBetween

abstract fun findByCreatedAtBetween(createdAtStart: Instant, createdAtEnd: Instant): List<Article>

게시글 생성일자 범위로 조회하는 메소드

abstract fun findById(id: Long): Optional<Article>

abstract fun <S : Article> findOne(example: Example<S>): Optional<S>

abstract fun flush()

abstract fun ~~getById~~(id: Long): Article

abstract fun ~~getOne~~(id: Long): Article

getReferenceById

abstract fun getReferenceById(id: Long): Article

increaseViewCount

@Modifying

@Query(value = " update Article a set a.viewCount = a.viewCount + 1 where a.id = :id")

abstract fun increaseViewCount(id: Long): Int

조회수 증가 메소드

abstract fun <S : Article> save(entity: S): S

abstract override fun <S : Article> saveAll(entities: MutableIterable<S>): MutableList<S>

saveAllAndFlush

abstract fun <S : Article> saveAllAndFlush(entities: MutableIterable<S>): MutableList<S>

abstract fun <S : Article> saveAndFlush(entity: S): S