Python insert_user_table Examples

Example #1

File: test_database.py Project: jd3builds/BadApplesJJP

 def test_query_multiple_items_by_name(self):
     self.assertTrue(db.insert_user_table(blueberries))
     self.assertTrue(db.insert_user_table(wild_blueberries))
     self.assertTrue(db.insert_user_table(blue_lollipops))
     result = db.query_user_item_by_name('blue')
     self.assertIsNotNone(result)
     self.assertEqual(len(result), 3)

Example #2

File: test_database.py Project: jd3builds/BadApplesJJP

 def test_query_by_id(self):
     self.assertTrue(db.insert_user_table(strawberries))
     self.assertTrue(db.insert_user_table(blueberries))
     self.assertTrue(db.insert_user_table(blackberries))
     result = db.query_user_item_by_id(blueberries[1])
     self.assertIsNotNone(result)
     self.assertEqual(len(result), 1)
     self.assertEqual(result[0][1], blueberries[1])

Example #3

File: test_database.py Project: jd3builds/BadApplesJJP

 def test_delete_all(self):
     self.assertTrue(db.insert_user_table(blueberries))
     self.assertTrue(db.insert_user_table(strawberries))
     self.assertTrue(db.insert_user_table(blackberries))
     self.assertTrue(db.delete_all_user_items())

Example #4

File: test_database.py Project: jd3builds/BadApplesJJP

 def test_add_unique_item_and_remove(self):
     self.assertTrue(db.insert_user_table(blueberries))
     self.assertTrue(db.delete_user_item(blueberries[1]))