- [feature] the MS Access dialect has been

    moved to its own project on Bitbucket,
    taking advantage of the new SQLAlchemy
    dialect compliance suite.   The dialect is
    still in very rough shape and probably not
    ready for general use yet, however
    it does have *extremely* rudimental
    functionality now.

2 files changed, 1 insertions, 34 deletions

diff --git a/test/dialect/test_access.py b/test/dialect/test_access.py
deleted file mode 100644
index 951d43e1a..000000000
--- a/test/dialect/test_access.py
+++ /dev/null
@@ -1,31 +0,0 @@
-from sqlalchemy import *
-from sqlalchemy import sql
-from sqlalchemy.databases import access
-from sqlalchemy.testing import *
-
-
-class CompileTest(fixtures.TestBase, AssertsCompiledSQL):
-    __dialect__ = access.dialect()
-
-    def test_extract(self):
-        t = sql.table('t', sql.column('col1'))
-
-        mapping = {
-            'month': 'm',
-            'day': 'd',
-            'year': 'yyyy',
-            'second': 's',
-            'hour': 'h',
-            'doy': 'y',
-            'minute': 'n',
-            'quarter': 'q',
-            'dow': 'w',
-            'week': 'ww'
-            }
-
-        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)
-
-
diff --git a/test/requirements.py b/test/requirements.py
index fb347187e..b0c072898 100644
--- a/test/requirements.py
+++ b/test/requirements.py
@@ -193,7 +193,6 @@ class DefaultRequirements(SuiteRequirements):
         """Target database must support savepoints."""
 
         return skip_if([
-                    "access",
                     "sqlite",
                     "sybase",
                     ("mysql", "<", (5, 0, 3)),
@@ -215,7 +214,7 @@ class DefaultRequirements(SuiteRequirements):
     @property
     def update_nowait(self):
         """Target database must support SELECT...FOR UPDATE NOWAIT"""
-        return skip_if(["access", "firebird", "mssql", "mysql", "sqlite", "sybase"],
+        return skip_if(["firebird", "mssql", "mysql", "sqlite", "sybase"],
                 "no FOR UPDATE NOWAIT support"
             )
 
@@ -259,7 +258,6 @@ class DefaultRequirements(SuiteRequirements):
         """Target database must support two-phase transactions."""
 
         return skip_if([
-            no_support('access', 'two-phase xact not supported by database'),
             no_support('firebird', 'no SA implementation'),
             no_support('maxdb', 'two-phase xact not supported by database'),
             no_support('mssql', 'two-phase xact not supported by drivers'),