diff options
| author | Federico Caselli <cfederico87@gmail.com> | 2020-03-14 14:02:44 +0100 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2020-03-21 17:03:45 -0400 |
| commit | 9ec75882203b2c01aa1d362f939e21ebcd188e8d (patch) | |
| tree | 343d9e368f12f839c2c737cc05d1f5e7bc615536 /test/sql/test_defaults.py | |
| parent | 376708f4a4958bf2559c14900c52aa6fc7fd05b3 (diff) | |
| download | sqlalchemy-9ec75882203b2c01aa1d362f939e21ebcd188e8d.tar.gz | |
Deprecate plain string in execute and introduce `exec_driver_sql`
Execution of literal sql string is deprecated in the
:meth:`.Connection.execute` and a warning is raised when used stating
that it will be coerced to :func:`.text` in a future release.
To execute a raw sql string the new connection method
:meth:`.Connection.exec_driver_sql` was added, that will retain the previous
behavior, passing the string to the DBAPI driver unchanged.
Usage of scalar or tuple positional parameters in :meth:`.Connection.execute`
is also deprecated.
Fixes: #4848
Fixes: #5178
Change-Id: I2830181054327996d594f7f0d59c157d477c3aa9
Diffstat (limited to 'test/sql/test_defaults.py')
| -rw-r--r-- | test/sql/test_defaults.py | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/test/sql/test_defaults.py b/test/sql/test_defaults.py index 957fa890a..7d33933f8 100644 --- a/test/sql/test_defaults.py +++ b/test/sql/test_defaults.py @@ -1654,9 +1654,11 @@ class SequenceAsServerDefaultTest( def test_default_textual_w_default(self): with testing.db.connect() as conn: - conn.execute("insert into t_seq_test (data) values ('some data')") + conn.exec_driver_sql( + "insert into t_seq_test (data) values ('some data')" + ) - eq_(conn.scalar("select id from t_seq_test"), 1) + eq_(conn.exec_driver_sql("select id from t_seq_test").scalar(), 1) def test_default_core_w_default(self): t_seq_test = self.tables.t_seq_test @@ -1667,11 +1669,13 @@ class SequenceAsServerDefaultTest( def test_default_textual_server_only(self): with testing.db.connect() as conn: - conn.execute( + conn.exec_driver_sql( "insert into t_seq_test_2 (data) values ('some data')" ) - eq_(conn.scalar("select id from t_seq_test_2"), 1) + eq_( + conn.exec_driver_sql("select id from t_seq_test_2").scalar(), 1 + ) def test_default_core_server_only(self): t_seq_test = self.tables.t_seq_test_2 |