python - SQLAlchemy，Python 我想按从一天开始到一天结束的创建日期来过滤我的模型

Question

我有一个模型，我想通过用户输入的日期时间来过滤数据，该日期时间是从一天的开始到一天的结束，例如DateTime从DateTime“2018-10-18T00:59:59.711602”到DateTime“2018- 10-18T23:59:59.711602"

   @classmethod
   def filter_by_created_date(cls, query, **kwargs):
        getDate = kwargs.get("filter_by_created_date")
        getSecondArgsDate = kwargs.get("filter_by_created_date_second_args")

        if  getDate and getSecondArgsDate is not None:
            DBMediaItem = GrapheneType.db_cls("MediaItem")

            query = query.filter(
                DBMediaItem.created_at < getDate,
                DBMediaItem.created_at >= getSecondArgsDate
            )

        return query

Answer 1

之间:

query = query.filter(DBMediaItem.created_at.between(getDate, getSecondArgsDate))