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