diff options
Diffstat (limited to 'tests/test_pipeline.py')
| -rw-r--r-- | tests/test_pipeline.py | 47 |
1 files changed, 24 insertions, 23 deletions
diff --git a/tests/test_pipeline.py b/tests/test_pipeline.py index 56eed4a..3442a5b 100644 --- a/tests/test_pipeline.py +++ b/tests/test_pipeline.py @@ -4,6 +4,7 @@ from sqlparse.filters import ColumnsSelect from sqlparse.lexer import tokenize from sqlparse.pipeline import Pipeline + class Test(unittest.TestCase): def setUp(self): @@ -34,35 +35,35 @@ class Test(unittest.TestCase): def test_3(self): sql = """ - SELECT - 0 AS st_dev, - 0 AS st_uid, - 0 AS st_gid, +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, +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, - dir_entries.modification AS st_mtime, - -- :creation AS st_ctime, - -- CAST(STRFTIME('%s',dir_entries.access) AS INTEGER) AS st_atime, - -- CAST(STRFTIME('%s',dir_entries.modification) AS INTEGER) AS st_mtime, +:creation AS st_ctime, +dir_entries.access AS st_atime, +dir_entries.modification AS st_mtime, +-- :creation AS st_ctime, +-- CAST(STRFTIME('%s',dir_entries.access) AS INTEGER) AS st_atime, +-- CAST(STRFTIME('%s',dir_entries.modification) AS INTEGER) AS st_mtime, - COALESCE(files.size,0) AS st_size, -- Python-FUSE - COALESCE(files.size,0) AS size -- PyFilesystem +COALESCE(files.size,0) AS st_size, -- Python-FUSE +COALESCE(files.size,0) AS size -- PyFilesystem - FROM dir_entries - LEFT JOIN files - ON dir_entries.inode == files.inode - LEFT JOIN links - ON dir_entries.inode == links.child_entry +FROM dir_entries +LEFT JOIN files +ON dir_entries.inode == files.inode +LEFT JOIN links +ON dir_entries.inode == links.child_entry - WHERE dir_entries.inode == :inode +WHERE dir_entries.inode == :inode - GROUP BY dir_entries.inode - LIMIT 1""" +GROUP BY dir_entries.inode +LIMIT 1""" self.assertEqual([u'st_dev', u'st_uid', u'st_gid', u'st_mode', u'st_ino', u'st_nlink', u'st_ctime', u'st_atime', u'st_mtime', u'st_size', u'size'], |