Message-
From: sqlalchemy@googlegroups.com
[mailto:sqlalchemy@googlegroups.com] On Behalf Of Simon King
Sent: Friday, October 04, 2013 7:01 PM
To: sqlalchemy@googlegroups.com
Subject: Re: [sqlalchemy] Query for date between a range
I'm not sure that will work on it's own, will it? When used
You can create a custom field in your model and check against it:
class Plan(Base):
.
.
.
@property
def calculated_date(self):
return date(self.year, self.month, self.day)
Then, in your query, use that field:
Subject: Re: [sqlalchemy] Query for date between a range
On Fri, 4 Oct 2013 15:55:07 +0300
Ofir Herzas herz...@gmail.com wrote:
You can create a custom field in your model and check against it:
class Plan(Base):
.
.
.
@property
def calculated_date(self):
return
tail.
-Original Message-
From: sqlalchemy@googlegroups.com
[mailto:sqlalchemy@googlegroups.com] On Behalf Of Enrico Morelli
Sent: Friday, October 04, 2013 4:05 PM
To: sqlalchemy@googlegroups.com
Subject: Re: [sqlalchemy] Query for date between a range
On Fri, 4 Oct 2013 15:55:07
modules are
frozen to avoid problems.
-Original Message-
From: sqlalchemy@googlegroups.com
[mailto:sqlalchemy@googlegroups.com] On Behalf Of Enrico Morelli
Sent: Friday, October 04, 2013 4:05 PM
To: sqlalchemy@googlegroups.com
Subject: Re: [sqlalchemy] Query for date between
, 2013 4:05 PM
To: sqlalchemy@googlegroups.com
Subject: Re: [sqlalchemy] Query for date between a range
On Fri, 4 Oct 2013 15:55:07 +0300
Ofir Herzas herz...@gmail.com wrote:
You can create a custom field in your model and check against it:
class Plan(Base):
.
.
.
@property
That query looks weird.
I'd suggest converting everything to a date in the database and having the
db sort it --
on postgres it would look like this --
create table test_date ( id serial primary key not null , int , mm int
, dd int );
select *
from
test_date
where
(
: Friday, October 04, 2013 4:05 PM
To: sqlalchemy@googlegroups.com
Subject: Re: [sqlalchemy] Query for date between a range
On Fri, 4 Oct 2013 15:55:07 +0300
Ofir Herzas herz...@gmail.com wrote:
You can create a custom field in your model and check against it:
class Plan(Base