Skip to content
This repository was archived by the owner on May 16, 2026. It is now read-only.

fix: Avoid sqlalchemy20 - #736

Merged
chalmerlowe merged 43 commits into
mainfrom
avoid-sqlalchemy20
Jan 30, 2023
Merged

fix: Avoid sqlalchemy20#736
chalmerlowe merged 43 commits into
mainfrom
avoid-sqlalchemy20

Conversation

@chalmerlowe

@chalmerlowechalmerlowe commented Jan 25, 2023

Copy link
Copy Markdown
Contributor

Prevents the prerelease/compliance installs from using sqlalchemy at >2.0.0 (NOTE: sqlalchemy 2.0.0 has many breaking changes and is not being supported at this time).

  • Removes the nox prerelease install in deference to the autogenerated prerelease_deps install.
  • prevents prerelease testing from installing sqlalchemy > 2.0.0
  • adds a warning suppression environmental variable related to attempts by the code to use syntax that is not found in sqlalchemy 2.0.0
  • corrects an error in how dependency testing is handled (by eliminating the SYSTEM_TEST_EXTRAS collection of test modules (specifically the only package in this collection was being improperly installed)).

@chalmerlowe
chalmerlowe requested review from a team and shollymanJanuary 25, 2023 19:32
@product-auto-labelproduct-auto-labelBot added size: xs Pull request size is extra small. api: bigquery Issues related to the googleapis/python-bigquery-sqlalchemy API. labels Jan 25, 2023
@chalmerlowechalmerlowe changed the title Avoid sqlalchemy20fix: Avoid sqlalchemy20Jan 25, 2023
@product-auto-labelproduct-auto-labelBot added size: u Pull request is empty. and removed size: xs Pull request size is extra small. labels Jan 25, 2023
@product-auto-labelproduct-auto-labelBot added size: xs Pull request size is extra small. and removed size: u Pull request is empty. labels Jan 25, 2023
@product-auto-labelproduct-auto-labelBot added size: u Pull request is empty. and removed size: xs Pull request size is extra small. labels Jan 25, 2023
@product-auto-labelproduct-auto-labelBot added size: xs Pull request size is extra small. and removed size: u Pull request is empty. labels Jan 25, 2023
@product-auto-labelproduct-auto-labelBot added size: u Pull request is empty. and removed size: xs Pull request size is extra small. labels Jan 25, 2023
@product-auto-labelproduct-auto-labelBot added size: xs Pull request size is extra small. and removed size: u Pull request is empty. labels Jan 25, 2023
@chalmerlowechalmerlowe added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jan 26, 2023
@yoshi-kokoroyoshi-kokoro removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jan 26, 2023
@chalmerlowechalmerlowe added kokoro:force-run Add this label to force Kokoro to re-run the tests. and removed owlbot:ignore instruct owl-bot to ignore a PR labels Jan 27, 2023
@yoshi-kokoroyoshi-kokoro removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jan 27, 2023
@chalmerlowechalmerlowe added the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jan 27, 2023
@yoshi-kokoroyoshi-kokoro removed the kokoro:force-run Add this label to force Kokoro to re-run the tests. label Jan 27, 2023

@shollymanshollyman left a comment

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM, but I defer to parthea who's far more familiar with the operational aspects here.

Comment threadnoxfile.py

session.install("--pre", "grpcio")

session.install("--pre", "--no-deps", "--upgrade", "sqlalchemy<2.0.0")

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

the goal with the upgrade + constraint is to pick up the latest of everything but sqlalchemy?

Copy link
Copy Markdown
ContributorAuthor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

The constraint is to ensure that we install a prerelease version of sqlalchemy up to but not including 2.0.0.

Comment threadowlbot.py
)


s.replace(

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I always worry about brittleness with these kinds of replacements, but alas that's problem for future us.

Copy link
Copy Markdown
ContributorAuthor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

you and me both.
i really disliked these s.replace() functions as I was writing them.

@chalmerlowe
chalmerlowe merged commit 0675b1e into mainJan 30, 2023
@chalmerlowe
chalmerlowe deleted the avoid-sqlalchemy20 branch January 30, 2023 15:33
@release-pleaserelease-pleaseBot mentioned this pull request Jan 30, 2023
Sign up for freeto subscribe to this conversation on GitHub. Already have an account? Sign in.

Labels

api: bigqueryIssues related to the googleapis/python-bigquery-sqlalchemy API.size: mPull request size is medium.

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants

@chalmerlowe@shollyman@parthea@yoshi-kokoro