程序包 com.alibaba.nacos.plugin.datasource.mapper

接口 HistoryConfigInfoMapper

所有超级接口:
Mapper
所有已知实现类:
HistoryConfigInfoMapperByDerby, HistoryConfigInfoMapperByMySql
public interface HistoryConfigInfoMapper extends Mapper
The history config info mapper.
作者:
hyx

  • 方法详细资料

    • removeConfigHistory

      MapperResult removeConfigHistory(MapperContext context)
      Delete data before startTime. The default sql: DELETE FROM his_config_info WHERE gmt_modified < ? LIMIT ?
      参数:
      context - sql paramMap
      返回:
      The sql of deleting data before startTime.

    • findConfigHistoryCountByTime

      default MapperResult findConfigHistoryCountByTime(MapperContext context)
      Get the number of configurations before the specified time. The default sql: SELECT count(*) FROM his_config_info WHERE gmt_modified < ?
      参数:
      context - sql paramMap
      返回:
      The sql of getting the number of configurations before the specified time.

    • findDeletedConfig

      default MapperResult findDeletedConfig(MapperContext context)
      Query deleted config. The default sql: SELECT DISTINCT data_id, group_id, tenant_id FROM his_config_info WHERE op_type = 'D' AND gmt_modified >=? AND gmt_modified <= ?
      参数:
      context - sql paramMap
      返回:
      The sql of querying deleted config.

    • findConfigHistoryFetchRows

      default MapperResult findConfigHistoryFetchRows(MapperContext context)
      List configuration history change record. The default sql: SELECT nid,data_id,group_id,tenant_id,app_name,src_ip,src_user,op_type,gmt_create,gmt_modified FROM his_config_info WHERE data_id = ? AND group_id = ? AND tenant_id = ? ORDER BY nid DESC
      参数:
      context - sql paramMap
      返回:
      The sql of listing configuration history change record.

    • pageFindConfigHistoryFetchRows

      MapperResult pageFindConfigHistoryFetchRows(MapperContext context)
      page search List configuration history. SELECT nid,data_id,group_id,tenant_id,app_name,src_ip,src_user,op_type,gmt_create,gmt_modified FROM his_config_info WHERE data_id = ? AND group_id = ? AND tenant_id = ? ORDER BY nid DESC limit ?,?
      参数:
      context - pageNo
      返回:

    • detailPreviousConfigHistory

      default MapperResult detailPreviousConfigHistory(MapperContext context)
      Get previous config detail. The default sql: SELECT nid,data_id,group_id,tenant_id,app_name,content,md5,src_user,src_ip,op_type,gmt_create,gmt_modified FROM his_config_info WHERE nid = (SELECT max(nid) FROM his_config_info WHERE id = ?)
      参数:
      context - sql paramMap
      返回:
      The sql of getting previous config detail.

    • getTableName

      default String getTableName()
      获取返回表名.
      指定者:
      getTableName 在接口中 Mapper
      返回:
      表名

    • getNextHistoryInfo

      default MapperResult getNextHistoryInfo(MapperContext context)
      Get updated history config detail of the history config. The default sql: SELECT nid,data_id,group_id,tenant_id,app_name,content,md5,src_user,src_ip,op_type,gmt_create,gmt_modified FROM his_config_info WHERE data_id = ? AND group_id = ? AND tenant_id = ? AND publish_type = ? AND gray_name = ? AND nid > ? ORDER BY nid LIMIT 1
      参数:
      context - sql paramMap
      返回:
      The sql of getting the next history config detail of the history config.