package jnpf.dmsMapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import jnpf.dmsEntity.permission.entity.DmsPermissionRevisionEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface DmsPermissionRevisionMapper extends BaseMapper<DmsPermissionRevisionEntity> {

    @Select("SELECT tenant_id, revision, updated_at FROM public.dms_permission_revisions "
            + "WHERE tenant_id = #{tenantId}")
    DmsPermissionRevisionEntity selectByTenant(@Param("tenantId") String tenantId);

    @Select("SELECT COALESCE((SELECT revision FROM public.dms_permission_revisions "
            + "WHERE tenant_id = #{tenantId}), 0)")
    long currentRevision(@Param("tenantId") String tenantId);
}