Re: [web2py] cannot define_table after executesql drop table

2010-12-28 Thread Bruno Rocha
Best way is manually defining migration file names, all the table history information and diffs are stored in /databases/xxx.table which is randomly named. You can do: db.define_table('products',Field('name'),migrate='products.table') In that way, when you need to purge the table inform

[web2py] cannot define_table after executesql drop table

2010-12-28 Thread apple
I called define_table to create a table "product". This worked fine. Then I called executesql("DROP TABLE PRODUCT"). The product table appears to have been dropped from the database. However when I run the application again it fails in the model in at the define_table line with "OperationalError: n