What do you expect to see in db.tables?
Tables defined in model(s) or tables on database?
On Tue, Feb 7, 2012 at 5:03 PM, Calycé <welcome.to.dev.n...@gmail.com>wrote:
> Just tried it -> same results.
> FYI, I'm only using the interactive python shell to illustrate the
> problem I face I my app...
>
> On Feb 7, 4:56 pm, Michele Comitini <michele.comit...@gmail.com>
> wrote:
> > python web2py/web2py.py -S courier
> >
> > add -M
> >
> > python web2py/web2py.py -S courier -M
> >
> > mic
> >
> > 2012/2/7 Calycé <welcome.to.dev.n...@gmail.com>:
> >
> >
> >
> >
> >
> >
> >
> > > Hi all,
> >
> > > I'm starting a new project in which I'm using Postgresql, but I have
> > > some problems.
> > > I have defined a couple of tables in models/db.py. I can see and
> > > manipulate those tables through web2py's admin interface, but when I
> > > try to use DAL I'm facing some problems. I can connect without
> > > problem, but afterwards I can't see nor access any tables.
> >
> > > Here's a copy of a python interactive session:
> > > (courier)[julie@landing courier]$ python web2py/web2py.py -S courier
> > > web2py Web Framework
> > > Created by Massimo Di Pierro, Copyright 2007-2011
> > > Version 1.99.3 (2011-12-09 16:18:03) stable
> > > Database drivers available: SQLite3, pymysql, PostgreSQL
> > > WARNING:web2py:import IPython error; use default python shell
> > > Python 2.7.2 (default, Jan 31 2012, 13:19:49)
> > > [GCC 4.6.2 20120120 (prerelease)] on linux2
> > > Type "help", "copyright", "credits" or "license" for more information.
> > > (InteractiveConsole)
> > >>>> db = DAL('postgres://postgres:********@localhost/courier')
> > >>>> print db.tables
> > > []
> >
> > > As you can see, I apparently have no tables in my database but I can
> > > definitely see them in web2py's admin interface!
> > > Am I doing something wrong ?
> >
> > > Spec:
> > > Web2py: 1.99.3
> > > Postgres: 9.1.2
> > > Psycopg2: 2.4.4
>
--
Massimiliano
