def test_cropsExist(self): database_initialiser = DatabaseInitialiser(self.config) self.helper.setup_clean_db() self.helper.setup_db_file('openihmdb_mysql_fix59.sql') # FIXME: push some data into the relevant table. #self._execute_instruction('insert into setup_foods_crops values (%s)') assert database_initialiser.cropsExist()
def test_initialiseDB(self): database_initialiser = DatabaseInitialiser(self.config) self.helper.setup_clean_db() self.assertEqual({ 'mysqlstarted': True, 'dbinstalled': True, 'dbuptodate': True}, database_initialiser.initialiseDB())
def test_updateDatabase(self): # NOTE: it might be worth adding a test that compares the new # database to the updated database to check they match. database_initialiser = DatabaseInitialiser(self.config) self.helper.setup_clean_db() # this isn't much of a check... # our coverage isn't very good. assert database_initialiser.updateDatabase()
def test_updateDatabase_needs_update(self): database_initialiser = DatabaseInitialiser(self.config) self.helper.setup_clean_db() self.make_db_outofdate() self.helper.setup_db_file('openihmdb_mysql_update.sql') assert database_initialiser.updateDatabase()
def test_setupStartupCrops(self): database_initialiser = DatabaseInitialiser(self.config) self.helper.setup_clean_db() self.helper.setup_db_file('openihmdb_mysql_fix59.sql') assert database_initialiser.setupStartupCrops()
def test_databaseUpToDate_fresh_db(self): database_initialiser = DatabaseInitialiser(self.config) self.helper.setup_clean_db() self.helper.execute_instruction('delete from dbupdate') assert database_initialiser.databaseUpToDate()
def test_databaseUpToDate_needupdate(self): database_initialiser = DatabaseInitialiser(self.config) self.helper.setup_clean_db() self.make_db_outofdate() assert not database_initialiser.databaseUpToDate()
def test_databaseUpToDate(self): database_initialiser = DatabaseInitialiser(self.config) self.helper.setup_clean_db() assert database_initialiser.databaseUpToDate()
def test_createDatabase(self): database_initialiser = DatabaseInitialiser(self.config) self.helper.setup_db_file('openihmdb_mysql.sql') assert database_initialiser.createDatabase()
def setup_clean_db(self): database_initialiser = DatabaseInitialiser(self.config) self.setup_db_file('openihmdb_mysql.sql') self.grant_permissions() assert database_initialiser.createDatabase()