[web2py] As an MVC framework, does web2py allows updating model from view?

2017-11-08 Thread Mike Stephenson
Can

[web2py] Re: SQLTABLE problem with 2.15.4

2017-11-08 Thread Leonel Câmara
The entity_quoting should be in your db.py where you have db = DAL(..., entity_quoting=False) Anyway, I'll take a look at your test app since the "SUM('dpspend'.'amount')" should have worked. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: SQLTABLE problem with 2.15.4

2017-11-08 Thread DaneW
Leonel - that seems like a good suggestion but I'm afraid it didn't work. Changing the 'SUM(dpspend.amount)' to "SUM('dpspend'.'amount')" had no effect and when I tried rows=db(query).select(.,entity_quoting=False) I got an exception - TypeError: _select_wcols() got an unexpected keyword

[web2py] Re: digitally signed urls

2017-11-08 Thread Anthony
On Wednesday, November 8, 2017 at 11:17:37 AM UTC-5, Pierre wrote: > > yes of course but Leonel your use-case looks very similar to the Auth case > (i mean user_signature=true + @auth.requires_signature) . It's also a one > hmac_key per user|client case. Actually i am not so much interested in

[web2py] Re: SQLTABLE problem with 2.15.4

2017-11-08 Thread Leonel Câmara
DaneW I think the problem is being caused by the new DAL entity quoting so your problem is fixed if you set entity_quoting=False in your DAL call or change your headers dictionary to have quotes for instance instead of 'SUM(dpspend.amount)' you will use "SUM('dpspend'.'amount')" -- Resources:

[web2py] Re: Future of web2py

2017-11-08 Thread Gabor Nyul
> > It is based on bottle + gevent + gunicorn + rethinkdb + pydal + vue.js + > some code ported from web2py (templates, helpers, validators, > internationalization, scheduler) > If it will use gunicorn, it means you will drop Windows support (as gunicorn only runs on *nix machines)? It would

[web2py] Re: SQLTABLE problem with 2.15.4

2017-11-08 Thread Leonel Câmara
Yes please provide me a test app I'll make it work. -- 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

[web2py] Re: SQLTABLE problem with 2.15.4

2017-11-08 Thread DaneW
Leonel and Donatus - thank you for your responses. Yes Leonel your suggested change works! The one thing that is not working is that the headers for the Sum and Count columns display as "count('dpspend'.'amount')" and "SUM('dpspend'.'amount')" rather than the values that I specified in the

Re: [web2py] Re: Translate language help

2017-11-08 Thread António Ramos
Than you Leonel. I solved it. 2017-11-08 15:46 GMT+00:00 Leonel Câmara : > Check how prettydate does it https://github.com/web2py/ > web2py/blob/master/gluon/tools.py#L5535 > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > -

[web2py] Re: Translate language help

2017-11-08 Thread Leonel Câmara
Check how prettydate does it https://github.com/web2py/web2py/blob/master/gluon/tools.py#L5535 -- 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

[web2py] Re: SQLTABLE problem with 2.15.4

2017-11-08 Thread Leonel Câmara
Can you test something for me: in your web2py folder in file gluon/sqlhtml.py in SQLTABLE can you replace tablemap = dict(((f.tablename, f.table) for f in fieldmap.values())) with: tablemap = dict(((f.tablename, f.table) if isinstance(f, Field) else (f. _table._tablename, f._table) for f in

[web2py] Re: where is pydal doc ?

2017-11-08 Thread Anthony
On Wednesday, November 8, 2017 at 5:14:11 AM UTC-5, Lars wrote: > > "Good morning, Dave.." :) > > Actually here I was looking for the decode_credential meaning, which I > guess is for database encryption, but I would have like it better to have a > description of its use, its handling (does it

[web2py] Re: digitally signed urls

2017-11-08 Thread Anthony
Another possible use case -- suppose your application generates various links to a particular action with different combinations of URL args and vars and wants to limit access to that action so only the explicitly generated links will work (i.e., prevent users from generating their own

[web2py] Re: digitally signed urls

2017-11-08 Thread Leonel Câmara
I'll give you an example, lets imagine I have a client database. I want to send a survey to my clients and I want the survey results to be associated with their profile in my database (note that my clients do not have users in my system). I send each one an email with a digitally signed URL,

[web2py] Re: where is pydal doc ?

2017-11-08 Thread Leonel Câmara
Lars I think everyone agrees the pyDAL codebase should be better documented. I even opened up an issue about it https://github.com/web2py/pydal/issues/468 I think what happened here was that people thought you wanted usage documentation, the DAL's usage is pretty well documented in the web2py

[web2py] Re: SQLTABLE problem with 2.15.4

2017-11-08 Thread Donatas Burba
The ticket is opened on this bug already without any attention, https://github.com/web2py/web2py/issues/1735 2017 m. lapkritis 7 d., antradienis 15:34:07 UTC+2, DaneW rašė: > > I have upgraded from 2.14.6 to 2.15.4 (in PythonAnywhere using Python 2.7 > and MySQL) and I now get AttributeError*:

[web2py] Re: where is pydal doc ?

2017-11-08 Thread Lars
"Good morning, Dave.." :) Actually here I was looking for the decode_credential meaning, which I guess is for database encryption, but I would have like it better to have a description of its use, its handling (does it suffice to encrypt the database or do I need to encrypt the database myself