本文整理汇总了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;未经允许,请勿转载。 |
请发表评论