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)