def delete_sow(self, context, id): session = get_session() with session.begin(): query = model_query(models.Sow, session=session, read_deleted="no") query = query.filter_by(id=id) try: query.soft_delete() except NoResultFound: raise exception.ResourceNotFound(name='sow', id=id)
def update_boar(self, context, id, updates): session = get_session() with session.begin(): query = model_query(models.Boar, session=session) query = query.filter_by(id=id) try: ref = query.with_lockmode('update').one() except NoResultFound: raise exception.ResourceNotFound(name='boar', id=id) ref.update(updates) return ref
def get_state_by_id(self, context, id): session = get_session() with session.begin(): #query = model_query(models.State).filter_by(id=id) query = model_query(models.State) try: query = query.filter_by(id=id) return query.one() except NoResultFound: raise exception.ResourceNotFound(name='State', id=id)
def get_sow_by_id(self, context, id): session = get_session() with session.begin(): #query = model_query(models.Sow).filter_by(id=id) query = model_query(models.Sow) columns_to_join = ['category', 'dormitory', 'source', 'state'] for column in columns_to_join: query = query.options(joinedload(column)) try: query = query.filter_by(id=id) return query.one() except NoResultFound: raise exception.ResourceNotFound(name='Sow', id=id)
def get_user_by_id(self, context, id): session = get_session() with session.begin(): #query = model_query(models.User).filter_by(id=id) query = model_query(models.User) columns_to_join = ['project'] for column in columns_to_join: query = query.options(joinedload(column)) try: query = query.filter_by(id=id) return query.one() except NoResultFound: raise exception.ResourceNotFound(name='User', id=id)