Re: [web2py] Re: How to iterate through column items and display its rows data

2018-05-05 Thread Maurice Waka
Thanks. It worked On Sun, 6 May 2018, 06:03 Massimo Di Pierro wrote: > you know you can do > > row = db(db.person.id>0).select(limitby=(0,1),orderby='').first() > > > On Tuesday, 1 May 2018 17:06:26 UTC-5, pbreit wrote: >> >> I am very sorry, I need to be more

[web2py] Re: web2py 2.16.1 is OUT

2018-05-05 Thread Massimo Di Pierro
can you show an example of what you mean? On Friday, 27 April 2018 21:21:47 UTC-5, lyn2py wrote: > > Hello, > > The traceback for Python 3 is not like the ones in Python 2 and it can get > difficult to debug the program, is it possible to see a fix soon? > > Thank you! > > On Tuesday, November

[web2py] Re: SQLite data file in production-backing up

2018-05-05 Thread Massimo Di Pierro
.htaccess? I would not recommend using apache. Use nginx. On Thursday, 3 May 2018 03:35:39 UTC-5, Tom Campbell wrote: > > SQLite is more than enough for my needs, I think. In the best of worlds we > will have no more than a few thousand customers after we get up and > running. But I'm not sure

[web2py] Re: [OFF TOPIC] Telegram Group for Web2py users

2018-05-05 Thread Massimo Di Pierro
Thank you. On Wednesday, 2 May 2018 16:48:52 UTC-5, marco mansilla wrote: > > I know this is the main communication channel for web2py users community, > but just in case anyone wants some interactivity I have created > https://t.me/web2py > > > Marco. > -- Resources: - http://web2py.com -

[web2py] Re: Guarantee closing of DB connections when using PyDAL outside a request

2018-05-05 Thread Massimo Di Pierro
maybe something like this? try: your script that defines a db = DAL(...) finally: db.close() On Saturday, 5 May 2018 19:53:48 UTC-5, Brendan Barnwell wrote: > > I think this question is more about PyDAL than web2py. What I'm doing is > using the web2py shell to call functions and do

[web2py] Re: Scheduler: Is it possible to assign a task to all workers that are part of a group?

2018-05-05 Thread Massimo Di Pierro
No. I do not believe there is any way to guarantee that every work will execute the same task. On Friday, 4 May 2018 17:36:30 UTC-5, Francisco Ribeiro wrote: > > The question refers to submitting a task simultaneously to all workers > within a group. > > Thank you > -- Resources: -

[web2py] Guarantee closing of DB connections when using PyDAL outside a request

2018-05-05 Thread Brendan Barnwell
I think this question is more about PyDAL than web2py. What I'm doing is using the web2py shell to call functions and do stuff within a web2py app, but without actually running the web server. Everything happens within a Python shell. In this environment, database transactions are not

[web2py] Re: impact of deploying w2p file

2018-05-05 Thread Massimo Di Pierro
the w2p may contain a sqlite database and databases/*.table metadata files. you normally use those for install, not for updates. On Saturday, 28 April 2018 03:49:49 UTC-5, Vic Ding wrote: > > Dear all, > I am wondering if there is any impact on database transactions or database > content when

Re: [web2py] Re: How to iterate through column items and display its rows data

2018-05-05 Thread Massimo Di Pierro
you know you can do row = db(db.person.id>0).select(limitby=(0,1),orderby='').first() On Tuesday, 1 May 2018 17:06:26 UTC-5, pbreit wrote: > > I am very sorry, I need to be more careful with my replies. > > I wasn't sure if random needed to be imported but it looks like it does. > So: > >

[web2py] Re: Web2py locks row at auth_user and web2py_session_* tables and doesn't unlock them

2018-05-05 Thread Massimo Di Pierro
That is a very old version of web2py. The problem may have been solved years ago. ;-) On Thursday, 3 May 2018 16:37:53 UTC-5, Lisandro wrote: > > I came back to reply this particular message, because the problem happened > again yesterday. > > Just in order to remember, the problem was with

Re: [web2py] pyDAL "adapter" for Pandas syntax (phylosophical)

2018-05-05 Thread Massimo Di Pierro
I would very muck have a db().select_as_pandas() that avoids parsing the database response a puts the tuples representing the rows directly in DB. If nobody beats me on the time, I may get it done next week. Massimo On Friday, 4 May 2018 08:26:35 UTC-5, Richard wrote: > > By include in