def go(): result = s.connection(bind_arguments=dict( mapper=User)).execute(stmt) while True: row = result.fetchone() if row is None: break
def test_merge_results(self, merge_fixture): r1, r2, r3, r4 = merge_fixture result = r1.merge(r2, r3, r4) eq_(result.keys(), ["user_id", "user_name"]) row = result.fetchone() eq_(row, (7, "u1")) result.close()
def test_mappings_with_columns(self): result = self._fixture() m1 = result.mappings().columns("b", "c") eq_(m1.fetchmany(2), [{"b": 1, "c": 1}, {"b": 1, "c": 2}]) # no slice here eq_(result.fetchone(), (1, 3, 2)) # still slices eq_(m1.fetchone(), {"b": 1, "c": 2})
def test_unique_default_filters_rearrange_twice(self): # test that the default uniqueness filter is reconfigured # each time columns() is called result = self._fixture( default_filters=[lambda x: x < 4, lambda x: x, lambda x: True]) result = result.unique() # 1, 1, 1 -> True, 1, True eq_(result.fetchone(), (1, 1, 1)) # now rearrange for b, a, c # 1, 2, 2 -> 1, True, True # 3, 1, 2 -> 3, True, True result = result.columns("b", "a", "c") eq_(result.fetchone(), (3, 1, 2)) # now rearrange for c, a # 2, 4 -> True, False result = result.columns("c", "a") eq_(result.fetchall(), [(2, 4)])
def go(): result = s.connection(mapper=User).execute(stmt) while True: row = result.fetchone() if row is None: break