net.sf.jsqlparser.schema.Table类的使用及代码示例

x33g5p2x  于2022-01-30 转载在 其他  
字(8.6k)|赞(0)|评价(0)|浏览(534)

本文整理了Java中net.sf.jsqlparser.schema.Table类的一些代码示例，展示了Table类的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Table类的具体详情如下：
包路径：net.sf.jsqlparser.schema.Table
类名称：Table

Table介绍

[英]A table. It can have an alias and the schema name it belongs to.
[中]一张桌子。它可以有别名和它所属的架构名称。

代码示例

代码示例来源：origin: baomidou/mybatis-plus

  1. Expression rightExpression = ((BinaryExpression) expression).getRightExpression();
  2. if (joinTable != null && rightExpression instanceof Column) {
  3.   if (Objects.equals(((Column) rightExpression).getTable().getName(), table.getAlias().getName())) {
  4.     validUseIndex(table, ((Column) rightExpression).getColumnName(), connection);
  5.     validUseIndex(joinTable, ((Column) leftExpression).getColumnName(), connection);
  6.   } else {
  7.     validUseIndex(joinTable, ((Column) rightExpression).getColumnName(), connection);

代码示例来源：origin: alibaba/mdrill

  1. Table table = null;
  2.   if (name3 != null) {
  3.       table = new Table(name1, name2);
  4.       colName = name3;
  5.   } else if (name2 != null) {
  6.       table = new Table(null, name1);
  7.       colName = name2;
  8.   } else {
  9.       table = new Table(null, null);
  10.       colName = name1;
  11.   {if (true) return new Column(table, colName);}
  12. throw new Error("Missing return statement in function");

代码示例来源：origin: JSQLParser/JSqlParser

  1. @Override
  2. public void visit(Column tableColumn) {
  3.   final Table table = tableColumn.getTable();
  4.   String tableName = null;
  5.   if (table != null) {
  6.     if (table.getAlias() != null) {
  7.       tableName = table.getAlias().getName();
  8.     } else {
  9.       tableName = table.getFullyQualifiedName();
  10.     }
  11.   }
  12.   if (tableName != null && !tableName.isEmpty()) {
  13.     buffer.append(tableName).append(".");
  14.   }
  15.   buffer.append(tableColumn.getColumnName());
  16. }

代码示例来源：origin: alibaba/mdrill

  1. public void visit(Table tableName) {
  2.   buffer.append(tableName.getWholeTableName());
  3.   String alias = tableName.getAlias();
  4.   if (alias != null && !alias.equals("")) {
  5.     buffer.append(" AS " + alias);
  6.   }
  7. }

代码示例来源：origin: JSQLParser/JSqlParser

  1. @Override
  2. public void visit(Table tableName) {
  3.   buffer.append(tableName.getFullyQualifiedName());
  4.   Alias alias = tableName.getAlias();
  5.   if (alias != null) {
  6.     buffer.append(alias);
  7.   }
  8.   Pivot pivot = tableName.getPivot();
  9.   if (pivot != null) {
  10.     pivot.accept(this);
  11.   }
  12.   MySQLIndexHint indexHint = tableName.getIndexHint();
  13.   if (indexHint != null) {
  14.     buffer.append(indexHint);
  15.   }
  16. }

代码示例来源：origin: it.unibz.inf.ontop/ontop-obdalib-core

  1. private Term getVariable(Column expression) {
  2.   QuotedID column = idfac.createAttributeID(expression.getColumnName());
  3.   RelationID relation = null;
  4.   if (expression.getTable().getName() != null)
  5.     relation = idfac.createRelationID(expression.getTable().getSchemaName(), expression.getTable().getName());
  6.   
  7.   QualifiedAttributeID qa = new QualifiedAttributeID(relation, column);
  8.   
  9.   return lookupTable.get(qa);
  10. }

代码示例来源：origin: geotools/geotools

  1. public static Column qualify(
  2.       ISession session, Map<String, Object> tableAliases, Column column) {
  3.     Table table = column.getTable();
  5.     String columnName = column.getColumnName();
  7.     Table unaliasedTable = (Table) tableAliases.get(table.getName());
  9.     Table qualifiedTable;
  11.     if (unaliasedTable == null) {
  12.       // not an aliased table, qualify it
  13.       qualifiedTable = TableQualifier.qualify(session, table);
  14.     } else {
  15.       // AllTableColumns is refering to an aliased table in the FROM
  16.       // clause,
  17.       // replace its table by the original one to get rid of the alias
  18.       qualifiedTable = unaliasedTable;
  19.     }
  21.     Column qualifiedColumn = new Column();
  23.     qualifiedColumn.setColumnName(columnName);
  24.     qualifiedColumn.setTable(qualifiedTable);
  26.     return qualifiedColumn;
  27.   }
  28. }

代码示例来源：origin: geotools/geotools

  1. final Table qualifiedTable = new Table();
  2. final String databaseName;
  3. final String userName;
  4. qualifiedTable.setName(table.getName());
  5. qualifiedTable.setAlias(table.getAlias());
  6. qualifiedTable.setSchemaName(qualifiedSchema.toUpperCase());

代码示例来源：origin: org.opencadc/cadc-adql

  1. @Override
  2.   public void visit(Table table)
  3.   {
  4.     log.debug("visit(table)" + table);
  5.     String tabName = table.getWholeTableName();
  6.     log.debug("looking for " + tabName + " in conversion map...");
  7.     Table ntab = map.get(tabName);
  8.     log.debug("found: " + ntab);
  9.     if (ntab != null)
  10.     {
  11.       log.debug("convert: " + table.getSchemaName() + "." + table.getName()
  12.           + " -> " + ntab.getSchemaName() + "." + ntab.getName());
  13.       table.setName(ntab.getName());
  14.       table.setSchemaName(ntab.getSchemaName());
  15.       // leave alias intact
  16.     }
  17.   }
  18. }

代码示例来源：origin: baomidou/mybatis-plus

  1. /**
  2.    * 租户字段别名设置
  3.    * <p>tableName.tenantId 或 tableAlias.tenantId</p>
  4.    *
  5.    * @param table 表对象
  6.    * @return 字段
  7.    */
  8.   protected Column getAliasColumn(Table table) {
  9.     StringBuilder column = new StringBuilder();
  10.     if (null == table.getAlias()) {
  11.       column.append(table.getName());
  12.     } else {
  13.       column.append(table.getAlias().getName());
  14.     }
  15.     column.append(StringPool.DOT);
  16.     column.append(tenantHandler.getTenantIdColumn());
  17.     return new Column(column.toString());
  18.   }
  19. }

