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 result_to_namedtuple(result: sqlalchemy.engine.result.ResultProxy): Record = collections.namedtuple('Record', result.keys()) records = [Record(*r) for r in result.fetchall()] return records
def test_columns(self): result = self._fixture() result = result.columns("b", "c") eq_(result.keys(), ["b", "c"]) eq_(result.all(), [(1, 1), (1, 2), (3, 2), (1, 2)])