com.jn.nacos.plugin.datasource.mapper.CommonConfigInfoBetaMapper Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of nacosplugin-datasource Show documentation

The newest version!

package com.jn.nacos.plugin.datasource.mapper;

import com.alibaba.nacos.plugin.datasource.mapper.ConfigInfoBetaMapper;
import com.alibaba.nacos.plugin.datasource.model.MapperContext;
import com.alibaba.nacos.plugin.datasource.model.MapperResult;
import com.jn.langx.util.collection.Lists;
import com.jn.nacos.plugin.datasource.NacosEnvs;
import com.jn.sqlhelper.dialect.pagination.RowSelection;

import java.util.List;

public class CommonConfigInfoBetaMapper extends BaseMapper implements ConfigInfoBetaMapper {

    /**
     * 当前nacos版本，不能使用 ? 用作 limit, offset 参数
     */
    @Override
    public MapperResult findAllConfigInfoBetaForDumpAllFetchRows(MapperContext context) {
        int startRow = context.getStartRow();
        int pageSize = context.getPageSize();

        RowSelection rowSelection = new RowSelection(startRow, pageSize);
        String subquery = "SELECT id FROM config_info_beta ORDER BY id ";
        subquery = getDialect().getLimitSql(subquery, true, false, rowSelection);
        String sql = "SELECT t.id,data_id,group_id,tenant_id,app_name,content,md5,gmt_modified,beta_ips " + (NacosEnvs.hasEncryptedDataKeyColumn() ? ", encrypted_data_key ":"")
                + " FROM ( " + subquery + " )" + " g, config_info_beta t WHERE g.id = t.id";

        List