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

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

39
40
41
42
43
44
45
46
47
48
49
50
                     + "    PROFILE_PAGE_URI VARCHAR(767),"//
                     + "    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
33
34
35
36
37
38
39
40
41
42
43
44
        String sql = "CREATE VIEW [Current Product List] AS\n" + //
                     "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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
public class SQLServerInsertTest6 extends TestCase {

    public void test() throws Exception {
        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
28
29
30
31
32
33
34
35
36
37
38
39
40
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);

        System.out.println("Tables : " + visitor.getTables());
View Full Code Here
14
15
16
17
18
19
20
21
22
23
24
25
public class MSSQLServerExportParameterVisitorTest extends TestCase {

    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
28
29
30
31
32
33
34
35
36
37
38
39
40
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);

        System.out.println("Tables : " + visitor.getTables());
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
42
        String expect = "INSERT INTO Cities" + //
                        "\n\t(Location)" + //
                        "\nVALUES" + //
                        "\n(dbo.CreateNewPoint(x, y))";

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

        String text = TestUtils.outputSqlServer(stmt);

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

    public void test_alter_first() throws Exception {
        String sql = "ALTER TABLE MyTable ALTER COLUMN NullCOl NVARCHAR(20) NOT NULL";
        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
32
33
34
35
36
37
38
39
40
41
42
43
                        "\tFROM master..syslogins\n" + //
                        "\tORDER BY name ASC\n" + //
                        "\t) sq\n" + //
                        "ORDER BY name DESC";

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

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
38
    public void test_isEmpty() throws Exception {
        String sql = "SELECT TOP 10 * FROM T";

        String expect = "SELECT TOP 10 *\nFROM T";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLSelectStatement stmt = (SQLSelectStatement) 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.