hx-base/my-test/src/main/java/org/example/join/util/SqlUtil.java

package org.example.join.util;

import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.metadata.TableFieldInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfo;
import com.baomidou.mybatisplus.core.metadata.TableInfoHelper;
import com.baomidou.mybatisplus.core.toolkit.StringPool;
import org.example.join.domain.Table;

import java.util.Map;

public class SqlUtil {

    public static String getTableAlias(Table table, Map<String, String> tableAliasMap) {
        String tableAlias = table.getAlias();
        String tableName = table.getName();

        if (StrUtil.isBlank(tableAlias)) {
            tableAlias = tableAliasMap.get(tableName);
            if (StrUtil.isBlank(tableAlias)) {
                throw new IllegalArgumentException("未知连表：" + tableName);
            }
        }
        return tableAlias;
    }

    public static String getTableDelFlag(Table table) {
        TableInfo tableInfo = TableInfoHelper.getTableInfo(table.getName());
        if (!tableInfo.isWithLogicDelete()) {
            return null;
        }

        TableFieldInfo logicDeleteFieldInfo = tableInfo.getLogicDeleteFieldInfo();
        return logicDeleteFieldInfo.getColumn();
    }

    public static String withBracket(String sql) {
        return StringPool.LEFT_BRACKET + sql + StringPool.RIGHT_BRACKET;
    }

}