summaryrefslogtreecommitdiff
path: root/tests
diff options
context:
space:
mode:
authorJesús Leganés Combarro "Piranna" <piranna@gmail.com>2012-05-23 21:54:47 +0200
committerJesús Leganés Combarro "Piranna" <piranna@gmail.com>2012-05-23 21:54:47 +0200
commita15e726d7231bcbfa42c49384a4ca9187dc128d1 (patch)
treea806e9f48caa590f19eb5fbe266816b4279a39e5 /tests
parente80e3fc36b60683fafaa51acdc5c95470dddc3fa (diff)
parenta18c97f796737b9a8ec57e56e185dead9b6e881a (diff)
downloadsqlparse-a15e726d7231bcbfa42c49384a4ca9187dc128d1.tar.gz
Merge branch 'master' of github.com:piranna/sqlparse
Conflicts: sqlparse/filters.py tests/test_functions.py
Diffstat (limited to 'tests')
-rw-r--r--tests/test_functions.py46
1 files changed, 39 insertions, 7 deletions
diff --git a/tests/test_functions.py b/tests/test_functions.py
index d5d8f91..aa382ce 100644
--- a/tests/test_functions.py
+++ b/tests/test_functions.py
@@ -5,7 +5,7 @@ Created on 13/02/2012
'''
from unittest import main, TestCase
-from sqlparse.filters import Tokens2Unicode
+from sqlparse.filters import IncludeStatement, Tokens2Unicode
from sqlparse.lexer import tokenize
import sys
@@ -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,27 @@ class Test_SQL(TestCase):
VALUES(:inode)
LIMIT 1"""
+ def test_includeStatement(self):
+ stream = tokenize(self.sql)
+ includeStatement = IncludeStatement('tests/files', raiseexceptions=True)
+ stream = includeStatement.process(None, stream)
+ stream = compact(stream)
+
+ 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,17 +84,28 @@ LIMIT 1"""
class Test_Compact(Test_SQL):
def test_compact1(self):
- self.assertEqual(Tokens2Unicode(compact(self.sql, 'tests/files')),
- 'INSERT INTO dir_entries(type)VALUES(:type);INSERT INTO '
- 'directories(inode)VALUES(:inode)LIMIT 1')
+ stream = compact(tokenize(self.sql))
+
+ result = Tokens2Unicode(stream)
+
+ self.assertEqual(result,
+ 'INSERT INTO directories(inode)VALUES(:inode)LIMIT 1')
def test_compact2(self):
- self.assertEqual(Tokens2Unicode(compact(self.sql2)),
+ stream = tokenize(self.sql2)
+
+ result = compact(stream)
+
+ self.assertEqual(Tokens2Unicode(result),
'SELECT child_entry,asdf AS inode,creation FROM links WHERE '
'parent_dir==:parent_dir AND name==:name LIMIT 1')
def test_compact3(self):
- self.assertEqual(Tokens2Unicode(compact(self.sql3)),
+ stream = tokenize(self.sql3)
+
+ result = compact(stream)
+
+ self.assertEqual(Tokens2Unicode(result),
'SELECT 0 AS st_dev,0 AS st_uid,0 AS st_gid,dir_entries.type AS '
'st_mode,dir_entries.inode AS st_ino,COUNT(links.child_entry)AS '
'st_nlink,:creation AS st_ctime,dir_entries.access AS st_atime,'