web2py db manual table entries

[Ali Kayes]

So, in my db.py, I defined a table as such:

db.define_table('dummy',
            Field('name'),
            Field('category'),
            Field('number'))

But how would I add my own values in that table? It seems like if I do something like:

db.dummy.insert(name='jon',category='cat',number='2')

I get a "Database is locked" error. So, how can I have my own manual table? I am using SQLite.

[Massimo Di Pierro]

Do you have a shell open with a transaction uncommitted? Or perhaps another instance of web2py that is stuck in a commit? Try kill all your pyhton instances.