Added rowset() testing helper.

2 files changed, 10 insertions, 0 deletions

diff --git a/test/testlib/__init__.py b/test/testlib/__init__.py
index 29b258c9f..d7daaddf8 100644
--- a/test/testlib/__init__.py
+++ b/test/testlib/__init__.py
@@ -7,6 +7,7 @@ import testlib.config
 from testlib.schema import Table, Column
 from testlib.orm import mapper
 import testlib.testing as testing
+from testlib.testing import rowset
 from testlib.testing import PersistTest, AssertMixin, ORMTest, SQLCompileTest
 import testlib.profiling as profiling
 import testlib.engines as engines
@@ -15,5 +16,6 @@ import testlib.engines as engines
 __all__ = ('testing',
            'mapper',
            'Table', 'Column',
+           'rowset',
            'PersistTest', 'AssertMixin', 'ORMTest', 'SQLCompileTest',
            'profiling', 'engines')
diff --git a/test/testlib/testing.py b/test/testlib/testing.py
index a1fb174b7..43bbb92ff 100644
--- a/test/testlib/testing.py
+++ b/test/testlib/testing.py
@@ -124,6 +124,14 @@ def against(*queries):
                 return True
     return False
 
+def rowset(results):
+    """Converts the results of sql execution into a plain set of column tuples.
+
+    Useful for asserting the results of an unordered query.
+    """
+
+    return set([tuple(row) for row in results])
+
 class TestData(object):
     """Tracks SQL expressions as they are executed via an instrumented ExecutionContext."""