def test_select_from_dual(self): sql = "SELECT 1" expected = { "meta": { "format": "table" }, "header": ["1"], "data": [[1]] } result = self._run_sql_query(sql) compare_to_expected(result.meta.jx_query, result, expected, places=6)
def test_filter(self): sql = 'select * from ' + TEST_TABLE + ' where v>=3' expected = { "meta": { "format": "table" }, "header": ["a", "v"], "data": [["c", 13], [NULL, 3], ["c", 7], ["c", 11]] } result = self._run_sql_query(sql) compare_to_expected(result.meta.jx_query, result, expected, places=6)
def test_empty_count(self): sql = "select count() from " + TEST_TABLE expected = { "meta": { "format": "table" }, "header": ["count"], "data": [[6]] } result = self._run_sql_query(sql) compare_to_expected(result.meta.jx_query, result, expected, places=6)
def test_count(self): sql = 'select a as "a", count(1) as "count" from ' + TEST_TABLE + ' group by a' expected = { "meta": { "format": "table" }, "header": ["a", "count"], "data": [["b", 2], ["c", 3], [NULL, 1]] } result = self._run_sql_query(sql) compare_to_expected(result.meta.jx_query, result, expected, places=6)
def test_in_clause(self): sql = "select * from " + TEST_TABLE + " where a IN ('b', 'c')" expected = { "meta": { "format": "table" }, "header": ["a", "v"], "data": [["c", 13], ["b", 2], ["b", None], ["c", 7], ["c", 11]] } result = self._run_sql_query(sql) compare_to_expected(result.meta.jx_query, result, expected, places=6)