bundle does not provide entities, fails on single inh

from sqlalchemy import *
from sqlalchemy.orm import *
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


class Employee(Base):
    __tablename__ = 'employee'
    id = Column(Integer, primary_key=True)
    type = Column(String(50))
    name = Column(String(30))

    __mapper_args__ = {
      'polymorphic_identity': 'employee',
      'polymorphic_on': type,
      'with_polymorphic': '*'
    }


class Engineer(Employee):
    __mapper_args__ = {
      'polymorphic_identity': 'engineer',
    }


class Manager(Employee):
    __mapper_args__ = {
      'polymorphic_identity': 'manager',
    }


e = create_engine("sqlite://", echo=True)
Base.metadata.create_all(e)

s = Session(e)
s.add_all([
  Engineer(name='e1'),
  Engineer(name='e2'),
  Manager(name='m1'),
])

s.commit()

print(s.query(Bundle("name", Manager.name)).select_from(Manager).all())

not adding the criteria for single inh

Comments (2)