I created an issue:
https://code.google.com/p/web2py/issues/detail?id=1722
On Sunday, October 13, 2013 6:36:36 PM UTC+2, Quint wrote:
>
> I have an update regarding this question.
>
> After i changed these lines, i'm getting a step further:
>
> if not request.env.web2py_runtime_gae:
> ## if NOT running on Google App Engine use SQLite or other DB
> db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all'])
> else:
> ## connect to Google BigTable (optional 'google:datastore://namespace')
> db = DAL('google:datastore')
>
>
> to:
>
> db = DAL('google:datastore')
>
> I got this error:
>
> Traceback (most recent call last):
> File "X:\GAE\*******\gluon\restricted.py", line 217, in restricted
> exec ccode in environment
> File "applications\init\models\menu.py", line 32, in <module>
> categories = db(db.category).select(orderby=db.category.name,
> cache=(cache.r
> am, 60))
> File "X:\GAE\*******\gluon\dal.py", line 10403, in select
> return adapter.select(self.query,fields,attributes)
> File "X:\GAE\*******\gluon\dal.py", line 4995, in select
> for t in fields] for item in items]
> File "C:\Program Files
> (x86)\Google\google_appengine\google\appengine\ext\db\_
> _init__.py", line 2094, in __iter__
> return self.run()
> File "C:\Program Files
> (x86)\Google\google_appengine\google\appengine\ext\db\_
> _init__.py", line 2075, in run
> raw_query = self._get_query()
> File "C:\Program Files
> (x86)\Google\google_appengine\google\appengine\ext\db\_
> _init__.py", line 2480, in _get_query
> _app=self._app)
> File "C:\Program Files
> (x86)\Google\google_appengine\google\appengine\api\data
> store.py", line 1343, in __init__
> self.__app = datastore_types.ResolveAppId(_app)
> File "C:\Program Files
> (x86)\Google\google_appengine\google\appengine\api\data
> store_types.py", line 225, in ResolveAppId
> ValidateString(app, 'app', datastore_errors.BadArgumentError)
> File "C:\Program Files
> (x86)\Google\google_appengine\google\appengine\api\data
> store_types.py", line 173, in ValidateString
> raise exception('%s must not be empty.' % name)*BadArgumentError: app
> must not be empty.*
>
> This error occurs because GAE needs the APPLICATION_ID os environ to be set.
>
> I had some db operations in my menu.py model and when i removed that code i
> could successfully start the web2py shell.
>
> But i cannot do any db queries from the shell because of the missing
> APPLICATION_ID environ.
>
> How can i make this work?
>
>
> Thanks!
>
>
>
>
> On Sunday, June 16, 2013 10:33:40 AM UTC+2, Massimo Di Pierro wrote:
>>
>> Please open a ticket. This is supposed to work, with quirks, but it
>> should work.
>>
>> On Wednesday, 12 June 2013 12:20:16 UTC-5, Quint wrote:
>>>
>>> Hello,
>>>
>>> I'm trying to use the interactive shell with the GAE dev server on
>>> Windows.
>>> Wahet do i need to do to getthis working?
>>>
>>> I'm now getting this error 5 times:
>>>
>>> web2py Web Framework
>>> Created by Massimo Di Pierro, Copyright 2007-2013
>>> Version 2.4.7-stable+timestamp.2013.05.24.17.48.47
>>> Database drivers available: SQLite(sqlite3), PostgreSQL(pg8000),
>>> MSSQL(pyodbc),
>>> DB2(pyodbc), Teradata(pyodbc), Ingres(pyodbc), CouchDB(couchdb),
>>> IMAP(imaplib)
>>> DEBUG: connect attempt 0, connection error:
>>> Traceback (most recent call last):
>>> File "C:\Users\*************\gluon\dal.py", line
>>> 7429, in __init__
>>> self._adapter = ADAPTERS[self._dbname](**kwargs)
>>> File "*************\gluon\dal.py", line
>>> 2220, in __init__
>>> if do_connect: self.reconnect()
>>> File "C:\Users\*************\gluon\dal.py", line
>>> 603, in reconnect
>>> self.connection = f()
>>> File "C:\Users\*************\gluon\dal.py", line
>>> 2218, in connector
>>> return self.driver.Connection(dbpath, **driver_args)
>>> OperationalError: unable to open database file
>>>
>>>
>>> I'v tried adding this folder to my PATH with the GAE modules.
>>>
>>> PATH=%PATH%;C:\Program Files
>>> (x86)\Google\google_appengine\google\appengine\ext
>>>
>>> Thanks!
>>>
>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
