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

接口 ConfigInfoMapper

所有超级接口:
Mapper
所有已知实现类:
ConfigInfoMapperByDerby, ConfigInfoMapperByMySql
public interface ConfigInfoMapper extends Mapper
The mapper of config info.
作者:
hyx

  • 方法详细资料

    • findConfigMaxId

      default MapperResult findConfigMaxId(MapperContext context)
      Get the maxId. The default sql: SELECT max(id) FROM config_info
      参数:
      context - sql paramMap
      返回:
      the sql of getting the maxId.

    • findAllDataIdAndGroup

      default MapperResult findAllDataIdAndGroup(MapperContext context)
      Find all dataId and group. The default sql: SELECT DISTINCT data_id, group_id FROM config_info
      参数:
      context - sql paramMap
      返回:
      The sql of finding all dataId and group.

    • findConfigInfoByAppCountRows

      default MapperResult findConfigInfoByAppCountRows(MapperContext context)
      Query the count of config_info by tenantId and appName. The default sql: SELECT count(*) FROM config_info WHERE tenant_id LIKE ? AND app_name=?
      参数:
      context - sql paramMap
      返回:
      The sql of querying the count of config_info.

    • findConfigInfoByAppFetchRows

      MapperResult findConfigInfoByAppFetchRows(MapperContext context)
      Query configuration information based on group.
      The default sql: SELECT id,data_id,group_id,tenant_id,app_name,content FROM config_info WHERE tenant_id LIKE ? AND app_name=? LIMIT startRow, pageSize
      参数:
      context - The context of startRow, pageSize
      返回:
      The sql of querying configration information based on group.

    • configInfoLikeTenantCount

      default MapperResult configInfoLikeTenantCount(MapperContext context)
      Returns the number of configuration items. The default sql: SELECT count(*) FROM config_info WHERE tenant_id LIKE ?
      参数:
      context - sql paramMap
      返回:
      The sql of querying the number of configuration items.

    • getTenantIdList

      MapperResult getTenantIdList(MapperContext context)
      Get tenant id list by page. The default sql: SELECT tenant_id FROM config_info WHERE tenant_id != '' GROUP BY tenant_id LIMIT startRow, pageSize
      参数:
      context - The context of startRow, pageSize
      返回:
      The sql of getting tenant id list by page.

    • getGroupIdList

      MapperResult getGroupIdList(MapperContext context)
      Get group id list by page. The default sql: SELECT group_id FROM config_info WHERE tenant_id ='{defaultNamespaceId}' GROUP BY group_id LIMIT startRow, pageSize
      参数:
      context - The context of startRow, pageSize
      返回:
      The sql of getting group id list by page.

    • findAllConfigKey

      MapperResult findAllConfigKey(MapperContext context)
      Query all configuration information by page. The default sql: SELECT data_id,group_id,app_name FROM ( SELECT id FROM config_info WHERE tenant_id LIKE ? ORDER BY id LIMIT startRow, pageSize ) g, config_info t WHERE g.id = t.id
      参数:
      context - The context of startRow, pageSize
      返回:
      The sql of querying all configuration information.

    • findAllConfigInfoBaseFetchRows

      MapperResult findAllConfigInfoBaseFetchRows(MapperContext context)
      Query all configuration information by page. The default sql: SELECT t.id,data_id,group_id,content,md5 FROM ( SELECT id FROM config_info ORDER BY id LIMIT ?,?) g, config_info t WHERE g.id = t.id
      参数:
      context - The context of startRow, pageSize
      返回:
      The sql of querying all configuration information by page.

    • findAllConfigInfoFragment

      MapperResult findAllConfigInfoFragment(MapperContext context)
      Query all config info. The default sql: "SELECT id,data_id,group_id,tenant_id,app_name,"+ (needContent ? "content," : "") + "md5,gmt_modified,type,encrypted_data_key FROM config_info WHERE id > ? ORDER BY id ASC LIMIT startRow,pageSize"
      参数:
      context - The context of startRow, pageSize
      返回:
      The sql of querying all config info.

    • findChangeConfig

      default MapperResult findChangeConfig(MapperContext context)
      Query change config.
      The default sql: SELECT id, data_id, group_id, tenant_id, app_name, md5, gmt_modified,encrypted_data_key FROM config_info WHERE gmt_modified >=? AND id > ? ORDER BY id LIMIT pageSize
      参数:
      context - sql paramMap
      返回:
      The sql of querying change config.

    • findChangeConfigCountRows

      default MapperResult findChangeConfigCountRows(MapperContext context)
      Get the count of config information. The default sql: SELECT count(*) FROM config_info WHERE ...
      参数:
      context - The map of params, the key is the parameter name(dataId, groupId, tenantId, appName, startTime, endTime, content), the value is the key's value.
      返回:
      The sql of getting the count of config information.

    • findChangeConfigFetchRows

      MapperResult findChangeConfigFetchRows(MapperContext context)
      According to the time period and configuration conditions to query the eligible configuration. The default sql: SELECT id,data_id,group_id,tenant_id,app_name,type,md5,gmt_modified FROM config_info WHERE ...
      参数:
      context - The map of params, the key is the parameter name(dataId, groupId, tenantId, appName, startTime, endTime, content, startTime, endTime), the value is the key's value.
      返回:
      The sql of getting config information according to the time period.

    • listGroupKeyMd5ByPageFetchRows

      MapperResult listGroupKeyMd5ByPageFetchRows(MapperContext context)
      list group key md5 by page. The default sql: SELECT t.id,data_id,group_id,tenant_id,app_name,md5,type,gmt_modified,encrypted_data_key FROM ( SELECT id FROM config_info ORDER BY id LIMIT ?,? ) g, config_info t WHERE g.id = t.id
      参数:
      context - The context of startRow, pageSize
      返回:
      The sql of listing group key md5 by page.

    • findAllConfigInfo4Export

      default MapperResult findAllConfigInfo4Export(MapperContext context)
      query all configuration information according to group, appName, tenant (for export). The default sql: SELECT id,data_id,group_id,tenant_id,app_name,content,type,md5,gmt_create,gmt_modified, src_user,src_ip,c_desc,c_use,effect,c_schema,encrypted_data_key FROM config_info WHERE ...
      参数:
      context - The map of params, the key is the parameter name(dataId, group, appName), the value is the key's value.
      返回:
      Collection of ConfigInfo objects

    • findConfigInfoBaseLikeCountRows

      default MapperResult findConfigInfoBaseLikeCountRows(MapperContext context)
      Get the count of config information. The default sql: SELECT count(*) FROM config_info WHERE ...
      参数:
      context - The map of params, the key is the parameter name(dataId, groupId, tenant_id, content), the value is the arbitrary object.
      返回:
      The sql of getting the count of config information.

    • findConfigInfoBaseLikeFetchRows

      MapperResult findConfigInfoBaseLikeFetchRows(MapperContext context)
      Get the config information. The default sql: SELECT id,data_id,group_id,tenant_id,content FROM config_info WHERE ...
      参数:
      context - The map of params, the key is the parameter name(dataId, groupId, tenant_id, content), the value is the key's value.
      返回:
      The sql of getting the config information.

    • findConfigInfo4PageCountRows

      default MapperResult findConfigInfo4PageCountRows(MapperContext context)
      find the count of config info. The default sql: SELECT count(*) FROM config_info ...
      参数:
      context - The mpa of dataId, groupId and appName.
      返回:
      The count of config info.

    • findConfigInfo4PageFetchRows

      MapperResult findConfigInfo4PageFetchRows(MapperContext context)
      find config info. The default sql: SELECT id,data_id,group_id,tenant_id,app_name,content,type,encrypted_data_key FROM config_info ...
      参数:
      context - The mpa of dataId, groupId and appName.
      返回:
      The sql of finding config info.

    • findConfigInfoBaseByGroupFetchRows

      MapperResult findConfigInfoBaseByGroupFetchRows(MapperContext context)
      Query configuration information based on group. The default sql: SELECT id,data_id,group_id,content FROM config_info WHERE group_id=? AND tenant_id=? LIMIT startRow, pageSize
      参数:
      context - The context of startRow, pageSize
      返回:
      Query configuration information based on group.

    • findConfigInfoLike4PageCountRows

      default MapperResult findConfigInfoLike4PageCountRows(MapperContext context)
      Query config info count. The default sql: SELECT count(*) FROM config_info ...
      参数:
      context - The map of dataId, group, appName, content
      返回:
      The sql of querying config info count

    • findConfigInfoLike4PageFetchRows

      MapperResult findConfigInfoLike4PageFetchRows(MapperContext context)
      Query config info.
      The default sql:
      SELECT id,data_id,group_id,tenant_id,app_name,content,encrypted_data_key FROM config_info ...
      参数:
      context - The context of startRow, pageSize
      返回:
      The sql of querying config info

    • findAllConfigInfoFetchRows

      MapperResult findAllConfigInfoFetchRows(MapperContext context)
      Query all configuration information by page.
      The default sql:
      SELECT t.id,data_id,group_id,tenant_id,app_name,content,md5 " + " FROM ( SELECT id FROM config_info WHERE tenant_id LIKE ? ORDER BY id LIMIT ?,? )" + " g, config_info t WHERE g.id = t.id
      参数:
      context - The context of startRow, pageSize
      返回:
      Query all configuration information by page.

    • findConfigInfosByIds

      default MapperResult findConfigInfosByIds(MapperContext context)
      find ConfigInfo by ids.
      The default sql:
      SELECT ID,data_id,group_id,tenant_id,app_name,content,md5 FROM config_info WHERE id IN (...)
      参数:
      context - the size of ids.
      返回:
      find ConfigInfo by ids.

    • removeConfigInfoByIdsAtomic

      default MapperResult removeConfigInfoByIdsAtomic(MapperContext context)
      Remove configuration; database atomic operation, minimum SQL action, no business encapsulation.
      参数:
      context - The size of ids.
      返回:
      The sql of removing configuration.

    • updateConfigInfoAtomicCas

      default MapperResult updateConfigInfoAtomicCas(MapperContext context)
      Update configuration; database atomic operation, minimum SQL action, no business encapsulation. The default sql: UPDATE config_info SET content=?, md5 = ?, src_ip=?,src_user=?,gmt_modified=?, app_name=?,c_desc=?,c_use=?, effect=?,type=?,c_schema=? WHERE data_id=? AND group_id=? AND tenant_id=? AND (md5=? OR md5 IS NULL OR md5='')
      参数:
      context - sql paramMap
      返回:
      The sql of updating configuration cas.

    • getTableName

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