Package com.alibaba.druid.sql.dialect.sqlserver.parser

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

30
31
32
33
34
35
36
37
38
39
40
41
        String expect = "INSERT INTO Production.UnitMeasure" + //
                        "\nVALUES" + //
                        "\n(N'F2', N'Square Feet', GETDATE())";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
44
public class SQLServerCreateIndexTest extends TestCase {

    public void test_0() throws Exception {
        String sql = "CREATE UNIQUE INDEX [unique_schema_migrations] ON [schema_migrations] ([version])";

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

        Assert.assertEquals(1, statementList.size());
       
        Assert.assertEquals("CREATE UNIQUE INDEX [unique_schema_migrations] ON [schema_migrations] ([version])", //
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
                        "\n\t\tAND a.time_add >= 2" + //
                        "\n\t\tAND a.time_add <= 3" + //
                        "\n\t) a" + //
                        "\nWHERE a.ROW BETWEEN 10 + 2 AND 20";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
public class SQLServerSetTest extends TestCase {

    public void test_0() {
        String sql = "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED";

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

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

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
67
    }

    public void test_1() {
        String sql = "SET FMTONLY ON";

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

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

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
    }

    public void test_2() {
        String sql = "SET STATISTICS XML OFF";

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

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

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
109
    }

    public void test_3() {
        String sql = "SET @state = N'Oregon'";

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

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

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
        String expect = "SELECT GEN_VAL" + //
                        "\nFROM ID_GENERATOR WITH (updlock, rowlock)" + //
                        "\nWHERE GEN_NAME = 'T_USERS'";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
                     + "[profile_id] int, " //
                     + "[language] NVARCHAR(5), "//
                     + "[copy_resource_id] int, "//
                     + "[long_name] NVARCHAR(256)) ";

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

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

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
        String sql = "SELECT name, password_hash FROM [master].[sys].sql_logins";

        String expect = "SELECT name, password_hash\n" + //
                        "FROM [master].[sys].sql_logins";

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

        String text = TestUtils.outputSqlServer(stmt);

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

Related Classes of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser

  • com.alibaba.druid.bvt.sql.sqlserver.MSSQLServerExportParameterVisitorTest
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_0
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_1
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_10
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_11
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_2
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_3
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_4
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_5
  • com.alibaba.druid.bvt.sql.sqlserver.SQLServerAlterTableTest_6
    • Copyright © 2018 www.massapicom. 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.