summaryrefslogtreecommitdiff
path: root/test/sql/test_resultset.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_resultset.py')
-rw-r--r--test/sql/test_resultset.py44
1 files changed, 44 insertions, 0 deletions
diff --git a/test/sql/test_resultset.py b/test/sql/test_resultset.py
index ff70fc184..cb9f93018 100644
--- a/test/sql/test_resultset.py
+++ b/test/sql/test_resultset.py
@@ -156,6 +156,50 @@ class CursorResultTest(fixtures.TablesTest):
rows.append(row)
eq_(len(rows), 3)
+ def test_scalars(self, connection):
+ users = self.tables.users
+
+ connection.execute(
+ users.insert(),
+ [
+ {"user_id": 7, "user_name": "jack"},
+ {"user_id": 8, "user_name": "ed"},
+ {"user_id": 9, "user_name": "fred"},
+ ],
+ )
+ r = connection.scalars(users.select().order_by(users.c.user_id))
+ eq_(r.all(), [7, 8, 9])
+
+ def test_result_tuples(self, connection):
+ users = self.tables.users
+
+ connection.execute(
+ users.insert(),
+ [
+ {"user_id": 7, "user_name": "jack"},
+ {"user_id": 8, "user_name": "ed"},
+ {"user_id": 9, "user_name": "fred"},
+ ],
+ )
+ r = connection.execute(
+ users.select().order_by(users.c.user_id)
+ ).tuples()
+ eq_(r.all(), [(7, "jack"), (8, "ed"), (9, "fred")])
+
+ def test_row_tuple(self, connection):
+ users = self.tables.users
+
+ connection.execute(
+ users.insert(),
+ [
+ {"user_id": 7, "user_name": "jack"},
+ {"user_id": 8, "user_name": "ed"},
+ {"user_id": 9, "user_name": "fred"},
+ ],
+ )
+ r = connection.execute(users.select().order_by(users.c.user_id))
+ eq_([row.t for row in r], [(7, "jack"), (8, "ed"), (9, "fred")])
+
def test_row_next(self, connection):
users = self.tables.users