[sqlalchemy] Re: Tool to check whether DB matches model - Paul Johnston - com.googlegroups.sqlalchemy

11 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: Tool to check whethe...

From	Sent On	Attachments
Paul Johnston	28 Jan 2007 01:58
Michael Bayer	28 Jan 2007 20:12
Paul Johnston	29 Jan 2007 12:05
Paul Johnston	30 Jan 2007 14:49
Michael Bayer	30 Jan 2007 15:49
Paul Johnston	01 Feb 2007 03:21
Michael Bayer	01 Feb 2007 12:06
Paul Johnston	02 Feb 2007 04:32
Michael Bayer	02 Feb 2007 09:10
Paul Johnston	02 Feb 2007 09:40
Michael Bayer	02 Feb 2007 11:43

Subject:	[sqlalchemy] Re: Tool to check whether DB matches model
From:	Paul Johnston (pa...@pajhome.org.uk)
Date:	01/29/2007 12:05:06 PM
List:	com.googlegroups.sqlalchemy

Hi,

SQLObject's status command tells you if the database schema matches your model. Well, at least if the same tables and columns exist, I don't think it looks at types.

I have now found the script again... http://www.sqlalchemy.org/trac/attachment/wiki/UsageRecipes/ModelUpdate/model_update.py

Paul

Michael Bayer wrote:

you might be thinking of migrate (http://trac.erosson.com/migrate ) but thats not exactly what you describe here. (i dont actually know what SO's status command does).

On Jan 28, 4:58 am, Paul Johnston <p....@pajhome.org.uk> wrote:

Hi,

Is there a tool to check whether the DB matches the model? Something like SQLObject's status command. I'm sure I noticed something along these lines on the site, that even did rudimentary automatic "alter table" commands, but I can't find it now!