diff options
| author | Andi Albrecht <albrecht.andi@gmail.com> | 2009-05-05 06:05:36 +0200 |
|---|---|---|
| committer | Andi Albrecht <albrecht.andi@gmail.com> | 2009-05-05 06:05:36 +0200 |
| commit | e9d921676a44b93d7d92978f8008cfdd9c5ca8b9 (patch) | |
| tree | 0f864a091b4e12a74a456295834ad638e0d41930 | |
| parent | 235864a1fcc5d871d584dcd8eeeeaded4f6572c9 (diff) | |
| download | sqlparse-e9d921676a44b93d7d92978f8008cfdd9c5ca8b9.tar.gz | |
Added unittest for issue3.
| -rw-r--r-- | tests/test_format.py | 17 |
1 files changed, 15 insertions, 2 deletions
diff --git a/tests/test_format.py b/tests/test_format.py index 4c2742d..9b296a3 100644 --- a/tests/test_format.py +++ b/tests/test_format.py @@ -148,8 +148,7 @@ class TestFormatReindent(TestCaseBase): ' else 5', 'end'])) - def test_nested_identifier_list(self): - # issue4 + def test_nested_identifier_list(self): # issue4 f = lambda sql: sqlparse.format(sql, reindent=True) s = '(foo as bar, bar1, bar2 as bar3, b4 as b5)' self.ndiffAssertEqual(f(s), '\n'.join(['(foo as bar,', @@ -157,4 +156,18 @@ class TestFormatReindent(TestCaseBase): ' bar2 as bar3,', ' b4 as b5)'])) + def test_duplicate_linebreaks(self): # issue3 + f = lambda sql: sqlparse.format(sql, reindent=True) + s = 'select c1 -- column1\nfrom foo' + self.ndiffAssertEqual(f(s), '\n'.join(['select c1 -- column1', + 'from foo'])) + s = 'select c1 -- column1\nfrom foo' + r = sqlparse.format(s, reindent=True, strip_comments=True) + self.ndiffAssertEqual(r, '\n'.join(['select c1', + 'from foo'])) + s = 'select c1\nfrom foo\norder by c1' + self.ndiffAssertEqual(f(s), '\n'.join(['select c1', + 'from foo', + 'order by c1'])) + |