[Chicago] GAE queries

Carl Karsten carl at personnelware.com
Fri Jun 27 18:52:00 CEST 2008

Massimo Di Pierro wrote:
> Most of the GAE functionality is supported by the web2py ORM and *any* 
> program written with web2py for GAE works on other databases 
> (mysql,postgresql,sqlite, oracle (and mssq soon)). The opposite is not 
> true. For example
>     db(db.table.field='value').select(db.table.ALL,orderby=~db.tabel.field)
> works everywhere including GAE but
> db((db.table.field='value')&(db.othertable.id==db.table.referencefield)).select(db.table.ALL,orderby=~db.tabel.field) 
> does not work on GAE because it does a join.

Somewhere I have some code to do 'client side join' when the base tables were on 
different data sources (servers).  worst case I dig it up and we figure out how 
to use it as designed.  my hunch is GAE provides something better.

post some code from kpax - maybe we can figure out how to make it run.

Carl K

More information about the Chicago mailing list