public void OneTimeSetup()
{
// We first connect to create the database with a connection string that does not contain the database parameter
// to create the database, and the we use the the conection with the database specified.
// We do this due to a bug in MySql. If we do not specify the database in the connection string we can not execute
// the stored procedures.
// TODO Remove this lines when the bug is fixed.
/*using (var mySqlNoDbConnector = new MySqlDatabaseConnector(this.ConnectionStringNoDb)) {
* mySqlNoDbConnector.ExecuteNonQuery(@"CREATE DATABASE IF NOT EXISTS `test`;");
* mySqlNoDbConnector.Close();
* }*/
Fixture = Activator.CreateInstance(typeof(MySqlStoredProcedureFixture)) as StoredProcedureFixtureBase;
if (Fixture == null)
{
throw new Exception("Couldn't create the fixture.");
}
// TODO Uncomment this line when the bug is fixed.
//Fixture.CreateDatabase();
Fixture.CreateParentTable();
Fixture.CreateChildTable();
Fixture.CreateStoredProcedures();
using (var databaseAccess = new DatabaseAccess(Fixture.Connector, typeof(SingleKeyParentTable)))
{
databaseAccess.Insert(Fixture.CreateNewActiveEntity());
databaseAccess.Insert(Fixture.CreateNewActiveEntity());
databaseAccess.Insert(Fixture.CreateNewInactiveEntity());
databaseAccess.Insert(Fixture.CreateNewInactiveEntity());
}
}
public SqlStoredProceduresTest()
{
this.Fixture = Activator.CreateInstance(typeof(SqlStoredProcedureFixture)) as StoredProcedureFixtureBase;
}
public PostgreSqlStoredProceduresTest()
{
Fixture = Activator.CreateInstance(typeof(PostgreSqlStoredProcedureFixture)) as StoredProcedureFixtureBase;
}
