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 2012 15:06, Niphlod <niph...@gmail.com> wrote: > 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 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 <mojor...@gmail.com> wrote: >> > 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 previously posted on here about >> >> truncating tables in my database. I ran in to all sorts of problems >> when I >> >> simply deleted the contents of the database table as recommended the >> last >> >> time. >> >> >> >> This could have been due to the fact I had a scheduler involved and >> >> perhaps after deleting the contents of the /database directory, I >> should >> >> have ran web2py without the scheduler to allow it to recreate the >> tables. >> >> >> >> Is this really the easiest way to truncate the DB? >> >> >> >> Cheers, >> >> >> >> -Mike >> >> >> >> >> > -- >> > >> > >> > >> > -- > > > > --
