• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# SQLMake.SQLPlusScanner类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中SQLMake.SQLPlusScanner的典型用法代码示例。如果您正苦于以下问题:C# SQLPlusScanner类的具体用法?C# SQLPlusScanner怎么用?C# SQLPlusScanner使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



SQLPlusScanner类属于SQLMake命名空间,在下文中一共展示了SQLPlusScanner类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: DropContextTest

        public void DropContextTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("DropContext"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "DropContext");
            scanner.readNextBlock();

            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("CONTEXT", scanner.currCommand.cmdName);
            Assert.AreEqual("DROP", scanner.currCommand.action);
            Assert.AreEqual("HR_CONTEXT", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerDropStatementsTest.cs


示例2: CreateClusterTest

        public void CreateClusterTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateCluster"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateCluster");
            scanner.readNextBlock();

            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("CLUSTER", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE", scanner.currCommand.action);
            Assert.AreEqual("PERSONNEL", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例3: CreateBitmapIndexTest

        public void CreateBitmapIndexTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateBitmapIndex"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateBitmapIndex");

            scanner.readNextBlock();
            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("BITMAP INDEX", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE", scanner.currCommand.action);
            Assert.AreEqual("PRODUCT_BM_IX", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例4: AnalyzeTableTest

        public void AnalyzeTableTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("AnalyzeTable"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "AnalyzeTable");
            scanner.readNextBlock();

            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("TABLE", scanner.currCommand.cmdName);
            Assert.AreEqual("ANALYZE", scanner.currCommand.action);
            Assert.AreEqual("HR.ORDERS", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SqlPlusScannerOtherStatementsTest.cs


示例5: AlterDatabaseTest

        public void AlterDatabaseTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("AlterDatabase"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "AlterDatabase");
            scanner.readNextBlock();

            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("DATABASE", scanner.currCommand.cmdName);
            Assert.AreEqual("ALTER", scanner.currCommand.action);
            Assert.AreEqual("", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerAlterStatementsTest.cs


示例6: DropDatabaseLinkTest

        public void DropDatabaseLinkTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("DropDatabaseLink"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "DropDatabaseLink");
            scanner.readNextBlock();

            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("DATABASE LINK", scanner.currCommand.cmdName);
            Assert.AreEqual("DROP", scanner.currCommand.action);
            Assert.AreEqual("REMOTE", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerDropStatementsTest.cs


示例7: CreateBigfileTablespaceTest

        public void CreateBigfileTablespaceTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateBigfileTablespace"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateBigfileTablespace");

            scanner.readNextBlock();
            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("BIGFILE TABLESPACE", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE", scanner.currCommand.action);
            Assert.AreEqual("BIGTBS_01", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例8: DeleteTableCollectionTest

        public void DeleteTableCollectionTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("DeleteTableCollection"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "DeleteTableCollection");
            scanner.readNextBlock();

            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("", scanner.currCommand.cmdName);
            Assert.AreEqual("DELETE", scanner.currCommand.action);
            Assert.AreEqual("[TABLE COLLECTION]", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerDmlTest.cs


示例9: WrappedPackageBodyTest

        public void WrappedPackageBodyTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("WrappedPackageBody"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "WrappedPackageBody");
            scanner.readNextBlock();

            Assert.AreEqual(CommandTypes.Plsql, scanner.currCommand.cmdType);
            Assert.AreEqual("PACKAGE BODY", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE OR REPLACE", scanner.currCommand.action);
            Assert.AreEqual("ZBLJ", scanner.currCommand.objectName);
            Assert.AreEqual(8, scanner.tokenCountWithoutComments);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:15,代码来源:SQLPlusScannerWrappedPlsqlTest.cs


示例10: AlterTableAddConstraintPrimaryTest

        public void AlterTableAddConstraintPrimaryTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("AlterTableAddConstraintPrimary"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "AlterTableAddConstraintPrimary");
            scanner.readNextBlock();

            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("TABLE", scanner.currCommand.cmdName);
            Assert.AreEqual("ALTER", scanner.currCommand.action);
            Assert.AreEqual("STUDENTS", scanner.currCommand.objectName);
            Assert.AreEqual("ADD CONSTRAINT", scanner.currCommand.alterType);
            Assert.AreEqual("PRIMARY", scanner.currCommand.secondaryCmdName);
            Assert.AreEqual("STUDENTS_PK", scanner.currCommand.secondaryObjectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:17,代码来源:SQLPlusScannerConstraints.cs


示例11: CreateSynonymTest

        public void CreateSynonymTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateSynonym"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateSynonym");

            scanner.readNextBlock();
            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("SYNONYM", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE OR REPLACE", scanner.currCommand.action);
            Assert.AreEqual("OFFICES", scanner.currCommand.objectName);
            Assert.AreEqual("HR.LOCATIONS", scanner.currCommand.secondaryObjectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:15,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例12: CreateSharedPublicDatabaseLinkTest

        public void CreateSharedPublicDatabaseLinkTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateSharedPublicDatabaseLink"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateSharedPublicDatabaseLink");

            scanner.readNextBlock();
            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("SHARED PUBLIC DATABASE LINK", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE", scanner.currCommand.action);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:13,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例13: CreateSequenceTest

        public void CreateSequenceTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateSequence"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateSequence");

            scanner.readNextBlock();
            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("SEQUENCE", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE", scanner.currCommand.action);
            Assert.AreEqual("CUSTOMERS_SEQ", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例14: CreateRollbackSegmentTest

        public void CreateRollbackSegmentTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateRollbackSegment"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateRollbackSegment");

            scanner.readNextBlock();
            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("ROLLBACK SEGMENT", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE", scanner.currCommand.action);
            Assert.AreEqual("RBS_ONE", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例15: CreateGlobalTemporaryTableTest

        public void CreateGlobalTemporaryTableTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateGlobalTemporaryTable"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateGlobalTemporaryTable");

            scanner.readNextBlock();
            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("GLOBAL TEMPORARY TABLE", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE", scanner.currCommand.action);
            Assert.AreEqual("TODAY_SALES", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例16: WrappedTypeTest

        public void WrappedTypeTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("WrappedType"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "WrappedType");
            scanner.readNextBlock();

            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("TYPE", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE", scanner.currCommand.action);
            Assert.AreEqual("SCHEMA_NAME.TYPE_NAME", scanner.currCommand.objectName);
            Assert.AreEqual(9, scanner.tokenCountWithoutComments);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:15,代码来源:SQLPlusScannerWrappedPlsqlTest.cs


示例17: CreateTypeTest

        public void CreateTypeTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateType"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateType");
            Assert.AreEqual("CREATE", scanner.get());
            Assert.AreEqual("TYPE", scanner.get());
            Assert.AreEqual("TEST", scanner.get());
            Assert.AreEqual("AS", scanner.get());
            Assert.AreEqual("OBJECT", scanner.get());
            Assert.AreEqual("(", scanner.get());
            Assert.AreEqual("A", scanner.get());
            Assert.AreEqual("NUMBER", scanner.get());
            Assert.AreEqual("(", scanner.get());
            Assert.AreEqual("1", scanner.get());
            Assert.AreEqual(")", scanner.get());
            Assert.AreEqual(")", scanner.get());

            try { scanner.get(); Assert.Fail(); }
            catch (EOBException)
            {
                Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
                Assert.AreEqual("TYPE", scanner.currCommand.cmdName);
                Assert.AreEqual("CREATE", scanner.currCommand.action);
            }
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:28,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例18: CreateProcedureTest

        public void CreateProcedureTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateProcedure"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateProcedure");

            scanner.readNextBlock();
            Assert.AreEqual(CommandTypes.Plsql, scanner.currCommand.cmdType);
            Assert.AreEqual("PROCEDURE", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE OR REPLACE", scanner.currCommand.action);
            Assert.AreEqual("REMOVE_EMP", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例19: CreateDiskgroupTest

        public void CreateDiskgroupTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateDiskgroup"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateDiskgroup");

            scanner.readNextBlock();
            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("DISKGROUP", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE", scanner.currCommand.action);
            Assert.AreEqual("DGROUP_01", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerCreateStatementsTest.cs


示例20: CreateFlashbackArchiveTest

        public void CreateFlashbackArchiveTest()
        {
            StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateFlashbackArchive"));
            SQLMake.Util.Settings.loadSettings();

            SQLPlusScanner scanner;
            scanner = new SQLPlusScanner(sr, "CreateFlashbackArchive");

            scanner.readNextBlock();
            Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
            Assert.AreEqual("FLASHBACK ARCHIVE", scanner.currCommand.cmdName);
            Assert.AreEqual("CREATE", scanner.currCommand.action);
            Assert.AreEqual("TEST_ARCHIVE1", scanner.currCommand.objectName);
        }
开发者ID:chadclan,项目名称:sqlmake,代码行数:14,代码来源:SQLPlusScannerCreateStatementsTest.cs



注:本文中的SQLMake.SQLPlusScanner类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# SQLite.SQLiteAsyncConnection类代码示例发布时间:2022-05-26
下一篇:
C# Definitions.WebPartDefinition类代码示例发布时间:2022-05-26
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap