Please change db().select(db.prime.id)
with db(db.prime.id>0).select() On Dec 4, 11:48 am, Gary <gary.k.ma...@gmail.com> wrote: > I've been trying to deploy an application to GAE and I'm confused by > the fact that it created the 'administration' files like auth_user, > but didn't create the files for the application. I've even taken the > prime number paging program from the web2py manual and, although it > works on localhost, it fails in local dev GAE. > > Here's the log from local GAE: > > ========== Start Log =================== > > 2009-12-04 12:36:52 PM Running command: "['/usr/bin/python2.5', '/home/ > gkm/google_appengine/dev_appserver.py', '--admin_console_server=', '-- > port=8080', '/home/gkm/google_appengine/web2py']" > INFO 2009-12-04 17:36:53,877 dev_appserver_main.py:478] Running > application verizonpal on port 8080:http://localhost:8080 > WARNING 2009-12-04 17:37:03,879 portalocker.py:91] no file locking > WARNING 2009-12-04 17:37:04,391 cache.py:36] unable to import dbhash > WARNING 2009-12-04 17:37:04,532 main.py:57] unable to import > wsgiserver > INFO 2009-12-04 17:37:04,543 gaehandler.py:56] **** Request: > 0.84ms/0.00ms (real time/cpu time) > INFO 2009-12-04 17:37:04,551 dev_appserver.py:3178] "GET /prime > HTTP/1.1" 400 - > INFO 2009-12-04 17:37:04,558 dev_appserver_index.py:205] Updating / > home/gkm/google_appengine/web2py/index.yaml > ERROR 2009-12-04 17:37:32,786 restricted.py:58] In FILE: /home/gkm/ > google_appengine/web2py/applications/primes/models/db.py > > Traceback (most recent call last): > File "/home/gkm/google_appengine/web2py/gluon/restricted.py", line > 184, in restricted > exec ccode in environment > File "/home/gkm/google_appengine/web2py/applications/primes/models/ > db.py", line 71, in <module> > if len(db().select(db.prime.id))==0: > File "/home/gkm/google_appengine/web2py/gluon/contrib/gql.py", line > 666, in select > (items, tablename, fields) = self._select(*fields, **attributes) > File "/home/gkm/google_appengine/web2py/gluon/contrib/gql.py", line > 611, in _select > table = self._get_table_or_raise() > File "/home/gkm/google_appengine/web2py/gluon/contrib/gql.py", line > 590, in _get_table_or_raise > raise SyntaxError, 'Set: no tables selected' > SyntaxError: Set: no tables selected > > INFO 2009-12-04 17:37:32,787 gaehandler.py:56] **** Request: > 194.54ms/150.00ms (real time/cpu time) > INFO 2009-12-04 17:37:32,794 dev_appserver.py:3178] "GET /primes > HTTP/1.1" 500 - > > INFO 2009-12-04 17:14:58,695 gaehandler.py:56] **** Request: > 63.15ms/60.00ms (real time/cpu time) > INFO 2009-12-04 17:14:58,702 dev_appserver.py:3178] "GET /primes > HTTP/1.1" 500 - > INFO 2009-12-04 17:14:58,706 dev_appserver_index.py:205] Updating / > home/gkm/google_appengine/web2py/index.yaml > > ========== End Log ================= > > I tried to read the code, but it's over my head. I'd guess that it > has something to do with GAE unsupported functions, but this: > > ======== Custom part of db.py =========== > > db.define_table('prime',Field('value','integer')) > > def isprime(p): > for i in range(2,p): > if p%i==0: return False > return True > > if len(db().select(db.prime.id))==0: > p=2 > for i in range(1000): > while not isprime(p): p+=1 > db.prime.insert(value=p) > p+=1 > > ======== End ======== > > is the only custom code in db.py - directly from the manual. > > Should web2py create the data files? If not, how do they get created? > > Thanks, > Gary -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@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.
