查询SQLAlchemy和Postgres中重叠的时间范围

from sqlalchemy import create_engine, Column, Integer, DateTime
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.sql import and_
from sqlalchemy.dialects.postgresql import TSRANGE

# 创建数据库连接
engine = create_engine('postgresql://username:password@localhost:5432/database')
Session = sessionmaker(bind=engine)
session = Session()

# 创建模型类
Base = declarative_base()

class Event(Base):
    __tablename__ = 'events'
    id = Column(Integer, primary_key=True)
    time_range = Column(TSRANGE)

# 查询重叠的时间范围
start_time = '2022-01-01 00:00:00'
end_time = '2022-01-02 00:00:00'

query = session.query(Event).filter(
    Event.time_range.op('&&')(TSRANGE(start_time, end_time, '[]'))
)

results = query.all()

# 打印查询结果
for event in results:
    print(event.id, event.time_range)