summaryrefslogtreecommitdiff
path: root/tests
diff options
context:
space:
mode:
authorJesús Leganés Combarro "Piranna <jesus.lc@vaelsys.com>2012-05-23 18:52:55 +0200
committerJesús Leganés Combarro "Piranna <jesus.lc@vaelsys.com>2012-05-23 18:52:55 +0200
commitdf7a0d01259b772b199eab042989f14e8a04d5fb (patch)
treea831dc0ff07cd178a94865cd1267ba276f49d31c /tests
parent482d6164a5d0e8f01dbf5b6c6d059763bf6d1eec (diff)
downloadsqlparse-df7a0d01259b772b199eab042989f14e8a04d5fb.tar.gz
Fixed 'compact' tests
Diffstat (limited to 'tests')
-rw-r--r--tests/test_functions.py25
1 files changed, 21 insertions, 4 deletions
diff --git a/tests/test_functions.py b/tests/test_functions.py
index 5ab1586..ff8625a 100644
--- a/tests/test_functions.py
+++ b/tests/test_functions.py
@@ -15,7 +15,7 @@ from sqlparse.filters import compact
from sqlparse.functions import getcolumns, getlimit, IsType
-class Test_SQL(TestCase):
+class Test_IncludeStatement(TestCase):
sql = """-- type: script
-- return: integer
@@ -25,6 +25,24 @@ class Test_SQL(TestCase):
VALUES(:inode)
LIMIT 1"""
+ def test_includeStatement(self):
+ stream = compact(tokenize(self.sql), 'tests/files')
+
+ result = Tokens2Unicode(stream)
+
+ self.assertEqual(result,
+ 'INSERT INTO dir_entries(type)VALUES(:type);INSERT INTO '
+ 'directories(inode)VALUES(:inode)LIMIT 1')
+
+
+class Test_SQL(TestCase):
+ sql = """-- type: script
+ -- return: integer
+
+ INSERT INTO directories(inode)
+ VALUES(:inode)
+ LIMIT 1"""
+
sql2 = """SELECT child_entry,asdf AS inode, creation
FROM links
WHERE parent_dir == :parent_dir AND name == :name
@@ -63,13 +81,12 @@ LIMIT 1"""
class Test_Compact(Test_SQL):
def test_compact1(self):
- stream = compact(tokenize(self.sql), 'tests/files')
+ stream = compact(tokenize(self.sql))
result = Tokens2Unicode(stream)
self.assertEqual(result,
- 'INSERT INTO dir_entries(type)VALUES(:type);INSERT INTO '
- 'directories(inode)VALUES(:inode)LIMIT 1')
+ 'INSERT INTO directories(inode)VALUES(:inode)LIMIT 1')
def test_compact2(self):
stream = tokenize(self.sql2)