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