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

Example 66 with SQLStatementParser

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

the class LogicalOperatorsTest method test_0.

public void test_0() throws Exception {
    String sql = "SELECT 10 IS TRUE;";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT 10 IS true;", text);
}

Example 67 with SQLStatementParser

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

the class LogicalOperatorsTest method test_9.

public void test_9() throws Exception {
    String sql = "SELECT 1 AND NULL;";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT 1\n\tAND NULL;", text);
}

Example 68 with SQLStatementParser

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

the class LogicalOperatorsTest method test_3.

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

Example 69 with SQLStatementParser

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

the class LogicalOperatorsTest method test_10.

public void test_10() throws Exception {
    String sql = "SELECT 0 OR NULL;";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT 0\n\tOR NULL;", text);
}

Example 70 with SQLStatementParser

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

the class LogicalOperatorsTest method test_1.

public void test_1() throws Exception {
    String sql = "SELECT -10 IS TRUE;";
    SQLStatementParser parser = new MySqlStatementParser(sql);
    List<SQLStatement> stmtList = parser.parseStatementList();
    String text = output(stmtList);
    Assert.assertEquals("SELECT -10 IS true;", text);
}