summaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2017-06-15 12:03:22 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2017-06-15 12:03:22 -0400
commit770e1e399cb0c91db73a551e1962ccbb57f42e76 (patch)
treed4803124576cc7f7c5422ad4e4571b09bb548744 /test
parent740f6b0d5ae3bda77f5c1829e9220d4ce9db8175 (diff)
downloadsqlalchemy-770e1e399cb0c91db73a551e1962ccbb57f42e76.tar.gz
Repair regression to pathing for subclasses
Issue #3963's initial commit narrowed the "current path" match rules too much such that a path that matches current path on subclass would no longer match. Change-Id: I8c9a0db91a09d789cfb8666288a913f8bbcdb2e9 Fixes: #3963
Diffstat (limited to 'test')
-rw-r--r--test/orm/test_options.py66
1 files changed, 65 insertions, 1 deletions
diff --git a/test/orm/test_options.py b/test/orm/test_options.py
index e29a63e08..053ba5e4b 100644
--- a/test/orm/test_options.py
+++ b/test/orm/test_options.py
@@ -9,7 +9,9 @@ import sqlalchemy as sa
from sqlalchemy import testing
from sqlalchemy.testing.assertions import eq_, assert_raises_message
from test.orm import _fixtures
-
+from sqlalchemy import Column, Integer, String, ForeignKey
+from sqlalchemy.orm import subqueryload
+from sqlalchemy.testing import fixtures
class QueryTest(_fixtures.FixtureTest):
run_setup_mappers = 'once'
@@ -572,6 +574,68 @@ class OptionsTest(PathTest, QueryTest):
])
+class FromSubclassOptionsTest(PathTest, fixtures.DeclarativeMappedTest):
+ # test for regression to #3963
+ run_setup_mappers = 'once'
+ run_inserts = 'once'
+ run_deletes = None
+
+ @classmethod
+ def setup_mappers(cls):
+ Base = cls.DeclarativeBasic
+
+ class BaseCls(Base):
+ __tablename__ = 'basecls'
+ id = Column(Integer, primary_key=True)
+
+ type = Column(String)
+ related_id = Column(ForeignKey('related.id'))
+ related = relationship("Related")
+
+ class SubClass(BaseCls):
+ __tablename__ = 'subcls'
+ id = Column(ForeignKey('basecls.id'), primary_key=True)
+
+ class Related(Base):
+ __tablename__ = 'related'
+ id = Column(Integer, primary_key=True)
+
+ sub_related_id = Column(ForeignKey('sub_related.id'))
+ sub_related = relationship('SubRelated')
+
+ class SubRelated(Base):
+ __tablename__ = 'sub_related'
+ id = Column(Integer, primary_key=True)
+
+ def _assert_path_result(self, opt, q, paths):
+ q._attributes = q._attributes.copy()
+ attr = {}
+
+ for val in opt._to_bind:
+ val._bind_loader(
+ [ent.entity_zero for ent in q._mapper_entities],
+ q._current_path, attr, False)
+
+ assert_paths = [k[1] for k in attr]
+ eq_(
+ set([p for p in assert_paths]),
+ set([self._make_path(p) for p in paths])
+ )
+
+ def test_with_current_nonmatching_entity_subclasses(self):
+ BaseCls, SubClass, Related, SubRelated = self.classes(
+ 'BaseCls', 'SubClass', 'Related', 'SubRelated')
+ sess = Session()
+
+ q = sess.query(Related)._with_current_path(
+ self._make_path_registry(
+ [inspect(SubClass), 'related'])
+ )
+
+ opt = subqueryload(SubClass.related).subqueryload(Related.sub_related)
+ self._assert_path_result(opt, q, [(Related, "sub_related")])
+
+
class OptionsNoPropTest(_fixtures.FixtureTest):
"""test the error messages emitted when using property
options in conjunction with column-only entities, or