在sqlalchemy和flask中获取上月数据

from datetime import datetime, timedelta
from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'your_database_uri'
db = SQLAlchemy(app)

class YourModel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    # 其他字段定义...
    created_at = db.Column(db.DateTime, default=datetime.utcnow)

today = datetime.now().date()
first_day_of_this_month = datetime(today.year, today.month, 1).date()
first_day_of_last_month = first_day_of_this_month - timedelta(days=1)
last_month_start = datetime(first_day_of_last_month.year, first_day_of_last_month.month, 1)
last_month_end = first_day_of_this_month - timedelta(days=1)

last_month_data = YourModel.query.filter(YourModel.created_at >= last_month_start, YourModel.created_at <= last_month_end).all()