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> 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+unsubscr...@googlegroups.com.
> 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.
