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 create also the 3 > tables the scheduler needs to work (just as the auth_* tables if you're > using web2py's Auth system). > > On Monday, December 3, 2012 9:16:47 PM UTC+1, Mike Anson wrote: >> >> 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 <nip...@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 >>>> >> >>>> >> >>>> > -- >>>> > >>>> > >>>> > >>>> >>> -- >>> >>> >>> >>> >> >>
--
