public void CheckIfExistsDatabaseTask() { //Arrange //Act & Assert Assert.Throws <ETLBoxException>(() => { IfDatabaseExistsTask.IsExisting("test"); }); }
public void IfDatabaseExists(IConnectionManager connection) { //Arrange string dbName = ("ETLBox_" + HashHelper.RandomString(10)).ToLower(); var existsBefore = IfDatabaseExistsTask.IsExisting(connection, dbName); //Act SqlTask.ExecuteNonQuery(connection, "Create DB", $"CREATE DATABASE {dbName}"); var existsAfter = IfDatabaseExistsTask.IsExisting(connection, dbName); //Assert Assert.False(existsBefore); Assert.True(existsAfter); //Cleanup DropDatabaseTask.Drop(connection, dbName); }
public void Drop(IConnectionManager connection) { //Arrange string dbName = "ETLBox_" + TestHashHelper.RandomString(10); CreateDatabaseTask.Create(connection, dbName); bool existsBefore = IfDatabaseExistsTask.IsExisting(connection, dbName); //Act DropDatabaseTask.Drop(connection, dbName); //Assert bool existsAfter = IfDatabaseExistsTask.IsExisting(connection, dbName); Assert.True(existsBefore); Assert.False(existsAfter); }
public void NotSupportedWithSQLite() { Assert.Throws <ETLBoxNotSupportedException>( () => IfDatabaseExistsTask.IsExisting(Config.SQLiteConnection.ConnectionManager("ControlFlow"), "Test") ); }