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 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 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
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
