def delete_table_json(id):
resp = not_implimented()
if request.method == 'GET':
lst = List.query.filter_by(id=id).first()
resp = jsonify(name = lst.name), 201
elif request.method == 'DELETE':
user_list = UserList.query.filter_by(user_id=session.get('user'), list_id=id).first()
user_lists = UserList.query.filter_by(list_id=id).all()
if len(user_lists) <= 1:
lst = List.query.filter_by(id=id).first()
db.session.delete(lst)
db.session.delete(user_list)
db.session.commit()
message = {
'status': 201,
'message': 'Created: '+request.url,
}
resp = jsonify(message)
resp.status_code = 201
return resp
def get_list():
resp = not_implimented()
if request.method == 'GET':
user = session.get('user')
lst = List.query.outerjoin(UserList, List.id == UserList.list_id).filter_by(user_id = user).all()
resp = jsonify(data=[i.serialize for i in lst]), 201
elif request.method == 'POST':
obj = request.get_json(silent=True)
lst = List.query.outerjoin(UserList, List.id == UserList.list_id).filter(List.name.ilike(obj)).filter(UserList.user_id == session.get('user')).first()
if lst is None:
lst = List(obj, session.get('user'))
db.session.add(lst)
kst = List.query.filter_by(creator_id = session.get('user')).order_by(List.id.desc()).first();
userList = UserList(session.get('user'), kst.id)
db.session.add(userList)
db.session.commit()
message = {
'status': 201,
'message': 'Created: '+request.url,
}
resp = jsonify(message), 201
return resp
