def test_create_batch_and_retrieve_limit(self):
table_name = 'password_db'
table_model = DataModel(table_name, PasswordData)
table_model.new_table()
l = []
for x in range(0, 5):
l.append(PasswordData('111' + str(x), '222'))
table_model.create_batch(l)
self.assertEqual(table_model.retrieve("name", "1110"), PasswordData('1110', '222'))
self.assertEqual(table_model.retrieve("name", "1114"), PasswordData('1114', '222'))
self.assertEqual(len(table_model.retrieve_limit(1, 3)), 3)
os.remove("./password_db.db")
def test_update(self):
table_name = 'password_db'
table_model = DataModel(table_name, PasswordData)
table_model.new_table()
l = []
for x in range(1, 6):
l.append(PasswordData('No' + str(x), str(x)))
table_model.create_batch(l)
row_size = table_model.update("name", "No3", "password", "new_password")
self.assertEqual(row_size, 1)
row_size = table_model.update("name", "No8", "password", "new_password")
self.assertEqual(row_size, 0)
os.remove("./password_db.db")