Description

licai1210

opened on Apr 17, 2023

Issue body actions

Hello, this issue is normal in 4.4, and there is an inaccurate issue with dynamically adding fields in the insert statement in 4.5/4.6. May I know how to solve it? Thank you

Activity

1. manticore-projects commented on Apr 17, 2023

   

   manticore-projects

   on Apr 17, 2023

   Contributor

   More actions

   Greetings.

   A lots of API has changed between 4.4 and 4.6 in order to streamline VALUES (..) statements.
   The easiest way to figure out the AST is using JSQLFormatter, which can visualize the Tree of Java Objects:

   

   You can try it online here
2. licai1210 commented on Apr 18, 2023

   

   licai1210

   on Apr 18, 2023

   Author

   More actions

   Hello, I need to add field values to existing SQL statements. May I know how to proceed? Thank you
3. manticore-projects commented on Apr 18, 2023

   

   manticore-projects

   on Apr 18, 2023

   Contributor

   More actions

   Recommendation: Checkout PR #1754 which will allow for

       @Test
       void testIssue1765() {
           String sqlStr = "INSERT INTO mytable (col1)\n"
                           + "VALUES ( 1 )";
   
           Insert insert = new Insert()
                               .withTable( new Table("mytable") )
                               .withColumns( Arrays.asList(new Column("col1")) )
                               .withSelect( new Values().addExpressions(new LongValue(1)) );
   
           assertStatementCanBeDeparsedAs(insert, sqlStr,true);
       }
4. manticore-projects commented on Apr 18, 2023

   

   manticore-projects

   on Apr 18, 2023

   Contributor

   More actions

   If you use Release 4.6 then your code will look like this:

       @Test
       void testIssue1765() {
           String sqlStr = "INSERT INTO mytable (col1)\n"
                           + "VALUES ( 1 )";
   
           Select select = new Select()
                                   .withSelectBody( new ValuesStatement().addExpressions( new LongValue(1)) );
   
           Insert insert = new Insert()
                                   .withTable( new Table("mytable") )
                                   .withColumns( Arrays.asList(new Column("col1")) )
                                   .withSelect(  select );
   
           assertStatementCanBeDeparsedAs(insert, sqlStr,true);
       }
5. manticore-projects

   converted this issue into a discussion #1766 on Apr 18, 2023

Issue actions