← Back to team overview

yahoo-eng-team team mailing list archive

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

 

Public bug reported:

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")

** Affects: neutron
     Importance: High
     Assignee: Rodolfo Alonso (rodolfo-alonso-hernandez)
         Status: In Progress

** Changed in: neutron
     Assignee: (unassigned) => Rodolfo Alonso (rodolfo-alonso-hernandez)

-- 
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:
  In Progress

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



Follow ups