public static void InitializeDatabaseSchema(MySqlConnection connectionIn, string tableCreationString, string tableName)
{
if (!DatabaseInitialized)
{
TestingDatabaseCreationUtils.InitializeDatabaseSchema();
DatabaseInitialized = true;
}
connectionIn.ConnectionString = TestingConstants.ConnectionString;
connectionIn.Open();
var cmd = connectionIn.CreateCommand();
cmd.CommandText = "select count(*) from information_schema.tables where table_name=\"{tableName}\"";
var reader = cmd.ExecuteReader();
int count = 0;
using (reader) {
reader.Read();
count = reader.GetInt32(0);
}
if (count == 0)
{
cmd.CommandText = tableCreationString;
cmd.ExecuteNonQuery();
}
}
public static void DestoryDatabase()
{
TestingDatabaseCreationUtils.DestoryDatabase();
DatabaseInitialized = false;
}
