PermissionRepository.kt

package io.github.lishangbu.avalon.auth.repository

import io.github.lishangbu.avalon.auth.entity.*
import io.github.lishangbu.avalon.auth.entity.dto.PermissionView
import org.babyfish.jimmer.Specification
import org.babyfish.jimmer.spring.repository.KRepository
import org.babyfish.jimmer.spring.repository.orderBy
import org.babyfish.jimmer.sql.kt.ast.expression.eq
import org.springframework.data.domain.Sort

/** 权限点仓储接口。 */
interface PermissionRepository : KRepository<Permission, Long> {
    /** 按条件查询权限点视图列表。 */
    fun listViews(specification: Specification<Permission>?): List<PermissionView> =
        sql
            .createQuery(Permission::class) {
                specification?.let(::where)
                orderBy(DEFAULT_SORT)
                select(table.fetch(PermissionView::class))
            }.execute()

    /** 根据 ID 查询权限点视图。 */
    fun loadViewById(id: Long): PermissionView? =
        sql
            .createQuery(Permission::class) {
                where(table.id eq id)
                orderBy(DEFAULT_SORT)
                select(table.fetch(PermissionView::class))
            }.execute()
            .firstOrNull()

    companion object {
        private val DEFAULT_SORT: Sort =
            Sort.by(Sort.Order.asc("sortingOrder"), Sort.Order.asc("id"))
    }
}