From 45cec095b4904ba71425d2fe18c143982dd08f43 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Wed, 10 Jun 2009 21:18:24 +0000
Subject: - unit tests have been migrated from unittest to nose. See
 README.unittests for information on how to run the tests.  [ticket:970]

---
 test/dialect/test_sybase.py | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 test/dialect/test_sybase.py

(limited to 'test/dialect/test_sybase.py')

diff --git a/test/dialect/test_sybase.py b/test/dialect/test_sybase.py
new file mode 100644
index 000000000..37de91d1c
--- /dev/null
+++ b/test/dialect/test_sybase.py
@@ -0,0 +1,28 @@
+from sqlalchemy import *
+from sqlalchemy import sql
+from sqlalchemy.databases import sybase
+from sqlalchemy.test import *
+
+
+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)
+
+
+
-- 
cgit v1.2.1