[web2py] SQLTABLE and SQLFORM.grid with PRE()

2019-04-15 Thread Dave S
I'd like to apply PRE() to each entry in a particular column. What's the way to do this with SQLTABLE() and SQLFORM.grid() ? /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues

[web2py] Re: Problem with oracle query

2019-04-15 Thread gliporace
This is the query: query = (db1.ana_paz.COGNOME==form.vars.cognome.upper()) if form.vars.nome: query = query & (db1.ana_paz.NOME==form.vars.nome.upper()) if form.vars.data_nascita: query = query & (db1.ana_paz.DATAJ_NAS==form.vars.data_nascita) try:

[web2py] Re: Web3py

2019-04-15 Thread 黄祥
*web3py/web3py/core.py* def start_server(args): host, port = args.address.split(':') if args.number_workers < 1: bottle.run(host=host, port=int(port)) else: if not gunicorn: logging.error('gunicorn not installed') *elif not gunicorn: # shoul

[web2py] Re: Web3py

2019-04-15 Thread 黄祥
*web3py/applications/myapp/controllers.py* def helloworld(): return dict(name=request.forms.get('name', 'visitor')) change *'visitor'* with whatever string value, require restart web server to update the new value *web3py/applications/myapp/templates/helloworld.html* Hello Dear [[=name]] change *

[web2py] Re: Problem with oracle query

2019-04-15 Thread gliporace
I think I found the problem: the query is sent with the table name double-quoted: select "ana_paz"."COGNOME", "ana_paz"."NOME" from "ana_paz" where "ana_paz"."COGNOME"='ROSSI' <--- doesn't not work ("table or view does not exists") select ana_paz."COGNOME", ana_paz."NOME" from "ana_paz" wh

[web2py] Re: I would like to log of all SQL commands web2py sends to SQLite. Is it possible?

2019-04-15 Thread João Matos
Thanks Anthony. I went with a simple solution that serves my purpose (it's a temporary need). I added this code starting with # JM to the gluon\packages\dal\pydal\adapters\base.py at line 413. @with_connection_or_raise def execute(self, *args, **kwargs): command = self.filter_sq

[web2py] Thoughts on Rules+Workflow engine

2019-04-15 Thread Kevin Keller
Hey everyone, I am pondering currently to create a web app that can create dynamic forms, which when submitted create a "document". The forms can be configured by users. Each document is attached to a workflow with different statuses, i.e. "rejected" "approved" After submission and during tra

[web2py] Re: Web3py

2019-04-15 Thread JorgeH
looks promising!! On Thursday, April 11, 2019 at 12:31:29 PM UTC-5, En Ware wrote: > > I git installed web3py and quite enjoy it. I see its updated regular too. > > For those who don't know and maybe this is common sense , not sure. > > once you *git clone https://github.com/web2py/web3py.git >

[web2py] Re: Web3py

2019-04-15 Thread JorgeH
Would it be Async?? -- 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 "web2py-use

[web2py] Re: Web3py

2019-04-15 Thread En Ware
from pydal._compat import StringIO, integer_types, basestring, unicodeT, urllib_unquote, \ ImportError: cannot import name 'unicodeT' I looked at pydal __compat and unicodeT is there On Monday, April 15, 2019 at 9:58:49 AM UTC-5, En Ware wrote: > > It's looking very good. > > I like the new st

[web2py] Re: Web3py

2019-04-15 Thread En Ware
Is this the newest version for pydal3 ? pydal3 (19.4) - a pure Python Database Abstraction Layer (for python version 2.7 and 3.x) INSTALLED: 19.4 (latest) , Not seeing a change log in the repo. On Thursday, April 11, 2019 at 12:31:29 PM UTC-5, En Ware wrote: > > I git installed web3py and

[web2py] Smartgrid link very slow.

2019-04-15 Thread David Manns
here is my smartgrid (simplified to show only essential pieces): grid = SQLFORM.smartgrid(db.Members, linked_tables=['Affiliations'], constraints=dict(Members=query), deletable=False, details=False, editable=True, create=True) Members is a table wit

[web2py] Re: howto prevent XSS in json data

2019-04-15 Thread Leonel Câmara
Change it to: var filterSettings = {{=XML(filter_settings, sanitize=True)}}; -- 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

[web2py] Re: howto prevent XSS in json data

2019-04-15 Thread Alex
thanks for your answer. Problem is when I use sanitize then the output is var filterSettings = {"section": "