def test_create_storage(self): """Test the fact of storage creation.""" m = Model() file_name = './file.sme.sqlite' remove_file(file_name) m.create_storage(file_name) exists = os.path.isfile(file_name) remove_file(file_name) self.assertEqual(exists, True)
def test_create_storage_in_home_dir(self): """Test the fact of storage creation.""" m = Model() file_name = '~/file.sme.sqlite' remove_file(file_name) m.create_storage(file_name) exists = os.path.isfile(os.path.expanduser(file_name)) remove_file(file_name) self.assertEqual(exists, True)
def test_create_storage_if_exists(self): """If file file_name exists it should be correctly replaced by new storage.""" m = Model() file_name = './copy-test.sme.sqlite' shutil.copy2('./test.sme.sqlite', file_name) m.create_storage(file_name) m.close_storage() conn = sqlite3.connect(file_name) c = conn.cursor() c.execute("select count(*) from examination") n = c.fetchone()[0] conn.close() remove_file(file_name) self.assertEqual(n, 0)
def test_insert_examination_to_new_storage(self): """Number of examination must be 1 after insertion examination to new empty storage.""" m = Model() file_name = './copy-test.sme.sqlite' m.create_storage(file_name) m.insert_exam(create_test_exam()) m.close_storage() conn = sqlite3.connect(file_name) c = conn.cursor() c.execute("select count(*) from examination") n = c.fetchone()[0] conn.close() remove_file(file_name) self.assertEqual(n, 1)