def test_get_where_stmnt(self):
db = AmmDB(self.password)
observed = db.get_where_stmnt("", "testCol", "testVal", "", 'like')
expected = "WHERE testCol LIKE '%testVal%' "
self.assertEqual(observed, expected)
observed = db.get_where_stmnt("", "testCol", "testVal", "", '')
expected = "WHERE testCol = 'testVal'"
self.assertEqual(observed, expected)
observed = db.get_where_stmnt("testWhere", "testCol", "testVal", ">", 'like')
expected = " > testCol LIKE '%testVal%' "
self.assertEqual(observed, expected)
observed = db.get_where_stmnt("testWhere", "testCol", "testVal", ">", '')
expected = " > testCol = 'testVal'"
self.assertEqual(observed, expected)