Examples with SQLStatementParser com.alibaba.druid.sql.parser.SQLStatementParser used on opensource projects

Example 16 with SQLStatementParser

use of com.alibaba.druid.sql.parser.SQLStatementParser in project druid by alibaba.

the class BitFunctionsTest method test_3.

public void test_3() throws Exception {
    String sql = "SELECT 1 ^ 0";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT 1 ^ 0;", text);
}

Example 17 with SQLStatementParser

use of com.alibaba.druid.sql.parser.SQLStatementParser in project druid by alibaba.

the class ControlFlowFunctionsTest method test_2.

public void test_2() throws Exception {
    String sql = "SELECT IF(1<2,'yes','no');";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT IF(1 < 2, 'yes', 'no');", text);
}

Example 18 with SQLStatementParser

use of com.alibaba.druid.sql.parser.SQLStatementParser in project druid by alibaba.

the class DateAndTimeFunctionsTest method test_44.

public void test_44() throws Exception {
    String sql = "SELECT TIMESTAMPADD(WEEK,1,'2003-01-02');";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT TIMESTAMPADD(WEEK, 1, '2003-01-02');", text);
}

Example 19 with SQLStatementParser

use of com.alibaba.druid.sql.parser.SQLStatementParser in project druid by alibaba.

the class DateAndTimeFunctionsTest method test_36.

public void test_36() throws Exception {
    String sql = "SELECT FROM_UNIXTIME(1196440219) + 0;";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT FROM_UNIXTIME(1196440219) + 0;", text);
}

Example 20 with SQLStatementParser

use of com.alibaba.druid.sql.parser.SQLStatementParser in project druid by alibaba.

the class DateAndTimeFunctionsTest method test_28.

public void test_28() throws Exception {
    String sql = "SELECT INTERVAL '1.999999' SECOND_MICROSECOND;";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT INTERVAL '1.999999' SECOND_MICROSECOND;", text);
}