def getVideos(tags=None, createdBy=None, count=None):
with Cursor() as cursor:
#what to project
project = " COUNT(*) " if count else " * "
query = "SELECT %s FROM VIDEOS " % project
#where clauses
tagsq = None if not tags else "tags = '%s' " % (tags, )
createdByq = None if not createdBy else "createdBy = '%s' " % (createdBy, )
query += utils.joinWheres([tagsq, createdByq])
cursor.execute(query)
return fetchall(cursor)
def test_joinWheres(self):
wheres = ['a = 1234 ', None, 'b = 456 ']
result = utils.joinWheres(wheres)
self.assertEqual(result, 'WHERE a = 1234 AND b = 456 ')
def test_joinWheres(self):
wheres = ['a = 1234 ' , None, 'b = 456 ']
result = utils.joinWheres(wheres)
self.assertEqual(result , 'WHERE a = 1234 AND b = 456 ')