On Jul 24, 2007, at 9:59 AM, Anton V. Belyaev wrote:
>
> Of course db modification is hard. It cant be done completely
> automatically. For now I would like SQLAlchemy just to signal somehow
> when its definitions are different from already existing db tables.
> When I do create_all() it checks anyway tables properties, but doesnt
> let me know when there is mismatch.
such a feature would make usage of table reflection, and then a
comparison operation, along the lines of :
t = Table('mytable', meta,
Column(...)
....
)
someothermeta = MetaData()
t2 = Table('mytable', someothermetadata, autoload=True,
autoload_with=<connection>)
assert t.compare(t2)
so if we had a comprehensive "compare()" method, we could probably
distill the above into something like:
table.verify(<connection>)
but why not just use autoload=True across the board in the first
place and eliminate the chance of any errors ?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
