summaryrefslogtreecommitdiff
path: root/test/sql/labels.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2007-03-28 01:39:58 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2007-03-28 01:39:58 +0000
commitccbcbda43e74a1d09d50aa2f8212b3cb9adafd23 (patch)
tree5ecf17fa8dd62f9b9d1495e25273b770d3ad07fb /test/sql/labels.py
parentd7c0daf1ec7918a8d5635696a067f035bda61fd6 (diff)
downloadsqlalchemy-ccbcbda43e74a1d09d50aa2f8212b3cb9adafd23.tar.gz
added label truncation for bind param names which was lost in the previous related commit.
added more tests plus test for column targeting with text() clause.
Diffstat (limited to 'test/sql/labels.py')
-rw-r--r--test/sql/labels.py10
1 files changed, 10 insertions, 0 deletions
diff --git a/test/sql/labels.py b/test/sql/labels.py
index 0b3957619..0302fee78 100644
--- a/test/sql/labels.py
+++ b/test/sql/labels.py
@@ -30,5 +30,15 @@ class LongLabelsTest(testbase.PersistTest):
(4, "data4"),
]
+ def test_colbinds(self):
+ r = table1.select(table1.c.this_is_the_primary_key_column == 4).execute()
+ assert r.fetchall() == [(4, "data4")]
+
+ r = table1.select(or_(
+ table1.c.this_is_the_primary_key_column == 4,
+ table1.c.this_is_the_primary_key_column == 2
+ )).execute()
+ assert r.fetchall() == [(2, "data2"), (4, "data4")]
+
if __name__ == '__main__':
testbase.main() \ No newline at end of file