replacing columns in reflected table that reference composite foreign key results in double remove of constraint -> key error

obvious ! you don't need a test !

just kidding !

from sqlalchemy import *

engine = create_engine('sqlite://')

meta = MetaData()
a = Table('a',
    meta,
    Column('x', Integer, primary_key=True),
    Column('y', Integer, primary_key=True),
)

b = Table('b',
    meta,
    Column('x', Integer, primary_key=True),
    Column('y', Integer, primary_key=True),
    ForeignKeyConstraint(['y']('x',), ['a.y']('a.x',))
)

meta.create_all(engine)

meta2 = MetaData()

b1 = Table('b',
    meta2,
    Column('x', Integer, primary_key=True),
    Column('y', Integer, primary_key=True),
    ForeignKeyConstraint(['y']('x',), ['a.y']('a.x',)),
    autoload=True,
    autoload_with=engine
)

Comments (2)