just features that weren't anticipated (I never use concrete inheritance).
here's what will work for now.
class AbstractConcreteAbstraction(AbstractConcreteBase, sqlite):
__table_args__ = (UniqueConstraint('derpa',
'derp'),)
id = Column(Integer, primary_key=True)
derpa = Column(Integer)
derp = Column(Integer)
@declared_attr
def something_id(cls):
return Column(ForeignKey(Something.id))
class ConcreteConcreteAbstraction(AbstractConcreteAbstraction):
__tablename__ = u'cca'
__mapper_args__ = {'polymorphic_identity': 'ccb',
'concrete': True}
something = relationship(Something)
import sqlalchemy
sqlalchemy.orm.configure_mappers()
AbstractConcreteAbstraction.something = relationship(Something)
sqlite.metadata.create_all()
# Works
print session.query(ConcreteConcreteAbstraction).filter(
ConcreteConcreteAbstraction.something.has(id=1)).all()
# Don't work
print session.query(AbstractConcreteAbstraction).filter(
AbstractConcreteAbstraction.something.has(id=1)).all()
On Feb 27, 2013, at 8:06 PM, Derek Litz <[email protected]> wrote:
> Having fun with AbstractBaseClasses tonight :) ... Anyways am I missing
> something here as well?
>
> I tried playing with querying the AbstractBaseClass and filtering on sub
> classes but that just produced
> a query that did not execute.
>
> from sqlalchemy.engine import Engine
> from sqlalchemy import event
> from sqlalchemy import (Column, Integer, Unicode, DateTime, ForeignKey,
> Boolean, Numeric, Time)
>
>
> # Taken from http://docs.sqlalchemy.org/ru/latest/dialects/sqlite.html
> @event.listens_for(Engine, "connect")
> def set_sqlite_pragma(dbapi_connection, connection_record):
> cursor = dbapi_connection.cursor()
> cursor.execute("PRAGMA foreign_keys=ON")
> cursor.close()
>
>
> from sqlalchemy import create_engine
> from sqlalchemy.ext.declarative import (declarative_base, declared_attr,
> AbstractConcreteBase)
> from sqlalchemy.orm import sessionmaker, relationship, backref, object_session
>
> engine = create_engine('sqlite:///test.db')
> sqlite = declarative_base(bind=engine)
> get_session = sessionmaker(bind=engine)
> session = get_session()
>
> from sqlalchemy.schema import UniqueConstraint
>
>
> class Something(sqlite):
> __tablename__ = u'something'
> id = Column(Integer, primary_key=True)
>
>
> class AbstractConcreteAbstraction(AbstractConcreteBase, sqlite):
> __table_args__ = (UniqueConstraint('derpa',
> 'derp'),)
> id = Column(Integer, primary_key=True)
> derpa = Column(Integer)
> derp = Column(Integer)
>
> @declared_attr
> def something_id(cls):
> return Column(ForeignKey(Something.id))
>
> @declared_attr
> def something(cls):
> return relationship(Something)
>
>
> class ConcreteConcreteAbstraction(AbstractConcreteAbstraction):
> __tablename__ = u'cca'
> __mapper_args__ = {'polymorphic_identity': 'ccb',
> 'concrete': True}
>
>
> import sqlalchemy
> sqlalchemy.orm.configure_mappers()
> sqlite.metadata.create_all()
>
> # Works
> print session.query(ConcreteConcreteAbstraction).filter(
> ConcreteConcreteAbstraction.something.has(id=1)).all()
> # Don't work
> print session.query(AbstractConcreteAbstraction).filter(
> AbstractConcreteAbstraction.something.has(id=1)).all()
>
>
> --
> 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?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
