Java ISelectable.getAlias方法代码示例

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
/**
 * 列的tablename会设为表别名
 * 
 * @return
 */
public List<ISelectable> getColumnsReferedForParent() {
    if (this.getAlias() == null) {
        return this.getColumnsRefered();
    } else {
        List<ISelectable> res = new ArrayList<ISelectable>(this.getColumnsRefered().size());
        for (ISelectable s : this.getColumnsRefered()) {
            ISelectable a = s.copy();
            if (this.getAlias() != null) {
                a.setTableName(this.getAlias());
            }

            if (s.getAlias() != null) {
                a.setColumnName(s.getAlias()); // 设置为alias name
                a.setAlias(null);
            }
            res.add(a);
        }
        return res;
    }
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
/**
 * 列的tablename会设为表别名
 * 
 * @return
 */
public List<ISelectable> getColumnsSelectedForParent() {
    List<ISelectable> res = new ArrayList<ISelectable>(this.getColumnsSelected().size());
    for (ISelectable s : this.getColumnsSelected()) {
        ISelectable a = s.copy();
        if (this.getAlias() != null) {
            a.setTableName(this.getAlias());
        }

        if (s.getAlias() != null) {
            a.setColumnName(s.getAlias()); // 设置为alias name
            a.setAlias(null);
        }
        res.add(a);
    }
    return res;
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
void putRetColumnInMeta(ISelectable column, List<ColumnMeta> metaColumns) {
    String columnName;

    columnName = column.getColumnName();
    DataType type = null;

    // 函数在Map和Reduce过程中的返回类型可以不同
    // 如Avg，map过程返回String
    // reduce过程中返回数字类型
    if (this.isMerge()) {
        type = column.getDataType();
    } else {
        if (column instanceof IFunction) {
            type = ((IFunction) column).getExtraFunction().getMapReturnType();
        } else {
            type = column.getDataType();
        }
    }

    ColumnMeta cm = new ColumnMeta(ExecUtils.getLogicTableName(column.getTableName()),
        columnName,
        type,
        column.getAlias(),
        true);
    metaColumns.add(cm);
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
public void buildSelect(IQueryTree<IQueryTree> query) {
    sqlBuilder.append("select ");
    boolean hasDistinct = false;
    boolean first = true;
    StringBuilder sb = new StringBuilder();
    for (ISelectable selected : query.getColumns()) {
        if (first) {
            first = false;
        } else {
            sb.append(",");
        }
        if (selected.isDistinct()) {
            hasDistinct = true;
        }
        MysqlPlanVisitorImpl visitor = this.getNewVisitor(selected);
        sb.append(visitor.getString());
        if (selected.getAlias() != null) {
            sb.append(" as ").append(selected.getAlias());
        }
    }

    if (hasDistinct) {
        sqlBuilder.append(" distinct ");
    }

    sqlBuilder.append(sb);
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
public static List<ColumnMeta> getColumnMetas(List<ISelectable> columns) {
    List<ColumnMeta> _columns = new ArrayList<ColumnMeta>(columns.size());
    for (ISelectable c : columns) {
        ColumnMeta ic = new ColumnMeta(c.getTableName(), c.getColumnName(), c.getDataType(), c.getAlias(), true);
        _columns.add(ic);
    }
    return _columns;
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
@Override
public boolean isSameName(ISelectable select) {
    String cn1 = this.getColumnName();
    if (TStringUtil.isNotEmpty(this.getAlias())) {
        cn1 = this.getAlias();
    }

    String cn2 = select.getColumnName();
    if (TStringUtil.isNotEmpty(select.getAlias())) {
        cn2 = select.getAlias();
    }

    return TStringUtil.equals(cn1, cn2);
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
void putRetColumnInMeta(ISelectable column, List<ColumnMeta> metaColumns) {
    String columnName;

    columnName = column.getColumnName();
    DataType type = null;

    // 函数在Map和Reduce过程中的返回类型可以不同
    // 如Avg，map过程返回String
    // reduce过程中返回数字类型
    if (this.isMerge()) {
        type = column.getDataType();
    } else {
        if (column instanceof IFunction) {

            if (((IFunction) column).getFunctionType().equals(FunctionType.Aggregate)) {
                type = ((AggregateFunction) ((IFunction) column).getExtraFunction()).getMapReturnType();
            } else {
                type = column.getDataType();
            }
        } else {
            type = column.getDataType();
        }
    }

    ColumnMeta cm = new ColumnMeta(ExecUtils.getLogicTableName(column.getTableName()),
        columnName,
        type,
        column.getAlias(),
        true);
    metaColumns.add(cm);
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
/**
 * 从select列表中查找
 */
private ISelectable getColumnFromSelecteList(ISelectable c) {
    ISelectable column = null;
    for (ISelectable selected : this.getNode().getColumnsSelected()) {
        boolean isThis = false;

        if (c.getTableName() != null && (!(node instanceof KVIndexNode))) {
            if (!c.getTableName().equals(selected.getTableName())) {
                continue;
            }
        }

        // 在当前select中查找，先比较column name，再比较alias name
        if (selected.getColumnName().equals(c.getColumnName())) {
            isThis = true;
        } else if (selected.getAlias() != null && selected.getAlias().equals(c.getColumnName())) {
            isThis = true;
        }

        if (isThis) {
            column = selected;
            return column;
        }
    }

    return column;
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
public static List<ColumnMeta> getColumnMetaWithLogicTables(List<ISelectable> columns) {
    List<ColumnMeta> _columns = new ArrayList<ColumnMeta>(columns.size());
    for (ISelectable c : columns) {
        ColumnMeta ic = new ColumnMeta(getLogicTableName(c.getTableName()),
            c.getColumnName(),
            c.getDataType(),
            c.getAlias(),
            true);
        _columns.add(ic);

        // if (ic.getDataType() == null)
        // throw new RuntimeException("fuck!");
    }
    return _columns;
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
public static ColumnMeta getColumnMeta(Object o, String columnAlias) {
    ISelectable c = (ISelectable) o;
    return new ColumnMeta(c.getTableName(), columnAlias, c.getDataType(), c.getAlias(), true);
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
public static ColumnMeta getColumnMetaTable(Object o, String tableName) {
    ISelectable c = (ISelectable) o;
    return new ColumnMeta(tableName, c.getColumnName(), c.getDataType(), c.getAlias(), true);
}
 

import com.taobao.tddl.optimizer.core.expression.ISelectable; //导入方法依赖的package包/类
public static ColumnMeta getColumnMeta(Object o) {
    ISelectable c = (ISelectable) o;
    return new ColumnMeta(c.getTableName(), c.getColumnName(), c.getDataType(), c.getAlias(), true);
}