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<javascript:>> > 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 > >> > >> > > -- > > > > > > > --
