SQLAlchemy：如何过滤日期字段？ [英] SQLAlchemy: how to filter date field?

问题描述

这里是模型：

  class User（Base）：
 ... 
 birthday =列（日期，索引= True）#in数据库它像'1987-01-17'
 ... 
  

b $ b

我想在两个日期之间进行过滤，例如选择18-30年间的所有用户。

如何使用SQLAlchemy实现？ / p>

我想起：

  query = DBSession.query .filter（
 and_（User.birthday> ='1988-01-17'，User.birthday< ='1985-01-17'）
）
 
 ＃means age> = 24 and age< = 27 
  

我知道这不正确，如何正确？

提前感谢！

解决方案

事实上，您的查询是正确的除了错字：您的过滤器是排除所有记录：您应该更改< = 为> = ，反之亦然：

  qry = DBSession.query（User）.filter（
 and_ User.birthday< ='1988-01-17'，User.birthday> ='1985-01-17'））
＃或相同：
 qry = DBSession.query（User）。 filter（User.birthday< ='1988-01-17'）。\ 
 filter（User.birthday> ='1985-01-17'）
  

也可以使用之间：

  qry = DBSession.query（User）.filter（User.birthday.between（'1985-01-17'，'1988-01-17'））
  




Here is model:

class User(Base):
    ...
    birthday = Column(Date, index=True)   #in database it's like '1987-01-17'
    ...

I want to filter between two dates, for example to choose all users in interval 18-30 years.

How to implement it with SQLAlchemy?

I think of:

query = DBSession.query(User).filter(
    and_(User.birthday >= '1988-01-17', User.birthday <= '1985-01-17')
) 

# means age >= 24 and age <= 27

I know this is not correct, but how to do correct?

Thanks in advance!

解决方案

In fact, your query is right except for the typo: your filter is excluding all records: you should change the <= for >= and vice versa:

qry = DBSession.query(User).filter(
        and_(User.birthday <= '1988-01-17', User.birthday >= '1985-01-17'))
# or same:
qry = DBSession.query(User).filter(User.birthday <= '1988-01-17').\
        filter(User.birthday >= '1985-01-17')

Also you can use between:

qry = DBSession.query(User).filter(User.birthday.between('1985-01-17', '1988-01-17'))

这篇关于SQLAlchemy：如何过滤日期字段？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！