public void DeleteDatabase_DeletesDatabase()
{
var databaseManager = new SqlServerDatabaseManager(connectionStringBuilder.ConnectionString, true);
SqlServerDatabase createdDatabase = createRandomDatabase(databaseManager);
databaseManager.DeleteDatabase(createdDatabase.Name);
Assert.IsFalse(databaseExists(createdDatabase.Name));
}
public void CreateDatabase_CreatesDatabase()
{
var databaseManager = new SqlServerDatabaseManager(connectionStringBuilder.ConnectionString, true);
SqlServerDatabase createdDatabase = createRandomDatabase(databaseManager);
Assert.IsNotNull(createdDatabase);
Assert.IsTrue(databaseExists(createdDatabase.Name));
deleteAllDatabases();
}
public static async Task RunOperationOnSmoDatabaseAsync(Func <Database, Task> asyncAction, string connectionString, SqlInfoMessageEventHandler infoMessageCallback = null)
{
async Task ConnectionAction(SqlConnection connection)
{
await RunOperationOnSmoDatabaseAsync(asyncAction, connection);
}
await SqlServerDatabaseManager.RunOperationOnSqlConnectionAsync(ConnectionAction, connectionString, infoMessageCallback);
}
public void GetAllDatabases_GetsAllDatabases()
{
var databaseManager = new SqlServerDatabaseManager(connectionStringBuilder.ConnectionString, true);
var createdDatabases = new List<SqlServerDatabase>();
for (int i = 0; i < 10; i++) {
createdDatabases.Add(createRandomDatabase(databaseManager));
}
IEnumerable<SqlServerDatabase> databases = databaseManager.GetAllDatabases();
Assert.IsTrue(databases.Any());
deleteAllDatabases();
}
/// <inheritdoc />
public void Execute(
DeleteDatabaseOp operation)
{
operation.MustForArg(nameof(operation)).NotBeNull();
// Change to master database since it is guaranteed to be there.
var connectionString = this.sqlServerLocator
.DeepCloneWithDatabaseName(SqlServerDatabaseManager.MasterDatabaseName)
.BuildConnectionString(this.defaultConnectionTimeout);
SqlServerDatabaseManager.Delete(connectionString, operation.DatabaseName, this.defaultCommandTimeout);
}
public void UpdateDatabase_UpdatesDatabase()
{
var databaseManager = new SqlServerDatabaseManager(connectionStringBuilder.ConnectionString, true);
SqlServerDatabase createdDatabase = createRandomDatabase(databaseManager);
string newDescription = DateTime.Now.ToFileTimeUtc().ToString();
databaseManager.UpdateDatabaseDescription(createdDatabase.Name, newDescription);
SqlServerDatabase updatedDatabase = databaseManager.GetDatabase(createdDatabase.Name);
databaseManager.DeleteDatabase(createdDatabase.Name);
Assert.AreEqual(createdDatabase.Description, updatedDatabase.Description);
deleteAllDatabases();
}
public void Retrieve___Should_do_something___When_called()
{
var sqlServerLocator = new SqlServerLocator("localhost", "Streams", "sa", "password", "SQLDEV2017");
var connectionString = sqlServerLocator.BuildConnectionString(TimeSpan.FromSeconds(100));
var output = SqlServerDatabaseManager.Retrieve(connectionString);
output.MustForTest().NotBeNull();
var jsonSerializer = new ObcJsonSerializer();
var json = jsonSerializer.SerializeToString(output);
this.testOutputHelper.WriteLine(json);
}
public void GetDatabase_GetsDatabase()
{
var databaseManager = new SqlServerDatabaseManager(connectionStringBuilder.ConnectionString, true);
var createdDatabases = new List<SqlServerDatabase>();
for (int i = 0; i < 10; i++) {
createdDatabases.Add(createRandomDatabase(databaseManager));
}
SqlServerDatabase databaseToFind = createdDatabases[new Random().Next(0, createdDatabases.Count - 1)];
SqlServerDatabase databaseFound = databaseManager.GetDatabase(databaseToFind.Name);
Assert.AreEqual(databaseToFind.Name, databaseFound.Name);
Assert.AreEqual(databaseToFind.Description, databaseFound.Description);
deleteAllDatabases();
}
/// <inheritdoc />
public void Execute(
CreateDatabaseOp operation)
{
operation.MustForArg(nameof(operation)).NotBeNull();
// Change to master database since it is guaranteed to be there.
var connectionString = this.sqlServerLocator
.DeepCloneWithDatabaseName(SqlServerDatabaseManager.MasterDatabaseName)
.BuildConnectionString(this.defaultConnectionTimeout);
var sqlServerDatabaseDefinition = operation.Definition as SqlServerDatabaseDefinition;
sqlServerDatabaseDefinition
.MustForArg(Invariant($"{nameof(operation)}.{nameof(operation.Definition)}"))
.NotBeNull(Invariant($"Only supporting: {typeof(SqlServerDatabaseDefinition).ToStringReadable()}."));
SqlServerDatabaseManager.Create(connectionString, sqlServerDatabaseDefinition, operation.ExistingDatabaseStrategy, this.defaultCommandTimeout);
}
public DatabasesController(SqlServerDatabaseManager databaseManager)
{
this.databaseManager = databaseManager;
}
private void deleteAllDatabases()
{
var databaseManager = new SqlServerDatabaseManager(connectionStringBuilder.ConnectionString, true);
foreach (SqlServerDatabase database in databaseManager.GetAllDatabases()) {
databaseManager.DeleteDatabase(database.Name);
}
}
