本文整理了Java中net.sf.jsqlparser.schema.Table.getAlias()
方法的一些代码示例,展示了Table.getAlias()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Table.getAlias()
方法的具体详情如下:
包路径:net.sf.jsqlparser.schema.Table
类名称:Table
方法名:getAlias
暂无
代码示例来源:origin: alibaba/mdrill
public void visit(Table tableName) {
buffer.append(tableName.getWholeTableName());
String alias = tableName.getAlias();
if (alias != null && !alias.equals("")) {
buffer.append(" AS " + alias);
}
}
代码示例来源:origin: JSQLParser/JSqlParser
/**
* Get name with out without using aliases.
*
* @param aliases
* @return
*/
public String getName(boolean aliases) {
StringBuilder fqn = new StringBuilder();
if (table != null) {
if (table.getAlias() != null && aliases) {
fqn.append(table.getAlias().getName());
} else {
fqn.append(table.getFullyQualifiedName());
}
}
if (fqn.length() > 0) {
fqn.append('.');
}
if (columnName != null) {
fqn.append(columnName);
}
return fqn.toString();
}
代码示例来源:origin: baomidou/mybatis-plus
/**
* 租户字段别名设置
* <p>tableName.tenantId 或 tableAlias.tenantId</p>
*
* @param table 表对象
* @return 字段
*/
protected Column getAliasColumn(Table table) {
StringBuilder column = new StringBuilder();
if (null == table.getAlias()) {
column.append(table.getName());
} else {
column.append(table.getAlias().getName());
}
column.append(StringPool.DOT);
column.append(tenantHandler.getTenantIdColumn());
return new Column(column.toString());
}
}
代码示例来源:origin: JSQLParser/JSqlParser
@Override
public void visit(Column tableColumn) {
final Table table = tableColumn.getTable();
String tableName = null;
if (table != null) {
if (table.getAlias() != null) {
tableName = table.getAlias().getName();
} else {
tableName = table.getFullyQualifiedName();
}
}
if (tableName != null && !tableName.isEmpty()) {
buffer.append(tableName).append(".");
}
buffer.append(tableColumn.getColumnName());
}
代码示例来源:origin: JSQLParser/JSqlParser
@Override
public void visit(Table tableName) {
buffer.append(tableName.getFullyQualifiedName());
Alias alias = tableName.getAlias();
if (alias != null) {
buffer.append(alias);
}
Pivot pivot = tableName.getPivot();
if (pivot != null) {
pivot.accept(this);
}
MySQLIndexHint indexHint = tableName.getIndexHint();
if (indexHint != null) {
buffer.append(indexHint);
}
}
代码示例来源:origin: baomidou/mybatis-plus
Expression rightExpression = ((BinaryExpression) expression).getRightExpression();
if (joinTable != null && rightExpression instanceof Column) {
if (Objects.equals(((Column) rightExpression).getTable().getName(), table.getAlias().getName())) {
validUseIndex(table, ((Column) rightExpression).getColumnName(), connection);
validUseIndex(joinTable, ((Column) leftExpression).getColumnName(), connection);
代码示例来源:origin: geotools/geotools
private Map<String, Table> extractTableAliases(List<FromItem> fromItems) {
Map<String, Table> aliases = new HashMap<String, Table>();
for (Iterator<FromItem> it = fromItems.iterator(); it.hasNext(); ) {
FromItem fromItem = it.next();
if (fromItem instanceof Table) {
Table table = (Table) fromItem;
String alias = table.getAlias();
if (alias != null) {
aliases.put(alias, table);
}
}
}
return aliases;
}
代码示例来源:origin: geotools/geotools
qualifiedTable.setAlias(table.getAlias());
代码示例来源:origin: org.geotools/gt-arcsde
private Map<String, Table> extractTableAliases(List<FromItem> fromItems) {
Map<String, Table> aliases = new HashMap<String, Table>();
for (Iterator<FromItem> it = fromItems.iterator(); it.hasNext();) {
FromItem fromItem = it.next();
if (fromItem instanceof Table) {
Table table = (Table) fromItem;
String alias = table.getAlias();
if (alias != null) {
aliases.put(alias, table);
}
}
}
return aliases;
}
代码示例来源:origin: Blazebit/blaze-persistence
private Table findTable(List<Table> tables, String alias) {
for (Table t : tables) {
if (alias.equals(t.getAlias().getName())) {
return t;
}
}
return null;
}
代码示例来源:origin: zhicwu/cassandra-jdbc-driver
public void visit(Table tableName) {
if (tableName.getAlias() != null) {
tableName.setAlias(null);
}
}
代码示例来源:origin: com.blazebit/blaze-persistence-testsuite-base-jpa
private Table findTable(List<Table> tables, String alias) {
for (Table t : tables) {
if (alias.equals(t.getAlias().getName())) {
return t;
}
}
return null;
}
代码示例来源:origin: org.opencadc/cadc-jsqlparser-compat
public void visit(Table tableName) {
buffer.append(tableName.getWholeTableName());
String alias = tableName.getAlias();
if (alias != null && !alias.isEmpty()) {
buffer.append(" AS " + alias);
}
}
代码示例来源:origin: com.eas.platypus/platypus-js-sql-parser
public void visit(Table aTable) {
buffer.append(aTable.getComment() != null ? aTable.getComment() + " " + ExpressionDeParser.LINE_SEPARATOR : "").append(aTable.getWholeTableName());
String alias = aTable.getAlias() != null ? aTable.getAlias().toString() : "";
if (alias != null && !alias.isEmpty()) {
buffer.append(" ").append(alias);// it's very strange, but in fact oracle doesn't permit as key word if form clause
// buffer.append(" as ").append(alias);
}
}
代码示例来源:origin: com.intoverflow.booster/booster-core
private static void fetchTables(Map<String, Table> tables, FromItem fromItem) {
if (fromItem instanceof Table) {
Alias alias = ((Table) fromItem).getAlias();
if (alias != null) {
tables.put(alias.getName(), (Table) fromItem);
} else {
tables.put(((Table) fromItem).getName(), (Table) fromItem);
}
}
}
代码示例来源:origin: diennea/herddb
static TableRef buildFrom(Table fromTable, String defaultTableSpace) {
String tableSpace = fromTable.getSchemaName();
String tableName = fromTable.getName();
String tableAlias = tableName;
if (fromTable.getAlias() != null && fromTable.getAlias().getName() != null) {
tableAlias = fromTable.getAlias().getName();
}
if (tableSpace == null) {
tableSpace = defaultTableSpace;
}
return new TableRef(tableSpace, tableName, tableAlias);
}
代码示例来源:origin: com.github.jsqlparser/jsqlparser
@Override
public void visit(Column tableColumn) {
final Table table = tableColumn.getTable();
String tableName = null;
if (table != null) {
if (table.getAlias() != null) {
tableName = table.getAlias().getName();
} else {
tableName = table.getFullyQualifiedName();
}
}
if (tableName != null && !tableName.isEmpty()) {
buffer.append(tableName).append(".");
}
buffer.append(tableColumn.getColumnName());
}
代码示例来源:origin: com.github.jsqlparser/jsqlparser
@Override
public void visit(Table tableName) {
buffer.append(tableName.getFullyQualifiedName());
Alias alias = tableName.getAlias();
if (alias != null) {
buffer.append(alias);
}
Pivot pivot = tableName.getPivot();
if (pivot != null) {
pivot.accept(this);
}
MySQLIndexHint indexHint = tableName.getIndexHint();
if (indexHint != null) {
buffer.append(indexHint);
}
}
代码示例来源:origin: Quetzal-RDF/quetzal
@Override
public void visit(Table tableName) {
SelectBody select = cteName2Def.get(tableName.getFullyQualifiedName());
if (select != null) {
SubSelect subSelect = new SubSelect();
subSelect.setSelectBody(select);
Alias alias;
if (tableName.getAlias()==null) {
alias= new Alias(tableName.getFullyQualifiedName(), useASInTableAlias);
} else {
alias = tableName.getAlias();
}
subSelect.setAlias(alias);
result = subSelect;
} else {
result = tableName;
}
}
代码示例来源:origin: it.unibz.inf.ontop/ontop-obdalib-core
@Override
public void visit(Table table) {
if (!withTCEs.contains(table.getFullyQualifiedName().toLowerCase())) {
RelationID relationId = idfac.createRelationID(table.getSchemaName(), table.getName());
relations.add(relationId);
if (inSubSelect && subSelectAlias != null) {
// ONLY SIMPLE SUBSELECTS, WITH ONE TABLE: see WhereClauseVisitor and ProjectionVisitor
RelationID subSelectAliasId = idfac.createRelationID(null, subSelectAlias.getName());
tables.put(subSelectAliasId, relationId);
}
else {
Alias as = table.getAlias();
RelationID aliasId = (as != null) ? idfac.createRelationID(null, as.getName()) : relationId;
tables.put(aliasId, relationId);
}
}
}
内容来源于网络,如有侵权,请联系作者删除!