summaryrefslogtreecommitdiff
path: root/test/sql
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2007-08-07 17:12:35 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2007-08-07 17:12:35 +0000
commitc7ee47e545316272ff0864e46c5afbd338df9cb1 (patch)
tree81d93dff2b8ffea77f4af9b7d0d13959c8f263b1 /test/sql
parent2babbe7843ac2d15ce415b6b604144f5d0d30359 (diff)
downloadsqlalchemy-c7ee47e545316272ff0864e46c5afbd338df9cb1.tar.gz
- migrated 'desc', 'asc', and 'distinct' to be in the Operators framework
- fixes to operator() method signature/calling
Diffstat (limited to 'test/sql')
-rw-r--r--test/sql/select.py8
1 files changed, 8 insertions, 0 deletions
diff --git a/test/sql/select.py b/test/sql/select.py
index 2e099b01a..0edaab071 100644
--- a/test/sql/select.py
+++ b/test/sql/select.py
@@ -314,6 +314,14 @@ sq.myothertable_othername AS sq_myothertable_othername FROM (" + sqstring + ") A
self.runtest(
select([table1.c.myid]).distinct(), "SELECT DISTINCT mytable.myid FROM mytable"
)
+
+ self.runtest(
+ select([func.count(table1.c.myid.distinct())]), "SELECT count(DISTINCT mytable.myid) FROM mytable"
+ )
+
+ self.runtest(
+ select([func.count(distinct(table1.c.myid))]), "SELECT count(DISTINCT mytable.myid) FROM mytable"
+ )
def testoperators(self):