SQL Alchemy - 如何从模型实例中删除？

from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
from models import YourModel

engine = create_engine('sqlite:///your_database.db')
Session = sessionmaker(bind=engine)
session = Session()

# 获取要删除的实例
instance_to_delete = session.query(YourModel).filter(YourModel.id == your_id).first()

# 删除实例
session.delete(instance_to_delete)

# 提交更改
session.commit()

from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
from models import YourModel

engine = create_engine('sqlite:///your_database.db')
Session = sessionmaker(bind=engine)
session = Session()

# 删除实例
session.query(YourModel).filter(YourModel.id == your_id).delete()

# 提交更改
session.commit()

from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine, delete
from models import YourModel

engine = create_engine('sqlite:///your_database.db')
Session = sessionmaker(bind=engine)
session = Session()

# 删除实例
delete_query = delete(YourModel).where(YourModel.id == your_id)
session.execute(delete_query)

# 提交更改
session.commit()