def search_post(): user_id = None keyword = None group_id = None if request.method == 'POST': user_id = session.get('user_id') # user_id = 1 keyword = request.form.get('keyword') group_id = request.form.get('group_id') if request.method == 'GET': user_id = session.get('user_id') # user_id = 1 keyword = request.args.get('keyword') group_id = request.args.get('group_id') if user_id is None: user_id = 0 # return jsonify({ # 'code': -1, # 'errMsg': '缺少参数user_id' # }) if keyword is None: return jsonify({'code': -1, 'errMsg': '缺少参数keyword'}) if group_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数group_id'}) send_log('/v1/post/search_post') return Post.search_post(keyword, group_id, user_id)
def add_post(): user_id = None group_id = None post_title = None content = None thumbs_up_num = None if request.method == 'POST': user_id = session.get('user_id') # user_id = 1 group_id = request.form.get('group_id') post_title = request.form.get('post_title') content = request.form.get('content') thumbs_up_num = request.form.get('thumbs_up_num') if request.method == 'GET': user_id = session.get('user_id') # user_id = 1 group_id = request.args.get('group_id') post_title = request.args.get('post_title') content = request.args.get('content') thumbs_up_num = request.args.get('thumbs_up_num') if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if group_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数group_id'}) if post_title is None: return jsonify({'code': -1, 'errMsg': '缺少参数post_title'}) if thumbs_up_num is None: thumbs_up_num = 0 if content is None: return jsonify({'code': -1, 'errMsg': '缺少参数content'}) send_log('/v1/post/add_post') return Post.add_post(group_id, user_id, post_title, content, thumbs_up_num)
def register(): form = RegisterForm(request.form) if form.validate(): db = pymysql.connect(host=current_app.config['HOST'], user=current_app.config['USER'], password=current_app.config['PASSWORD'], port=current_app.config['PORT'], database=current_app.config['DATABASE'], charset=current_app.config['CHARSET']) cursor = db.cursor() # SQL 插入语句 sql = "INSERT INTO vuser(user_nickname,password, email) VALUES ('%s', '%s', '%s' )" % \ (form.data['nickname'], generate_password_hash(form.data['password']), form.data['email']) try: cursor.execute(sql) last_id = cursor.lastrowid sql = "INSERT INTO vfollow(user_id,to_user_id) VALUES (%s,%s)" % ( last_id, last_id) cursor.execute(sql) # 执行sql语句 db.commit() except Exception as e: # 发生错误时回滚 db.rollback() return jsonify({"code": -1, "errMsg": e.args}) finally: send_log('/v1/auth/register') # 关闭数据库连接 db.close() return jsonify({"code": 200}) else: return jsonify({"code": -1, "errMsg": form.errors})
def add_zone(): user_id = session.get('user_id') content = request.form.get('content') item_type = request.form.get('item_type') item_id = request.form.get('item_id') ''' user_id = 3 content = '测试发送动态内容(无attach)' item_type = 0 item_id = 0 测试结果: { "code": 0, "Msg": "动态发送成功zone_id:5" } ''' if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if content is None: return jsonify({'code': -1, 'errMsg': '缺少参数content'}) if item_type is None: return jsonify({'code': -1, 'errMsg': '缺少参数item_type'}) if item_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数item_id'}) send_log('/v1/zone/add_zone') return Zone.add_zone(user_id, content, item_type, item_id)
def login(): form = LoginForm(request.form) if form.validate(): db = pymysql.connect(host=current_app.config['HOST'], user=current_app.config['USER'], password=current_app.config['PASSWORD'], port=current_app.config['PORT'], database=current_app.config['DATABASE'], charset=current_app.config['CHARSET']) cursor = db.cursor() # SQL 插入语句 sql = "SELECT * FROM vuser WHERE email = '%s'" % (form.data['email']) try: cursor.execute(sql) user = cursor.fetchone() if len(user) == 0: return jsonify({"code": -1, "errMsg": "账号不存在"}) userObject = User() userObject.set_attr(user, 0) if user and check_password_hash(userObject.password, form.data['password']): login_user(userObject) return jsonify({"code": 200, "Msg": "登录成功"}) else: return jsonify({"code": -1, "errMsg": "账号或密码输入错误"}) except Exception as e: return jsonify({"code": -1, "errMsg": e.args}) finally: # 关闭数据库连接 send_log('/v1/auth/login') db.close() else: return jsonify({"code": -1, "errMsg": form.errors})
def add_comment(): user_id = session.get('user_id') item_type = request.form.get('item_type') item_id = request.form.get('item_id') content = request.form.get('content') ''' 测试结果: user_id = 2 item_type = 2 item_id = 1 content = '测试评论' { "code": 0, "Msg": "评论成功,comment_id:3" } ''' if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if item_type is None: return jsonify({'code': -1, 'errMsg': '缺少参数item_type'}) if item_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数item_id'}) if content is None: return jsonify({'code': -1, 'errMsg': '缺少参数content'}) send_log('/v1/comment/add_comment') return Comment.add_comment(user_id, item_type, item_id, content)
def all_sheets(): user_id = session.get("user_id") if user_id is None: user_id = 0 limit = request.form.get('limit') if limit is None: limit = 50 send_log('/v1/sheet/all_sheets') return SongSheet.sheets_to_jsonify(user_id, SongSheet.query_all(limit))
def load_group_by_id(): user_id = session.get('user_id') if user_id is None: user_id = 0 group_id = request.form.get('group_id') if group_id is None: return jsonify({'code': '-1', 'errMsg': '缺少参数group_id'}) send_log('/v1/group/load_group_by_id') return Group.load_group_by_id(group_id, user_id)
def sheets_by_owner(): user_id = session.get('user_id') if user_id is None: user_id = 0 owner = request.form.get('user_id') if owner is None: owner = 0 send_log('/v1/sheet/sheets_by_owner') return SongSheet.sheets_to_jsonify(user_id, SongSheet.query_by_owner(owner))
def forget_password(token): form = ResetPasswordForm(request.form) if form.validate(): success = User.reset_password(token, form.password1.data) if success: send_log('/v1/auth/reset/password/') return jsonify({"code": 200}) else: send_log('/v1/auth/reset/password/') return jsonify({"code": -1, "errMsg": "密码修改失败"})
def sheets_by_user(): user_id = session.get('user_id') if user_id is None: user_id = 0 q_user_id = request.form.get('user_id') if q_user_id is None: q_user_id = 0 send_log('/v1/sheet/sheets_by_user') return SongSheet.sheets_to_jsonify(user_id, SongSheet.query_by_user(q_user_id))
def delete_sheet(): sheet_id = None user_id = session.get("user_id") if request.method == 'POST': sheet_id = request.form.get('sheet_id') if request.method == 'GET': sheet_id = request.args.get('sheet_id') if sheet_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数sheet_id'}) send_log('/v1/sheet/delete_sheet') return SongSheet.delete_sheet(sheet_id, user_id)
def songs_by_sheet(): user_id = session.get("user_id") if user_id is None: user_id = 0 sheet_id = None if request.method == 'POST': sheet_id = request.form.get('sheet_id') if request.method == 'GET': sheet_id = request.args.get('sheet_id') if sheet_id is None: return all_songs() send_log('/v1/song/songs_by_sheet') return Song.songs_to_jsonify(user_id, Song.query_by_sheet(sheet_id))
def sheets_by_name(): user_id = session.get("user_id") if user_id is None: user_id = 0 name = None if request.method == 'POST': name = request.form.get('name') if request.method == 'GET': name = request.args.get('name') if name is None: return all_sheets() send_log('/v1/sheet/sheets_by_name') return SongSheet.sheets_to_jsonify(user_id, SongSheet.query_by_name(name))
def create_sheet(): sheet_name = None user_id = session.get("user_id") sheet_img = None if request.method == 'POST': sheet_name = request.form.get('sheet_name') sheet_img = request.files.get('file') if request.method == 'GET': sheet_name = request.args.get('sheet_name') sheet_img = request.files.get('file') if sheet_name is None: return jsonify({'code': -1, 'errMsg': '缺少参数sheet_name'}) send_log('/v1/sheet/create_sheet') return SongSheet.create_sheet(sheet_name, user_id, sheet_img)
def sheets_by_id(): user_id = session.get("user_id") if user_id is None: user_id = 0 sheet_id = None if request.method == 'POST': sheet_id = request.form.get('sheet_id') if request.method == 'GET': sheet_id = request.args.get('sheet_id') if sheet_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数sheet_id'}) send_log('/v1/sheet/sheets_by_id') return SongSheet.sheets_details_to_jsonify(user_id, SongSheet.query_by_id(sheet_id), Song.query_by_sheet(sheet_id))
def search_group(): keyword = None user_id = session.get('user_id') if user_id is None: user_id = 0 if request.method == 'POST': # user_id = 1 keyword = request.form.get('keyword') if request.method == 'GET': # user_id = 1 keyword = request.args.get('keyword') if keyword is None: return jsonify({'code': '-1', 'errMsg': '缺少参数keyword'}) send_log('/v1/group/search_group') return Group.search_group(keyword, user_id)
def load_post_by_id(): user_id = None post_id = None if request.method == 'POST': user_id = session.get('user_id') post_id = request.form.get('post_id') if request.method == 'GET': user_id = session.get('user_id') post_id = request.args.get('post_id') if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if post_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数group_id'}) send_log('/v1/post/load_post') return Post.load_post_by_id(post_id, user_id)
def load_zone(): user_id = session.get('user_id') ''' user_id = 1 测试结果: { "code": 0, "data": [ { "content": "user6 zone3", "create_time": "Tue, 19 Nov 2019 21:43:51 GMT", "is_liked": false, "item_id": 0, "item_type": 0, "thumbs_up_num": 3, "user_id": 6, "user_nickname": "用户4", "zone_id": 3 }, { "content": "user2 zone2", "create_time": "Tue, 19 Nov 2019 21:43:29 GMT", "is_liked": true, "item_id": 0, "item_type": 0, "thumbs_up_num": 13, "user_id": 2, "user_nickname": "ikun永相随", "zone_id": 2 }, { "content": "user1 zone1", "create_time": "Tue, 19 Nov 2019 21:43:06 GMT", "is_liked": false, "item_id": 0, "item_type": 0, "thumbs_up_num": 11, "user_id": 1, "user_nickname": "胖菊喵喵喵", "zone_id": 1 } ] } ''' if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) send_log('/v1/zone/load_zone') return Zone.zones_to_jsonify(Zone.load_zone(user_id))
def sheet_delete_song(): user_id = session.get("user_id") sheet_id = None song_id = None if request.method == 'POST': sheet_id = request.form.get('sheet_id') song_id = request.form.get('song_id') if request.method == 'GET': sheet_id = request.args.get('sheet_id') song_id = request.args.get('song_id') if sheet_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数sheet_name'}) if song_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数song_id'}) send_log('/v1/sheet/sheet_delete_song') return SongSheet.sheet_delete_song(sheet_id, song_id, user_id)
def load_comment(): user_id = session.get('user_id') item_type = request.form.get('item_type') item_id = request.form.get('item_id') ''' 测试结果: user_id = 1 item_type = 1 item_id = 1 { "code": 0, "data": [ { "comment_id": 2, "content": "测试修改", "create_time": "Tue, 19 Nov 2019 23:15:30 GMT", "is_liked": false, "item_id": 1, "item_type": 1, "thumbs_up_num": 0, "user_id": 1, "user_nickname": "胖菊喵喵喵" }, { "comment_id": 1, "content": "坤坤的wait wait wait太棒了!", "create_time": "Tue, 19 Nov 2019 22:45:57 GMT", "is_liked": true, "item_id": 1, "item_type": 1, "thumbs_up_num": 1000, "user_id": 1, "user_nickname": "胖菊喵喵喵" } ] } ''' if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if item_type is None: return jsonify({'code': -1, 'errMsg': '缺少参数item_type'}) if item_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数item_id'}) send_log('/v1/comment/load_comment') return Comment.comments_to_jsonify( Comment.load_comment(user_id, item_type, item_id))
def delete_post(): user_id = None post_id = None if request.method == 'POST': user_id = session.get('user_id') # user_id = 1 post_id = request.form.get('post_id') if request.method == 'GET': user_id = session.get('user_id') # user_id = 1 post_id = request.args.get('post_id') if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if post_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数post_id'}) send_log('/v1/post/delete_post') return Post.delete_post(post_id)
def delete_comment(): user_id = session.get('user_id') comment_id = request.form.get('comment_id') ''' 测试结果: user_id = 2 comment_id = 3 { "code": 0, "Msg": "删除评论成功" } ''' if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if comment_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数comment_id'}) send_log('/v1/comment/delete_comment') return Comment.delete_comment(user_id, comment_id)
def delete_group(): user_id = None group_id = None if request.method == 'POST': user_id = request.form.get('user_id') # user_id = 1 group_id = request.form.get('group_id') if request.method == 'GET': user_id = request.args.get('user_id') # user_id = 1 group_id = request.args.get('group_id') if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if group_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数group_id'}) send_log('/v1/group/delete_group') return Group.delete_group(group_id, user_id)
def songs_by_name(): user_id = session.get("user_id") if user_id is None: user_id = 0 name = None if request.method == 'POST': name = request.form.get('name') if request.method == 'GET': name = request.args.get('name') if name is None: return all_songs() else: url = "http://shysimon.cn:3000/v1/search" params = {"keywords": name} res = requests.get(url, params) for i in res.json()['result']['songs']: Song.add_from_music163(i) send_log('/v1/song/songs_by_name') return Song.songs_to_jsonify(user_id, Song.query_by_name(name))
def delete_zone(): user_id = session.get('user_id') zone_id = request.form.get('zone_id') ''' user_id = 3 zone_id = 5 测试结果: { "code": 0, "Msg": "删除动态成功" } ''' if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if zone_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数zone_id'}) send_log('/v1/zone/delete_zone') return Zone.delete_zone(user_id, zone_id)
def modify_comment(): user_id = session.get('user_id') comment_id = request.form.get('comment_id') content = request.form.get('content') ''' 测试结果: user_id = 1 comment_id = 2 content = '测试修改222' { "code": 0, "Msg": "修改评论成功" } ''' if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if comment_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数comment_id'}) if content is None: return jsonify({'code': -1, 'errMsg': '缺少参数content'}) send_log('/v1/comment/modify_comment') return Comment.modify_comment(user_id, comment_id, content)
def like(): user_id = session.get('user_id') item_type = request.form.get('item_type') item_id = request.form.get('item_id') ''' user_id = 2 item_type = 5 item_id = 2 测试结果: { "code": 0, "Msg": "点赞成功" } ''' if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if item_type is None: return jsonify({'code': -1, 'errMsg': '缺少参数item_type'}) if item_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数item_id'}) send_log('/v1/thumbs/like') return Thumbs.like(user_id, item_type, item_id)
def invite_friend(): user_id = None friend_id = None group_id = None if request.method == 'POST': user_id = session.get('user_id') # user_id = 1 friend_id = request.form.get('friend_id') group_id = request.form.get('group_id') if request.method == 'GET': user_id = session.get('user_id') # user_id = 1 friend_id = request.args.get('friend_id') group_id = request.args.get('group_id') if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if friend_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数friend_id'}) if group_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数group_id'}) send_log('/v1/group/invite_friend') return Group.invite_user(friend_id, group_id)
def modify_post(): user_id = None post_id = None new_content = None if request.method == 'POST': user_id = session.get('user_id') # user_id = 1 post_id = request.form.get('post_id') new_content = request.form.get('new_content') if request.method == 'GET': user_id = session.get('user_id') # user_id = 1 post_id = request.args.get('post_id') new_content = request.args.get('new_content') if user_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数user_id'}) if post_id is None: return jsonify({'code': -1, 'errMsg': '缺少参数post_id'}) if new_content is None: return jsonify({'code': -1, 'errMsg': '缺少参数new_content'}) send_log('/v1/post/modify_post') return Post.modify_post(post_id, new_content)