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()
