def get_caches_by_user_id_and_group_id(user_id, group_id):
db = MyPymysqlPool()
sql = "select * from `cache` where user_id=%s and group_id=%s"
result = db.getAll(sql, (user_id, group_id))
db.dispose()
return result
def get_images_by_group_id(group_id):
db = MyPymysqlPool()
sql = "SELECT * FROM `photo` where group_id=%s"
result = db.getAll(sql, group_id)
db.dispose()
return result
def get_faces_by_group_id(group_id):
db = MyPymysqlPool()
sql = "select * from `face` where group_id=%s"
result = db.getAll(sql, group_id)
db.dispose()
return result