public DatabaseSandboxSqlConnectionTest()
{
IConnectionStringBuilder connectionStringBuilder = new StubConnectionStringBuilder();
_sqlServerDbSandBoxConnection =
new SqlServerDbSandBoxConnection(connectionStringBuilder);
}
public void open_connection_with_userPassword_ConnectionString()
{
IConnectionStringBuilder connectionStringBuilder = new StubConnectionStringBuilder()
.SetConnectionString("data source=.\\MSSQLSERVER2016;initial catalog=master;User Id=sa;Password=123456");
var serverConnectionString =
new SqlServerDbSandBoxConnection(connectionStringBuilder);
serverConnectionString.Open();
}
public void when_canNot_open_connection_to_database_should_throw_exception()
{
IConnectionStringBuilder connectionStringBuilder = new StubConnectionStringBuilder()
.SetConnectionString("data source=.;initial catalog=master;User Id=sa;Password=123457");
var serverConnectionString =
new SqlServerDbSandBoxConnection(connectionStringBuilder);
Action action = () => serverConnectionString.Open();
action.Should().Throw <CannotConnectToDatabaseException>();
}
ExistDatabaseWithThatName(this StringAssertions assertions,
string connectionString)
{
var databaseName = assertions.Subject;
var sqlServerCreator = new SQLServerCreator(StubConnectionStringBuilder.Create());
var isExists = sqlServerCreator.IsExists(databaseName) &&
!string.IsNullOrEmpty(databaseName);
Execute.Assertion.ForCondition(isExists).FailWith("database does not exists");
return(new AndConstraint <StringAssertions>(assertions));
}
public async Task when_openAsync_canNot_open_connection_to_database_should_throw_exception()
{
//Todo: what should i do for CI server, is there any account!!!
IConnectionStringBuilder connectionStringBuilder = new StubConnectionStringBuilder()
.SetConnectionString("data source=.;initial catalog=master;User Id=sa;Password=123457");
var serverConnectionString =
new SqlServerDbSandBoxConnection(connectionStringBuilder);
Func <Task> action = async() => await serverConnectionString.OpenAsync();
action.Should().Throw <CannotConnectToDatabaseException>();
}
public void when_run_concurrency_command_should_execute_all_commands()
{
var connectionString = StubConnectionStringBuilder.Create();
Parallel.For(0, 20, (i) =>
{
var sqlServerCreator = new SQLServerCreator(connectionString);
var databaseName = DatabaseGenerator.NewName;
sqlServerCreator.Create(databaseName);
sqlServerCreator.Drop(databaseName);
});
}
public SQLServerCreatorTest()
{
_database = new SQLServerCreator(StubConnectionStringBuilder.Create());
}
public SqlServerCreatorConnectWithSqlDbSandboxConnectionTest()
{
_database = new SQLServerCreator(new SqlServerDbSandBoxConnection(StubConnectionStringBuilder.Create()));
}
public FluentDatabaseSandBoxTest()
{
_sqlServerDatabase = new SQLServerCreator(StubConnectionStringBuilder.Create());
_migrationDllPath = Directory.GetCurrentDirectory() + @"\MigratorFile\FluentMigrator.dll";
CreateFluentMigratorHandler();
}