代码示例来源：origin: JSQLParser/JSqlParser

  1. @Override
  2. public void visit(Column tableColumn) {
  3.   if (allowColumnProcessing && tableColumn.getTable() != null && tableColumn.getTable().getName() != null) {
  4.     visit(tableColumn.getTable());
  5.   }
  6. }

代码示例来源：origin: pagehelper/Mybatis-PageHelper

  1. allColumnsTables.add(((AllTableColumns) item).getTable().getName());
  2.     ((Column) expression).setTable(null);
  3.   String table = ((Column) expression).getTable().getName();
  4.   if (table == null) { // 表名为空
  5.     if (allColumns ||
  6.         (allColumnsTables.size() == 1 && plainSelect.getJoins() == null) ||
  7.         aliases.contains(((Column) expression).getColumnName())) {

代码示例来源：origin: it.unibz.inf.ontop/ontop-obdalib-core

  1. public static void normalizeColumnName(QuotedIDFactory idfac, Column tableColumn) {
  2.   QuotedID columnName = idfac.createAttributeID(tableColumn.getColumnName());
  3.   tableColumn.setColumnName(columnName.getSQLRendering());
  4.   Table table = tableColumn.getTable();
  5.   RelationID tableName = idfac.createRelationID(table.getSchemaName(), table.getName());
  6.   table.setSchemaName(tableName.getSchemaSQLRendering());
  7.   table.setName(tableName.getTableNameSQLRendering());
  8. }

代码示例来源：origin: it.unibz.inf.ontop/ontop-obdalib-core

  1. @Override
  2. public void visit(Table table) {
  3.   //obtain the column names from the metadata
  4.   RelationID tableID = idfac.createRelationID(table.getSchemaName(), table.getName());
  5.   RelationDefinition tableDefinition = metadata.getRelation(tableID);
  6.   if (tableDefinition == null)
  7.     throw new RuntimeException("Definition not found for table '" + table + "'.");
  8.   Table tableName;
  9.   if (aliasSubselect != null) 
  10.     tableName = new Table(aliasSubselect);
  11.   else if (table.getAlias() != null)  //use the alias if present
  12.     tableName = new Table(table.getAlias().getName());
  13.   else 
  14.     tableName = table;
  15.   for (Attribute att : tableDefinition.getAttributes()) {
  16.     // ROMAN (9 Oct 2015)
  17.     // the unquoted name is used for comparisons
  18.     Column columnNameUnquoted = new Column(tableName, att.getID().getSQLRendering());
  19.    
  20.     if (variables.contains(columnNameUnquoted.getFullyQualifiedName(), att.getID().getName())) {
  21.       // properly quoted name if necessary 
  22.       Column columnName = new Column(tableName, att.getID().getSQLRendering());
  23.       columns.add(new SelectExpressionItem(columnName));
  24.     }
  25.   }
  26. }

代码示例来源：origin: geotools/geotools

  1. private static List getTableColumns(ISession session, Table table) throws IOException {
  2.     List colNames = new ArrayList();
  3.     String tableName = table.getSchemaName() + "." + table.getName();
  4.     SeColumnDefinition[] cols = session.describe(tableName);
  5.     for (int i = 0; i < cols.length; i++) {
  6.       String colName = cols[i].getName();
  7.       colName = tableName + "." + colName;
  8.       colNames.add(colName);
  9.     }
  10.     return colNames;
  11.   }
  12. }

代码示例来源：origin: com.intoverflow.booster/booster-core

  1. @Override
  2.   public void visit(Column column) {
  3.     Table table = column.getTable();
  4.     if (table == null || StringUtils.isBlank(table.getName())) {
  5.       Table t = new Table(tableName);
  6.       if (tableAlias != null) {
  7.         t.setAlias(new Alias(tableAlias, false));
  8.       }
  9.       column.setTable(t);
  10.     }
  11.   }
  12. });

