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.
