def get(self): parser = RequestParser() parser.add_argument('token', type=str, location="headers", required=True) args = parser.parse_args(strict=True) token = args.get('token') user_id = verify_token(token) if user_id is None: return {'message': 'Illegal token.'}, 403 cursor.execute("SELECT * FROM Movie_Comments WHERE User_id = %d" % (user_id)) result = cursor.fetchall() result_m = cursor.fetchall() for i in result: i['Create_time'] = str(i['Create_time']) connection.commit() return {"result": result}
def get(self): cursor.execute( "SELECT Topic_id FROM Topic_Contents GROUP BY Topic_id ORDER BY COUNT(Topic_Content_id) DESC" ) result = cursor.fetchmany(2) connection.commit() cursor.execute( "SELECT * FROM Topics WHERE Topic_id = '%d' or Topic_id = '%d'" % (result[0]['Topic_id'], result[1]['Topic_id'])) result = cursor.fetchall() connection.commit() return {'result': result}
def get(self): parser = reqparse.RequestParser() parser.add_argument("keywords", type=str, location="args", required=True) req = parser.parse_args(strict=True) keywords = '%' + req.get("keywords") + '%' cursor.execute("SELECT * FROM Books WHERE Book_name LIKE '%s' " % (keywords)) result = cursor.fetchall() connection.commit() return {'result': result}
def get(self): cursor.execute( "SELECT Book_comment_id,Book_comment_title,Book_comment_approve,Book_comment_disapprove,Book_comment_content,\ Book_id,Create_time,`User`.User_id,`User`.User_name FROM Book_Comments,`User`\ WHERE Book_Comments.User_id=User.User_id") resultb = cursor.fetchall() connection.commit() cursor.execute( "SELECT Movie_comment_id,Movie_comment_title,Movie_comment_approve,Movie_comment_disapprove,Movie_comment_content,\ Movie_id,Create_time,`User`.User_id,`User`.User_name FROM Movie_Comments,`User`\ WHERE Movie_Comments.User_id=User.User_id") resultm = cursor.fetchall() connection.commit() for i in resultb: i['Create_time'] = str(i['Create_time']) for i in resultm: i['Create_time'] = str(i['Create_time']) return { 'result': { 'book_comments': resultb, 'movie_comments': resultm, } }
def get(self): parser = reqparse.RequestParser() parser.add_argument("keywords", type=str, location="args", required=True) req = parser.parse_args(strict=True) keywords = '%' + req.get("keywords") + '%' cursor.execute( "SELECT * FROM Group_Contents WHERE Group_content_title LIKE '%s' OR Group_content_content LIKE '%s' " % (keywords, keywords)) result = cursor.fetchall() connection.commit() for i in result: i['Create_time'] = str(i['Create_time']) return {'result': result}
def get(self): parser = RequestParser() parser.add_argument('token', type=str, location='headers', required=True) args = parser.parse_args(strict=True) token = args["token"] user_id = verify_token(token) if user_id is None: return {'message': 'Illegal token.'}, 403 cursor.execute( "SELECT * FROM Movie_Comment_Approvals WHERE User_id = %d" % (user_id)) result = cursor.fetchall() connection.commit() return {"result": result}
def get(self, topic_id): cursor.execute("SELECT * FROM Topics WHERE Topic_id LIKE '%s'" % (topic_id)) result = cursor.fetchone() if result is None: abort_if_doesnt_exist("Topic_id") cursor.execute( "SELECT Topic_content_id,Topic_content_content,Topic_content_image,Topic_id,Create_time,`User`.User_id,`User`.User_name FROM Topic_Contents,`User`\ WHERE Topic_id = %d AND Topic_Contents.User_id=`User`.User_id" % (topic_id)) content = cursor.fetchall() connection.commit() for i in content: i['Create_time'] = str(i['Create_time']) return { 'result': { 'info': result, 'contents': content, } }
def get(self, group_id): cursor.execute("SELECT * FROM Groups WHERE Group_id LIKE '%s'" % (group_id)) result = cursor.fetchone() if result is None: abort_if_doesnt_exist("Group_id") cursor.execute( "SELECT Group_content_id,Group_content_content,Group_content_title,Group_id,Group_content_image,Create_time,\ Is_highlighted,Is_pinned,`User`.User_id,`User`.User_name FROM Group_Contents,`User`\ WHERE Group_id=%d and Group_Contents.User_id=User.User_id ORDER BY Is_pinned DESC" % (group_id)) content = cursor.fetchall() connection.commit() for i in content: i['Create_time'] = str(i['Create_time']) return { 'result': { 'info': result, 'contents': content, } }
def get(self, book_id): cursor.execute("SELECT * FROM Books WHERE Book_id LIKE '%s'" % (book_id)) result = cursor.fetchone() if result is None: abort_if_doesnt_exist("Book_id") cursor.execute( "SELECT Book_comment_id,Book_comment_title,Book_comment_approve,Book_comment_disapprove,Book_comment_content,\ Book_id,Create_time,`User`.User_id,`User`.User_name FROM Book_Comments,`User`\ WHERE Book_id= %d and Book_Comments.User_id=User.User_id" % (book_id)) content = cursor.fetchall() connection.commit() for i in content: i['Create_time'] = str(i['Create_time']) return { 'result': { 'info': result, 'comments': content, } }
def get(self): cursor.execute('SELECT * FROM Groups;') connection.commit() return {'result': cursor.fetchall()}