Examples of net.sf.jsqlparser.statement.update.Update

Package net.sf.jsqlparser.statement.update

Examples of net.sf.jsqlparser.statement.update.Update

net.sf.jsqlparser.statement.update.Update
The update statement.

      {if (true) return stm;}
    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;
    jj_consume_token(K_UPDATE);
    table = TableWithAlias();
    jj_consume_token(K_SET);
    tableColumn = Column();
    jj_consume_token(77);
    value = SimpleExpression();
                                                                columns.add(tableColumn); expList.add(value);
    label_1:
    while (true) {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case 78:
        ;
        break;
      default:
        jj_la1[2] = jj_gen;
        break label_1;
      }
      jj_consume_token(78);
      tableColumn = Column();
      jj_consume_token(77);
      value = SimpleExpression();
                                                                            columns.add(tableColumn); expList.add(value);
    }
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_WHERE:
      where = WhereClause();
                           update.setWhere(where);
      break;
    default:
      jj_la1[3] = jj_gen;
      ;
    }
                update.setColumns(columns);
                update.setExpressions(expList);
                update.setTable(table);
                {if (true) return update;}
    throw new Error("Missing return statement in function");
  }

View Full Code Here

    @Test
  public void testGetTableListFromUpdate() throws Exception {
    String sql = "UPDATE MY_TABLE1 SET a = (SELECT a from MY_TABLE2 WHERE a = 1)";
    net.sf.jsqlparser.statement.Statement statement = pm.parse(new StringReader(sql));


    Update updateStatement = (Update) statement;
    TablesNamesFinder tablesNamesFinder = new TablesNamesFinder();
    List<String> tableList = tablesNamesFinder.getTableList(updateStatement);
    assertEquals(2, tableList.size());
    assertTrue(tableList.contains("MY_TABLE1"));
    assertTrue(tableList.contains("MY_TABLE2"));

View Full Code Here

    @Test
  public void testGetTableListFromUpdate2() throws Exception {
    String sql = "UPDATE MY_TABLE1 SET a = 5 WHERE 0 < (SELECT COUNT(b) FROM MY_TABLE3)";
    net.sf.jsqlparser.statement.Statement statement = pm.parse(new StringReader(sql));


    Update updateStatement = (Update) statement;
    TablesNamesFinder tablesNamesFinder = new TablesNamesFinder();
    List<String> tableList = tablesNamesFinder.getTableList(updateStatement);
    assertEquals(2, tableList.size());
    assertTrue(tableList.contains("MY_TABLE1"));
    assertTrue(tableList.contains("MY_TABLE3"));

View Full Code Here

    @Test
  public void testGetTableListFromUpdate3() throws Exception {
    String sql = "UPDATE MY_TABLE1 SET a = 5 FROM MY_TABLE1 INNER JOIN MY_TABLE2 on MY_TABLE1.C = MY_TABLE2.D WHERE 0 < (SELECT COUNT(b) FROM MY_TABLE3)";
    net.sf.jsqlparser.statement.Statement statement = pm.parse(new StringReader(sql));


    Update updateStatement = (Update) statement;
    TablesNamesFinder tablesNamesFinder = new TablesNamesFinder();
    List<String> tableList = tablesNamesFinder.getTableList(updateStatement);
    assertEquals(3, tableList.size());
    assertTrue(tableList.contains("MY_TABLE1"));
    assertTrue(tableList.contains("MY_TABLE2"));

View Full Code Here

  static CCJSqlParserManager parserManager = new CCJSqlParserManager();


    @Test
  public void testUpdate() throws JSQLParserException {
    String statement = "UPDATE mytable set col1='as', col2=?, col3=565 Where o >= 3";
    Update update = (Update) parserManager.parse(new StringReader(statement));
    assertEquals("mytable", update.getTables().get(0).getName());
    assertEquals(3, update.getColumns().size());
    assertEquals("col1", ((Column) update.getColumns().get(0)).getColumnName());
    assertEquals("col2", ((Column) update.getColumns().get(1)).getColumnName());
    assertEquals("col3", ((Column) update.getColumns().get(2)).getColumnName());
    assertEquals("as", ((StringValue) update.getExpressions().get(0)).getValue());
    assertTrue(update.getExpressions().get(1) instanceof JdbcParameter);
    assertEquals(565, ((LongValue) update.getExpressions().get(2)).getValue());


    assertTrue(update.getWhere() instanceof GreaterThanEquals);
  }

View Full Code Here

  }


    @Test
  public void testUpdateWAlias() throws JSQLParserException {
    String statement = "UPDATE table1 A SET A.columna = 'XXX' WHERE A.cod_table = 'YYY'";
    Update update = (Update) parserManager.parse(new StringReader(statement));
  }

View Full Code Here

    }


    @SuppressWarnings("unchecked")
    private int handleUpdate(String sql) throws JSQLParserException {
        int returnval = 0;
        Update update = (Update) this.parserManager.parse(new StringReader(sql));
        String domain = this.getWriteTableName(update.getTable());


        String qury = "SELECT * FROM " + SimpleDBUtils.quoteName(domain) + " WHERE "
                + update.getWhere().toString();


        SelectRequest selectRequest = new SelectRequest(qury);
        List<Item> items = this.connection.getSimpleDB().select(selectRequest).getItems();
        List<ReplaceableItem> data = new ArrayList<ReplaceableItem>();
        for (Item item : items) {


            List<Column> columns = (List<Column>) update.getColumns();
            List<Expression> expressions = (List<Expression>) update.getExpressions();
            List<ReplaceableAttribute> attributes = new ArrayList<ReplaceableAttribute>();


            int count = 0;
            for (Column column : columns) {
                String attributeName = column.getColumnName();

View Full Code Here

    }


    @SuppressWarnings("unchecked")
  private int handleUpdate() throws JSQLParserException, SQLException {
        int returnval = 0;
        Update update = (Update) this.parserManager.parse(new StringReader(this.sql));
        String domain = update.getTable().getName();


        String qury = "SELECT * FROM " + SimpleDBUtils.quoteName(domain) +
                " WHERE " + update.getWhere().toString();


        int sizeSets = update.getColumns().size(); // this is the size of sets
        int argsSize = this.args.size();
        for (int x = sizeSets; x < argsSize; x++) {
            qury = qury.replaceFirst("\\?", SimpleDBUtils.quoteValue(this.args.get(x)));
        }


        SelectRequest selectRequest = new SelectRequest(qury);
        List<Item> items = this.connection.getSimpleDB().select(selectRequest).getItems();
        List<ReplaceableItem> data = new ArrayList<ReplaceableItem>();


        for (Item item : items) {
            List<Column> columns = (List<Column>) update.getColumns();            
            List<ReplaceableAttribute> attributes = new ArrayList<ReplaceableAttribute>();


            int count = 0;
            for (int x = 0; x < sizeSets; x++) {
                String attributeName = columns.get(x).getColumnName();

View Full Code Here

TOP

Related Classes of net.sf.jsqlparser.statement.update.Update

com.beacon50.jdbc.aws.SimpleDBPreparedStatement

com.beacon50.jdbc.aws.SimpleDBStatement

net.sf.jsqlparser.parser.CCJSqlParser

net.sf.jsqlparser.test.update.UpdateTest

net.sf.jsqlparser.util.TablesNamesFinderTest

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.