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)