public void OracleObjectName() { TestUtility.CheckDatabaseAvailability("Oracle"); TestUtility.ShouldFail(() => SqlUtility.GetSchemaName("someview"), "Missing schema"); Assert.AreEqual("someview", SqlUtility.GetShortName("someview")); }
public void MsSqlObjectName() { TestUtility.CheckDatabaseAvailability("MsSql"); Assert.AreEqual("dbo", SqlUtility.GetSchemaName("someview")); Assert.AreEqual("someview", SqlUtility.GetShortName("someview")); }
public void CheckDatabaseIsOracle() { // Creating empty Rhetos DI scope just to initialize static utilities that are required for test in this class. using (var scope = TestScope.Create()) Assert.IsNotNull(SqlUtility.ConnectionString); TestUtility.CheckDatabaseAvailability("Oracle"); }
public void SqlObjectName() { TestUtility.CheckDatabaseAvailability(); Assert.AreEqual("someschema", SqlUtility.GetSchemaName("someschema.someview")); Assert.AreEqual("someview", SqlUtility.GetShortName("someschema.someview")); TestUtility.ShouldFail(() => SqlUtility.GetShortName("a.b.c"), "Invalid database object name"); TestUtility.ShouldFail(() => SqlUtility.GetShortName("a."), "Invalid database object name"); }
public void ChecklDatabaseAvailability() { var configuration = new ConfigurationBuilder(new ConsoleLogProvider()) .AddConfigurationManagerConfiguration() .Build(); LegacyUtilities.Initialize(configuration); TestUtility.CheckDatabaseAvailability("MsSql"); }
public static void DropRhetosUnitTestSchema() { try { TestUtility.CheckDatabaseAvailability("MsSql"); } catch { return; } NewSqlExecuter().ExecuteSql(new[] { @"DECLARE @sql NVARCHAR(MAX) SET @sql = '' SELECT @sql = @sql + 'DROP TABLE RhetosUnitTest.' + QUOTENAME(name) + ';' + CHAR(13) + CHAR(10) FROM sys.tables WHERE schema_id = SCHEMA_ID('RhetosUnitTest') EXEC (@sql)", "IF SCHEMA_ID('RhetosUnitTest') IS NOT NULL DROP SCHEMA RhetosUnitTest" }); }
public static void MyTestCleanup() { try { TestUtility.CheckDatabaseAvailability("Oracle"); } catch { return; } GetSqlExecuter().ExecuteSql(new[] { @"declare c integer; begin select count(*) into c from SYS.user$ where Name = 'RHETOSUNITTEST'; if c = 1 then BEGIN EXECUTE IMMEDIATE ('drop user ""RHETOSUNITTEST"" CASCADE'); END; end if; end;" }); }
public void ChecklDatabaseAvailability() { TestUtility.CheckDatabaseAvailability("MsSql"); }
public void CheckDatabaseAvailability() { TestUtility.CheckDatabaseAvailability("Oracle"); }