Examples of net.sf.jsqlparser.statement.insert.Insert

Package net.sf.jsqlparser.statement.insert

Examples of net.sf.jsqlparser.statement.insert.Insert

net.sf.jsqlparser.statement.insert.Insert
The insert statement. Every column name in columnNames matches an item in itemsList

                {if (true) return replace;}
    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;
    jj_consume_token(K_INSERT);
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_INTO:
      jj_consume_token(K_INTO);
      break;
    default:
      jj_la1[10] = jj_gen;
      ;
    }
    table = Table();
    if (jj_2_2(2)) {
      jj_consume_token(79);
      tableColumn = Column();
                                              columns.add(tableColumn);
      label_5:
      while (true) {
        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
        case 78:
          ;
          break;
        default:
          jj_la1[11] = jj_gen;
          break label_5;
        }
        jj_consume_token(78);
        tableColumn = Column();
                                                                                                      columns.add(tableColumn);
      }
      jj_consume_token(80);
    } else {
      ;
    }
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_VALUES:
      jj_consume_token(K_VALUES);
      jj_consume_token(79);
      exp = SimpleExpression();
                                                         primaryExpList.add(exp);
      label_6:
      while (true) {
        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
        case 78:
          ;
          break;
        default:
          jj_la1[12] = jj_gen;
          break label_6;
        }
        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);
      } else {
        ;
      }
                          insert.setUseValues(false);
      itemsList = SubSelect();
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case 80:
        jj_consume_token(80);
        break;
      default:
        jj_la1[13] = jj_gen;
        ;
      }
      break;
    default:
      jj_la1[14] = jj_gen;
      jj_consume_token(-1);
      throw new ParseException();
    }
                insert.setItemsList(itemsList);
            insert.setTable(table);
            if (columns.size() > 0)
                insert.setColumns(columns);
        {if (true) return insert;}
    throw new Error("Missing return statement in function");
  }

View Full Code Here

  public void parse(String sql) throws JSQLParserException, JSONException
  {
    this.sql=sql;


        CCJSqlParserManager parserManager = new CCJSqlParserManager();
     Insert insert = (Insert) parserManager.parse(new StringReader(sql));
         this.tablename=insert.getTable().getName();
         
         fl=new String[insert.getColumns().size()];
         for(int i=0;i<fl.length;i++)
         {
           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++)
     {

View Full Code Here

  }


    @Test
  public void testInsertWithKeywordValue() throws JSQLParserException {
    String statement = "INSERT INTO mytable (col1) VALUE ('val1')";
    Insert insert = (Insert) parserManager.parse(new StringReader(statement));
    assertEquals("mytable", insert.getTable().getName());
    assertEquals(1, insert.getColumns().size());
    assertEquals("col1", ((Column) insert.getColumns().get(0)).getColumnName());
    assertEquals("val1",
        ((StringValue) ((ExpressionList) insert.getItemsList()).getExpressions().get(0)).getValue());
    assertEquals("INSERT INTO mytable (col1) VALUES ('val1')", insert.toString());
  }

View Full Code Here

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


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

View Full Code Here

    @Test
  public void testGetTableListFromInsertValues() throws Exception {
    String sql = "INSERT INTO MY_TABLE1 (a) VALUES (5)";
    net.sf.jsqlparser.statement.Statement statement = pm.parse(new StringReader(sql));


    Insert insertStatement = (Insert) statement;
    TablesNamesFinder tablesNamesFinder = new TablesNamesFinder();
    List<String> tableList = tablesNamesFinder.getTableList(insertStatement);
    assertEquals(1, tableList.size());
    assertTrue(tableList.contains("MY_TABLE1"));
  }

View Full Code Here

  }


    @Test
  public void testInsertFromSelect() throws JSQLParserException {
    String statement = "INSERT INTO mytable (col1, col2, col3) SELECT * FROM mytable2";
    Insert insert = (Insert) parserManager.parse(new StringReader(statement));
    assertEquals("mytable", insert.getTable().getName());
    assertEquals(3, insert.getColumns().size());
    assertEquals("col1", ((Column) insert.getColumns().get(0)).getColumnName());
    assertEquals("col2", ((Column) insert.getColumns().get(1)).getColumnName());
    assertEquals("col3", ((Column) insert.getColumns().get(2)).getColumnName());
    assertNull(insert.getItemsList());
        assertNotNull(insert.getSelect());
    assertEquals("mytable2",
        ((Table) ((PlainSelect)insert.getSelect().getSelectBody()).getFromItem()).getName());


    // toString uses brakets
    String statementToString = "INSERT INTO mytable (col1, col2, col3) SELECT * FROM mytable2";
    assertEquals(statementToString, "" + insert);
  }

