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)
