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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.