def get_by_name(self, name: str): try: logging.debug("MachineDAO:get_by_name() on name : {}".format(name)) return self._database_session.query(Machine).filter_by( name=name, brand=brand).order_by(Machine.name).one() except NoResultFound: logging.error("MachineDAO:get_by_name() on name : {}".format(name)) raise ResourceNotFound()
def get(self, id): try: logging.debug("CoachDAO:get() on id : {}".format(id)) return self._database_session.query(Coach).filter_by( id=id).order_by(Coach.firstname).one() except NoResultFound: logging.error("CoachDAO:get() on id : {}".format(id)) raise ResourceNotFound()
def get_all(self): try: logging.debug("MachineDAO:get_all()") return self._database_session.query(Machine).filter_by( Machine.name).all() except NoResultFound: logging.error("MachineDAO:get_all()") raise ResourceNotFound()
def gather_all_informations(self): try: logging.debug("CoachDAO:gather_all_informations()") fields = ['id', 'email', 'phone_number'] return self._database_session.query(Coach.id, Coach.email, Coach.phone_number, Coach.lastname).all() except NoResultFound: logging.error("CoachDAO:gather_all_informations()") raise ResourceNotFound()
def get(self, id=None): if id is not None: objs = self.original_query.get(id) if not objs: raise ResourceNotFound(self.model_title, id) else: if self.opts['paginate']: objs = self.get_query().items else: objs = self.get_query().all() self.opts['many'] = (id is None) return objs
def handler(*args, **kwargs): try: return func(*args, **kwargs) except NoResultFound: logging.error("NoResultFound caught from SQLAlchemy") raise ResourceNotFound("Resource not found") except IntegrityError as e: logging.debug("Integrity error caught from SQLAlchemy (%s)" % str(e)) raise Error("Error data may be malformed") except SQLAlchemyError as e: raise Error("An error occurred (%s)" % str(e))
def get_by_name(self, firstname: str, lastname: str): try: logging.debug( "CoachDAO:get_by_name() on firstname : {}, lastname : {}". format(firstname, lastname)) return self._database_session.query(Coach).filter_by( firstname=firstname, lastname=lastname).order_by(Coach.firstname).one() except NoResultFound: logging.error( "CoachDAO:get_all() on firstname : {}, lastname : {}".format( firstname, lastname)) raise ResourceNotFound()
def delete_sport(self, sport, session): sport_association = None for association in self.sports: if association.sport == sport: sport_association = association break if sport_association is not None: self.sports.remove(sport_association) session.delete(sport_association) session.flush() else: raise ResourceNotFound("Sport %s not assigned to user %s" % (sport.name, self.firstname))
def delete(self, id=None): if id is not None: dbo = self.original_query.get(id) if not dbo: return jsonify({ self.pk: id, 'deleted': False, 'message': ResourceNotFound(self.model_title, id).message }) db.session.delete(dbo) db.session.commit() if self.cached: cache.clear() return jsonify({'deleted': True}) else: query = self.get_query(skip_order_query=True, skip_paginate_query=True) log.debug("Delete query: \n%s" % query) count = query.delete(synchronize_session='fetch') return jsonify({'deleted': True})
def get_all(self): try: return self._database_session.query(Article).order_by(Article.name).all() except NoResultFound: raise ResourceNotFound()
def get_all(self): try: return self._database_session.query(Bras).order_by( Bras.B_NumSerie).all() except NoResultFound: raise ResourceNotFound()
def get_by_Microcontroleur(self, MC_ID: str): try: return self.__data_session.query(Robot).filter_by( MC_ID=Mc_ID).order_by(Robot.R_Nom).one() except NoResultFound: raise ResourceNotFound()
def get_by_Nom(self, R_Nom: str): try: return self._database_session.query(Robot).filter_by( R_Nom=R_Nom).order_by(Robot.R_Nom).one() except NoResultFound: raise ResourceNotFound()
def get_all(self): try: return self._database_session.query(Member).order_by( Member.firstname).all() except NoResultFound: raise ResourceNotFound()
def get_all_mail(self): try: return self._database_session.query(Admin.login).all() except NoResultFound : raise ResourceNotFound()
def get(self, id): try: return self._database_session.query(Lesson).filter_by(id=id).order_by(Lesson.date).one() except NoResultFound: raise ResourceNotFound()
def get_by_name(self, username: str): try: return self._database_session.query(User).filter_by(username=username) \ .order_by(User.username).one() except NoResultFound: raise ResourceNotFound()
def put(self, id=None): data = self.get_data() # Loop through updates objs = [] for d in data: self.raise_if_forbidden(d, type='write') # Check for object existence oid = d.pop(self.pk, None) or d.pop('id', None) or id if oid is None: raise ResourceFieldMissing(self.model_title, self.pk, request.method) # Get object to update log.debug("Updating %s.%s with update: \n%s" % (self.model_title, oid, pprint.pformat(d))) obj = self.original_query.get(oid) if not obj: raise ResourceNotFound(self.model_title, oid) # Relationship updates if self.opts['_action'] == 'append': rel_updates = { k: v for k, v in d.items() if k in self.relationships } new, errors = self.schema().load(rel_updates, session=db.session, partial=True) if errors: raise SchemaValidationError(self.model_title, errors=errors) make_transient(new) # to avoid IntegrityErrors for name in rel_updates: rel_old = getattr(obj, name) rel_new = getattr(new, name) rel_old.extend(rel_new) d = {k: v for k, v in d.items() if k not in rel_updates} # Other updates _, errors = self.schema().load(d, instance=obj, session=db.session, partial=True) if errors: raise SchemaValidationError(self.model_title, errors=errors) # Add this db object objs.append(obj) # Add all objects and commit db.session.add_all(objs) db.session.commit() # Clear cache # if self.cached: cache.clear() # Set 'many' option for jsonify self.opts['many'] = (id is None) return objs
def get_all(self): try: return self._database_session.query(Microcontroleur).order_by( Microcontroleur.MC_NumSerie).all() except NoResultFound: raise ResourceNotFound()
def get_by_Moteur(self, M_ID: str): try: return self._database_session.query(Microcontroleur).filter_by( M_ID=M_ID).order_by(Microcontroleur.MC_NumSerie).one() except NoResultFound: raise ResourceNotFound()
def get_all(self): try: return self._database_session.query(Music_Like).all() except NoResultFound: raise ResourceNotFound()
def get_by_user_id(self, user_id): try: return self._database_session.query(Music_Like).filter_by( id_utilisateur=user_id).all() except NoResultFound: raise ResourceNotFound()
def get_by_NumSerie(self, B_NumSerie: str): try: return self._database_session.query(Bras).filter_by( B_NumSerie=B_NumSerie).order_by(Bras.B_NumSerie).one() except NoResultFound: raise ResourceNotFound()
def get_by_date_time(self, date: str, start_time: int, end_time: int): try: return self._database_session.query(Lesson).filter_by(date=date, start_time=start_time, end_time=end_time) \ .order_by(Lesson.date).one() except NoResultFound: raise ResourceNotFound()
def get_by_name(self, name: str): try: return self._database_session.query(Aticle).filter_by(name=name)\ .order_by(Article.name).one() except NoResultFound: raise ResourceNotFound()
def get_by_NumSerie(self, M_NumSerie: str): try: return self._database_session.query(Moteur).filter_by(M_NumSerie=M_NumSerie).order_by(Moteur.M_NumSerie).one() except NoResultFound: raise ResourceNotFound()
def get(self, id): try: return self._database_session.query(Member).filter_by( id=id).order_by(Member.firstname).one() except NoResultFound: raise ResourceNotFound()
def get(self, id): try: return self._database_session.query(Microcontroleur).filter_by( id=id).order_by(Microcontroleur.MC_NumSerie).one() except NoResultFound: raise ResourceNotFound()
def get_by_name(self, firstname: str, lastname: str): try: return self._database_session.query(Member).filter_by(firstname=firstname, lastname=lastname)\ .order_by(Member.firstname).one() except NoResultFound: raise ResourceNotFound()
def retrieve_url(url, cookies=None, headers=None): res = requests.get(url, cookies=cookies, headers=headers) if res.status_code != 200: raise ResourceNotFound( f'Server responded with {res.status_code} to {url}') return res