def edit():
collection_id = request.form.get('collection_id')
block_id = request.form.get('block_id')
content = request.form.get('content', None)
"""
content = none的情况请直接返回
"""
if content is None:
ret = {'msg': 'content is None!'}
return json_util.dumps(ret)
try:
row = db_session.query(CollectionBlock).filter(
CollectionBlock.id == collection_id,
CollectionBlock.block_id == block_id).first()
if row is None:
ret = {'msg': 'collection_id and block_id error!'}
return json_util.dumps(ret)
item = db_session.query(Block).filter(Block.id == block_id).first()
type_item = item.type
if type_item == 'text' or type_item == 'url':
item.content_text = content
else:
item.content_pic = content
db_session.commit()
except BaseException as e:
print(str(e))
ret = {'msg': 'failed!'}
return json_util.dumps(ret)
ret = {'msg': 'succuss'}
return json_util.dumps(ret)
def register():
if request.method == 'POST':
phonenum = request.form['phonenum']
username = request.form['username']
password = request.form['password']
password1 = request.form['password1']
msg = ''
userlist = db_session.query(Users)
flag = 1
for user in userlist:
if user.phonenum == phonenum:
flag = 0
break
if flag == 0:
msg = "手机号已被注册！"
return jsonify({'code': 0, 'msg': msg})
else:
if phonenum != '' and password != '':
if password == password1:
user = Users(phonenum=phonenum, name=username, password=password)
db_session.add(user)
db_session.commit()
return jsonify({'code': 1, 'name': username, 'phonenum': phonenum})
else:
msg = "两次输入密码不一致！"
return jsonify({'code': 2, 'msg': msg})
else:
msg = "请输入完整登录信息！"
return jsonify({'code': 3, 'msg': msg})
else:
msg = "提交失败，请重新注册！"
return jsonify({'code': 4, 'msg': msg})
def get_like():
id = request.form.get('collection_id')
phonenum = request.form.get('phonenum')
"""
增加点赞数
更新用户的点赞状态
"""
ret = {'msg': 'succuss'}
try:
s = UserLike(phonenum=phonenum, collection_id=id, state=1)
row = db_session.query(UserLike).filter(UserLike.collection_id == id, UserLike.phonenum == phonenum).first()
if row is None:
db_session.add(s)
db_session.query(Collection).filter(Collection.id == id).update({Collection.like: Collection.like + 1})
db_session.commit()
else:
db_session.query(UserLike).filter(UserLike.collection_id == id, UserLike.phonenum == phonenum).update(
{UserLike.state: 1})
db_session.query(Collection).filter(Collection.id == id).update({Collection.like: Collection.like + 1})
db_session.commit()
except BaseException as e:
print(str(e))
ret = {'msg': 'failed!'}
return json_util.dumps(ret)
return json_util.dumps(ret)
def swap():
id = request.form.get('id')
collection_id = request.form.get('collection_id')
order = request.form.get('new_order')
"""
把这个collection_id的collection的这个id的块和顺序是order的块交换
编号从零开始，有可能是自己
"""
try:
row = db_session.query(CollectionBlock).filter(
CollectionBlock.id == collection_id,
CollectionBlock.block_id == id).first()
if row is None:
ret = {'msg': 'collection_id and block_id error!'}
return json_util.dumps(ret)
item1 = db_session.query(Block).filter(Block.id == id).first()
item2 = db_session.query(Block).filter(Block.order == order).first()
order1 = item1.order
# order2 = item2.order
id2 = item2.id
db_session.query(Block).filter(Block.id == id).update(
{Block.order: order})
db_session.query(Block).filter(Block.id == id2).update(
{Block.order: order1})
db_session.commit()
except BaseException as e:
print(str(e))
ret = {'msg': 'failed!'}
return json_util.dumps(ret)
ret = {'msg': 'succuss'}
return json_util.dumps(ret)
def get_unlike():
id = request.form.get('collection_id')
phonenum = request.form.get('phonenum')
"""
减少点赞数
更新用户的点赞状态
"""
ret = {'msg': 'succuss'}
try:
db_session.query(UserLike).filter(UserLike.collection_id == id, UserLike.phonenum == phonenum).update(
{UserLike.state: 0})
db_session.query(Collection).filter(Collection.id == id).update({Collection.like: Collection.like - 1})
db_session.commit()
except BaseException as e:
print(str(e))
ret = {'msg': 'failed!'}
return json_util.dumps(ret)
return json_util.dumps(ret)
def edit():
id = request.form.get('collection_id')
name = request.form.get('name', None)
tag = request.form.get('tag', None)
"""
全部是none的情况请直接返回
"""
if id is None and name is None and tag is None:
ret = {'msg': 'id,name,tag are all none!'}
return json_util.dumps(ret)
try:
db_session.query(Collection).filter(Collection.id == id).update({Collection.name: name, Collection.tag: tag})
db_session.commit()
except BaseException as e:
print(str(e))
ret = {'msg': 'failed!'}
return json_util.dumps(ret)
ret = {'msg': 'succuss'}
return json_util.dumps(ret)
def forget():
if request.method == 'POST':
phonenum = request.form['phonenum']
username = request.form['username']
password = request.form['password']
password1 = request.form['password1']
msg = ''
userlist = db_session.query(Users)
flag = 0
for user in userlist:
if user.phonenum == phonenum:
if user.name == username:
user.password = password
db_session.commit()
flag = 1
else:
flag = 2
break
if flag == 0:
msg = "手机号还未注册！"
return jsonify({'code': 0, 'msg': msg})
else:
if phonenum != '' and password != '':
if password == password1:
if flag == 1:
msg = "修改密码成功！"
return jsonify({'code': 1, 'name': username, 'phonenum': phonenum})
else:
msg = "用户名输入错误！"
return jsonify({'code': 2, 'msg': msg})
else:
msg = "两次输入密码不一致！"
return jsonify({'code': 3, 'msg': msg})
else:
msg = "请输入完整修改密码信息！"
return jsonify({'code': 4, 'msg': msg})
else:
msg = "提交失败，请重新修改密码！"
return jsonify({'code': 5, 'msg': msg})
def delete():
id = request.form.get('collection_id')
"""
删除这个id的collection，记得刷新顺序
"""
try:
# 删除collection
item = db_session.query(Collection).filter(Collection.id == id).first()
order_item = item.order
db_session.delete(item)
# 刷新order顺序
db_session.query(Collection).filter(Collection.order > order_item).update(
{Collection.order: Collection.order - 1})
db_session.commit()
except BaseException as e:
print(str(e))
ret = {'msg': 'failed!'}
return json_util.dumps(ret)
ret = {'msg': 'succuss'}
return json_util.dumps(ret)
def add_collection():
name = request.form.get('name')
tag = request.form.get('tag', None)
phonenum = request.form.get('phonenum')
id = str(uuid.uuid1())
try:
count = Collection.query.count()
print(count)
c = Collection(id=id, name=name, tag=tag, phonenum=phonenum, order=count)
db_session.add(c)
db_session.commit()
except BaseException as e:
print(e)
ret = {'msg': 'failed!', 'name': name}
return json_util.dumps(ret)
ret = {'msg': 'succuss', 'name': name, 'id': id}
"""；
插入最末尾
ret['id'] =
"""
return json_util.dumps(ret)
def delete():
collection_id = request.form.get('collection_id')
block_id = request.form.get('block_id')
"""
删除这个id的collection的block，记得刷新顺序
"""
try:
db_session.query(CollectionBlock).filter(
CollectionBlock.id == collection_id,
CollectionBlock.block_id == block_id).delete()
item = db_session.query(Block).filter(Block.id == block_id).first()
order_item = item.order
db_session.delete(item)
db_session.query(Block).filter(Block.order > order_item).update(
{Block.order: Block.order - 1})
db_session.commit()
except BaseException as e:
print(str(e))
ret = {'msg': 'failed!'}
return json_util.dumps(ret)
ret = {'msg': 'succuss'}
return json_util.dumps(ret)
def swap():
id = request.form.get('id')
order = request.form.get('new_order')
"""
把这个id的collection和顺序是order的collection交换
编号从零开始，有可能是自己
"""
try:
item1 = db_session.query(Collection).filter(Collection.id == id).first()
item2 = db_session.query(Collection).filter(Collection.order == order).first()
order1 = item1.order
# order2 = item2.order
id2 = item2.id
db_session.query(Collection).filter(Collection.id == id).update({Collection.order: order})
db_session.query(Collection).filter(Collection.id == id2).update({Collection.order: order1})
db_session.commit()
except BaseException as e:
print(str(e))
ret = {'msg': 'failed!'}
return json_util.dumps(ret)
ret = {'msg': 'succuss'}
return json_util.dumps(ret)
def add_block():
type = request.form.get('type')
collection_id = request.form.get("collection_id")
id = str(uuid.uuid4())
print(request.form)
try:
count = Block.query.count()
print(count)
if type == 'text' or type == 'url':
content = request.form.get("content")
b = Block(type=type, content_text=content, order=count, id=id)
else:
img = request.files.get("content")
print(img)
path = basedir + "/static/img/"
file_path = path + id + '.png'
img.save(file_path)
b = Block(type=type,
content_text='static/img/' + id + '.png',
order=count,
id=id)
db_session.add(b)
cb = CollectionBlock(id=collection_id, block_id=id)
db_session.add(cb)
db_session.commit()
except BaseException as e:
print(e)
ret = {'msg': 'failed!', 'collection_id': collection_id}
return json_util.dumps(ret)
ret = {'msg': 'succuss', 'id': id}
"""
插入最末尾
ret['id'] =
"""
return json_util.dumps(ret)