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");
}
