1515from 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
6482class 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