Re: [web2py] matching a Week day in query
On Wednesday, November 2, 2016 at 1:47:20 AM UTC-7, Manuele wrote: > > Il 02/11/16 09:27, icodk ha scritto: > > Ex. on Manday I want to select all record where the Monday field is true. > > maybe something like that? > > from datetime import dateimport calendarmy_date = date.today() > > There's request.now, which has already done these steps, though you'll need the import below. Also, it assumes that today is the day the OP is looking for, but generalizing should not be hard. > dow = calendar.day_name[my_date.weekday()].lower() > db(db.time_rule[dow]==True).select() > > I misread this the first time I looked at your answer, misled by the field called dowmask (an integer). > > > M. > /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] matching a Week day in query
Thanks Manuele Looks like it work On Wednesday, November 2, 2016 at 9:47:20 AM UTC+1, Manuele wrote: > > Il 02/11/16 09:27, icodk ha scritto: > > Ex. on Manday I want to select all record where the Monday field is true. > > maybe something like that? > > from datetime import dateimport calendarmy_date = date.today()dow = > calendar.day_name[my_date.weekday()].lower() > db(db.time_rule[dow]==True).select() > > > M. > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] matching a Week day in query
Il 02/11/16 09:27, icodk ha scritto: > Ex. on Manday I want to select all record where the Monday field is true. maybe something like that? |fromdatetime importdate importcalendar my_date =date.today()dow = calendar.day_name[my_date.weekday()].lower() db(db.time_rule[dow]==True).select() | ||M.| | || -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] matching a Week day in query
I have a table with a Boolean field for each week day. How can I select all records of which a certain week day is true ? Ex. on Manday I want to select all record where the Monday field is true. db.define_table('time_rule', Field('start_time','time'), Field('end_time','time'), Field('monday','boolean'). Field('tuesday','boolean'), Field('wednesday','boolean'), Field('thursday','boolean'), Field('friday','boolean'), Field('saturday','boolean'), Field('sunday','boolean'), Field('dowmask','integer') ) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.