如何使用sqlite作为数据库在python中为peewee列设置datediff？

pip install peewee
pip install pysqlite3

from peewee import *
from datetime import datetime

db = SqliteDatabase('mydatabase.db')

class MyModel(Model):
    date_field = DateField()

    class Meta:
        database = db

db.create_tables([MyModel])

MyModel.create(date_field=datetime.now().date())

query = MyModel.select().where(fn.date_diff(MyModel.date_field, datetime.now().date()) > 7)

results = query.execute()
for result in results:
    print(result.date_field)