diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2008-01-01 00:43:24 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2008-01-01 00:43:24 +0000 |
| commit | 65c618534ff5c6401d1e6f6318e3e4c6b1516204 (patch) | |
| tree | 3ecfd57636e6ebec648b9d397200cb2537f773a7 /test/sql/defaults.py | |
| parent | 85ab0501f46b473e4283dd2df9f9b74a89ad9021 (diff) | |
| download | sqlalchemy-65c618534ff5c6401d1e6f6318e3e4c6b1516204.tar.gz | |
fix up oracle handling of LOB/string [ticket:902], slight fixes to defaults.py but we
will need to fix up result-type handling some more
Diffstat (limited to 'test/sql/defaults.py')
| -rw-r--r-- | test/sql/defaults.py | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/test/sql/defaults.py b/test/sql/defaults.py index bce499686..a67eea894 100644 --- a/test/sql/defaults.py +++ b/test/sql/defaults.py @@ -40,13 +40,15 @@ class DefaultTest(PersistTest): currenttime = func.current_date(type_=Date, bind=db) if is_oracle: - ts = db.func.trunc(func.sysdate(), literal_column("'DAY'")).scalar() + ts = db.scalar(select([func.trunc(func.sysdate(), literal_column("'DAY'"), type_=Date).label('today')])) + assert isinstance(ts, datetime.date) and not isinstance(ts, datetime.datetime) f = select([func.length('abcdef')], bind=db).scalar() f2 = select([func.length('abcdefghijk')], bind=db).scalar() # TODO: engine propigation across nested functions not working - currenttime = func.trunc(currenttime, literal_column("'DAY'"), bind=db) + currenttime = func.trunc(currenttime, literal_column("'DAY'"), bind=db, type_=Date) def1 = currenttime - def2 = func.trunc(text("sysdate"), literal_column("'DAY'")) + def2 = func.trunc(text("sysdate"), literal_column("'DAY'"), type_=Date) + deftype = Date elif use_function_defaults: f = select([func.length('abcdef')], bind=db).scalar() @@ -146,10 +148,10 @@ class DefaultTest(PersistTest): t.insert().execute() t.insert().execute() - ctexec = currenttime.scalar() + ctexec = select([currenttime.label('now')], bind=testbase.db).scalar() l = t.select().execute() today = datetime.date.today() - self.assert_(l.fetchall() == [ + self.assertEquals(l.fetchall(), [ (51, 'imthedefault', f, ts, ts, ctexec, True, False, 12, today), (52, 'imthedefault', f, ts, ts, ctexec, True, False, 12, today), (53, 'imthedefault', f, ts, ts, ctexec, True, False, 12, today), |