From b15c9c60e2479f6397b7bbcb0787ee66c499e7f8 Mon Sep 17 00:00:00 2001 From: Adam Greenhall Date: Sat, 12 Sep 2015 01:30:37 -0700 Subject: Fix/Test Joins --- tests/test_format.py | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) (limited to 'tests') diff --git a/tests/test_format.py b/tests/test_format.py index 9548dc3..dccc3ec 100644 --- a/tests/test_format.py +++ b/tests/test_format.py @@ -139,6 +139,32 @@ class TestFormatReindentAligned(TestCaseBase): ' limit 10', ])) + def test_joins(self): + sql = """ + select * from a + join b on a.one = b.one + left join c on c.two = a.two and c.three = a.three + full outer join d on d.three = a.three + cross join e on e.four = a.four + join f using (one, two, three) + """ + self.ndiffAssertEqual( + self.formatter(sql), + '\n'.join([ + 'select *', + ' from a', + ' join b', + ' on a.one = b.one', + ' left join c', + ' on c.two = a.two', + ' and c.three = a.three', + ' full outer join d', + ' on d.three = a.three', + ' cross join e', + ' on e.four = a.four', + ' join f using (one, two, three)', + ])) + def test_case_statement(self): sql = """ select a, -- cgit v1.2.1