abc inheritance broken

from sqlalchemy import *
from sqlalchemy.orm import *

import logging
logging.basicConfig()
logging.getLogger('sqlalchemy.engine').setLevel(logging.DEBUG)

metadata = MetaData('sqlite://')

a = Table('a', metadata,
          Column('id', Integer, primary_key=True),
          Column('type', String(20), nullable=False),
          Column('name', String(20))
          )

b = Table('b', metadata,
          Column('id', Integer, ForeignKey('a.id'), primary_key=True),
          Column('bname', String(20))
          )

c = Table('c', metadata,
          Column('id', Integer, ForeignKey('b.id'), primary_key=True)
          )

metadata.create_all()

class A(object):
    pass

class B(A):
    pass

class C(B):
    pass

mapper(A, a, polymorphic_on=a.c.type, polymorphic_identity='a')
mapper(B, b, inherits=A, polymorphic_identity='b')
mapper(C, c, inherits=B, polymorphic_identity='c')

session = create_session()

for x in range(1, 3):
    objb = B()
    objb.name = x
    objb.bname = x
    session.save(objb)

    objc = C()
    objc.name = x
    objc.bname = x
    session.save(objc)

session.flush()
session.clear()

for obj in session.query(A).all():
    print obj, obj.name, obj.bname
    assert obj.name == obj.bname
Comments (2)
