def test_columns_unique_freeze(self):
result = self._fixture()
result = result.columns("b", "c").unique()
frozen = result.freeze()
r1 = frozen()
eq_(r1.fetchall(), [(1, 1), (1, 2), (3, 2)])
def test_scalars_freeze(self):
result = self._fixture()
frozen = result.freeze()
r1 = frozen()
eq_(r1.scalars(1).fetchall(), [1, 1, 3, 1])
r2 = frozen().scalars(1).unique()
eq_(r2.fetchall(), [1, 3])
def test_freeze(self):
result = self._fixture()
frozen = result.freeze()
r1 = frozen()
eq_(r1.fetchall(), [(1, 1, 1), (2, 1, 2), (1, 3, 2), (4, 1, 2)])
eq_(r1.fetchall(), [])
r2 = frozen()
eq_(r1.fetchall(), [])
eq_(r2.fetchall(), [(1, 1, 1), (2, 1, 2), (1, 3, 2), (4, 1, 2)])
eq_(r2.fetchall(), [])