diff options
Diffstat (limited to 'test/sql/test_resultset.py')
| -rw-r--r-- | test/sql/test_resultset.py | 44 |
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 |
