Python & Peewee Query Example Needed

[Rob Gaddi]

On Mon, 16 Feb 2015 11:08:18 -0800, Travis VanDame wrote:

> On Monday, February 16, 2015 at 12:35:00 PM UTC-6, Travis VanDame wrote:
>> I'm new to python and peewee and was looking for an example on how to
>> query a mysql table with a datetime column only returning rows that are
>> 30 days old.
> 
> Well this is what I've come up with....
> 
>    @classmethod
>     def get_archive_xml(cls, day_count):
>         return cls.select().where(cls.created +
>         datetime.timedelta(days=int(day_count)) >=
>         datetime.date.today())


Without having actually executed your code, that looks about right.  
There's probably an efficiency pickup to be had only doing the datetime 
math once, but that's a technicality.  Did it work?

  @classmethod
  def get_archive_xml(cls, day_count):
    then = datetime.date.today()-datetime.timedelta(days=int(day_count))
    return cls.select().where(cls.created >= then)

-- 
Rob Gaddi, Highland Technology -- www.highlandtechnology.com
Email address domain is currently out of order.  See above to fix.