← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 2008223] Re: [sqlalchemy-20] The Engine.execute() method is considered legacy as of the 1.x series

 

Reviewed:  https://review.opendev.org/c/openstack/neutron-lib/+/874866
Committed: https://opendev.org/openstack/neutron-lib/commit/444cec2ba04d12980b116086b727c7ff40db63f4
Submitter: "Zuul (22348)"
Branch:    master

commit 444cec2ba04d12980b116086b727c7ff40db63f4
Author: Rodolfo Alonso Hernandez <ralonsoh@xxxxxxxxxx>
Date:   Sat Feb 18 14:50:58 2023 +0100

    [sqlalchemy-20] Use Connection.execute() instead of Engine.execute()
    
    According to the SLQAlchemy documentation, "the Engine.execute() method
    is considered legacy as of the 1.x series of SQLAlchemy and will be
    removed in 2.0. All statement execution in SQLAlchemy 2.0 is performed
    by the Connection.execute() method of Connection, or in the ORM by the
    Session.execute() method of Session."
    
    Change-Id: Ic4d7a0740f7136cac2055e57e57f66e76cb150f3
    Closes-Bug: #2008223


** Changed in: neutron
       Status: In Progress => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/2008223

Title:
  [sqlalchemy-20] The Engine.execute() method is considered legacy as of
  the 1.x series

Status in neutron:
  Fix Released

Bug description:
  Testing patch: https://review.opendev.org/c/openstack/neutron/+/874778

  Logs:
  https://c06c4109be1832423601-1eb2471c773c922210e88856273ba212.ssl.cf5.rackcdn.com/874778/1/check/neutron-
  functional-with-uwsgi/4c704c1/job-output.txt

  Error:
  2023-02-22 20:05:21.282046 | controller |   engine = engines.create_engine(
  2023-02-22 20:05:21.282060 | controller | /home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-functional-gate/lib/python3.10/site-packages/neutron_lib/fixture.py:103: RemovedIn20Warning: The Engine.execute() method is considered legacy as of the 1.x series of SQLAlchemy and will be removed in 2.0. All statement execution in SQLAlchemy 2.0 is performed by the Connection.execute() method of Connection, or in the ORM by the Session.execute() method of Session. (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)
  2023-02-22 20:05:21.282074 | controller |   self.engine.execute("PRAGMA foreign_keys=ON")

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/2008223/+subscriptions



References