Fully self contained example:
>web2py.py -p 80 -S myapp2
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2013
Version 2.4.1-alpha.2+timestamp.2013.02.07.05.36.19
Database drivers available: SQLite(sqlite3), MySQL(pymysql),
PostgreSQL(pg8000), Oracle(cx_Oracle), MongoDB(pymongo), IMAP(imaplib)
Python 2.7.3 (default, Apr 10 2012, 23:24:47) [MSC v.1500 64 bit (AMD64)]
Type "copyright", "credits" or "license" for more information.
In [1]: db = DAL('sqlite://myapp2.sqlite', pool_size=1, check_reserved=['all'])
In [2]: db.tables
Out[2]: []
In [3]: db.define_table('examples_are_awesome', Field('foo'))
Out[3]: <Table examples_are_awesome (id,foo)>
In [4]: db.commit() # tried with + without this line
In [5]: db.tables
Out[5]: ['examples_are_awesome']
In [6]: exit
>web2py.py -p 80 -S myapp2
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2013
Version 2.4.1-alpha.2+timestamp.2013.02.07.05.36.19
Database drivers available: SQLite(sqlite3), MySQL(pymysql), PostgreSQL(pg8000),
Oracle(cx_Oracle), MongoDB(pymongo), IMAP(imaplib)
Python 2.7.3 (default, Apr 10 2012, 23:24:47) [MSC v.1500 64 bit (AMD64)]
Type "copyright", "credits" or "license" for more information.
In [1]: db = DAL('sqlite://myapp2.sqlite', pool_size=1, check_reserved=['all'])
In [2]: db.tables()
Out[2]: []
On Sat, Feb 9, 2013 at 3:07 AM, Alec Taylor <alec.tayl...@gmail.com> wrote:
> Experiencing some very strange errors on the latest web2py
> (2.4.1-alpha.2+timestamp.2013.02.07.05.36.19).
>
> In my 'myapp2' application I have created a database, defined as follows:
>
> db = DAL('sqlite://mydb2.sqlite', pool_size=1, check_reserved=['all'])
>
> Now I defined some tables and inserted some data into it. (all from
> the \modules folder)
>
> To confirm the tables and data exists I opened up the 5KB SQLite file
> in two different external database programs, including the SQLite
> Manager firefox extension.
>
> It was all there.
>
> But one of my functions in that same \modules folder couldn't find an
> entry in the db (the db DAL object was sent from \controllers though).
>
> So from my code (and subsequent from $web2py.py -S myapp2) I ran
> db.tables and got [].
>
> The exact same connection string is used throughout my code; so why
> isn't this working?
>
> Thanks for all suggestions,
>
> Alec Taylor
>
> PS: Searching my entire web2py directory brought up only one sqlite
> file named 'mydb2'
--
---
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.
