diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2022-04-04 10:13:23 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2022-04-07 10:47:53 -0400 |
| commit | 2acc9ec1281b2818bd44804f040d94ec46215688 (patch) | |
| tree | 40e77ef66a8682b4a1d885575412a78152806397 /test/sql/test_insert.py | |
| parent | 3b4d62f4f72e8dfad7f38db192a6a90a8551608c (diff) | |
| download | sqlalchemy-2acc9ec1281b2818bd44804f040d94ec46215688.tar.gz | |
cx_Oracle modernize
Full "RETURNING" support is implemented for the cx_Oracle dialect, meaning
multiple RETURNING rows are now recived for DML statements that produce
more than one row for RETURNING.
cx_Oracle 7 is now the minimum version for cx_Oracle.
Getting Oracle to do multirow returning took about 5 minutes. however,
getting Oracle's RETURNING system to integrate with ORM-enabled
insert, update, delete, is a big deal because that architecture wasn't
really working very robustly, including some recent changes in 1.4
for FromStatement were done in a hurry, so this patch also cleans up
the FromStatement situation and begins to establish it more concretely
as the base for all ReturnsRows / TextClause ORM scenarios.
Fixes: #6245
Change-Id: I2b4e6007affa51ce311d2d5baa3917f356ab961f
Diffstat (limited to 'test/sql/test_insert.py')
| -rw-r--r-- | test/sql/test_insert.py | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/test/sql/test_insert.py b/test/sql/test_insert.py index 74a60bd21..5f02fde4c 100644 --- a/test/sql/test_insert.py +++ b/test/sql/test_insert.py @@ -1423,7 +1423,7 @@ class MultirowTest(_InsertTestBase, fixtures.TablesTest, AssertsCompiledSQL): stmt = table.insert().return_defaults().values(id=func.foobar()) compiled = stmt.compile(dialect=sqlite.dialect(), column_keys=["data"]) eq_(compiled.postfetch, []) - eq_(compiled.returning, []) + eq_(compiled.implicit_returning, []) self.assert_compile( stmt, @@ -1452,7 +1452,7 @@ class MultirowTest(_InsertTestBase, fixtures.TablesTest, AssertsCompiledSQL): dialect=returning_dialect, column_keys=["data"] ) eq_(compiled.postfetch, []) - eq_(compiled.returning, [table.c.id]) + eq_(compiled.implicit_returning, [table.c.id]) self.assert_compile( stmt, @@ -1482,7 +1482,7 @@ class MultirowTest(_InsertTestBase, fixtures.TablesTest, AssertsCompiledSQL): dialect=returning_dialect, column_keys=["data"] ) eq_(compiled.postfetch, []) - eq_(compiled.returning, [table.c.id]) + eq_(compiled.implicit_returning, [table.c.id]) self.assert_compile( stmt, |