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