Examples with SQLStatement com.alibaba.druid.sql.ast.SQLStatement used on opensource projects

Example 66 with SQLStatement

use of com.alibaba.druid.sql.ast.SQLStatement in project druid by alibaba.

the class DMLReplaceParserTest method testReplace_1.

public void testReplace_1() throws Exception {
    String sql = "ReplaCe   test.t1 seT t1.id1:=? ";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toMySqlString(stmt);
    Assert.assertEquals("REPLACE INTO test.t1 (t1.id1)\nVALUES (?)", output);
}

Example 67 with SQLStatement

use of com.alibaba.druid.sql.ast.SQLStatement in project druid by alibaba.

the class DMLReplaceParserTest method testReplace_6.

public void testReplace_6() throws Exception {
    String sql = "ReplaCe LOW_PRIORITY t1 (select id from t1) ";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toMySqlString(stmt);
    Assert.assertEquals("REPLACE LOW_PRIORITY INTO t1\n\tSELECT id\n\tFROM t1", output);
}

Example 68 with SQLStatement

use of com.alibaba.druid.sql.ast.SQLStatement in project druid by alibaba.

the class DMLReplaceParserTest method testReplace_10.

public void testReplace_10() throws Exception {
    String sql = "replace LOW_PRIORITY  intO t1 (col1) ( select id from t3) ";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toMySqlString(stmt);
    Assert.assertEquals("REPLACE LOW_PRIORITY INTO t1 (col1)\n\tSELECT id\n\tFROM t3", output);
}

Example 69 with SQLStatement

use of com.alibaba.druid.sql.ast.SQLStatement in project druid by alibaba.

the class DMLCallParserTest method testCall_0.

public void testCall_0() throws Exception {
    String sql = "call p(?,?)";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toMySqlString(stmt);
    Assert.assertEquals("CALL p(?, ?)", output);
}

Example 70 with SQLStatement

use of com.alibaba.druid.sql.ast.SQLStatement in project druid by alibaba.

the class DMLCallParserTest method testCall_1.

public void testCall_1() throws Exception {
    String sql = "call p(@var1,'@var2',var3)";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toMySqlString(stmt);
    Assert.assertEquals("CALL p(@var1, '@var2', var3)", output);
}