[web2py] Re: List | Create | Modify and Delete Users directly from Python controller without using HMI

2020-06-04 Thread Nicolas Hiblot
Thanks Dave and Val It's perfect !! Web2py forever Le mardi 2 juin 2020 23:57:31 UTC+2, Nicolas Hiblot a écrit : > > Hello All, > > I have read a lot of cases and uses cases about web2py users. > But my case is a little différent ; > I would like to > > *List | Create | Modify and Delete Use

[web2py] Re: List | Create | Modify and Delete Users directly from Python controller without using HMI

2020-06-04 Thread Val K
db.auth_user is just a table like any other 1) db(~db.auth_user.id.belongs([1,2])).select(...) or db(~db.auth_user.username.belongs(['user0', 'user1'])).select(...) note that `~` inverts `belongs` i.e. it is equal sql -`NOT IN` 2) db.auth_user.insert(username = 'John', ...) - nothing new e

Re: [web2py] Re: web2py online debugger under python3

2020-06-04 Thread Clemens
Hi Andrew, I've switched over to PyCharm and really like it. Thanks a lot for the push! Best regards Clemens On Wednesday, May 6, 2020 at 3:11:00 AM UTC+2, AGRogers wrote: > > Hi Clemens > > I think a standalone debugger is much better. The online debugger could be > great to debug application

[web2py] Re: Changing my datetime from UTC to local time

2020-06-04 Thread mostwanted
Instead of using this method i decided to just add the time difference to the UTC time to get my local time. import datetime db.define_table('my_token', Field('purchased_on', 'datetime', default=(request.now+datetime. timedelta(hours=2)), readable=False, writable=False), .