从Peewee查询中删除相关表

from peewee import *

db = SqliteDatabase('my_database.db')

class BaseModel(Model):
    class Meta:
        database = db

class User(BaseModel):
    username = CharField()

class Order(BaseModel):
    user = ForeignKeyField(User, backref='orders')
    product = CharField()

# 创建表
db.create_tables([User, Order])

# 插入数据
user = User.create(username='john')
Order.create(user=user, product='product1')
Order.create(user=user, product='product2')

# 级联删除用户及其所有订单
user.delete_instance(recursive=True)

from peewee import *

db = SqliteDatabase('my_database.db')

class BaseModel(Model):
    class Meta:
        database = db

class Post(BaseModel):
    title = CharField()
    content = TextField()
    is_deleted = BooleanField(default=False)

# 创建表
db.create_tables([Post])

# 插入数据
post = Post.create(title='Hello World', content='This is a test post.')

# 软删除帖子
post.is_deleted = True
post.save()

class Order(BaseModel):
    user = ForeignKeyField(User, backref='orders', on_delete='cascade')
    product = CharField()

# 查询所有未被软删除的帖子
posts = Post.select().where(Post.is_deleted == False)