Re: [web2py] Re: problems changing database field type

2011-09-10 Thread Richard Vézina
This seems interresting... Thanks Richard On Fri, Sep 9, 2011 at 6:18 PM, Michael Toomim wrote: > I think we need more tools for fixing broken migrations! > > When I have something broken, sometimes I go into the sql console, > edit the database manually, and then use these functions to tell >

[web2py] Re: problems changing database field type

2011-09-09 Thread Michael Toomim
I think we need more tools for fixing broken migrations! When I have something broken, sometimes I go into the sql console, edit the database manually, and then use these functions to tell web2py that I've changed the table in sql. (However, I haven't had to use these for at least a year... maybe

Re: [web2py] Re: problems changing database field type

2011-09-09 Thread pbreit
Yeah, I wonder if there'd be an easy way to review a migration before it executes?

Re: [web2py] Re: problems changing database field type

2011-09-09 Thread Richard Vézina
To me fake_migrate and migrate also is a lot magical... I would like to be able to short cut the migrate process and get the DDL and excute it myself after have reading it and... So fake_migrate to should generate a SQL script file that I could read and execute... It should just do the samething o

Re: [web2py] Re: problems changing database field type

2011-09-09 Thread pbreit
And known migration limitations of the various DB backends.

Re: [web2py] Re: problems changing database field type

2011-09-09 Thread pbreit
I think we need some more documentation on migrations, especially around fixing broken migrations, how to modify schema manually, how the sql.log and .table files work and how/when to recreate, etc.

Re: [web2py] Re: problems changing database field type

2011-09-09 Thread Richard Vézina
I think you will have to show a bit your model... You can also just copy/paste your app and rename it and change the db connexion setting create a new db and load your app... If you still have trace back... You most probably have mistake in your model... Richard On Thu, Sep 8, 2011 at 6:21 PM, E

[web2py] Re: problems changing database field type

2011-09-08 Thread Eric
And settings.migrate is set to 'True'. On Sep 8, 1:45 pm, Richard Vézina wrote: > Drop the table... and recreate it... Use pgAdmin or erase your db model > reload your app... paste your model reload... > > Don't need fake migrate just migrate true... > > Richard > > > > > > > > On Thu, Sep 8, 201

[web2py] Re: problems changing database field type

2011-09-08 Thread Eric
Thanks for your reply, Richard. I dropped the table, and when I went to reload and got this traceback (same one I got before I dropped the table). db_wizard.py is where the table is defined. Traceback (most recent call last): File "/home/www-data/web2py/gluon/restricted.py", line 192, in restr