-
Notifications
You must be signed in to change notification settings - Fork 10
Expand file tree
/
Copy pathDropDatabaseTaskTests.cs
More file actions
59 lines (51 loc) · 2 KB
/
DropDatabaseTaskTests.cs
File metadata and controls
59 lines (51 loc) · 2 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
using ALE.ETLBox;
using ALE.ETLBox.Common;
using ALE.ETLBox.ControlFlow;
using TestControlFlowTasks.Fixtures;
namespace TestControlFlowTasks
{
[Collection(nameof(ControlFlowCollection))]
public class DropDatabaseTaskTests : ControlFlowTestBase
{
public DropDatabaseTaskTests(ControlFlowDatabaseFixture fixture)
: base(fixture) { }
[Theory, MemberData(nameof(DbConnectionTypesWithMaster))]
public void Drop(string dbType)
{
//Arrange
using var connection = CreateConnectionManager(dbType);
string dbName = "ETLBox_" + HashHelper.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);
}
[Theory, MemberData(nameof(DbConnectionTypesWithMaster))]
public void DropIfExists(string dbType)
{
//Arrange
using var connection = CreateConnectionManager(dbType);
string dbName = "ETLBox_" + HashHelper.RandomString(10);
DropDatabaseTask.DropIfExists(connection, dbName);
CreateDatabaseTask.Create(connection, dbName);
bool existsBefore = IfDatabaseExistsTask.IsExisting(connection, dbName);
//Act
DropDatabaseTask.DropIfExists(connection, dbName);
//Assert
bool existsAfter = IfDatabaseExistsTask.IsExisting(connection, dbName);
Assert.True(existsBefore);
Assert.False(existsAfter);
}
[Fact]
public void NotSupportedWithSQLite()
{
Assert.Throws<ETLBoxNotSupportedException>(
() => DropDatabaseTask.Drop(SqliteConnection, "Test")
);
}
}
}