Hi
I cant seem to find on the web how to remove a ForeignKey from a table,
using a migrate script
I'm using Turbogears 2.2, and writing a migrrate script with "paster
migrate script..."
Model:
class Yeshiva(DeclarativeBase):
__tablename__ = 'yeshivot'
id = Column(Integer, autoincrement=True, primary_key=True)
start = Column(DateTime)
end = Column(DateTime)
I want to a add a ForeignKey to the model that will be:
organ_id = Column(Integer, ForeignKey('organs.id'))
Here is my migrate script:
from sqlalchemy import *
from migrate import *
from model import metadata
def upgrade(migrate_engine):
metadata.bind = migrate_engine
yeshivotTable = Table('yeshivot', metadata, autoload=True)
* organ_id = Column('organ_id',Integer, ForeignKey('organs.id'))*
organ_id.create(yeshivotTable)
def downgrade(migrate_engine):
# Operations to reverse the above upgrade go here.
metadata.bind = migrate_engine
yeshivotTable = Table('yeshivot', metadata, autoload=True)
yeshivotTable.c.organ_id.drop()
The Upgrade method works.
The Downgrade method doesn't work, and i don't know how to achive deleting
that ForeignKey column
Thanks for the Help
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
