def test_count_no_rows_exact_typed(self): reader = PandasReader(schema, df) query = QueryParser(schema).queries("SELECT COUNT(*) as c FROM PUMS.PUMS WHERE age > 100")[0] trs = reader.execute_ast_typed(query) assert(trs['c'][0] == 0)
def test_sum_noisy(self): reader = PandasReader(schema, df) query = QueryParser(schema).queries("SELECT SUM(age) as age_total FROM PUMS.PUMS")[0] trs = reader.execute_ast_typed(query) assert(trs['age_total'][0] > 1000)