Examples with MySqlStatementParser com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser used on opensource projects

Example 16 with MySqlStatementParser

use of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser in project druid by alibaba.

the class Bug_for_weizhi method test_for_issue.

public void test_for_issue() throws Exception {
    String sql = "insert into aaa values(1,2,'这是个反斜杠\\\\');";
    String expected = "INSERT INTO aaa\nVALUES (1, 2, '这是个反斜杠\\\\');";
    StringBuilder out = new StringBuilder();
    MySqlOutputVisitor visitor = new MySqlOutputVisitor(out);
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    for (SQLStatement statement : statementList) {
        statement.accept(visitor);
        visitor.print(";");
    }
    System.out.println(out.toString());
    Assert.assertEquals(expected, out.toString());
}

Example 17 with MySqlStatementParser

use of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser in project druid by alibaba.

the class MySqlPerfMain_visitor method perfMySql.

static long perfMySql(String sql) {
    long startYGC = TestUtils.getYoungGC();
    long startYGCTime = TestUtils.getYoungGCTime();
    long startFGC = TestUtils.getFullGC();
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    long startMillis = System.currentTimeMillis();
    for (int i = 0; i < 1000 * 1000 * 1; ++i) {
        execMySql(statementList);
    }
    long millis = System.currentTimeMillis() - startMillis;
    long ygc = TestUtils.getYoungGC() - startYGC;
    long ygct = TestUtils.getYoungGCTime() - startYGCTime;
    long fgc = TestUtils.getFullGC() - startFGC;
    System.out.println("MySql\t" + millis + ", ygc " + ygc + ", ygct " + ygct + ", fgc " + fgc);
    return millis;
}

Example 18 with MySqlStatementParser

use of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser in project druid by alibaba.

the class MySqlPerfTest method execMySql.

private String execMySql(String sql) {
    StringBuilder out = new StringBuilder();
    MySqlOutputVisitor visitor = new MySqlOutputVisitor(out);
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    // }
    return out.toString();
}

Example 19 with MySqlStatementParser

use of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser in project druid by alibaba.

the class DALParserTest method test_show_character_set_2.

public void test_show_character_set_2() throws Exception {
    String sql = "SHOW CHARACTER SET";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    MySqlShowCharacterSetStatement show = (MySqlShowCharacterSetStatement) parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toMySqlString(show);
    Assert.assertEquals("SHOW CHARACTER SET", output);
}

Example 20 with MySqlStatementParser

use of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser in project druid by alibaba.

the class DALParserTest method test_show_errors_1.

public void test_show_errors_1() throws Exception {
    String sql = "SHOW ERRORS";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    MySqlShowErrorsStatement show = (MySqlShowErrorsStatement) parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toMySqlString(show);
    Assert.assertEquals("SHOW ERRORS", output);
}