目的:查询数据库中本年、本月、本日的销售数量
引入:
from datetime import date,datetime
from sqlalchemy import extract
# 日激活量
today = datetime.utcnow()
today_activate_card = Activate_Card.query.filter(extract('year', Activate_Card.activate_time) == today.year,
extract('month', Activate_Card.activate_time) == today.month,
extract('day', Activate_Card.activate_time) == today.day).all()
today_activate_num = len(today_activate_card)
# 月激活量
month_activate_card = Activate_Card.query.filter(extract('year', Activate_Card.activate_time) == today.year,
extract('month', Activate_Card.activate_time) == today.month).all()
month_activate_num = len(month_activate_card)
# 年激活量
year_activate_card = Activate_Card.query.filter(extract('year', Activate_Card.activate_time) == today.year,).all()
year_activate_num = len(year_activate_card)
其中Activate_Card是我的类名,activate_time是数据库中字段为date的属性,extract是过滤。