from the book*
Google NoSQL (Datastore)** does not allow joins, left joins, aggregates,
expression, OR involving more than one table, the ‘like’ operator searches
in "text" fields.
*
tl;dr : no references allowed AFAIK.
On Wednesday, June 12, 2013 10:07:01 AM UTC+2, Jacinto Parga wrote:
>
> Hi,
>
> I have deployed a *SQLFORM.smartgrid* very simple book's example:
>
> *db.define_table('t_parent',Field('name'),format='%(name)s')
> db.define_table('child',Field('name'),Field('f_parent','reference
> t_parent'))*
>
> Controller
>
> *@auth.requires_login()
> def index():
> db.child.f_parent.writable = False
> grid =
> SQLFORM.smartgrid(db.t_parent,linked_tables=['child'],create=True,
> editable=dict(t_parent=True,child=True))
> return dict(grid=grid)*
>
> In view:
>
> *{{=grid}}*
>
> It works fine in localhost, works fine in pythonanywhere (
> http://jparga.pythonanywhere.com/borrame/default/index<http://jparga.pythonanywhere.com/borrame/default/user/login?_next=/borrame/default/index>
> )
>
> BUT ,in* GAE *it doesn't work and dysplay the following message:* Query
> Not Supported: invalid filter: __key__ filter value must be a Key; received
> None (a NoneType)*
> (http://web2gae.appspot.com/borrame/default/index/)
>
> I have tried adding several requirements to db.child.f_parent, like
> IS_NOT_EMPTY, a default value and so on but it did'n work.
>
> Thanks for your help.
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
