From fab9be5d0ea3e329921d6c474c4ecc618bda17ec Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 30 Sep 2012 20:17:49 -0400 Subject: - [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. --- test/dialect/test_access.py | 31 ------------------------------- test/requirements.py | 4 +--- 2 files changed, 1 insertion(+), 34 deletions(-) delete mode 100644 test/dialect/test_access.py (limited to 'test') 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'), -- cgit v1.2.1