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 <mojoris...@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 >> >> > -- > > > --