代码示例来源：origin: com.intoverflow.booster/booster-core

  1. @Override
  2.   public void visit(Column column) {
  3.     net.sf.jsqlparser.schema.Table table = column.getTable();
  4.     if (table == null) {
  5.       table = new net.sf.jsqlparser.schema.Table(mainAlias);
  6.       column.setTable(table);
  7.     } else {
  8.       if (StringUtils.isBlank(table.getName())) {
  9.         table.setName(mainAlias);
  10.       }
  11.     }
  12.   }
  13. });

代码示例来源：origin: com.eas.platypus/platypus-js-sql-parser

  1. public void visit(Column tableColumn) {
  2.   buffer.append(tableColumn.getComment() != null ? tableColumn.getComment() + " " + ExpressionDeParser.LINE_SEPARATOR : "");
  3.   if (tableColumn.getTable().getName() != null) {
  4.     String tableName = tableColumn.getTable().getWholeTableName();
  5.     buffer.append(tableName).append(".");
  6.   }
  7.   buffer.append(tableColumn.getColumnName());
  8. }

代码示例来源：origin: diennea/herddb

  1. static TableRef buildFrom(Table fromTable, String defaultTableSpace) {
  2.   String tableSpace = fromTable.getSchemaName();
  3.   String tableName = fromTable.getName();
  4.   String tableAlias = tableName;
  5.   if (fromTable.getAlias() != null && fromTable.getAlias().getName() != null) {
  6.     tableAlias = fromTable.getAlias().getName();
  7.   }
  8.   if (tableSpace == null) {
  9.     tableSpace = defaultTableSpace;
  10.   }
  11.   return new TableRef(tableSpace, tableName, tableAlias);
  12. }

代码示例来源：origin: geotools/geotools

  1. Table unaliasedTable = (Table) tableAliases.get(qt.getName());
  2. String tableName = qt.getSchemaName() + "." + qt.getName();
  3. SeColumnDefinition[] cols;
  4. try {
  5.   String colName = cols[i].getName();
  6.   Column column = new Column();
  7.   column.setTable(qt);
  8.   column.setColumnName(colName);

内容来源于网络，如有侵权，请联系作者删除！

Table

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com