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
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:
*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
*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 *
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
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
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
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
>
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
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
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
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
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
thanks for your answer. Problem is when I use sanitize then the output is
var filterSettings = {"section":
"
My bad. distinct only works in select. But a grid doesn't accept a select
only a query.
I see 3 options:
1. Don't use the grid and you can use the distinct=True in the select;
2. Use the grid and use groupby as a replacement of distinct (this is not a
recommend use, but for some situations it wo
added parameter for logging the app or server would be nice in
web3py-start, problem found is when try to analyze the root cause during
the test in docker. checked in docker logs, there is no logs, when try the
interactively inside web3py folder and /var/log/ there is none of the log
tell about
Hello everybody,
I'm trying to add an "Edit" and "Delete" buttons on each row on a
Datatable. When I click on "edit", it calls a controller function and needs
to pass the id of that row as argument. I'm having issues doing it right.
Any suggestions?
Thank you!
My controller
def usuarioUpd
crud() method is obsolete, perhaps you can use sqlform()
ref:
http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-and-insert-update-delete
best regards,
stifan
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Sou
I have a database of items sold, I am updating the quantity of an item by
subtracting the amount purchased from the current available Quantity. How
do i replace the old value with the difference between the current value
and the purchased value?
In the controller below i have an *itemCount *
db.table.field.represent = lambda value, row: PRE(value)
On Monday, 15 April 2019 02:19:07 UTC-7, Dave S wrote:
>
> 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
- ht
Damn Oracle! Can you find some documentation that says that quoting of
table names is not supported and we will change? Want to make sure there
not some other configuration quirk before removing a useful feature.
On Monday, 15 April 2019 04:20:36 UTC-7, gliporace wrote:
>
> I think I found the p
we had a mismanagement. today pydal3 is the latest. Tomorrow I will kill
pydal and deploy the latest as pydal.
On Monday, 15 April 2019 08:38:45 UTC-7, En Ware wrote:
>
> Is this the newest version for pydal3 ?
>
> pydal3 (19.4) - a pure Python Database Abstraction Layer (for python
> version
sorry. Have not tested docker-compose yet. If you can help fix this would
be great.
On Sunday, 14 April 2019 22:11:26 UTC-7, 黄祥 wrote:
>
> *test dockerfile provided on web3py*
> *1st attempt from github (not worked)*
> git clone https://github.com/web2py/web3py
> cd web3py/docker
> docker build
On Monday, April 15, 2019 at 10:51:17 PM UTC-7, Massimo Di Pierro wrote:
>
> db.table.field.represent = lambda value, row: PRE(value)
>
>
Obvious now! Thank you much.
/dps
> On Monday, 15 April 2019 02:19:07 UTC-7, Dave S wrote:
>>
>> I'd like to apply PRE() to each entry in a particular col
On Monday, April 15, 2019 at 11:04:26 AM UTC-7, Alex wrote:
>
> thanks for your answer. Problem is when I use sanitize then the output is
> var filterSettings = {"section":
> "
The http://localhost:8000/dashboard needs some love. It is very crude.
Click on the spinning thing to reload the app when editing it.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issu
When a table is created in Oracle, it is always created in uppercase
letters, if not created by using quotes.
create table test= TEST
create table "test" = test
it is very likely that the table when created, was created without quotes
and hence the table name is saved in uppercase letters.
Now yo
On Monday, April 15, 2019 at 11:45:06 PM UTC-7, Dave S wrote:
>
> On Monday, April 15, 2019 at 11:04:26 AM UTC-7, Alex wrote:
>>
>> thanks for your answer. Problem is when I use sanitize then the output is
>> var filterSettings = {"section":
>> "
28 matches
Mail list logo