sqlalchemy 取两个时间段的数据
from_day = datetime.now().replace(hour=0, minute=0, second=0, microsecond=0)
to_day = datetime.now().replace(hour=23, minute=59, second=59, microsecond=999999)
print(from_day)
session.query(Stock_rpa_mb52).filter(Stock_rpa_mb52.export_date >=from_day,
Stock_rpa_mb52.export_date <= to_day).delete()
session.commit()
excel_mb52_to_db()
查询的时候可以用 between,删除或更新的时候不可以
session.query(Stock_rpa_mb52).filter(Stock_rpa_mb52.export_date.between(from_day, to_day)).all()
获取当天0点之后的数据,执行结果为10条
# 查询执行结果
def query_result():
test = datetime.now().replace(hour=0, minute=0, second=0, microsecond=0)
print(test)
results = ss.query(Material).filter(Material.transfer >= test).all()
print(len(results))
参考
https://stackoverflow.com/questions/12686735/how-to-get-time-170000-today-or-yesterday