use of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser 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);
}
use of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser 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);
}
use of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser in project druid by alibaba.
the class DMLDeleteParserTest method testDelete_8.
public void testDelete_8() throws Exception {
String sql = "deLetE from t1";
MySqlStatementParser parser = new MySqlStatementParser(sql);
SQLStatement stmt = parser.parseStatementList().get(0);
parser.match(Token.EOF);
String output = SQLUtils.toMySqlString(stmt);
Assert.assertEquals("DELETE FROM t1", output);
}
use of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser in project druid by alibaba.
the class DMLDeleteParserTest method testDelete_4.
public void testDelete_4() throws Exception {
String sql = "deLetE from id where col1='adf' ordEr by d liMit ? offset 2";
MySqlStatementParser parser = new MySqlStatementParser(sql);
SQLStatement stmt = parser.parseStatementList().get(0);
parser.match(Token.EOF);
String output = SQLUtils.toMySqlString(stmt);
Assert.assertEquals(//
"DELETE FROM id\n" + //
"WHERE col1 = 'adf'\n" + //
"ORDER BY d\n" + "LIMIT 2, ?", output);
}
use of com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser in project druid by alibaba.
the class DMLDeleteParserTest method testDelete_10.
public void testDelete_10() throws Exception {
String sql = "deLetE quick tb1.*,id1.t from t1";
MySqlStatementParser parser = new MySqlStatementParser(sql);
SQLStatement stmt = parser.parseStatementList().get(0);
parser.match(Token.EOF);
String output = SQLUtils.toMySqlString(stmt);
Assert.assertEquals("DELETE QUICK tb1.*, id1.t\n" + "FROM t1", output);
}
Aggregations