py4web grid syntax - needs testers

[Massimo Di Pierro]

I just pushed some changes to the new py4web grid (aka mtable aka publisher). It requires the latest pydal.

There is an example in http://127.0.0.1:8000/examples

But as of today it works like this:

0) make sure you have

apps/{yourapp}/static/components/mtable.js and mtable.html (copy them from _dashboard)

1) in controller define a publisher:

from py4web.utils.publisher import Publisher

publisher = Publisher(db, policy=ALLOW_ALL_POLICY)

# you can set more complex policies using the pydal restapi policy format. If the policy requires a logger in user do:

publisher = Publisher(db, auth=auth.user, policy=ALLOW_ALL_POLICY)

2) in the action:

# exposed as /examples/grid                                                                
@action('mygrid')
@action.uses('mygrid.html')
def example_grid():
    return dict(grid=publisher.grid(db.mytablename)) ### <<< your table name

3) In mygrid.html all you need is

[[extends "layout.html"]]

[[=grid]]

Notice you can have multiple grids per page. You can also have multiple publishers if you need different policies for different grids but you probably can do everything with one publisher. Each publisher exposes its own RESTAPI.

Does it work? Suggestions for improvements?

[isi_jca]

Hi!!!

1°)

When I try to use 

"A page with an update form example", the console show:

ERROR:root:Traceback (most recent call last):

  File "/home/jalbornoz/py4web-env/lib64/python3.7/site-packages/py4web/core.py", line 461, in wrapper

    ret = func(*func_args, **func_kwargs)

  File "/home/jalbornoz/py4web-env/lib64/python3.7/site-packages/py4web/core.py", line 427, in wrapper

    ret = func(*args, **kwargs)

  File "/home/jalbornoz/apps/examples/__init__.py", line 33, in example_form

    form = Form(db.person, id, deletable=False, formstyle=FormStyleBulma)

  File "/home/jalbornoz/py4web-env/lib64/python3.7/site-packages/py4web/utils/form.py", line 184, in __init__

    (value, error) = field.validate(value)

TypeError: validate() missing 1 required positional argument: 'record_id'

id= 42

2°) The dashboard don't let to edit row on table or create a new row.

[Massimo Di Pierro]

You have an olv version of pydal

python3 -m pip install -U pydal

[IVINH]

For a new update in model, controller or view, do I need to restart the server?

[Massimo Di Pierro]

You need to press the reload button in the dashboard or restart the server.

[isi_jca]

Hi!!!

In models.py, I have this table

db.define_table('tempresa',
Field('descripcion','string',length=50,label = T('Enterprise')),
Field('email','string',length=50, label = T('Email')),
Field('phone','string',length=50, label = T('Phone')),
Field('estado','reference trestado',label = T('State')),migrate=False)

When I use grid get this string:

{ "__class__": "lazyT", "kwargs": {}, "text": "Enterprise", "translator": { "__class__": "method" } }
{ "__class__": "lazyT", "kwargs": {}, "text": "Email", "translator": { "__class__": "method" } }
{ "__class__": "lazyT", "kwargs": {}, "text": "Phone", "translator": { "__class__": "method" } }
{ "__class__": "lazyT", "kwargs": {}, "text": "State", "translator": { "__class__": "method" } } In init.py my script is this. # exposed as /examples/grid @action('empresa_grid', method=['GET','POST']) @action.uses('empresa_grid.html',db, session,T) def empresa_grid():     Titulo = T('Enterprise')     grid=publisher.grid(db.tempresa)     return locals()

[isi_jca]

Hi! 

Anybody have idea why py4web doesn't translate  the labels?

Best regards

[Massimo Di Pierro]

Thanks for catching that. Please open a ticket and I will fix it asap.