Start the shell with: c:\suzand\swDev\private\web2py>python web2py.py -S gps -M
On Mon, Oct 28, 2013 at 7:10 AM, arutti <[email protected]> wrote: > Hi, > > I'm trying to use DAL in web2py interactive shell. > > The troubles is that DAL doesn' show the already defined tables. > I can create new tables perfectly > They show up in SQLLite manager (Firefox add-on). > > After closing/reopening the shell, it's as if the database connexion didn't > work correctly. > > Any idea what's happening ? > > Best regards, > Andre > > see below a log of the interactive session. > > c:\suzand\swDev\private\web2py>python web2py.py -S gps > web2py Web Framework > Created by Massimo Di Pierro, Copyright 2007-2013 > Version 2.7.4-stable+timestamp.2013.10.14.15.16.29 > Database drivers available: SQLite(sqlite3), MySQL(pymysql), > PostgreSQL(pg8000), > MSSQL(pyodbc), DB2(pyodbc), Teradata(pyodbc), Ingres(pyodbc), IMAP(imaplib) > Python 2.7.2 (default, Jun 24 2011, 12:21:10) [MSC v.1500 32 bit (Intel)] > Type "copyright", "credits" or "license" for more information. > > IPython 0.11 -- An enhanced Interactive Python. > ? -> Introduction and overview of IPython's features. > %quickref -> Quick reference. > help -> Python's own help system. > object? -> Details about 'object', use 'object??' for extra details. > > In [1]: db = DAL('sqlite://storage.sqlite') > > In [2]: db._tables > Out[2]: [] > > In [3]: db.define_table('foo') > Out[3]: <Table foo (id)> > > In [4]: db.commit() > > In [5]: db.define_table('foo_2') > Out[5]: <Table foo_2 (id)> > > In [6]: db._tables > Out[6]: ['foo', 'foo_2'] > > In [7]: > Do you really want to exit ([y]/n)? y > > > c:\suzand\swDev\private\web2py> > c:\suzand\swDev\private\web2py>python web2py.py -S gps > web2py Web Framework > Created by Massimo Di Pierro, Copyright 2007-2013 > Version 2.7.4-stable+timestamp.2013.10.14.15.16.29 > Database drivers available: SQLite(sqlite3), MySQL(pymysql), > PostgreSQL(pg8000), > MSSQL(pyodbc), DB2(pyodbc), Teradata(pyodbc), Ingres(pyodbc), IMAP(imaplib) > Python 2.7.2 (default, Jun 24 2011, 12:21:10) [MSC v.1500 32 bit (Intel)] > Type "copyright", "credits" or "license" for more information. > > IPython 0.11 -- An enhanced Interactive Python. > ? -> Introduction and overview of IPython's features. > %quickref -> Quick reference. > help -> Python's own help system. > object? -> Details about 'object', use 'object??' for extra details. > > In [1]: db = DAL('sqlite://storage.sqlite') > > In [2]: db._tables > Out[2]: [] > > In [3]: > > > > > -- > 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 [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. -- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
