使用SQLite和SQLAlchemy查询格式化日期，以获得用于绘制图形的月份和年份

import datetime
from sqlalchemy import create_engine, func
from sqlalchemy.orm import sessionmaker

engine = create_engine('sqlite:///your_database.db')
Session = sessionmaker(bind=engine)
session = Session()

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, DateTime

Base = declarative_base()

class YourModel(Base):
    __tablename__ = 'your_table'
    id = Column(Integer, primary_key=True)
    date = Column(DateTime)

result = session.query(func.strftime('%Y-%m', YourModel.date)).all()

formatted_dates = [date[0] for date in result]

session.close()