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

Examples of com.alibaba.druid.sql.dialect.sqlserver.parser.SQLServerStatementParser.parseStatementList()

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
43
44
45
46
47
48
49
50
51
52
53
                     + "[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
29
30
31
32
33
34
35
36
37
38
39
        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
40
41
42
43
44
45
46
47
48
49
50
                     + "    PROFILE_PICTURE_URI VARCHAR(767),"//
                     + "    USERNAME VARCHAR(255),"//
                     + ")";

        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
34
35
36
37
38
39
40
41
42
43
44
                     "SELECT ProductID,ProductName\n" + //
                     "FROM Products\n" + //
                     "WHERE Discontinued=No";

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

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

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
        String sql = "INSERT [dbo].[SurveyAnswer]([CustomerId], [QuestionId], [OptionId], [CreateTime], [LastUpdateTime]) VALUES (@0, @1, @2, @3, @4)";

        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
29
30
31
32
33
34
35
36
37
38
39
public class SQLServerAlterTableTest_0 extends TestCase {

    public void test_alter_first() throws Exception {
        String sql = "alter table st_jklsxxb enable constraint FK_ST_xxx_REFERENCE_ST_xxx";
        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLStatement stmt = parser.parseStatementList().get(0);
        parser.match(Token.EOF);

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
        stmt.accept(visitor);
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
    public void test_0() throws Exception {
        String sql = "CREATE NONCLUSTERED INDEX IX_SalesPerson_SalesQuota_SalesYTD" //
                     + "    ON Sales.SalesPerson (SalesQuota, SalesYTD);";

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

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

        Assert.assertEquals("CREATE NONCLUSTERED INDEX IX_SalesPerson_SalesQuota_SalesYTD" //
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
    public void test_sqlserver() throws Exception {
        String sql = "select fname, count(*) from t where fid = 1 group by fname order by 1";

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

        List<Object> parameters = new ArrayList<Object>();
        MSSQLServerExportParameterVisitor visitor = new MSSQLServerExportParameterVisitor(parameters);
        stmt.accept(visitor);
       
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
public class SQLServerDropIndex_Test extends TestCase {

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

        SQLServerSchemaStatVisitor visitor = new SQLServerSchemaStatVisitor();
        stmt.accept(visitor);
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.