SQLAlchemy按时间串过滤

from datetime import datetime
from sqlalchemy import create_engine, Column, DateTime, Integer
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class MyTable(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    created_at = Column(DateTime)

# 创建数据库连接
engine = create_engine('your_database_connection_string')
Session = sessionmaker(bind=engine)
session = Session()

# 按时间串过滤数据
start_time = datetime(2022, 1, 1)
end_time = datetime(2022, 12, 31)
query = session.query(MyTable).filter(MyTable.created_at.between(start_time, end_time))
results = query.all()

# 打印结果
for result in results:
    print(result.id, result.created_at)

# 关闭数据库连接
session.close()