本文整理汇总了C#中SQLMake.SQLPlusScanner.readNextBlock方法的典型用法代码示例。如果您正苦于以下问题：C# SQLPlusScanner.readNextBlock方法的具体用法？C# SQLPlusScanner.readNextBlock怎么用？C# SQLPlusScanner.readNextBlock使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SQLMake.SQLPlusScanner的用法示例。
在下文中一共展示了SQLPlusScanner.readNextBlock方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: 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);
}示例2: 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);
}示例3: 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);
}示例4: 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);
}示例5: 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);
}示例6: 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);
}示例7: 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);
}示例8: 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);
}示例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: AlterTableAddConstraintCheckTest
public void AlterTableAddConstraintCheckTest()
{
StringReader sr = new StringReader(ResourceHelper.GetResourceString("AlterTableAddConstraintCheck"));
SQLMake.Util.Settings.loadSettings();
SQLPlusScanner scanner;
scanner = new SQLPlusScanner(sr, "AlterTableAddConstraintCheck");
scanner.readNextBlock();
Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
Assert.AreEqual("TABLE", scanner.currCommand.cmdName);
Assert.AreEqual("ALTER", scanner.currCommand.action);
Assert.AreEqual("SUPPLIERS", scanner.currCommand.objectName);
Assert.AreEqual("ADD CONSTRAINT", scanner.currCommand.alterType);
Assert.AreEqual("CHECK", scanner.currCommand.secondaryCmdName);
Assert.AreEqual("CHECK_SUPPLIER_NAME", scanner.currCommand.secondaryObjectName);
}示例11: AlterTableAddConstraintForeignTest
public void AlterTableAddConstraintForeignTest()
{
StringReader sr = new StringReader(ResourceHelper.GetResourceString("AlterTableAddConstraintForeign"));
SQLMake.Util.Settings.loadSettings();
SQLPlusScanner scanner;
scanner = new SQLPlusScanner(sr, "AlterTableAddConstraintForeign");
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("FOREIGN", scanner.currCommand.secondaryCmdName);
Assert.AreEqual("SCHOOL_FK", scanner.currCommand.secondaryObjectName);
}示例12: CreateControlFileTest
public void CreateControlFileTest()
{
StringReader sr = new StringReader(ResourceHelper.GetResourceString("CreateControlFile"));
SQLMake.Util.Settings.loadSettings();
SQLPlusScanner scanner;
scanner = new SQLPlusScanner(sr, "CreateControlFile");
scanner.readNextBlock();
Assert.AreEqual(CommandTypes.Sql, scanner.currCommand.cmdType);
Assert.AreEqual("CONTROLFILE", scanner.currCommand.cmdName);
Assert.AreEqual("CREATE", scanner.currCommand.action);
}示例13: 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);
}示例14: 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);
}示例15: 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);
}