web2py shell transcript of session resulting in no records in sqlite
storage.db file after doing an insert with no error:
[thequietcenter@ubuntu ~/prg/yinyogaworks] ../web2py/web2py.py --
shell=tmp
web2py Enterprise Web Framework
Created by Massimo Di Pierro, Copyright 2007-2011
Version 1.94.4 (2011-03-18 02:53:34)
Database drivers available: SQLite3, pymysql, CouchDB
WARNING:web2py:import IPython error; use default python shell
Python 2.6.5 (r265:79063, Apr 16 2010, 13:09:56)
[GCC 4.4.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> db = DAL('sqlite://storage.db')
>>> db.define_table('asanas', Field('name'), Field('img_url'),
>>> Field('page_url'))
<Table {'ALL': <gluon.dal.SQLALL object at 0x897b6ac>,
'virtualfields': [], '_sequence_name': 'asanas_sequence', 'name':
<gluon.dal.Field object at 0x897b24c>, '_referenced_by': [], 'fields':
['id', 'name', 'img_url', 'page_url'], '_db': <DAL {'_lastsql': '',
'_db_codec': 'UTF-8', '_fake_migrate': False, '_dbname': 'sqlite',
'_adapter': <gluon.dal.SQLiteAdapter object at 0x897b2cc>,
'check_reserved': None, '_uri': 'sqlite://storage.db', 'tables':
['asanas'], 'asanas': <Table {...}>, '_migrate': True, '_pool_size': 0}
>, '_dbt': 'applications/tmp/databases/
fb87181b96a99be45f5a23f4277867ce_asanas.table', '_trigger_name':
'asanas_sequence', '_loggername': 'applications/tmp/databases/
sql.log', '_tablename': 'asanas', '_format': None, '_id':
<gluon.dal.Field object at 0x897b66c>, 'img_url': <gluon.dal.Field
object at 0x897b40c>, 'id': <gluon.dal.Field object at 0x897b66c>,
'page_url': <gluon.dal.Field object at 0x897b5ec>}>
>>> db.asanas.insert(name='placeholder', img_url='http://place',
>>> page_url='http://holder')
1
>>> db.commit()
>>>
[thequietcenter@ubuntu ~/prg/yinyogaworks] ls -l
total 12
drwxr-xr-x 2 thequietcenter thequietcenter 4096 2011-03-18 12:10 dojo
-rw-r--r-- 1 thequietcenter thequietcenter 1037 2011-03-18 19:07 grab-
asanas.py
-rw-r--r-- 1 thequietcenter thequietcenter 333 2011-03-18 08:40 grab-
asanas.py~
-rw-r--r-- 1 thequietcenter thequietcenter 0 2011-03-18 19:07
storage.db
[thequietcenter@ubuntu ~/prg/yinyogaworks]
