def test_set_methods(self): """ this tests all of the set methods since they need to work together """ save_config_file = config.ConfigObject.CONFIG_FILE # Test the default with no file is 'unittest' config.reset() config.ConfigObject.CONFIG_FILE = 'badfile.xxx' self.assertEqual(config.get_environment(), 'unittest') config.ConfigObject.CONFIG_FILE = save_config_file # test that if we the database name we have an unknown environmentwe config.reset() config.set_database_name('MyTest.db') self.assertEqual(config.get_environment(), '????') os.remove('MyTest.db') # test that if we the database name we have an unknown environmentwe config.reset() config.set_enviornment('test') self.assertTrue(config.get_database_name()) # test that we have an instance and database config.reset() self.assertTrue(config.get_environment( )) # All these values must be set... Can't test to what though self.assertTrue(config.get_database_name()) self.assertTrue(config.get_database_instance()) self.assertTrue(config.get_database())
def test_set_methods(self): """ this tests all of the set methods since they need to work together """ save_config_file = config.ConfigObject.CONFIG_FILE # Test the default with no file is 'unittest' config.reset() config.ConfigObject.CONFIG_FILE = 'badfile.xxx' self.assertEqual(config.get_environment(), 'unittest') config.ConfigObject.CONFIG_FILE = save_config_file # test that if we the database name we have an unknown environmentwe config.reset() config.set_database_name(':memory:') self.assertEqual(config.get_environment(), '????') # test that if we the database name we have an unknown environmentwe config.reset() config.set_enviornment('test') self.assertTrue(config.get_database_name()) # test that we have an instance and database config.reset() self.assertTrue(config.get_environment()) # All these values must be set... Can't test to what though self.assertTrue(config.get_database_name()) self.assertTrue(config.get_database_instance()) self.assertTrue(config.get_database())
elif cell.value is None: data = data + " Null," else: raise AppError('*** Not Loaded',cell.value, type(cell.value)) i += 1 data = data + ')' data = data.replace(',)', ')') insert = insert + data print(insert) self.dbi.execute(insert) def commit (self): self.dbi.commit() def close(self): self.dbi.close() if __name__ == '__main__': None worksheet = config.get_file_dir() + 'database.xlsx' config.set_database_name('browse.db') loader = Loader() loader.open_excel(worksheet) loader.load_all_sheets() loader.close()
# data = data + str(cell.value.strftime("%Y/%m/%d")) + "," elif cell.value is None: data = data + " Null," else: raise AppError('*** Not Loaded', cell.value, type(cell.value)) i += 1 data = data + ')' data = data.replace(',)', ')') insert = insert + data print(insert) self.dbi.execute(insert) def commit(self): self.dbi.commit() def close(self): self.dbi.close() if __name__ == '__main__': None worksheet = config.get_file_dir() + 'database.xlsx' config.set_database_name('browse.db') loader = Loader() loader.open_excel(worksheet) loader.load_all_sheets() loader.close()