def get_image_by_muiti_condition(filename, oss_filename, head_group_id): db = MyPymysqlPool() sql = "select id from `photo` where name=%s and oss_path=%s and group_id =%s" result = db.getOne(sql, (filename, oss_filename, head_group_id)) db.dispose() return result
def get_image(_id): db = MyPymysqlPool() sql = "SELECT * FROM `photo` where id=%s" result = db.getOne(sql, _id) db.dispose() return result
def get_image_by_oss_path(oss_path): db = MyPymysqlPool() sql = "SELECT * FROM `photo` where oss_path like '%%%s'" % oss_path result = db.getOne(sql) db.dispose() return result
def get_cache_by_muti_condition(user_id, group_id, photo_id): db = MyPymysqlPool() sql = "select * from `cache` where user_id=%s and group_id=%s and similar_photo_id=%s" result = db.getOne(sql, (user_id, group_id, photo_id)) db.dispose() return result
def count_group(_id): db = MyPymysqlPool() sql = "SELECT COUNT(*) FROM `photo` WHERE group_id = %s" result = db.getOne(sql, _id) db.dispose() return result
def get_group_by_dir(_dir): db = MyPymysqlPool() sql = "SELECT * FROM `group` WHERE oss_dir = %s" result = db.getOne(sql, _dir) db.dispose() return result
def get_cache(_id): db = MyPymysqlPool() sql = "select * from `cache` where id=%s" result = db.getOne(sql, _id) db.dispose() return result
def get_face_by_photo_id(photo_id): db = MyPymysqlPool() sql = "select id from `face` where photo_id=%s" result = db.getOne(sql, photo_id) db.dispose() return result
def get_face_by_user_id_and_grou_id(user_id, group_id): db = MyPymysqlPool() sql = "select id from `face` where user_id=%s and group_id =%s" result = db.getOne(sql, (user_id, group_id)) db.dispose() return result
def get_group(_id): db = MyPymysqlPool() sql = "SELECT * FROM `group` WHERE id = %s" result = db.getOne(sql, _id) db.dispose() return result