7日滚动平均值的Peewee / SQLite查询

from datetime import datetime, timedelta
from peewee import *

# 连接SQLite数据库
db = SqliteDatabase('data.db')

# 定义模型类
class Data(Model):
    date = DateField()
    value = FloatField()

    class Meta:
        database = db

# 创建数据表
db.create_tables([Data])

# 计算7日滚动平均值
end_date = datetime.now().date()
start_date = end_date - timedelta(days=6)

query = (Data
         .select(fn.avg(Data.value).alias('average'))
         .where(Data.date.between(start_date, end_date)))

average = query.scalar()

print(f"7日滚动平均值: {average}")