Re: [web2py] Re: Truncate Sqlite DB

2012-12-03 Thread Mike Anson
Cheers for all the responses. On Monday, 3 December 2012 16:16:22 UTC-5, Niphlod wrote: > > without migrations, db and tables have to be there. As soon as you turn > migrations on, the first request will recreate databases and the tables. > Having a scheduler defined in your models will just crea

Re: [web2py] Re: Truncate Sqlite DB

2012-12-03 Thread Niphlod
without migrations, db and tables have to be there. As soon as you turn migrations on, the first request will recreate databases and the tables. Having a scheduler defined in your models will just create also the 3 tables the scheduler needs to work (just as the auth_* tables if you're using web

Re: [web2py] Re: Truncate Sqlite DB

2012-12-03 Thread Mike Anson
Yes I did delete everything from /databases before but my problems could have arisen from not having migrations turned on. Just want to make sure that if I have a scheduler, should I restart web2py without the scheduler initially so the DB can be recreated or does it not matter? On 3 December 20

Re: [web2py] Re: Truncate Sqlite DB

2012-12-03 Thread Niphlod
with sqlite wouldn't it be easier to just delete all contents of the databases/* folder ? As long as the first request comes in and you have table migrations turned on, the database and all the tables will be recreated. On Monday, December 3, 2012 8:47:45 PM UTC+1, viniciusban wrote: > > Do you

Re: [web2py] Re: Truncate Sqlite DB

2012-12-03 Thread Vinicius Assef
Do you want a code snippet to clear you database? Try this: >>> for t in db.tables: >>>db[t].truncate() >>>db.commit() On Mon, Dec 3, 2012 at 5:17 PM, Mike Anson wrote: > Can anyone else give my advice on clearing out my database? > > > On Wednesday, November 28, 2012 12:10:13 PM UTC-5,

[web2py] Re: Truncate Sqlite DB

2012-12-03 Thread Mike Anson
Can anyone else give my advice on clearing out my database? On Wednesday, November 28, 2012 12:10:13 PM UTC-5, Mike Anson wrote: > > *Database: Sqlite v3.7* > > Hello all, > > I have thousands of test records accumulated through testing my > application. > > Forgive me for not taking the advice p