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