Ilias Lazaridis a écrit : > Oleg Broytmann wrote: > >> On Sun, Sep 24, 2006 at 12:03:04AM +0200, sophana wrote: >> >>> Here is my (very small) contribution to sqlobject, that I find very cool >>> to program with. >>> > ... > > >> With all those print's this >> >> >>> def updateSchema(self, doIt=False, connection=None): >>> >> looks like a debugging procedure... >> >> Oleg. >> > > shouldn't this be used by the team? > > I mean, it's a _very_ important functionality. > > . > > It's true that it helps a lot when upgrading the schema. I don't understand why it was not in SqlObject before. I tried to use sqlObjectAdmin but I couldn't even find this functionality which fits in so few lines of code.
To resume what it does, it compares the columns in the object and in the database. It deletes all columns that are not in the SqlObject declaration, and add missing ones to the database. It suffers from default values not being set correctly because _extraSQL method in col.py that does not add default values. Default values are important when upgrading a schema... When you don't set doIt to True, the method only tells what it is going to do. This is important if you don't want a column to be deleted by accident... ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
