[web2py] Book need update on recaptcha v2

2018-03-08 Thread Alexander Scarlat MD
As of 2018 March 31 Google doesn't support reCaptcha V1 anymore. I thought the book should be updated with the following modification: instead of *Recaptcha* it should be *Recaptcha2* from gluon.tools import *Recaptcha2* auth.settings.captcha = *Recaptcha2*(request,'PUBLIC_KEY','SECRET_KEY') an

[web2py] Re: Sites Powered by web2py

2018-03-08 Thread Alexander Scarlat MD
Tried today to upload a new website https://www.text2codes.com/ and got the same link to internal error ticket. IMHO, I think the list needs be curated the same way Massimo did with the Web2Py consultants list a couple of years ago. Cheers Alex2 On Sunday, April 2, 2017 at 1:58:27 PM UTC-7, Al

Re: [web2py] Unit testing apis

2018-03-08 Thread Kevin Huang
Thanks all for the replies, I was able to go to gluon.globals and get the HTTP 400 error to show what the problem was, turns out the request was still sending args and vars from the previous test. Oddly enough, clearing the request variables and arguments (setting them to [] for instance) was

[web2py] Re: Off Topic:Pony

2018-03-08 Thread greenpoise
Nice indeed. Thanks On Wednesday, March 7, 2018 at 3:19:14 AM UTC-8, Ramos wrote: > > Nice ... > https://ponyorm.com/ > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Repor

[web2py] How can I disable the "working..." button text?

2018-03-08 Thread 'Yan Wong' via web2py-users
I'm using submit buttons on forms to submit post requests to new windows, using . The problem is, web2py automatically changes the button text to "Working..." on the original page, after the submit button is clicked. There are some specific buttons where I don't want this to happen. How can I d

[web2py] Re: How would I get a sum of virtual fields?

2018-03-08 Thread Anthony
You can try: task_duration = (db.t_periods.f_end.epoch() - db.t_periods.f_start.epoch()). sum().with_alias('task_duration') That should give you the duration in seconds, which you can then convert to a Python timedelta object if desired. Anthony On Thursday, March 8, 2018 at 2:27:24 PM UTC-5,

[web2py] Re: new style of welcome app

2018-03-08 Thread Anthony
Please show the source html. -- 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 "w

Re: [web2py] CPU 210%

2018-03-08 Thread Richard Vézina
Couples of folks seem to work over performance tuning right now, so I thought bring that thread UP would give some cues On Tue, Feb 19, 2013 at 12:02 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Ok, find thanks for clarification. > > Richard > > > On Tue, Feb 19, 2013 at 11:30 AM, N

[web2py] Re: How would I get a sum of virtual fields?

2018-03-08 Thread backseat
Thanks Anthony. It almost works (but it fails in an odd way). I was getting some odd results, and I've narrowed it down to this: In [10]: task_duration = (db.t_periods.f_end - db.t_periods.f_start) In [11]: results = db(query).select(p.id, p.f_start, p.f_end, task_duration ).as_list() In [1

[web2py] Re: DAL response limit

2018-03-08 Thread Arve Lømsland
Yepp, thanx. I found it in the book and changed the number in rest.py. torsdag 8. mars 2018 17.06.49 UTC+1 skrev Anthony følgende: > > The "vars" argument to parse_as_rest() can include "offset" and "limit" > keys, which default to 0 and 1000, respectively. > > If you want to return all records,

[web2py] Re: DAL response limit

2018-03-08 Thread Anthony
The "vars" argument to parse_as_rest() can include "offset" and "limit" keys, which default to 0 and 1000, respectively. If you want to return all records, you can add "limit" to the URL query string: /myapp/controller/api?limit=[very large number] or just update the "vars" dictionary within t

[web2py] DAL response limit

2018-03-08 Thread Arve Lømsland
I am using web2py as REST api. The db contains of 4911 records. When we request all records with .../default/api/Employee.json it only returns 1000 records. I cant understand what is wrong? Is there a limit somewhere in DAL or in the json output? If i select with shell db_visma(db_visma.Employee)

[web2py] Re: Unexpected behaviour executing a query with DAL and record versioning enabled

2018-03-08 Thread Anthony
On Thursday, March 8, 2018 at 10:28:38 AM UTC-5, Leonel Câmara wrote: > > Record versioning uses a common filter. > > Common filters do not work if you do not provide a query which is what > happens when you do: > > db().select(db.test.ALL) > > You need to do: > > db(db.test.id > 0).select(db.test

[web2py] Re: Unexpected behaviour executing a query with DAL and record versioning enabled

2018-03-08 Thread Leonel Câmara
Record versioning uses a common filter. Common filters do not work if you do not provide a query which is what happens when you do: db().select(db.test.ALL) You need to do: db(db.test.id > 0).select(db.test.ALL) And then it will work. Note that the calling the DAL without a query shortcut is

[web2py] Re: How would I get a sum of virtual fields?

2018-03-08 Thread Anthony
Try something like this: task_duration = (db.t_periods.f_end - db.t_periods.f_start).sum().with_alias('task_duration') results = db(query).select(db.t_tasks.f_name, task_duration, groupby=db.t_tasks.f_name) On Thursday, March 8, 2018 at 3:34:26 AM UTC-5, backseat wro

[web2py] How would I get a sum of virtual fields?

2018-03-08 Thread backseat
OK, I know I can't get a sum of virtual fields, but here's what I'm trying to do: db.define_table( 't_periods', Field('f_start', type='datetime', label=T('Start time')), Field('f_end', type='datetime', label=T('End time')), Field('f_task', type='reference t_tasks', label=T('Task')

Re: [web2py] Re: Unexpected behaviour executing a query with DAL and record versioning enabled

2018-03-08 Thread 'Awe' via web2py-users
You wrote: In [4]: query = (test2.type_marker=='object') | (test2.type_marker==None) & (test1.type_marker=='person') ...: In [5]: db().select(db.test.ALL) Out[5]: So in [5] you did not use the query definition, its db() AND the result is 3 Rows, it should be 2! Thats why I asked for the q