From 7dc411dc63faf59b4e28fa0dea805887821d0d99 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 27 May 2020 10:18:33 -0400 Subject: Render table hints in generic SQL Added :meth:`.Select.with_hint` output to the generic SQL string that is produced when calling ``str()`` on a statement. Previously, this clause would be omitted under the assumption that it was dialect specific. The hint text is presented within brackets to indicate the rendering of such hints varies among backends. Fixes: #5353 References: #4667 Change-Id: I01d97d6baa993e495519036ec7ecd5ae62856c16 --- test/sql/test_compiler.py | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) (limited to 'test/sql') diff --git a/test/sql/test_compiler.py b/test/sql/test_compiler.py index efe4d08c5..20f31ba1e 100644 --- a/test/sql/test_compiler.py +++ b/test/sql/test_compiler.py @@ -3886,6 +3886,41 @@ class StringifySpecialTest(fixtures.TestBase): "'%s'" % value, ) + def test_with_hint_table(self): + stmt = ( + select([table1]) + .select_from( + table1.join(table2, table1.c.myid == table2.c.otherid) + ) + .with_hint(table1, "use some_hint") + ) + + # note that some dialects instead use the "with_select_hint" + # hook to put the 'hint' up front + eq_ignore_whitespace( + str(stmt), + "SELECT mytable.myid, mytable.name, mytable.description " + "FROM mytable [use some_hint] " + "JOIN myothertable ON mytable.myid = myothertable.otherid", + ) + + def test_with_hint_statement(self): + stmt = ( + select([table1]) + .select_from( + table1.join(table2, table1.c.myid == table2.c.otherid) + ) + .with_statement_hint("use some_hint") + ) + + eq_ignore_whitespace( + str(stmt), + "SELECT mytable.myid, mytable.name, mytable.description " + "FROM mytable " + "JOIN myothertable ON mytable.myid = myothertable.otherid " + "use some_hint", + ) + class KwargPropagationTest(fixtures.TestBase): @classmethod -- cgit v1.2.1