def get_user(): global DBSESSION check_dbsession(DBSESSION) sql = 'SELECT uid, nickname, update_time FROM profile ORDER BY update_time DESC' users = DBSESSION.execute(sql) res = [] for u in users: res.append({ 'uid': u.uid, 'nickname': u.nickname, 'update_time': millisecond_to_datestr(u.update_time), }) return res
def get_comment(root_id): global DBSESSION check_dbsession(DBSESSION) sql = 'SELECT * FROM comment WHERE status=0 AND root_id="' + root_id + '" ORDER BY update_time DESC' print sql comments = DBSESSION.execute(sql) res = [] for c in comments: res.append({ 'id': c.id, 'parent_id': c.parent_id, 'reply_user': c.reply_user, 'root_id': c.root_id, 'content': c.content, 'author_id': c.author_id, 'nickname': c.nickname, 'avatar': 'http://image.ciwei.io/' + c.avatar, 'type': c.type, 'comment_count': c.comment_count, 'like_count': c.like_count, 'update_time': millisecond_to_datestr(c.update_time) }) return res
def get_post(): global DBSESSION check_dbsession(DBSESSION) sql = ('SELECT * ' 'FROM post WHERE status=0 ORDER BY update_time DESC' ) posts = DBSESSION.execute(sql) res = [] for p in posts: res.append({ 'id': p.id, 'parent_id': p.parent_id, 'author_id': p.author_id, 'nickname': p.nickname, 'avatar': 'http://image.ciwei.io/' + p.avatar, 'group_name': p.group_name, 'content': p.content, 'pictures': p.pictures, 'comment_count': p.comment_count, 'like_count': p.like_count, 'update_time': millisecond_to_datestr(p.update_time), }) return res