I've been prototyping a few projects in a stand alone python script, all of this out the web2py framework I am seeing an issue where I can not access an existing sqlite tables and data I've created/inserted. But when I directly connect to it with SQLite console or other tools I have, the tables and data do exist.
Example DB I create: >>> >>> from gluon import DAL, Field >>> >>> db = DAL('sqlite://TestDB.sqlite') >>> db.define_table('person', Field('fname', 'string'), Field('lname', 'string'), Field('building', 'string') ) <Table person (id,fname,lname,building)> >>> >>> db.person.insert(fname='Billy', lname='Thorns', building='A') 1L >>> db.person.insert(fname='Judy', lname='Thorns', building='A') 2L >>> db.person.insert(fname='Edd', lname='Spurs', building='A') 3L >>> >>> rows = db(db.person.lname == 'Thorns').select() >>> for e in rows: print e <Row {'building': 'A', 'lname': 'Thorns', 'fname': 'Billy', 'id': 1L}> <Row {'building': 'A', 'lname': 'Thorns', 'fname': 'Judy', 'id': 2L}> >>> db.commit() But when I reopen the 'TestDB.sqlite' file in a new python shell I suddenly see the data or table does not exist. >>> from gluon import DAL, Field >>> >>> db = DAL('sqlite://TestDB.sqlite') >>> rows = db(db.person.lname == 'Thorns').select() Traceback (most recent call last): File "<pyshell#11>", line 1, in <module> rows = db(db.person.lname == 'Thorns').select() File "C:\Users\Navajo\Documents\code\web2py_win\gluon\packages\dal\pydal\base.py", line 921, in __getattr__ return BasicStorage.__getattribute__(self, key) AttributeError: 'DAL' object has no attribute 'person' >>> db.tables [] >>> If I open the table within a SQLite console I see there is data: SQLite version 3.11.1 2016-03-03 16:17:53 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open TestDB.sqlite sqlite> select * from person; 1|||Thorns|A|Billy 2|||Thorns|A|Judy 3|||Spurs|A|Edd Any suggestions on how I can reopen a file I've made? -- 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/d/optout.