def test_vertica_query_uses_double_quote_chars(self):
q = VerticaQuery.from_(self.table_abc).select(
self.table_abc.foo
).groupby(
self.table_abc.foo
).having(
self.table_abc.buz == 'fiz'
)
self.assertEqual("SELECT \"foo\" FROM \"abc\" GROUP BY \"foo\" HAVING \"buz\"='fiz'", str(q))
def test_vertica_query_uses_double_quote_chars(self):
q = VerticaQuery.from_('abc').select('foo', 'bar')
self.assertEqual('SELECT "foo","bar" FROM "abc"', str(q))
def test_vertica_query_uses_double_quote_chars(self):
q = VerticaQuery.from_(self.t).groupby(self.t.foo).select(self.t.foo)
self.assertEqual('SELECT "foo" FROM "abc" GROUP BY "foo"', str(q))
def test_add_hint_to_query_if_supported_by_dialect_and_hint_is_set(self):
query = VerticaQuery.from_('table').select('*')
query_hint = add_hints([query], 'test_hint')
self.assertEqual('SELECT /*+label(test_hint)*/ * FROM "table"', str(query_hint[0]))
def test_do_not_add_hints_to_query_if_no_hint_string_supplied(self):
query = VerticaQuery.from_('table').select('*')
query_hint = add_hints([query], hint=None)
self.assertEqual('SELECT * FROM "table"', str(query_hint[0]))
def test_vertica_query_uses_double_quote_chars(self):
q = VerticaQuery.from_("abc").select("foo", "bar")
self.assertEqual('SELECT "foo","bar" FROM "abc"', str(q))
def test_vertica_query_uses_double_quote_chars(self):
q = VerticaQuery.from_(self.t).groupby(self.t.foo).select(self.t.foo)
self.assertEqual('SELECT "foo" FROM "abc" GROUP BY "foo"', str(q))
def test__split_part(self):
q = VerticaQuery.from_(self.t).select(fn.SplitPart(self.t.foo, "|", 3))
self.assertEqual('SELECT SPLIT_PART("foo",\'|\',3) FROM "abc"', str(q))
def test__regexp_like(self):
q = VerticaQuery.from_(self.t).select(
fn.RegexpLike(self.t.foo, "^a", "x"))
self.assertEqual("SELECT REGEXP_LIKE(\"foo\",'^a','x') FROM \"abc\"",
str(q))
def test__split_part(self):
q = VerticaQuery.from_(self.t).select(fn.SplitPart(self.t.foo, '|', 3))
self.assertEqual("SELECT SPLIT_PART(\"foo\",\'|\',3) FROM \"abc\"", str(q))
def test__regexp_like(self):
q = VerticaQuery.from_(self.t).select(fn.RegexpLike(self.t.foo, '^a', 'x'))
self.assertEqual("SELECT REGEXP_LIKE(\"foo\",\'^a\',\'x\') FROM \"abc\"", str(q))
def test__split_part(self):
q = VerticaQuery.from_(self.t).select(fn.SplitPart(self.t.foo, '|', 3))
self.assertEqual("SELECT SPLIT_PART(\"foo\",\'|\',3) FROM \"abc\"", str(q))
def test_do_not_add_hints_to_query_if_no_hint_string_supplied(self):
query = VerticaQuery.from_('table').select('*')
query_hint = add_hints([query], hint=None)
self.assertEqual('SELECT * FROM "table"', str(query_hint[0]))
def test_add_hint_to_query_if_supported_by_dialect_and_hint_is_set(self):
query = VerticaQuery.from_('table').select('*')
query_hint = add_hints([query], 'test_hint')
self.assertEqual('SELECT /*+label(test_hint)*/ * FROM "table"',
str(query_hint[0]))