def get_detail(cls, id):
sql = 'select * from view_user where user_id = %s;'
res = query(sql, [id])
if res:
item = res[0]
return utils.format_model_item(item)
return None
def query_user_timeline(user_id, types, start, per_page):
"""查询用户时间线"""
sql = "select * from action where type in %s and user_id = %s " \
"and create_ts < %s order by create_ts desc limit 0,%s"
t = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(start))
return query(sql, [types, user_id, t, per_page])
def get_user_last_location_time(cls, user_id):
'''查询用户最后的位置'''
sql = 'select * from view_last_location_time where user_id = %s'
res = query(sql, [user_id])
if res:
return res[0]['create_ts']
else:
return 0
def query_related_videos(cls, id):
sql = "SELECT * FROM view_video where user_id <='' LIMIT 0,4;"
res = query(sql, [])
map(utils.map_model_item, res)
return res
def get_video_detail(cls, id):
sql = "SELECT * FROM view_video WHERE res_id = %s;"
res = query(sql, [id])
if res:
item = res[0]
return utils.format_model_item(item)
return None
def get_collection_detail(cls, id):
sql = "select * from view_collection where res_id = %s;"
res = query(sql, [id])
if res:
item = res[0]
item = utils.format_model_item(item)
return item
else:
return None
def get_comments(cls, **params):
'''获取评论列表'''
start = int(params['start'])
res_id = params['res_id']
per_page = int(params['per_page'])
sql = "select * from view_comment WHERE res_id = %s " \
"and create_ts < %s limit 0,%s;"
res = query(sql, [res_id, start, per_page])
return res
def get_similar_users(cls, user_id):
sql = """
SELECT id AS user_id,name,portrait,gender FROM user WHERE id IN (
SELECT distinct user_id from action WHERE res_id IN (
SELECT res_id FROM action WHERE type = 27 AND user_id = %s
) AND user_id>''
);
"""
return query(sql, [user_id])
def get_pushs(cls):
sql = "select * from view_push"
return query(sql, [])
def get_replys(cls, **params):
'''根据评论id过去回复列表'''
comment_id = params['comment_id']
sql = ' select * from view_reply where comment_id = %s'
res = query(sql, [comment_id])
return res
def get_items(cls, ):
sql = "select * from view_collection"
res = query(sql, [])
map(utils.map_model_item, res)
return res
def get_items(cls):
sql = 'select * from view_audio'
res = query(sql, [])
map(utils.map_model_item, res)
return res
def get_videos(cls):
sql = "SELECT * FROM view_video"
res = query(sql, [])
map(utils.map_model_item, res)
return res
def get_normal_users(cls):
sql = "SELECT * FROM view_user WHERE status = 52;"
res = query(sql, [])
map(utils.map_model_item, res)
return res