对SQLALCHEMY和flask中的一对多关系进行排序和删除

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///example.db'
db = SQLAlchemy(app)

class Author(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    books = db.relationship('Book', backref='author', lazy=True)

class Book(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100))
    author_id = db.Column(db.Integer, db.ForeignKey('author.id'))

# 排序一对多关系
author = Author.query.filter_by(name='John').first()
sorted_books = author.books.order_by(Book.title.desc()).all()

# 删除一对多关系
author = Author.query.filter_by(name='John').first()
for book in author.books:
    db.session.delete(book)
db.session.delete(author)
db.session.commit()