/SQLAlchemy-0.7.8/test/dialect/test_access.py
Python | 31 lines | 24 code | 7 blank | 0 comment | 1 complexity | 80bdedcae8799780b3f6c9e8fdbba73f MD5 | raw file
- from sqlalchemy import *
- from sqlalchemy import sql
- from sqlalchemy.databases import access
- from test.lib 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)