summaryrefslogtreecommitdiff
path: root/test/dialect/test_sqlite.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/dialect/test_sqlite.py')
-rw-r--r--test/dialect/test_sqlite.py8
1 files changed, 3 insertions, 5 deletions
diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py
index 23ceb88b3..ad169eebf 100644
--- a/test/dialect/test_sqlite.py
+++ b/test/dialect/test_sqlite.py
@@ -536,17 +536,15 @@ class DefaultsTest(fixtures.TestBase, AssertsCompiledSQL):
"t",
self.metadata,
Column("id", Integer, primary_key=True),
- Column("x", DateTime(), server_default=func.now()),
+ Column("x", String(), server_default=func.lower("UPPERCASE")),
)
t.create(testing.db)
with testing.db.begin() as conn:
- now = conn.scalar(func.now())
- today = datetime.datetime.today()
conn.execute(t.insert())
- conn.execute(t.insert().values(x=today))
+ conn.execute(t.insert().values(x="foobar"))
eq_(
conn.execute(select(t.c.x).order_by(t.c.id)).fetchall(),
- [(now,), (today,)],
+ [("uppercase",), ("foobar",)],
)
@testing.provide_metadata