[GitHub] [shardingsphere] tristaZero edited a comment on issue #7869: New independent SQLParserEngine is going online to parse SQL for different database dialects

[GitBox <gi...@apache.org>]

tristaZero edited a comment on issue #7869:
URL: https://github.com/apache/shardingsphere/issues/7869#issuecomment-720315491


   Hi,
   
   Thanks for everyone's feedback and opinions!
   Given the comments here, it looks that the second one is the most expectation. Hence, the following API is our final choice!
   ```java
   public static void main(String[] args) {
       String dbType = "MySQL";
       String visitorType = "SQLStatement";
       boolean useCache = true;
       
       String sql1 = "select * from tb1";
       String sql2 = "select * from tb2";
   
       // Way2
       SQLParserEngine parser = new SQLParserEngine(dbType);
       SQLVisitorEngine visitor = new SQLVisitorEngine(dbType,  visitorType);
       
       SQLStatement result1 = visitor.visit(parser.parse(sql1,  useCache));
       SQLStatement result2 = visitor.visit(parser.parse(sql2,  useCache));
   }
   ```
   I will finish this modification ASAP and re-prepare our incoming 5.0.0-alpha release. Please wait for my updates.
   
   Best,
   Trista


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org