diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-01-28 23:33:53 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-01-28 23:33:53 +0000 |
| commit | bbc5e7c285a160f148eafa0ab442675fe88551ce (patch) | |
| tree | 71f407e9de4c29ac427d01acc7730ac3dd714a80 /test/sql | |
| parent | 7a1a746d7abaebb1e1712224a8ebbf037cc94435 (diff) | |
| download | sqlalchemy-bbc5e7c285a160f148eafa0ab442675fe88551ce.tar.gz | |
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.
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/quote.py | 7 |
1 files changed, 7 insertions, 0 deletions
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() |
