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
