Dont forget to run latest 1.96.2 version...
Em 03/06/2011 12:28, "Massimo Di Pierro" <massimo.dipie...@gmail.com>
escreveu:
> no, please do not use exec_environment.
>
> from gluon import DAL
> db = DAL('sqlite://....',folder='/your/app/
> databases',auto_import=True)
>
> print db.tables
>
>
>
> On Jun 3, 9:27 am, "j...@qlf.com" <j...@qlf.com> wrote:
>> Hi
>>
>> Just starting with web2py. I've been using TurboGears (w/ SQLObject) for
many years and am excited about the things that web2py has to offer. On to
my question...
>>
>> I have a need to use the DAL outside of web2py. I found the following in
the manual...
>>
>> from gluon.shell import exec_environment
>> cas = exec_environment('applications/cas/models/db.py')
>> rows = cas.db().select(cas.db.user.ALL)
>>
>> I've modified it a bit and came up with...
>>
>> import sys
>>
>> sys.path.append('w:/web2py/library.zip')
>>
>> from gluon.shell import exec_environment
>>
>> ic = exec_environment('/applications/InfoCenter/models/db.py')
>>
>> rows = ic.db().select(ic.db.auth_user.ALL)
>>
>> for row in rows:
>>
>> print row
>>
>> ...but am getting the following:
>>
>> Traceback (most recent call last):
>>
>> File "C:/dev/miscellaneous/playground/dalOutside.py", line 4, in
<module>
>>
>> ic = exec_environment('/applications/InfoCenter/models/db.py')
>>
>> File "gluon/shell.py", line 60, in exec_environment
>>
>> File "gluon/compileapp.py", line 230, in build_environment
>>
>> File "gluon/cache.py", line 371, in __init__
>>
>> File "gluon/cache.py", line 229, in __init__
>>
>> WindowsError: [Error 3] The system cannot find the path specified:
'applications\\InfoCenter\\cache'
>>
>> Any clues to what I should be looking at?
>>
>> Thanks!
>>
>> -Jim
