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);
|
}
|
