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

Example 71 with SQLStatement

use of com.alibaba.druid.sql.ast.SQLStatement 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);
}

Example 72 with SQLStatement

use of com.alibaba.druid.sql.ast.SQLStatement 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);
}

Example 73 with SQLStatement

use of com.alibaba.druid.sql.ast.SQLStatement 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);
}

Example 74 with SQLStatement

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

the class DMLDeleteParserTest method testDelete_7.

public void testDelete_7() throws Exception {
    String sql = "deLetE from t1 where t1.id1='abc' order by a limit 5";
    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\n" + //
    "WHERE t1.id1 = 'abc'\n" + //
    "ORDER BY a\n" + "LIMIT 5", output);
}

Example 75 with SQLStatement

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

the class DMLDeleteParserTest method testDelete_2.

public void testDelete_2() throws Exception {
    String sql = "delete from offer.*,wp_image.* using offer a,wp_image b where a.member_id=b.member_id and a.member_id='abc' ";
    MySqlStatementParser parser = new MySqlStatementParser(sql);
    SQLStatement stmt = parser.parseStatementList().get(0);
    parser.match(Token.EOF);
    String output = SQLUtils.toMySqlString(stmt);
    Assert.assertEquals(//
    "DELETE FROM offer.*, wp_image.*" + //
    " USING (offer) AS a, wp_image b\n" + //
    "WHERE a.member_id = b.member_id\n" + "\tAND a.member_id = 'abc'", output);
}