From bbc5e7c285a160f148eafa0ab442675fe88551ce Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 28 Jan 2007 23:33:53 +0000 Subject: merged the polymorphic relationship refactoring branch in. i want to go further on that branch and introduce the foreign_keys argument, and further centralize the "intelligence" about the joins and selectables into PropertyLoader so that lazyloader/sync can be simplified, but the current branch goes pretty far. - relations keep track of "polymorphic_primaryjoin", "polymorphic_secondaryjoin" which it derives from the plain primaryjoin/secondaryjoin. - lazy/eagerloaders work from those polymorphic join objects. - the join exported by PropertyLoader to Query/SelectResults is the polymorphic join, so that join_to/etc work properly. - Query builds itself against the base Mapper again, not the "polymorphic" mapper. uses the "polymorphic" version only as appropriate. this helps join_by/join_to/etc to work with polymorphic mappers. - Query will also adapt incoming WHERE criterion to the polymorphic mapper, i.e. the "people" table becomes the "person_join" automatically. - quoting has been modified since labels made out of non-case-sensitive columns could themselves require quoting..so case_sensitive defaults to True if not otherwise specified (used to be based on the identifier itself). - the test harness gets an ORMTest base class and a bunch of the ORM unit tests are using it now, decreases a lot of redundancy. --- test/sql/quote.py | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'test/sql') diff --git a/test/sql/quote.py b/test/sql/quote.py index 6438586f6..8ae228031 100644 --- a/test/sql/quote.py +++ b/test/sql/quote.py @@ -89,6 +89,13 @@ class QuoteTest(PersistTest): where the "UPPERCASE" column of "LaLa" doesnt exist. """ x = table1.select(distinct=True).alias("LaLa").select().scalar() + + def testlabels2(self): + metadata = MetaData() + table = Table("ImATable", metadata, + Column("col1", Integer)) + x = select([table.c.col1.label("ImATable_col1")]).alias("SomeAlias") + assert str(select([x.c.ImATable_col1])) == '''SELECT "SomeAlias"."ImATable_col1" \nFROM (SELECT "ImATable".col1 AS "ImATable_col1" \nFROM "ImATable") AS "SomeAlias"''' def testlabelsnocase(self): metadata = MetaData() -- cgit v1.2.1