def delete(self, id): route = Route.get(id) if route: try: Route.delete(id) return jsonify({'success': u'删除成功'}) except IntegrityError, e: response = jsonify({'error': u'存在引用的外鍵'}) response.status_code = 422
def get(self, id): buses_in_group = Bus.query.filter(and_(Bus.user_id == g.user.id, Bus.group_id == id)).all() buses_in_group_res = [] for bus in buses_in_group: b = dict() b['route_id'] = bus.route_id b['bus_name'] = bus.plate_number b['bus_id'] = bus.id b['bus_eui'] = bus.eui buses_in_group_res.append(b) routes = Route.get_routes() buses_all = Bus.get_all() res = [] for route in routes: data = {} data['route_id'] = route.id data['route_name'] = route.route_name buses = [] for bus in buses_all: if bus.route_id == route.id: in_group = bus.group_id == id buses.append({'route_id': bus.route_id, 'bus_name': bus.plate_number, 'bus_id': bus.id, 'in_group': in_group, 'bus_eui': bus.eui}) data['buses'] = buses res.append(data) return jsonify({'buses_all': res, 'in_group': buses_in_group_res})
def post(self): district_id = request.json.get('district_id') route_name = request.json.get('route_name') if not route_name: abort(422) route = Route(district_id, route_name) db.session.add(route) db.session.commit() return route
def put(self, id): district_id = request.json.get('district_id') route_name = request.json.get('route_name') route = Route.get(id) if not route: abort(404) route.district_id = district_id route.route_name = route_name db.session.add(route) db.session.commit() return route, 201
def delete(self, id): route = Route.get(id) if route: if route.buses: return jsonify({'resCode': '30', 'resMsg': 'theere is some buses index for it'}) else: db.session.delete(route) db.session.commit() return jsonify({"resCode": '20', 'resMsg': 'delete success'}) else: return jsonify({"resCode": '30', 'resMsg': 'route is not exit'})
def get(self, id): route = Route.get(id) if not route: abort(404) return route
def get(self): routes = Route.get_routes() # if not routes: # abort(404) return routes