Re: [SQLObject] sqlobject-admin - DB migration?

[Oleg B. <ph...@ph...>]

On Thu, Feb 19, 2009 at 12:25:43PM +0100, Christian Widmer wrote:
> "sqlobject-admin upgrade -h" says:
> This command runs scripts (that you write by hand) to upgrade a database....
> 
> Does this mean, that I end up having to manually update the table 
> definition AND the class definition each time?

   Well, in any case you have to manually update table definitions. But you
can use a different approach - SQLObject can draw table definitions from
the DB iteslf; of course in this case you have to manually alter tables.

> Is there no way to create 
> a "diff" between the class defined in python and the current database 
> scheme automatically?

   I think "sqlobject-admin status" and "sqlobject-admin record" may help.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.