本文整理汇总了C#中SQLMake.SQLPlusScanner类的典型用法代码示例。如果您正苦于以下问题：C# SQLPlusScanner类的具体用法？C# SQLPlusScanner怎么用？C# SQLPlusScanner使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SQLPlusScanner类属于SQLMake命名空间，在下文中一共展示了SQLPlusScanner类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的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);
}示例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);
}示例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);
}示例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);
}示例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);
}示例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);
}示例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);
}示例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);
}示例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);
}示例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);
}示例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);
}示例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);
}示例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);
}示例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);
}示例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);
}