Answer:
db.define_table('datein',
Field('date_in'),
)
def days_of_week():
import datetime
from datetime import date, timedelta
import calendar
weekNumber = date.today().isocalendar()[1]
today = datetime.date.today()
td = str(today)
dt = datetime.datetime.strptime(td, '%Y-%m-%d')
start = dt - timedelta(days=dt.weekday())
end = start + timedelta(days=6)
step = datetime.timedelta(days=1)
while start <= end:
blah = start.strftime('%Y-%m-%d')
start += step
db.datein.insert(date_in = blah)
if db(db.datein).isempty(): days_of_week()
On Saturday, 30 April 2016 12:44:25 UTC-4, Wayne Tooley wrote:
>
> Hi Everyone;
> I hardly ever post as I can usually find answers to my questions but I
> have been having a hard time with this datetime stuff. When I run the code
> in db1.py (minus the databse code) with pycharm I get the correct results.
> Running it in Web2py I get the correct dates but it gives 3 sets of them.
> I'm sure it's simple but I can't figure it out. Any help appreciated.
> Thanks....
>
>
>
> *db1.py*
> db.define_table('datein',
> Field('date_in'),
> )
>
> import datetime
> from datetime import date, timedelta
> import calendar
>
> weekNumber = date.today().isocalendar()[1]
>
> today = datetime.date.today()
>
> td = str(today)
>
> dt = datetime.datetime.strptime(td, '%Y-%m-%d')
>
> start = dt - timedelta(days=dt.weekday())
>
> end = start + timedelta(days=6)
>
> step = datetime.timedelta(days=1)
> while start <= end:
> blah = start.strftime('%Y-%m-%d')
> db.datein.insert(date_in=blah)
> # if not db(db.datein).count():
> start += step
>
> *Result*
> 21 selected
> datein.id
> <http://127.0.0.1:8000/testinput/appadmin/select/db?orderby=datein.id>
> datein.date_in
> <http://127.0.0.1:8000/testinput/appadmin/select/db?orderby=datein.date_in>
> 545 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/545>
> 2016-04-25
> 546 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/546>
> 2016-04-26
> 547 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/547>
> 2016-04-27
> 548 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/548>
> 2016-04-28
> 549 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/549>
> 2016-04-29
> 550 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/550>
> 2016-04-30
> 551 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/551>
> 2016-05-01
> 552 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/552>
> 2016-04-25
> 553 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/553>
> 2016-04-26
> 554 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/554>
> 2016-04-27
> 555 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/555>
> 2016-04-28
> 556 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/556>
> 2016-04-29
> 557 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/557>
> 2016-04-30
> 558 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/558>
> 2016-05-01
> 559 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/559>
> 2016-04-25
> 560 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/560>
> 2016-04-26
> 561 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/561>
> 2016-04-27
> 562 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/562>
> 2016-04-28
> 563 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/563>
> 2016-04-29
> 564 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/564>
> 2016-04-30
> 565 <http://127.0.0.1:8000/testinput/appadmin/update/db/datein/565>
> 2016-05-01
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
