from sqlalchemy.orm import sessionmaker from myapp.models import User from myapp.database import engine Session = sessionmaker(bind=engine) session = Session() # Delete a single object user = session.query(User).filter_by(username='alice').first() session.delete(user) # Delete multiple objects users = session.query(User).filter_by(active=False).all() for user in users: session.delete(user) session.commit()
from sqlalchemy.orm import Session from myapp.models import User from myapp.database import session_factory session = Session(session_factory()) # Delete all objects of a given type session.query(User).delete() session.commit()In this example, we use a session factory function to create a session object, and then delete all user objects from the database. Overall, the Python SQLAlchemy ORM package library is a powerful tool that simplifies database operations in Python applications. The Session class delete() method is just one of many convenient APIs provided by SQLAlchemy ORM.