Maybe a python function to join 2 dict (selects results) using some criteria coul be developed.
On Mon, Dec 29, 2008 at 12:38 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > > t2 work. the puppy app does not. you have to break the select into > multiple selects. > > Massimo > > On Dec 29, 12:28 am, "Miguel Goncalves" <goncalvesmig...@gmail.com> > wrote: > > So I suppose the JOIN in the puppy tutorial is the "friendship" > declaration. > > > > What is the recommended pattern to "simulate" a JOIN in order to run on > the > > GAE? > > > > Thanks > > Miguel > > > > On Fri, Dec 26, 2008 at 2:54 PM, mdipierro <mdipie...@cs.depaul.edu> > wrote: > > > > > you cannot do JOINS on GAE. The puppy tutorial does a JOIN. > > > > > On Dec 26, 2:11 pm, Miguel <goncalvesmig...@gmail.com> wrote: > > > > Hi > > > > > > I installed web2py and the T2 plugin. I also when through the puppies > > > > tutorial and everything works fine locally when I am running web2py > > > > server. > > > > > > However when I run GAE locally (dev_appserver.py) I get the following > > > > error: > > > > Internal Error > > > > Ticket Issued: Unknown > > > > > > What am I missing? > > > > Bellow is the command line log of GAE: > > > > > > G:\google_appengine>dev_appserver.py crbox > > > > INFO 2008-12-26 19:57:44,191 appcfg.py] Server: > > > > appengine.google.com > > > > INFO 2008-12-26 19:57:44,216 appcfg.py] Checking for updates to > > > > the SDK. > > > > INFO 2008-12-26 19:57:44,476 appcfg.py] The SDK is up to date. > > > > WARNING 2008-12-26 19:57:44,726 dev_appserver.py] Could not > > > > initialize images API; you are likely missing the Python "PIL" module > > > > . ImportError: No module named PIL > > > > INFO 2008-12-26 19:57:45,052 dev_appserver_main.py] Running > > > > application crbox on port 8080:http://localhost:8080 > > > > WARNING 2008-12-26 20:03:13,944 portalocker.py] no file locking > > > > WARNING 2008-12-26 20:03:19,069 cache.py] unable to import dbhash > > > > WARNING 2008-12-26 20:03:20,520 compileapp.py] unable to import > > > > py_compile > > > > WARNING 2008-12-26 20:03:22,191 main.py] unable to import wsgiserver > > > > INFO 2008-12-26 20:03:28,384 dev_appserver.py] "GET / HTTP/1.1" > > > > 303 - > > > > INFO 2008-12-26 20:03:28,684 dev_appserver_index.py] Updating G: > > > > \google_appengine\crbox\index.yaml > > > > WARNING 2008-12-26 20:03:28,885 cache.py] no cache.disk > > > > ERROR 2008-12-26 20:03:30,119 main.py] Traceback (most recent call > > > > last): > > > > File "G:\google_appengine\crbox\gluon\restricted.py", line 62, in > > > > restricted > > > > exec ccode in environment > > > > File "G:\google_appengine\crbox\applications\welcome/models/db.py", > > > > line 60, in <module> > > > > friendship=db.t2_person.id==db.link.person_id and > > > > db.company.id==db.link.company_id > > > > File "G:\google_appengine\crbox\gluon\contrib\gql.py", line 205, in > > > > __eq__ > > > > def __eq__(self,value): return SQLQuery(self,'=',value) > > > > File "G:\google_appengine\crbox\gluon\contrib\gql.py", line 321, in > > > > __init__ > > > > raise SyntaxError, 'SQLQuery: right side of filter must be a > value > > > > or entity' > > > > SyntaxError: SQLQuery: right side of filter must be a value or entity > > > > > > INFO 2008-12-26 20:03:30,354 dev_appserver.py] "GET /welcome/ > > > > default/index HTTP/1.1" 200 - > > > -- Atenciosamente -- ========================= Alexandre Miguel de Andrade Souza Diretoria de Otimização de Processos do SISEMA Secretaria de Estado de Meio Ambiente e Desenvolvimento Sustentável --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---