diff options
| author | Jason Kirtland <jek@discorporate.us> | 2009-03-30 20:41:48 +0000 |
|---|---|---|
| committer | Jason Kirtland <jek@discorporate.us> | 2009-03-30 20:41:48 +0000 |
| commit | aca84bebb091a51ceeb911249c366e17b954826a (patch) | |
| tree | 87a0424805905c9fdae0ab6930144c91b9a78ff6 /lib/sqlalchemy/databases/access.py | |
| parent | 1ad157a0a1823706ffb43ee7d235c38ae16f46ff (diff) | |
| download | sqlalchemy-aca84bebb091a51ceeb911249c366e17b954826a.tar.gz | |
extract() is now dialect-sensitive and supports SQLite and others.
Diffstat (limited to 'lib/sqlalchemy/databases/access.py')
| -rw-r--r-- | lib/sqlalchemy/databases/access.py | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/lib/sqlalchemy/databases/access.py b/lib/sqlalchemy/databases/access.py index 67af4a7a4..56c28b8cc 100644 --- a/lib/sqlalchemy/databases/access.py +++ b/lib/sqlalchemy/databases/access.py @@ -328,6 +328,20 @@ class AccessDialect(default.DefaultDialect): class AccessCompiler(compiler.DefaultCompiler): + extract_map = compiler.DefaultCompiler.extract_map.copy() + extract_map.update ({ + 'month': 'm', + 'day': 'd', + 'year': 'yyyy', + 'second': 's', + 'hour': 'h', + 'doy': 'y', + 'minute': 'n', + 'quarter': 'q', + 'dow': 'w', + 'week': 'ww' + }) + def visit_select_precolumns(self, select): """Access puts TOP, it's version of LIMIT here """ s = select.distinct and "DISTINCT " or "" @@ -375,6 +389,10 @@ class AccessCompiler(compiler.DefaultCompiler): return (self.process(join.left, asfrom=True) + (join.isouter and " LEFT OUTER JOIN " or " INNER JOIN ") + \ self.process(join.right, asfrom=True) + " ON " + self.process(join.onclause)) + def visit_extract(self, extract): + field = self.extract_map.get(extract.field, extract.field) + return 'DATEPART("%s", %s)' % (field, self.process(extract.expr)) + class AccessSchemaGenerator(compiler.SchemaGenerator): def get_column_specification(self, column, **kwargs): @@ -422,4 +440,4 @@ dialect.schemagenerator = AccessSchemaGenerator dialect.schemadropper = AccessSchemaDropper dialect.preparer = AccessIdentifierPreparer dialect.defaultrunner = AccessDefaultRunner -dialect.execution_ctx_cls = AccessExecutionContext
\ No newline at end of file +dialect.execution_ctx_cls = AccessExecutionContext |