May be web2py need a password to be define to acces model in shell??
So use -a parameter to set a pwd here my start command, notice I am not
sure but have auto after the -M that maybe required?? :
python web2py.py -a '12345' -i 127.0.0.1 -p 8001 -S apllication_name -M
auto'
Richard
On Tue, Feb 7, 2012 at 11:12 AM, Massimiliano <mbelle...@gmail.com> wrote:
> 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
>
