From 684d8d4c8112b34bbe5d5e35bb2ecba1686fda4c Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 27 Jan 2013 17:15:25 -0500 Subject: [PATCH] - use SQL constructs here for databases that need to escape names like "data" --- lib/sqlalchemy/testing/suite/test_ddl.py | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) diff --git a/lib/sqlalchemy/testing/suite/test_ddl.py b/lib/sqlalchemy/testing/suite/test_ddl.py index c5b162413f..fc1c19362e 100644 --- a/lib/sqlalchemy/testing/suite/test_ddl.py +++ b/lib/sqlalchemy/testing/suite/test_ddl.py @@ -15,11 +15,10 @@ class TableDDLTest(fixtures.TestBase): Column('data', String(50)) ) - def _simple_roundtrip(self): + def _simple_roundtrip(self, table): with config.db.begin() as conn: - conn.execute("insert into test_table(id, data) values " - "(1, 'some data')") - result = conn.execute("select id, data from test_table") + conn.execute(table.insert().values((1, 'some data'))) + result = conn.execute(table.select()) eq_( result.first(), (1, 'some data') @@ -32,7 +31,7 @@ class TableDDLTest(fixtures.TestBase): table.create( config.db, checkfirst=False ) - self._simple_roundtrip() + self._simple_roundtrip(table) @requirements.drop_table @util.provide_metadata -- 2.47.2