def test_coalesce(sqla): t = symbol('t', discover(sqla)) assert ( compute(coalesce(t.B, -1), {t: sqla}, return_type=list) == [(1,), (1,), (-1,)] ) assert ( compute(coalesce(t.A, 'z'), {t: sqla}, return_type=list) == [('a',), ('z',), ('c',)] )
def test_coalesce(sqla): t = symbol('t', discover(sqla)) assert ( compute(coalesce(t.B, -1), {t: sqla}, return_type=list) == [1, 1, -1] ) assert ( compute(coalesce(t.A, 'z'), {t: sqla}, return_type=list) == ['a', 'z', 'c'] )