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)