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()}
