I am trying to create a query that will show a running list of log
entries for the current day. I have reviewed the web2py docs and the
Python Datetime object documentation, but a working solution continues
to elude me.
Here is a snippet of my model:
db.define_table('item',
Field('barcode','string'),
Field('name','string'),
Field('unit_cost','double'),
Field('unit_price','double')
)
db.define_table('sale',
Field('location_id','reference location'),
Field('timestamp','datetime',default=now, readable=False,
writable=False,),
Field('item_id','reference item'),
Field('qty','integer')
)
And here is the snippet of code from the controller where I attempting
to query and total a running list of the number of items sold on a
given day.
todays_trans = (db.sale.item_id == db.item.id) & (db.sale.timestamp
== datetime.date.today())
return dict(form=crud.create(db.sale),
sales=db(db.sale.item_id == db.item.id).select(limitby=(0,
15), orderby=~db.sale.timestamp),
daytotal=db(todays_trans).select(db.item.name,
db.sale.qty.sum(), groupby=db.sale.item_id)
)
I can not seem to get the second part of the todays_trans WHERE
statement to properly filter for just the current days sales entries.
I have tried (db.sale.timestamp.date() == datetime.date.today()) , but
that just throws this error:
"...AttributeError: 'Field' object has no attribute 'date'..."
Obviously, there is something that I missing concerning accessing the
date portion of my sales table's timestamp field, but I can't find the
answer.
Any ideas?
-Eric
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
