def deletar(id):
try:
session = Session()
item = session.query(Item).get(id)
session.delete(item)
session.commit()
except Exception as e:
return internal_error(e), 500
finally:
session.close()
def delete(self, id):
status = 200
session = Session()
deleteStock = session.query(Stock).filter_by(id = id).first()
if deleteStock:
session.delete(deleteStock)
res = deleteStock._asdict()
session.flush()
session.commit()
session.close()
else:
errors = []
errors.append('Stock not found')
status = 400
res = GenericError(0, errors).__dict__
return res, status
'''
Purpose: Join Query
'''
from connection import Session, engine, Base
from user_model import User, Address
from sqlalchemy.sql import func
session = Session()
amit = session.query(User).filter_by(name='amit').one()
session.delete(amit)
amit = session.query(User).filter_by(name='amit').count()
print('jack persernt', amit)
user_date=session.query(User,Address).filter(User.id==Address.user_id).\
filter(Address.email_address=='*****@*****.**').all()
for user, address in user_date:
print(user)
print(address)
# using join operation
user_details = session.query(User).join(Address).all()
for user in user_details:
print(user)
stmt = session.query(Address.user_id, func.count('*').\
label('address_count')).\
group_by(Address.user_id).subquery()
for u, count in session.query(User, stmt.c.address_count).\
'''
cascade delete both table
'''
from connection import Session, engine, Base
from user_model import User, Address
session = Session()
#get user obj using id
jack = session.query(User).get(10)
print(jack)
#delete one address usign obj
del jack.addresses[1]
query = session.query(Address).filter(
Address.email_address.in_(['*****@*****.**', '*****@*****.**'])).count()
print(query)
session.delete(jack)
user = session.query(User).filter_by(name='amit').count()
print(user)
query = session.query(Address).filter(
Address.email_address.in_(['*****@*****.**', '*****@*****.**'])).count()
print(query)
