summaryrefslogtreecommitdiff
path: root/test/sql/query.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/query.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/query.py')
-rw-r--r--test/sql/query.py4
1 files changed, 4 insertions, 0 deletions
diff --git a/test/sql/query.py b/test/sql/query.py
index 224741867..3c3e2334c 100644
--- a/test/sql/query.py
+++ b/test/sql/query.py
@@ -216,6 +216,10 @@ class QueryTest(PersistTest):
self.assert_(r.user_id == r['user_id'] == r[self.users.c.user_id] == 2)
self.assert_(r.user_name == r['user_name'] == r[self.users.c.user_name] == 'jack')
+ r = text("select * from query_users where user_id=2", engine=testbase.db).execute().fetchone()
+ self.assert_(r.user_id == r['user_id'] == r[self.users.c.user_id] == 2)
+ self.assert_(r.user_name == r['user_name'] == r[self.users.c.user_name] == 'jack')
+
def test_keys(self):
self.users.insert().execute(user_id=1, user_name='foo')
r = self.users.select().execute().fetchone()