def api_modify_sight(): request_data = request.args.to_dict(flat=True) if 'tag' in request_data: request_data['tag'] = request_data['tag'].split(',') request_data.pop('id_sight') session.query(Sights).filter(Sights.id_sight == request.args['id_sight']).update(request_data) session.commit() return jsonify({'message': None, 'data': request_data, 'status': 'success'}), 200
def update(self, data, object_id): port = session.query(Port).filter_by(port_id=object_id).first() port = self._parse_port(data=data, port=port) try: session.commit() return port except Exception as e: print(e.__str__()) session.rollback() return None
def update(self, data, object_id): region = session.query(Region).filter_by(region_id=object_id).first() region = self._parse_region(data=data, region=region) try: session.commit() return region except Exception as e: print(e.__str__()) session.rollback() return None
def check_exist(self, data): if not isinstance(data, dict): return None vessel = self._parse_vessel(data=data, vessel=None) if vessel is None: return None search = session.query(Vessel).filter(Vessel.name == vessel.name).first() if search is None: return False, vessel else: return True, search
def check_exist(self, data): if not isinstance(data, dict): return None region = self._parse_region(data=data, region=None) if region is None: return None search = session.query(Region).filter(Region.name == region.name, Region.acronym == region.acronym).first() if search is None: return False, region else: return True, search
def get_by_id(self, port_id): port = session.query(Port).filter_by(port_id=port_id).first() return port