Examples of net.sf.jsqlparser.schema.Table

net.sf.jsqlparser.schema.Table
A table. It can have an alias and the schema name it belongs to.

    public SelingerSelectivityEstimatorTest() {
    }


    @BeforeClass
    public static void setUpClass() throws Exception {
        Table table = new Table();
        table.setName("ORDERS");
        List<Table> tableList = new ArrayList<Table>(Arrays.asList(table));


        _columnOrderdate = new Column();
        _columnOrderdate.setTable(table);
        _columnOrderdate.setColumnName("ORDERDATE");

View Full Code Here

    throw new UnsupportedOperationException("Not supported yet.");
  }


  @Override
  public void visit(Column column) {
    final Table affectedTable = column.getTable();
    if (_sideTable == null)
      _sideTable = affectedTable;
    else if (!ParserUtil.equals(_sideTable, affectedTable))
      throw new RuntimeException(
          "Multiple tables on one side of a join condition is not supported yet!");

View Full Code Here

  public void visit(DoubleValue dv) {
  }


  @Override
  public void visit(EqualsTo et) {
    final Table leftTable = visitSideEquals(et.getLeftExpression());
    final Table rightTable = visitSideEquals(et.getRightExpression());
    _joinTablesExp.addEntry(leftTable, rightTable, et);
  }

View Full Code Here

  public static Column nameToColumn(String name) {
    final String[] nameParts = name.split("\\.");
    final String compName = nameParts[0];
    final String columnName = nameParts[1];


    final Table table = new Table();
    table.setAlias(compName);
    final Column column = new Column();
    column.setColumnName(columnName);
    column.setTable(table);
    return column;
  }

View Full Code Here

        //getting results
        List<Expression> listExpr = instance.getExprList();
        List<OrExpression> orListExpr = instance.getOrExprs();
                
        //expected results
        Table tableN1 = new Table(); tableN1.setName("N1");
        Table tableN2 = new Table(); tableN2.setName("N2");
        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();

View Full Code Here

    throw new Error("Missing return statement in function");
  }


  final public Update Update() throws ParseException {
        Update update = new Update();
        Table table = null;
        Expression where = null;
        Column tableColumn = null;
        List expList = new ArrayList();
        List columns = new ArrayList();
        Expression value = null;

View Full Code Here

    throw new Error("Missing return statement in function");
  }


  final public Replace Replace() throws ParseException {
        Replace replace = new Replace();
        Table table = null;
        Column tableColumn = null;
        Expression value = null;


        List columns = new ArrayList();
        List expList = new ArrayList();

View Full Code Here

    throw new Error("Missing return statement in function");
  }


  final public Insert Insert() throws ParseException {
        Insert insert = new Insert();
        Table table = null;
        Column tableColumn = null;
        List columns = new ArrayList();
        List primaryExpList = new ArrayList();
        ItemsList itemsList = null;
        Expression exp = null;

View Full Code Here

    throw new Error("Missing return statement in function");
  }


  final public Delete Delete() throws ParseException {
        Delete delete = new Delete();
        Table table = null;
        Expression where = null;
    jj_consume_token(K_DELETE);
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_FROM:
      jj_consume_token(K_FROM);

View Full Code Here

    default:
      jj_la1[18] = jj_gen;
      ;
    }
        String colName = null;
        Table table = null;
        if (name3 != null) {
                table = new Table(name1, name2);
                colName = name3;
        } else if (name2 != null) {
                table = new Table(null, name1);
                colName = name2;
        } else {
                table = new Table(null, null);
                colName = name1;
        }


        {if (true) return new Column(table, colName);}
    throw new Error("Missing return statement in function");

View Full Code Here

0 1 2

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

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.