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