View Full Code Here

  CCJSqlParserManager parserManager = new CCJSqlParserManager();


    @Test
  public void testRegularInsert() throws JSQLParserException {
    String statement = "INSERT INTO mytable (col1, col2, col3) VALUES (?, 'sadfsd', 234)";
    Insert insert = (Insert) parserManager.parse(new StringReader(statement));
    assertEquals("mytable", insert.getTable().getName());
    assertEquals(3, insert.getColumns().size());
    assertEquals("col1", ((Column) insert.getColumns().get(0)).getColumnName());
    assertEquals("col2", ((Column) insert.getColumns().get(1)).getColumnName());
    assertEquals("col3", ((Column) insert.getColumns().get(2)).getColumnName());
    assertEquals(3, ((ExpressionList) insert.getItemsList()).getExpressions().size());
    assertTrue(((ExpressionList) insert.getItemsList()).getExpressions().get(0) instanceof JdbcParameter);
    assertEquals("sadfsd",
        ((StringValue) ((ExpressionList) insert.getItemsList()).getExpressions().get(1)).getValue());
    assertEquals(234, ((LongValue) ((ExpressionList) insert.getItemsList()).getExpressions().get(2)).getValue());
    assertEquals(statement, "" + insert);


    statement = "INSERT INTO myschema.mytable VALUES (?, ?, 2.3)";
    insert = (Insert) parserManager.parse(new StringReader(statement));
    assertEquals("myschema.mytable", insert.getTable().getFullyQualifiedName());
    assertEquals(3, ((ExpressionList) insert.getItemsList()).getExpressions().size());
    assertTrue(((ExpressionList) insert.getItemsList()).getExpressions().get(0) instanceof JdbcParameter);
    assertEquals(2.3, ((DoubleValue) ((ExpressionList) insert.getItemsList()).getExpressions().get(2)).getValue(),
        0.0);
    assertEquals(statement, "" + insert);


  }

View Full Code Here

     * @return at this point an int hardcoded to 1
     * @throws JSQLParserException
     */
    @SuppressWarnings("unchecked")
    private int handleInsert(String sql) throws JSQLParserException {
        Insert insert = (Insert) this.parserManager.parse(new StringReader(sql));
        String domain = this.getWriteTableName(insert.getTable());
        try {
            this.connection.getSimpleDB().createDomain(new CreateDomainRequest(domain));
        } catch (Exception e) {
            e.printStackTrace();
        }


        List<Column> columns = (List<Column>) insert.getColumns();
        List list = ((ExpressionList) insert.getItemsList()).getExpressions();


        List<ReplaceableAttribute> attributes = new ArrayList<ReplaceableAttribute>();
        int count = 0;
        String id = null;

View Full Code Here

        return returnval;
  }


  @SuppressWarnings("unchecked")
  private int handleInsert() throws JSQLParserException {
        Insert insert = (Insert) this.parserManager.parse(new StringReader(sql));
        String domain = insert.getTable().getName();


        try {
            this.connection.getSimpleDB().createDomain(new CreateDomainRequest(domain));
        } catch (Exception e) {
            e.printStackTrace();
        }


        List<Column> columns = (List<Column>) insert.getColumns();
        List<ReplaceableAttribute> attributes = new ArrayList<ReplaceableAttribute>();
        int count = 0;
        String id = null;


        for (Column column : columns) {

View Full Code Here

TOP

Related Classes of net.sf.jsqlparser.statement.insert.Insert

com.alimama.mdrill.jdbc.InsertParser

com.beacon50.jdbc.aws.SimpleDBPreparedStatement

com.beacon50.jdbc.aws.SimpleDBStatement

net.sf.jsqlparser.parser.CCJSqlParser

net.sf.jsqlparser.test.insert.InsertTest

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.