Examples of net.sf.jsqlparser.expression.operators.relational.ExpressionList

Package net.sf.jsqlparser.expression.operators.relational

Examples of net.sf.jsqlparser.expression.operators.relational.ExpressionList

net.sf.jsqlparser.expression.operators.relational.ExpressionList
A list of expressions, as in SELECT A FROM TAB WHERE B IN (expr1,expr2,expr3)

        Table tableLineitem = new Table(); tableLineitem.setName("LINEITEM");
        
        Column se1 = new Column(); se1.setTable(tableN1); se1.setColumnName("NAME");
        Column se2 = new Column(); se2.setTable(tableN2); se2.setColumnName("NAME");
        Column ls = new Column(); ls.setTable(tableLineitem); ls.setColumnName("SHIPDATE");
        ExpressionList el = new ExpressionList();
        el.setExpressions(Arrays.asList(ls));
        Function se3 = new Function(); se3.setName("EXTRACT_YEAR"); se3.setParameters(el);
        Column le = new Column(); le.setTable(tableLineitem); le.setColumnName("EXTENDEDPRICE");
        Column ld = new Column(); ld.setTable(tableLineitem); ld.setColumnName("DISCOUNT");
        Subtraction diff = new Subtraction(); diff.setLeftExpression(new DoubleValue("1.0")); diff.setRightExpression(ld);
        Parenthesis diffPnths = new Parenthesis();diffPnths.setExpression(diff);

View Full Code Here

          jj_consume_token(78);
          exp = PrimaryExpression();
                                                                                expList.add(exp);
        }
        jj_consume_token(80);
                                                                                                             itemsList = new ExpressionList(expList);
        break;
      case K_SELECT:
      case 79:
                                          replace.setUseValues(false);
        itemsList = SubSelect();

View Full Code Here

        jj_consume_token(78);
        exp = SimpleExpression();
                                                               primaryExpList.add(exp);
      }
      jj_consume_token(80);
                                                                                                   itemsList = new ExpressionList(primaryExpList);
      break;
    case K_SELECT:
    case 79:
      if (jj_2_3(2)) {
        jj_consume_token(79);

View Full Code Here

                {if (true) return result;}
    throw new Error("Missing return statement in function");
  }


  final public ExpressionList SQLExpressionList() throws ParseException {
        ExpressionList retval = new ExpressionList();
        List expressions = new ArrayList();
        Expression expr = null;
    expr = Expression();
                        expressions.add(expr);
    label_18:
    while (true) {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case 78:
        ;
        break;
      default:
        jj_la1[96] = jj_gen;
        break label_18;
      }
      jj_consume_token(78);
      expr = Expression();
                                                                          expressions.add(expr);
    }
                retval.setExpressions(expressions);
                {if (true) return retval;}
    throw new Error("Missing return statement in function");
  }

View Full Code Here

                {if (true) return retval;}
    throw new Error("Missing return statement in function");
  }


  final public ExpressionList SimpleExpressionList() throws ParseException {
        ExpressionList retval = new ExpressionList();
        List expressions = new ArrayList();
        Expression expr = null;
    expr = SimpleExpression();
                              expressions.add(expr);
    label_19:
    while (true) {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case 78:
        ;
        break;
      default:
        jj_la1[97] = jj_gen;
        break label_19;
      }
      jj_consume_token(78);
      expr = SimpleExpression();
                                                                                      expressions.add(expr);
    }
                retval.setExpressions(expressions);
                {if (true) return retval;}
    throw new Error("Missing return statement in function");
  }

View Full Code Here


  final public Function Function() throws ParseException {
        Function retval = new Function();
        String funcName = null;
        String tmp = null;
        ExpressionList expressionList = null;
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case 102:
      jj_consume_token(102);
                 retval.setEscaped(true);
      break;

View Full Code Here

         {
           fl[i]=((Column) insert.getColumns().get(i)).getColumnName();
         }
         
         
     ExpressionList explist=((ExpressionList) insert.getItemsList());
       JSONObject item=new JSONObject();


       List expressions=explist.getExpressions();
     for(int i=0;i<expressions.size();i++)
     {
       
       Object val=expressions.get(i);
       if(val instanceof StringValue)

View Full Code Here

            Expression qExp = ExpressionQualifier.qualify(session, tableAliases, exp);


            qualifiedList.add(qExp);
        }


        ExpressionList qExpList = new ExpressionList();
        qExpList.setExpressions(qualifiedList);
        this._qualifiedList = qExpList;
    }

View Full Code Here

        Function qfunction = new Function();
        qfunction.setAllColumns(function.isAllColumns());
        qfunction.setEscaped(function.isEscaped());
        qfunction.setName(function.getName());


        ExpressionList parameters = function.getParameters();
        ExpressionList qualifiedParams;


        qualifiedParams = (ExpressionList) ItemsListQualifier.qualify(session, tableAliases,
                parameters);


        qfunction.setParameters(qualifiedParams);

View Full Code Here

0 1

TOP

Related Classes of net.sf.jsqlparser.expression.operators.relational.ExpressionList

com.alimama.mdrill.jdbc.InsertParser

net.sf.jsqlparser.parser.CCJSqlParser

optimizers.cost.ProjGlobalCollectTest

org.geotools.arcsde.data.view.ExpressionQualifier

org.geotools.arcsde.data.view.ItemsListQualifier

sql.optimizers.name.ProjGlobalCollect

sql.util.ParserUtil

sql.visitors.jsql.ColumnCollectVisitor

sql.visitors.jsql.JoinTablesExprsVisitor

sql.visitors.jsql.PrintVisitor

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.