extract() is now dialect-sensitive and supports SQLite and others.

1 files changed, 21 insertions, 5 deletions

diff --git a/test/dialect/sybase.py b/test/dialect/sybase.py
index 19cca465b..32b9904d8 100644
--- a/test/dialect/sybase.py
+++ b/test/dialect/sybase.py
@@ -1,14 +1,30 @@
 import testenv; testenv.configure_for_tests()
 from sqlalchemy import *
+from sqlalchemy import sql
 from sqlalchemy.databases import sybase
 from testlib import *
 
 
-class BasicTest(TestBase, AssertsExecutionResults):
-    # A simple import of the database/ module should work on all systems.
-    def test_import(self):
-        # we got this far, right?
-        return True
+class CompileTest(TestBase, AssertsCompiledSQL):
+    __dialect__ = sybase.dialect()
+
+    def test_extract(self):
+        t = sql.table('t', sql.column('col1'))
+
+        mapping = {
+            'day': 'day',
+            'doy': 'dayofyear',
+            'dow': 'weekday',
+            'milliseconds': 'millisecond',
+            'millisecond': 'millisecond',
+            'year': 'year',
+            }
+
+        for field, subst in mapping.items():
+            self.assert_compile(
+                select([extract(field, t.c.col1)]),
+                'SELECT DATEPART("%s", t.col1) AS anon_1 FROM t' % subst)
+
 
 
 if __name__ == "__main__":