public void GetConnectionString()
{
var options = new UniqueDbConnectionProviderOptions("server", "database");
var connectionProvider = new UniqueDbConnectionProvider(options);
var connectionString = connectionProvider.GetSqlConnectionString();
Console.WriteLine(connectionString);
}
public void GetConnectionString_WithUserNameAndPassword()
{
var options = new UniqueDbConnectionProviderOptions("server", "database", "user", "password");
var connectionProvider = new UniqueDbConnectionProvider(options);
var connectionString = connectionProvider.GetSqlConnectionString();
Console.WriteLine(connectionString);
}
public static UniqueDbConnectionProvider GetUniqueSqlConnectionProvider(
string databasePrefix = "UniqueDb")
{
var dbConnectionProvider = new UniqueDbConnectionProvider(
new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", databasePrefix))
.AndAutoDeleteDbOlderThan5Minutes();
return(dbConnectionProvider);
}
public void TestExecuteScalar()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
using (connectionProvider.ToSelfDeletingDisposable())
{
connectionProvider.CreateDatabase();
connectionProvider.ExecuteScalar <int>("Select 1");
}
}
public void TestExecute()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
using (connectionProvider.ToSelfDeletingDisposable())
{
connectionProvider.CreateDatabase();
connectionProvider.ExecuteNonDapper("Use [" + connectionProvider.DatabaseName + "]");
}
}
public static List <string> GetOldDatabasesFromUniqueDb(UniqueDbConnectionProvider uniqueDbConnectionProvider, TimeSpan olderThan)
{
var connection = uniqueDbConnectionProvider.ConnectionAsMaster();
var databases = connection
.Query <string>("SELECT NAME FROM SYSDATABASES")
.Where(x => x.StartsWith(uniqueDbConnectionProvider.Options.DatabaseNamePrefix))
.ToList();
var dateTimeFormat = uniqueDbConnectionProvider.Options.TimeStampFormat;
var databases1HourOrOlder = SelectDatabaseNamesOlderThan(databases, dateTimeFormat, olderThan);
return(databases1HourOrOlder.ToList());
}
public void CreateTableShouldWork()
{
ISqlConnectionProvider sourceSqlConnectionProvider = null;
UniqueDbConnectionProvider targetSqlConnectionProvider = null;
SqlTableReference sourceSqlTableReference = null;
SqlTableReference targetSqlTableReference = null;
"Given a blank target database"
._(() =>
{
targetSqlConnectionProvider =
new UniqueDbConnectionProvider(new UniqueDbConnectionProviderOptions(
"ws2012sqlexp1\\sqlexpress", "TableManipulationTests"));
targetSqlConnectionProvider.CreateDatabase();
});
using (targetSqlConnectionProvider.ToSelfDeletingDisposable())
{
"Given a source database and a new blank database"
._(() =>
{
sourceSqlConnectionProvider = SqlConnectionProviders.AdventureWorksDb;
});
"Given a source table to copy"
._(() =>
{
sourceSqlTableReference = new SqlTableReference(
sourceSqlConnectionProvider, "Person.Person");
});
"When copying the source table to the target db."
._(() =>
{
targetSqlTableReference = new SqlTableReference(
targetSqlConnectionProvider, "dbo.Person");
TableManipulation.CopyTableStructure(sourceSqlTableReference, targetSqlTableReference);
});
"Then there should be a copy of the table at the target DB"
._(() =>
{
var tableSchemas =
InformationSchemaMetadataExplorer.GetInformationSchemaTablesOnly(targetSqlConnectionProvider);
tableSchemas.Count.Should().Be(1);
tableSchemas[0].TABLE_NAME.Should().Be("Person");
});
}
}
public void ShouldDispose()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
"After creating a database"
._(() => connectionProvider.CreateDatabase());
"Disposing of the disposable provided by the ToSelfDeletingDisposable extension method should delete the database"
._(() =>
{
using (var lifecycle = connectionProvider.ToSelfDeletingDisposable())
{
var result = connectionProvider.ExecuteScalar <int>("SELECT 1 ");
}
});
}
public void ShouldDispose()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
"After creating a database"
._(() => connectionProvider.CreateDatabase());
using (var lifecycle = connectionProvider.ToSelfDeletingDisposable())
{
"Make sure the table doesn't exist"
._(() =>
{
var doesTableExist = connectionProvider.CheckTableExistence("dbo", "SimpleClass");
doesTableExist.Should().BeFalse();
});
"Create the table"
._(() =>
{
connectionProvider.EnsureTableExists <SimpleClass>("dbo", "SimpleClass");
});
"Make sure the table does exist"
._(() =>
{
var doesTableExist = connectionProvider.CheckTableExistence("dbo", "SimpleClass");
doesTableExist.Should().BeTrue();
});
"Truncate the table"
._(() =>
{
connectionProvider.TruncateTable("dbo", "SimpleClass");
});
"Delete the table"
._(() =>
{
connectionProvider.DropTable("dbo", "SimpleClass");
});
"Make sure the table doesn't exist"
._(() =>
{
var doesTableExist = connectionProvider.CheckTableExistence("dbo", "SimpleClass");
doesTableExist.Should().BeFalse();
});
}
}
public void DropTableShouldWork()
{
ISqlConnectionProvider sourceSqlConnectionProvider = null;
UniqueDbConnectionProvider targetSqlConnectionProvider = null;
SqlTableReference sourceSqlTableReference = null;
SqlTableReference targetSqlTableReference = null;
"Given a table to drop in the database."
._(() =>
{
targetSqlConnectionProvider =
new UniqueDbConnectionProvider(new UniqueDbConnectionProviderOptions(
"ws2012sqlexp1\\sqlexpress", "TableManipulationTests"));
targetSqlConnectionProvider.CreateDatabase();
sourceSqlConnectionProvider = SqlConnectionProviders.AdventureWorksDb;
sourceSqlTableReference = new SqlTableReference(
sourceSqlConnectionProvider, "Person.Person");
targetSqlTableReference = new SqlTableReference(
targetSqlConnectionProvider, "dbo.Person");
TableManipulation.CopyTableStructure(sourceSqlTableReference, targetSqlTableReference);
var tableSchemas =
InformationSchemaMetadataExplorer.GetInformationSchemaTablesOnly(targetSqlConnectionProvider);
tableSchemas.Count.Should().Be(1);
tableSchemas[0].TABLE_NAME.Should().Be("Person");
});
using (targetSqlConnectionProvider.ToSelfDeletingDisposable())
{
"When dropping the target table."
._(() =>
{
TableManipulation.DropTable(targetSqlTableReference);
});
"Then the table should be removed from the database."
._(() =>
{
var tableSchemas =
InformationSchemaMetadataExplorer.GetInformationSchemaTablesOnly(targetSqlConnectionProvider);
tableSchemas.Count.Should().Be(0);
});
}
}
public void IntegrationTest()
{
var databasePrefix = "OldDatabaseDeleterTests.IntegrationTest-" +
Guid.NewGuid().ToString("N").Substring(0, 8);
UniqueDbConnectionProvider uniqueDbProvider1 = null;
UniqueDbConnectionProvider uniqueDbProvider2 = null;
"Given two databases created 7 seconds apart"
._(() =>
{
uniqueDbProvider1 = new UniqueDbConnectionProvider(new UniqueDbConnectionProviderOptions(
TestingConstants.SqlServerInstance, databasePrefix));
uniqueDbProvider1.CreateDatabase();
Thread.Sleep(7000);
uniqueDbProvider2 = new UniqueDbConnectionProvider(new UniqueDbConnectionProviderOptions(
TestingConstants.SqlServerInstance, databasePrefix));
uniqueDbProvider2.CreateDatabase();
OldDatabaseDeleter.GetOldDatabasesFromUniqueDb(uniqueDbProvider1, TimeSpan.FromSeconds(0))
.Count.Should()
.Be(2);
});
"When we delete databases older than 7 seconds, we should delete the first of the two"
._(() =>
{
OldDatabaseDeleter.DeleteOldDatabases(uniqueDbProvider1, TimeSpan.FromSeconds(7));
OldDatabaseDeleter.GetOldDatabasesFromUniqueDb(uniqueDbProvider2, TimeSpan.FromSeconds(0))
.Count.Should()
.Be(1);
});
"Now let's delete all the datbases to clean up"
._(() =>
{
uniqueDbProvider2.AndAutoDeleteDbOlderThan(TimeSpan.FromSeconds(0));
OldDatabaseDeleter.GetOldDatabasesFromUniqueDb(uniqueDbProvider1, TimeSpan.FromSeconds(0))
.Count.Should()
.Be(0);
});
}
public void DoesDatabaseExist_Test()
{
var fixture = new Fixture();
var madeUpDatabaseName = fixture.Create <string>();
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
var doesMadeUpDatabaseExist = connectionProvider.DoesDatabaseExist(madeUpDatabaseName);
doesMadeUpDatabaseExist.Should().BeFalse();
var doesConnectionProviderDatabaseExist = connectionProvider.DoesDatabaseExist();
doesMadeUpDatabaseExist.Should().BeFalse();
var doesActualDatabaseExist = connectionProvider.DoesDatabaseExist("JobMgmt");
doesActualDatabaseExist.Should().BeTrue();
}
public void InsertSimpleClass()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
"After creating a database"
._(() => connectionProvider.CreateDatabase());
using (var lifecycle = connectionProvider.ToSelfDeletingDisposable())
{
BddStringExtensions._("Create the table", () =>
{
connectionProvider.EnsureTableExists <SimpleClass>("dbo", "SimpleClass");
});
BddStringExtensions._("Insert into the table", () =>
{
connectionProvider.Insert(SimpleClass.GetSample(), "SimpleClass");
});
}
}
public void SlowBulkInsertSimpleClass()
{
var options = new UniqueDbConnectionProviderOptions("ws2012sqlexp1\\sqlexpress", "autodisposedatabase");
var connectionProvider = new UniqueDbConnectionProvider(options);
"After creating a database"
._(() => connectionProvider.CreateDatabase());
using (var lifecycle = connectionProvider.ToSelfDeletingDisposable())
{
BddStringExtensions._("Create the table", () =>
{
connectionProvider.EnsureTableExists <SimpleClass>("dbo", "SimpleClass");
});
BddStringExtensions._("Insert into the table", () =>
{
var listOfSimpleClass = Enumerable.Range(0, 1000).Select(i => SimpleClass.GetSample()).ToList();
foreach (var simpleClass in listOfSimpleClass)
{
connectionProvider.Insert(simpleClass, "SimpleClass");
}
});
}
}
public static UniqueDbConnectionProvider AndAutoDeleteDbOlderThan(
this UniqueDbConnectionProvider uniqueDbConnectionProvider, TimeSpan olderThan)
{
OldDatabaseDeleter.DeleteOldDatabases(uniqueDbConnectionProvider, olderThan);
return(uniqueDbConnectionProvider);
}
public static UniqueDbConnectionProvider AndAutoDeleteDbOlderThan5Minutes(
this UniqueDbConnectionProvider uniqueDbConnectionProvider)
{
OldDatabaseDeleter.DeleteOldDatabases(uniqueDbConnectionProvider, TimeSpan.FromMinutes(5));
return(uniqueDbConnectionProvider);
}
/// <summary>
/// Deletes matching databases with a lifespan of greater than 5 minutes.
/// </summary>
/// <param name="uniqueDbConnectionProvider"></param>
public static void DeleteOldDatabases(UniqueDbConnectionProvider uniqueDbConnectionProvider)
{
DeleteOldDatabases(uniqueDbConnectionProvider, TimeSpan.FromMinutes(5));
}
public static void DeleteOldDatabases(UniqueDbConnectionProvider uniqueDbConnectionProvider, TimeSpan olderThan)
{
var oldDatabasesFromUniqueDb = GetOldDatabasesFromUniqueDb(uniqueDbConnectionProvider, olderThan);
oldDatabasesFromUniqueDb.ForEach(database => DeleteDatabase(uniqueDbConnectionProvider, database));
}
private static void DeleteDatabase(UniqueDbConnectionProvider connectionProvider, string databaseName)
{
var staticSqlConnectionProvider = connectionProvider.ChangeDatabase(databaseName);
DatabaseDeleter.DeleteDatabase(staticSqlConnectionProvider);
}
