On Tuesday, October 3, 2017 at 5:08:27 PM UTC-7, Dave S wrote:
>
>
>
> On Tuesday, October 3, 2017 at 4:48:52 PM UTC-7, Jim S wrote:
>>
>> I don't think that will do it. The date stored in the database would be
>> 10/15/1980, or 10/21/1993.
>>
>> Those should both show a birthday in the month of August.
>>
>
> Er, October?
>
>
>> But, I don't want just a matching month. I want it for the next 30 days.
>>
>> So, on December 15th I should see all birthdays between December 15th and
>> January 15th regardless of what year the birthday is in.
>>
>> Jim
>>
>>
> It's not too much more. You identify the current day and month, and the
> day and month of 30 days from now, and do 2 selects:
> First for the bdays whose month matches the current and whose day is
> greater than today.
> Second for the bdays whose month matches the successor month and whose day
> is less than the +30 day.
>
>
Here's my actual code. It doesn't do a thirty day window, just to EOM
(and then tacks on a few if being near EOM makes the results short)
def overview():
results = db((db.composer.birthdate.month()==request.now.month)&(db.
composer.birthdate.day()>=request.now.day)).select( db.composer.given_names,
db.composer.surname, db.composer.birthdate,
limitby=(0, 75), orderby=~db.composer.birthdate.month()|db.
composer.birthdate.day())
if len(results) < 3:
results2 = db(db.composer.birthdate.month()==monthsuccessor(request.
now.month)).select( db.composer.given_names, db.composer.surname, db.
composer.birthdate,limitby=(0,2), orderby=db.composer.birthdate.day())
results = results | results2
return dict(records=results)
def monthsuccessor(month):
if month == 12: return 1
return month + 1
Right now, the overview results look a lot like the month results below,
but start at Gottschalk.
(My example covers years from 1600 to present, for composers. i also have
> getting everybody in any single calendar month, which is just one query.
> Results for October:
>
(without the table formatting, this looks better in monospaced fonts. I
should have done tabs->spaces, too)
>
> Paul Abraham Dukas 1865-10-01
> Stephen Michael Reich 1936-10-03
> Louis Ferdinand Gottschalk 1864-10-07
> Toru Takemitsu 1930-10-08
> Giulio Romolo Caccini 1551-10-08
> Charles-Camille Saint-Saëns 1835-10-09
> Einojuhani Rautavaara 1928-10-09
> Giuseppe Fortunino Francesco Verdi 1813-10-10
> Ralph Vaughan Williams 1872-10-12
> Sylvius Leopold Weiss 1687-10-12
> Healey Willan 1880-10-12
> Ciprian Porumbescu 1853-10-14
> Dag Ivar Wirén 1905-10-15
> Jan Dismas Zelenka 1679-10-16
> Albert Franz Doppler 1821-10-16
> Domenico Zipoli 1688-10-17
> Herbert Norman Howells 1892-10-17
> Baldassare Galuppi 1706-10-18
> Howard Leslie Shore 1946-10-18
> Charles Edward Ives 1874-10-20
> Sir Malcolm Henry Arnold 1921-10-21
> Joseph Canteloube 1879-10-21
> Franz Liszt 1811-10-22
> Ned Rorem 1923-10-23
> Johann Baptist (II) Strauss 1825-10-25
> Georges Bizet 1838-10-25
> Peter Lieberson 1946-10-25
> Giuseppe Domenico Scarlatti 1685-10-26
> Niccolò Paganini 1782-10-27
> Carl Davis 1936-10-28
> Peter Warlock 1894-10-30
> Unico Wilhelm van Wassenaer 1692-10-30
>
> )
>
>
/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.
