Package net.sf.jsqlparser.statement.select

Examples of net.sf.jsqlparser.statement.select.FromItem

266
267
268
269
270
271
272
273
274
275
276
277
      buffer.append("JOIN ");

    }
   
    FromItem fromItem = join.getRightItem();
    fromItem.accept(this);
    if (join.getOnExpression() != null) {
      buffer.append(" ON ");
      join.getOnExpression().accept(expressionVisitor);
    }
    if (join.getUsingColumns() != null) {
View Full Code Here
580
581
582
583
584
585
586
587
588
589
590
  }

  final public PlainSelect PlainSelect() throws ParseException {
        PlainSelect plainSelect = new PlainSelect();
        List selectItems = null;
        FromItem fromItem = null;
        List joins = null;
        List distinctOn = null;
        Expression where = null;
        List orderByElements;
        List groupByColumnReferences = null;
View Full Code Here
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
      Table();
    }
  }

  final public FromItem FromItem() throws ParseException {
        FromItem fromItem = null;
        String alias = null;
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case 79:
      jj_consume_token(79);
      if (jj_2_7(2147483647)) {
        fromItem = SubJoin();
      } else {
        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
        case K_SELECT:
        case 79:
          fromItem = SubSelect();
          break;
        default:
          jj_la1[55] = jj_gen;
          jj_consume_token(-1);
          throw new ParseException();
        }
      }
      jj_consume_token(80);
      break;
    case S_IDENTIFIER:
    case S_QUOTED_IDENTIFIER:
      fromItem = Table();
      break;
    default:
      jj_la1[56] = jj_gen;
      jj_consume_token(-1);
      throw new ParseException();
    }
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_AS:
    case S_IDENTIFIER:
    case S_QUOTED_IDENTIFIER:
      alias = Alias();
                         fromItem.setAlias(alias);
      break;
    default:
      jj_la1[57] = jj_gen;
      ;
    }
View Full Code Here
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
                {if (true) return fromItem;}
    throw new Error("Missing return statement in function");
  }

  final public FromItem SubJoin() throws ParseException {
        FromItem fromItem = null;
        Join join = null;
        SubJoin subJoin = new SubJoin();
    fromItem = FromItem();
                              subJoin.setLeft(fromItem);
    join = JoinerExpression();
View Full Code Here
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
    throw new Error("Missing return statement in function");
  }

  final public Join JoinerExpression() throws ParseException {
        Join join = new Join();
        FromItem right = null;
        Expression onExpression = null;
        Column tableColumn;
        List columns = null;
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_LEFT:
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
    }

    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
134
135
136
137
138
139
140
141
142
143
144
    private List<FromItem> removeTableAliases(final List<FromItem> fromItems) {
        List<FromItem> items = new ArrayList<FromItem>(fromItems);

        for (Iterator<FromItem> it = items.iterator(); it.hasNext();) {

            FromItem fromItem = it.next();

            if (fromItem instanceof Table) {
                Table table = (Table) fromItem;
                table.setAlias(null);
            }
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
210
211
        }

        List<FromItem> qualifiedFromItems = new ArrayList<FromItem>();

        for (Iterator it = fromItems.iterator(); it.hasNext();) {
            FromItem fromItem = (FromItem) it.next();

            FromItem qualifiedItem = FromItemQualifier.qualify(session, fromItem);

            qualifiedFromItems.add(qualifiedItem);
        }

        return qualifiedFromItems;
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
        }

        List tableNames = new ArrayList(fromItems.size());

        for (Iterator it = fromItems.iterator(); it.hasNext();) {
            FromItem fromItem = (FromItem) it.next();
            String fromItemDef = fromItem.toString();
            tableNames.add(fromItemDef);
        }
        return (String[]) tableNames.toArray(new String[tableNames.size()]);
    }
View Full Code Here
TOP

Related Classes of net.sf.jsqlparser.statement.select.FromItem

  • net.sf.jsqlparser.parser.CCJSqlParser
  • net.sf.jsqlparser.util.deparser.SelectDeParser
  • org.geotools.arcsde.data.view.QueryInfoParser
  • org.geotools.arcsde.data.view.SelectQualifier
    • 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.