Examples of SQLServerStatementParser

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

21
22
23
24
25
26
27
28
29
30
31
32
public class SQLServerDeclareTest extends TestCase {

    public void test_0() {
        String sql = "declare @is_updated bit";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        Assert.assertEquals(1, stmtList.size());

        String text = SQLUtils.toSQLString(stmtList, JdbcUtils.SQL_SERVER);
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

34
35
36
37
38
39
40
41
42
43
44
45
    }
   
    public void test_1() {
        String sql = "DECLARE @Group nvarchar(50), @Sales money=1;";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        Assert.assertEquals(1, stmtList.size());

        String text = SQLUtils.toSQLString(stmtList, JdbcUtils.SQL_SERVER);
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

47
48
49
50
51
52
53
54
55
56
57
58
    }
   
    public void test_2() {
        String sql = "DECLARE @cursor CURSOR";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        Assert.assertEquals(1, stmtList.size());

        String text = SQLUtils.toSQLString(stmtList, JdbcUtils.SQL_SERVER);
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

60
61
62
63
64
65
66
67
68
69
70
71
    }

    public void test_3() {
        String sql = "DECLARE @MyTableVar table( EmpID int NOT NULL, OldVacationHours int, NewVacationHours int, ModifiedDate datetime);";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();

        Assert.assertEquals(1, stmtList.size());

        String text = SQLUtils.toSQLString(stmtList, JdbcUtils.SQL_SERVER);
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

28
29
30
31
32
33
34
35
36
37
38
39
40
public class SQLServerAlterTableTest_9 extends TestCase {

    public void test_alter_first() throws Exception {
        String sql = "ALTER TABLE dbo.doc_exy ALTER COLUMN column_a DECIMAL (5, 2) ;";
        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
        stmt.accept(visitor);

        System.out.println("Tables : " + visitor.getTables());
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

30
31
32
33
34
35
36
37
38
39
40
41
                     "FROM Sales.SalesOrderDetail;";

        String expect = "SELECT AVG(UnitPrice) AS 'Average Price'" + //
                        "\nFROM Sales.SalesOrderDetail";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

28
29
30
31
32
33
34
35
36
37
38
39
40
public class SQLServerDropIndex_Test_2 extends TestCase {

    public void test_alter_first() throws Exception {
        String sql = "DROP INDEX IX_ProductVendor_VendorID     ON Purchasing.ProductVendor;";
        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
        stmt.accept(visitor);

        System.out.println("Tables : " + visitor.getTables());
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

28
29
30
31
32
33
34
35
36
37
38
39
    public void test_simple() throws Exception {
        String sql = "SELECT 1";

        String expect = "SELECT 1";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

33
34
35
36
37
38
39
40
41
42
43
44
public class SQLServerCreateTableTest_2 extends TestCase {

    public void test_0() throws Exception {
        String sql = "CREATE TABLE #Test (C1 nvarchar(10), C2 nvarchar(50), C3 datetime);";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLCreateTableStatement stmt = (SQLCreateTableStatement) statementList.get(0);

        Assert.assertEquals(1, statementList.size());

        String output = SQLUtils.toSQLString(stmt, JdbcConstants.SQL_SERVER);
View Full Code Here

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

30
31
32
33
34
35
36
37
38
39
40
41
42
43
public class SQLServerInsertTest7 extends TestCase {

    public void test_0() throws Exception {
        String sql = "INSERT Production.ScrapReason OUTPUT INSERTED.ScrapReasonID, INSERTED.Name, INSERTED.ModifiedDate INTO @MyTableVar VALUES (N'Operator error', GETDATE());";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        parser.setParseCompleteValues(false);
        parser.setParseValuesSize(3);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);

        SQLServerInsertStatement insertStmt = (SQLServerInsertStatement) stmt;

        Assert.assertEquals(1, insertStmt.getValuesList().size());
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.