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

Example 41 with SQLStatementParser

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

the class ArithmeticOperatorsTest method test_8.

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

Example 42 with SQLStatementParser

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

the class ArithmeticOperatorsTest method test_7.

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

Example 43 with SQLStatementParser

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

the class ArithmeticOperatorsTest method test_9.

public void test_9() throws Exception {
    String sql = "SELECT a + b + c;";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT a + b + c;", text);
}

Example 44 with SQLStatementParser

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

the class ComparisonFunctionsAndOperatorsTest method test_0.

public void test_0() 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 45 with SQLStatementParser

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

the class ComparisonFunctionsAndOperatorsTest method test_19.

public void test_19() throws Exception {
    String sql = "SELECT GREATEST('B', 'A', 'C');";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT GREATEST('B', 'A', 'C');", text);
}