From 47e7f56a52870bdb278225fc05866efcb5e65a1d Mon Sep 17 00:00:00 2001 From: Andi Albrecht Date: Wed, 13 Apr 2011 16:04:56 +0200 Subject: Don't group trailing whitepsace in WHERE clauses (fixes issue35). --- tests/test_regressions.py | 12 ++++++++++-- 1 file changed, 10 insertions(+), 2 deletions(-) (limited to 'tests') diff --git a/tests/test_regressions.py b/tests/test_regressions.py index 3046b97..cbe1234 100644 --- a/tests/test_regressions.py +++ b/tests/test_regressions.py @@ -1,13 +1,13 @@ # -*- coding: utf-8 -*- -import unittest +from tests.utils import TestCaseBase import sqlparse from sqlparse import sql from sqlparse import tokens as T -class RegressionTests(unittest.TestCase): +class RegressionTests(TestCaseBase): def test_issue9(self): # make sure where doesn't consume parenthesis @@ -31,3 +31,11 @@ class RegressionTests(unittest.TestCase): t = sqlparse.parse("create")[0].token_first() self.assertEqual(t.match(T.Keyword.DDL, "create"), True) self.assertEqual(t.match(T.Keyword.DDL, "CREATE"), True) + + def test_issue35(self): + # missing space before LIMIT + sql = sqlparse.format("select * from foo where bar = 1 limit 1", + reindent=True) + self.ndiffAssertEqual(sql, "\n".join(["select *", + "from foo", + "where bar = 1 limit 1"])) -- cgit v1.2.1