Skip to content

Commit df7a0d0

Browse files
author
Jesús Leganés Combarro "Piranna
committed
Fixed 'compact' tests
1 parent 482d616 commit df7a0d0

File tree

1 file changed

+21
-4
lines changed

1 file changed

+21
-4
lines changed

tests/test_functions.py

Lines changed: 21 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -15,7 +15,7 @@
1515
from sqlparse.functions import getcolumns, getlimit, IsType
1616

1717

18-
class Test_SQL(TestCase):
18+
class Test_IncludeStatement(TestCase):
1919
sql = """-- type: script
2020
-- return: integer
2121
@@ -25,6 +25,24 @@ class Test_SQL(TestCase):
2525
VALUES(:inode)
2626
LIMIT 1"""
2727

28+
def test_includeStatement(self):
29+
stream = compact(tokenize(self.sql), 'tests/files')
30+
31+
result = Tokens2Unicode(stream)
32+
33+
self.assertEqual(result,
34+
'INSERT INTO dir_entries(type)VALUES(:type);INSERT INTO '
35+
'directories(inode)VALUES(:inode)LIMIT 1')
36+
37+
38+
class Test_SQL(TestCase):
39+
sql = """-- type: script
40+
-- return: integer
41+
42+
INSERT INTO directories(inode)
43+
VALUES(:inode)
44+
LIMIT 1"""
45+
2846
sql2 = """SELECT child_entry,asdf AS inode, creation
2947
FROM links
3048
WHERE parent_dir == :parent_dir AND name == :name
@@ -63,13 +81,12 @@ class Test_SQL(TestCase):
6381

6482
class Test_Compact(Test_SQL):
6583
def test_compact1(self):
66-
stream = compact(tokenize(self.sql), 'tests/files')
84+
stream = compact(tokenize(self.sql))
6785

6886
result = Tokens2Unicode(stream)
6987

7088
self.assertEqual(result,
71-
'INSERT INTO dir_entries(type)VALUES(:type);INSERT INTO '
72-
'directories(inode)VALUES(:inode)LIMIT 1')
89+
'INSERT INTO directories(inode)VALUES(:inode)LIMIT 1')
7390

7491
def test_compact2(self):
7592
stream = tokenize(self.sql2)

0 commit comments

Comments
 (0)