[web2py] Re: SQLTABLE problem with 2.15.4

2017-11-09 Thread DaneW
Thank you - I've now added entity_quoting=False to the right place in the db=DAL statement and magically all the SQLTABLEs are now working! There is one strange behaviour - any references to the SUM statement must have the word 'SUM' in uppercase but references to 'COUNT' must all be in lower

[web2py] Re: where is pydal doc ?

2017-11-09 Thread Lars
Thanks for the support, I already feel less less. :) On Wednesday, November 8, 2017 at 3:40:33 PM UTC+1, Leonel Câmara wrote: > > 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

[web2py] Custom SOAP service response

2017-11-09 Thread Nicola Gramola
Hello. I have made a SOAP service using service decorator like this: @service.soap('fileSdIConMetadati', returns={'Esito': str}, args={'IdentificativoSdI': int, 'NomeFile': str, 'File': str, 'NomeFileMetadati': str, 'Metadati': str}) def ricevi_fatture(IdentificativoSdI, NomeFile, File,

[web2py] Re: ipython notebook and web2py

2017-11-09 Thread Morganti
Hi, I am using the web2py version 2.15.4 and used the these intructions to use web2py with ipython. I am having the error below: if request.global_settings.web2py_version < "2.14.1": > 9 raise HTTP(500, "Requires web2py 2.13.3 or newer") 10 11 ## if SSL/HTTPS is properly

[web2py] Re: where is pydal doc ?

2017-11-09 Thread Lars
> As suggested, if you can't find documentation on something, first trying > searching this forum, as there are several posts explaining > decode_credentials (e.g., > https://groups.google.com/d/msg/web2py/xPREtSr3-PI/xx5EPVrU738J). It has > nothing to do with database encryption. Rather,

[web2py] Re: where is pydal doc ?

2017-11-09 Thread Anthony
> As suggested, if you can't find documentation on something, first trying >> searching this forum, as there are several posts explaining >> decode_credentials (e.g., >> https://groups.google.com/d/msg/web2py/xPREtSr3-PI/xx5EPVrU738J). It has >> nothing to do with database encryption.

[web2py] Re: SQLTABLE problem with 2.15.4

2017-11-09 Thread Leonel Câmara
I actually think that is also a bug because it is an inconsistency. For some reason in https://github.com/web2py/pydal/blob/master/pydal/dialects/base.py the DAL is using caps for everything but not for count. I'll submit a pull request for that too. web2py pull request fixing the tablename

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

2017-11-09 Thread Mike Stephenson
So in the same way, can it make updates in the db? And why is it not recommended in web2py if the diagram doesn't say so? On Thursday, November 9, 2017 at 6:17:42 PM UTC+5:30, Leonel Câmara wrote: > > In the way shown in that diagram yes it can. You can make > db(query).select() inside a view

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

2017-11-09 Thread Leonel Câmara
In the way shown in that diagram yes it can. You can make db(query).select() inside a view so you can actually get the data directly from the model. That is not usually recommended. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

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

2017-11-09 Thread Mike Stephenson
Thanks On Thursday, November 9, 2017 at 6:25:00 PM UTC+5:30, Leonel Câmara wrote: > > It's not recommended because the logic in web2py is that you use the same > controller for many different views (html, json, pdf, etc) so if you put > the getting of data in the view you will have to replicate

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

2017-11-09 Thread Anthony
I suspect this model is intended to describe the original MVC pattern of event-driven desktop GUI apps rather than MVC as commonly implemented in web frameworks. The view in particular in this diagram doesn't quite map to what web2py calls a view. Note, some frameworks, such as Django and

[web2py] Re: Why web2py server hangs/freeze?

2017-11-09 Thread Narendra Kumar
setup Script included in web2py, is not working properly. I get a nice post, which work perfect.(https://www.digitalocean.com/community/tutorials/how-to-deploy-web2py-python-applications-with-uwsgi-and-nginx-on-centos-7) By using Nginx, web2py working fine from last 4 weeks. Regards Narendra

[web2py] Re: ipython notebook and web2py

2017-11-09 Thread Anthony
Here is updated code. Note, it assumes the web2py folder is at the top level within the home directory of the current user (you can change that back to the old behavior if desired). It also allows you to have multiple versions in different folders, such as "/web2py-2.15", "web2py-master", etc.

[web2py] Re: What sort of "form" should I use?

2017-11-09 Thread Leonel Câmara
Read up on access control for only letting certain users edit: http://www.web2py.com/books/default/chapter/29/09/access-control Then you can use something like plugin_ckeditor https://github.com/timrichardson/web2py_ckeditor4 for the pages. Your model would be something like: ckeditor =

[web2py] Re: What sort of "form" should I use?

2017-11-09 Thread Cypher Ace
I think I've actually figured this out and and realized I was asking a sort of dumb question. If anyone stops by and looks at this, here's another that seems more well informed. Could any of you point me where I should start reading to figure out how to create a form/page that only admins can

[web2py] Re: ipython notebook and web2py

2017-11-09 Thread Morganti
Anthony, Thanks a lot! Best regards André Em quinta-feira, 9 de novembro de 2017 13:42:20 UTC-2, Anthony escreveu: > > Here is updated code. Note, it assumes the web2py folder is at the top > level within the home directory of the current user (you can change that > back to the old behavior

[web2py] Re: Future of web2py

2017-11-09 Thread Jason Solack
is this official? we use web2py in production and would love to migrate to python 3. I am just concerned about edge cases that would cause an issuse. On Saturday, November 4, 2017 at 2:53:13 PM UTC-4, Anthony wrote: > > About Python, I know many people are still on Python 2, but to me it's >>

[web2py] Re: Future of web2py

2017-11-09 Thread Leonel Câmara
Yes python 3 support is official. Compatibility problems with python 3 are considered bugs. The upcoming version will bring some fixes for some problems that were already found. As always before putting it in production test everything works for your app with python 3. If something doesn't work

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

2017-11-09 Thread Leonel Câmara
It's not recommended because the logic in web2py is that you use the same controller for many different views (html, json, pdf, etc) so if you put the getting of data in the view you will have to replicate it in all the other views for that same controller. However you should use it where it

[web2py] Re: digitally signed urls

2017-11-09 Thread Anthony
> > @auth.requires_login() > def main_func(): > form = SQLFORM(db.atable) > if form.process(onvalidation=..., dbio=False).accepted: > rtn = scheduler.queue_task(task_func,….) > if not rtn.id: #there are errors > raise HTTP(404) > else: >

[web2py] uploadseparate

2017-11-09 Thread T.R.Rajkumar
The uploadseparate creates folder sructure like uploads/amc_master.annexure/a0, uploads/amc_master.annexure/87 for the field annexure in table amc_master. Here a folder is created with the first two letters of UUID. So for me each session a new UUID folder is created and the annexure file is