your database is located in the folder ../web2py/applications/tmp/
databases/
On 19 Mrz., 00:18, metaperl <scheme...@gmail.com> wrote:
> 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]
