Thanks Marin
Is there any way to tun the script in "isolation" so that it can detect the
tables?
My current setup is that I have the web2py.py server already running and
then running each Private script in isolation (general web scraping).
On Sunday, 4 May 2014 09:58:38 UTC+2, Marin Pranjić wrote:
>
> Tables are in there but if you don't call db.define_table(...) DAL will
> not know about them.
>
> How are you running the script in private?
>
>
> You can do something like this:
> python web2py.py -S appname -M -R
> applications/appname/private/scriptname.py
>
> This will run your models before running the script, so scriptname.py will
> have access to DAL and everything.
> Of course, this expects table definitions in application's model files.
>
> Marin
>
>
> On Sat, May 3, 2014 at 2:03 PM, <jaw...@gmail.com <javascript:>> wrote:
>
>> I'm trying to query my tables from the private folder:
>>
>> from gluon.tools import DAL
>>
>> db = DAL("sqlite://../databases/storage.sqlite")
>> print db.tables
>>
>> However none of my tables can be seen.
>>
>> The idea is to have a better manner of extracting data rather than the
>> old-school:
>>
>> with sqlite3.connect('../databases/storage.sqlite') as conn:
>> c = conn.cursor()
>> etc....
>>
>> What am I missing?
>>
>> --
>> 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+un...@googlegroups.com <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
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/d/optout.
