Java SQLUtils.normalize方法代码示例

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public boolean isReferenced(String tableName) {
    if (tableName == null) {
        return false;
    }

    tableName = SQLUtils.normalize(tableName);

    for (SQLTableElement element : this.tableElementList) {
        if (element instanceof SQLForeignKeyConstraint) {
            SQLForeignKeyConstraint fk = (SQLForeignKeyConstraint) element;
            String refTableName = fk.getReferencedTableName().getSimpleName();

            if (SQLUtils.nameEquals(tableName, refTableName)) {
                return true;
            }
        }
    }

    return false;
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public String computeName() {
    if (tableSource == null) {
        return null;
    }

    SQLExpr expr = tableSource.getExpr();
    if (expr instanceof SQLName) {
        String name = ((SQLName) expr).getSimpleName();
        return SQLUtils.normalize(name);
    }

    return null;
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public String computeAlias() {
    String alias = this.getAlias();
    if (alias == null) {
        if (expr instanceof SQLIdentifierExpr) {
            alias = ((SQLIdentifierExpr) expr).getName();
        } else if (expr instanceof SQLPropertyExpr) {
            alias = ((SQLPropertyExpr) expr).getName();
        }
    }

    return SQLUtils.normalize(alias);
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public String computeAlias() {
    String alias = null;

    if (name instanceof SQLIdentifierExpr) {
        alias = ((SQLIdentifierExpr) name).getName();
    } else if (name instanceof SQLPropertyExpr) {
        alias = ((SQLPropertyExpr) name).getName();
    }

    return SQLUtils.normalize(alias);
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public void simplify() {
    enable = null;
    validate = null;
    rely = null;


    if (this.name instanceof SQLIdentifierExpr) {
        SQLIdentifierExpr identExpr = (SQLIdentifierExpr) this.name;
        String columnName = identExpr.getName();
        String normalized = SQLUtils.normalize(columnName, dbType);
        if (normalized != columnName) {
            this.setName(normalized);
        }
    }
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public void simplify() {
    if (this.name instanceof SQLIdentifierExpr) {
        SQLIdentifierExpr identExpr = (SQLIdentifierExpr) this.name;
        String columnName = identExpr.getName();

        String normalized = SQLUtils.normalize(columnName, dbType);
        if (columnName != normalized) {
            this.setName(normalized);
        }
    }
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public String computeAlias() {
    String alias = this.getAlias();

    if (alias == null) {
        if (expr instanceof SQLName) {
            alias =((SQLName) expr).getSimpleName();
        }
    }

    return SQLUtils.normalize(alias);
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public void simplify() {
    super.simplify();

    for (SQLSelectOrderByItem item : columns) {
        SQLExpr column = item.getExpr();
        if (column instanceof SQLIdentifierExpr) {
            SQLIdentifierExpr identExpr = (SQLIdentifierExpr) column;
            String columnName = identExpr.getName();
            String normalized = SQLUtils.normalize(columnName, dbType);
            if (normalized != columnName) {
                item.setExpr(new SQLIdentifierExpr(columnName));
            }
        }
    }
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public SQLIdentifierExpr simplify() {
    String normalized = SQLUtils.normalize(name);
    if (normalized != name) {
       return new SQLIdentifierExpr(normalized, hashCode64);
    }
    return this;
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public String normalizedName() {

        String ownerName;
        if (owner instanceof SQLIdentifierExpr) {
            ownerName = ((SQLIdentifierExpr) owner).normalizedName();
        } else if (owner instanceof SQLPropertyExpr) {
            ownerName = ((SQLPropertyExpr) owner).normalizedName();
        } else {
            ownerName = owner.toString();
        }

        return ownerName + '.' + SQLUtils.normalize(name);
    }
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public SQLPropertyExpr simplify() {
    String normalizedName = SQLUtils.normalize(name);
    SQLExpr normalizedOwner = this.owner;
    if (normalizedOwner instanceof SQLIdentifierExpr) {
        normalizedOwner = ((SQLIdentifierExpr) normalizedOwner).simplify();
    }

    if (normalizedName != name || normalizedOwner != owner) {
        return new SQLPropertyExpr(normalizedOwner, normalizedName, hashCode64);
    }

    return this;
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public void addTableMapping(String srcTable, String destTable) {
    if (tableMapping == null) {
        tableMapping = new HashMap<String, String>();
    }

    if (srcTable.indexOf('.') >= 0) {
        SQLExpr expr = SQLUtils.toSQLExpr(srcTable, dbType);
        if (expr instanceof SQLPropertyExpr) {
            srcTable = ((SQLPropertyExpr) expr).simplify().toString();
        }
    } else {
        srcTable = SQLUtils.normalize(srcTable);
    }
    tableMapping.put(srcTable, destTable);
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public String normalizedName() {
    return SQLUtils.normalize(name);
}
 

import com.alibaba.druid.sql.SQLUtils; //导入方法依赖的package包/类
public static List<SQLStatement> resolve(SQLCreateViewStatement stmt) {
    List<SQLStatement> targetList = new ArrayList<SQLStatement>();
    targetList.add(stmt);

    String viewName = SQLUtils.normalize(stmt.getName().getSimpleName());

    FromSubqueryResolver visitor = new FromSubqueryResolver(targetList, viewName);

    SQLWithSubqueryClause withSubqueryClause = stmt.getSubQuery().getWithSubQuery();
    if (withSubqueryClause != null) {
        stmt.getSubQuery().setWithSubQuery(null);

        for (SQLWithSubqueryClause.Entry entry : withSubqueryClause.getEntries()) {
            String entryName = entry.getAlias();

            SQLCreateViewStatement entryStmt = new SQLCreateViewStatement();
            entryStmt.setOrReplace(true);
            entryStmt.setDbType(stmt.getDbType());

            String entryViewName = visitor.generateSubViewName();
            entryStmt.setName(entryViewName);
            entryStmt.setSubQuery(entry.getSubQuery());

            visitor.targetList.add(0, entryStmt);
            visitor.mappings.put(entryName, entryViewName);

            entryStmt.accept(visitor);
        }
    }

    stmt.accept(visitor);

    String dbType = stmt.getDbType();
    for (int i = 0; i < targetList.size() - 1; ++i) {
        SQLCreateViewStatement targetStmt = (SQLCreateViewStatement) targetList.get(i);
        targetStmt.setOrReplace(true);
        targetStmt.setDbType(dbType);
        targetStmt.setAfterSemi(true);
    }

    return targetList;
}