Package net.sf.jsqlparser.schema

Examples of net.sf.jsqlparser.schema.Table

119
120
121
122
123
124
125
126
127
128
129
130
    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);
                }
            }
        }
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
        for (Iterator<FromItem> it = items.iterator(); it.hasNext();) {

            FromItem fromItem = it.next();

            if (fromItem instanceof Table) {
                Table table = (Table) fromItem;
                table.setAlias(null);
            }
        }
        return items;
    }
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
            item = (SelectItem) it.next();
            if (item instanceof AllColumns) {
                continue;
            } else if (item instanceof AllTableColumns) {
                AllTableColumns allTableCols = (AllTableColumns) item;
                Table table = allTableCols.getTable();
                List tableColNames = getTableColumns(session, table);
                colNames.addAll(tableColNames);
            } else if (item instanceof SelectExpressionItem) {
                String stringItem = item.toString();
                colNames.add(stringItem);
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
    public static Table qualify(ISession session, Table table) throws IllegalStateException {
        if (table == null) {
            return null;
        }

        final Table qualifiedTable = new Table();
        final String databaseName;
        final String userName;

        qualifiedTable.setName(table.getName());
        qualifiedTable.setAlias(table.getAlias());

        // String schema = table.getSchemaName(); // user name in sde land

        // if (schema != null) {
        try {
            databaseName = session.getDatabaseName();
            userName = session.getUser();
        } catch (IOException e) {
            throw new IllegalStateException("getting database name: " + e.getMessage());
        }

        // we'll replace the table schema name by
        // databaseName.userName
        String qualifiedSchema = databaseName;
        if ("".equals(qualifiedSchema)) {
            qualifiedSchema = userName;
        } else {
            qualifiedSchema += ("." + userName);
        }

        qualifiedTable.setSchemaName(qualifiedSchema.toUpperCase());
        // }

        return qualifiedTable;
    }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
* @since 2.3.x
*/
class ColumnQualifier {

    public static Column qualify(ISession session, Map<String, Object> tableAliases, Column column) {
        Table table = column.getTable();

        String columnName = column.getColumnName();

        Table unaliasedTable = (Table) tableAliases.get(table.getName());

        Table qualifiedTable;

        if (unaliasedTable == null) {
            // not an aliased table, qualify it
            qualifiedTable = TableQualifier.qualify(session, table);
        } else {
View Full Code Here
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
  {
    SourceTableList sourceTables = new SourceTableList();
   
    for(int fromItemIndex : v.fromItemVisitor.tables.keySet())
    {
      Table t = v.fromItemVisitor.tables.get(fromItemIndex);
      String schema = t.getSchemaName();
      if(schema != null)
      {
        schema = schema.replaceAll("`", "");
      }
      String tableName = t.getName();
      tableName = tableName.replaceAll("`", "");
      List<ZNRecord> tuples = null;
      String key = null;
      if(schema != null && (schema.equalsIgnoreCase("explodeList") || schema.equalsIgnoreCase("explodeMap")))
      {
        tuples = getExplodedTable(schema, tableName, tupleReader);
        key = (t.getAlias() != null ? t.getAlias() : "xxx_random_" + System.currentTimeMillis());
      }
      else
      {
        tuples = tupleReader.get(tableName);
        key = (t.getAlias() != null ? t.getAlias() : tableName);
      }
      sourceTables.add(new SourceTable(key, fromItemIndex, tuples));
    }
   
    for(int fromItemIndex : v.fromItemVisitor.subSelects.keySet())
View Full Code Here
TOP

Related Classes of net.sf.jsqlparser.schema.Table

  • com.linkedin.helix.josql.ZNRecordQueryProcessor
  • estimators.SelingerSelectivityEstimatorTest
  • net.sf.jsqlparser.parser.CCJSqlParser
  • net.sf.jsqlparser.util.SelectUtilsTest
  • optimizers.cost.ProjGlobalCollectTest
  • org.geotools.arcsde.data.view.ColumnQualifier
  • org.geotools.arcsde.data.view.QueryInfoParser
  • org.geotools.arcsde.data.view.SelectItemQualifier
  • org.geotools.arcsde.data.view.SelectQualifier
  • org.geotools.arcsde.data.view.TableQualifier
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.