Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Import broken by sqlalchemy 1.4.0 #505

Closed
NakulK48 opened this issue Mar 15, 2021 · 10 comments · Fixed by #506
Closed

Import broken by sqlalchemy 1.4.0 #505

NakulK48 opened this issue Mar 15, 2021 · 10 comments · Fixed by #506

Comments

@NakulK48
Copy link 

[2021-03-15T18:09:18.021Z] ../../../miniconda/envs/jenkins-jca_multibranch-PR-52-1/lib/python3.8/site-packages/sqlalchemy_utils/functions/orm.py:14: in <module>

[2021-03-15T18:09:18.021Z]     from sqlalchemy.orm.query import _ColumnEntity

[2021-03-15T18:09:18.021Z] E   ImportError: cannot import name '_ColumnEntity' from 'sqlalchemy.orm.query' (/home/jcauser/miniconda/envs/jenkins-jca_multibranch-PR-52-1/lib/python3.8/site-packages/sqlalchemy/orm/query.py)
@greschd greschd mentioned this issue Mar 15, 2021
Closed
@bahamut45
Copy link

👍 same error

@aduggirala28
Copy link

aduggirala28 commented Mar 15, 2021 •
edited
Loading

Same issue, error with importing '_ColumnEntity'

14:45:43 .tox/py37/lib/python3.7/site-packages/sqlalchemy_utils/functions/orm.py:14: in <module>
14:45:43     from sqlalchemy.orm.query import _ColumnEntity
14:45:43 E   ImportError: cannot import name '_ColumnEntity' from 'sqlalchemy.orm.query'

Name: SQLAlchemy
Version: 1.4.0
Summary: Database Abstraction Library
Home-page: http://www.sqlalchemy.org
Author: Mike Bayer
Author-email: [email protected]
License: MIT
Requires: greenlet
Required-by: SQLAlchemy-Utils, Flask-SQLAlchemy, alembic

Name: SQLAlchemy-Utils
Version: 0.36.8
Summary: Various utility functions for SQLAlchemy.
Home-page: https://github.com/kvesteri/sqlalchemy-utils
Author: Konsta Vesterinen, Ryan Leckey, Janne Vanhala, Vesa Uimonen
Author-email: [email protected]
License: BSD
Requires: six, SQLAlchemy
Required-by:

@SamWheating SamWheating mentioned this issue Mar 15, 2021
Closed
@jbvsmo
Copy link

jbvsmo commented Mar 15, 2021

Can you guys make a quick fix by adding requirement version < 1.4.0? Otherwise if people start doing it they might get stuck with old sqlalchemy

@jceresini jceresini mentioned this issue Mar 15, 2021
Closed
@acrellin acrellin mentioned this issue Mar 15, 2021
Merged
@nsoranzo
Copy link
Contributor

Duplicate of #474

@NakulK48
Copy link
Author

Duplicate of #474

1.4 left beta yesterday, so I think this is more urgent now than it was.

@yannickperrenet yannickperrenet mentioned this issue Mar 16, 2021
Merged
3 tasks
yannickperrenet added a commit to orchest/orchest that referenced this issue Mar 16, 2021
@yannickperrenet
Fix sqlalchemy version on 1.3.23
5e9eb9e 
The latest 1.4.0 release breaks sqlalchemy-utils.

See: kvesteri/sqlalchemy-utils#505
@sphuber
Copy link

sphuber commented Mar 16, 2021

There is another problem:

/opt/hostedtoolcache/Python/3.8.8/x64/lib/python3.8/site-packages/sqlalchemy_utils/expressions.py:4: in <module>
    from sqlalchemy.sql.expression import (
E   ImportError: cannot import name '_literal_as_text' from 'sqlalchemy.sql.expression' (/opt/hostedtoolcache/Python/3.8.8/x64/lib/python3.8/site-packages/sqlalchemy/sql/expression.py)

This is because of this commit in sqlalchemy.

@sphuber sphuber mentioned this issue Mar 16, 2021
Closed
techouse referenced this issue in techouse/sqlite3-to-mysql Mar 16, 2021
@techouse
🚑 Temporarily require sqlalchemy <1.4.0 to make compatible with sqlal…
7884ad8 
…chemy-utils
techouse referenced this issue in techouse/mysql-to-sqlite3 Mar 16, 2021
@techouse
🚑 Temporarily require sqlalchemy <1.4.0 to make compatible with sqlal…
159b45b 
…chemy-utils
@pacospace pacospace mentioned this issue Mar 16, 2021
Closed
fmigneault added a commit to Ouranosinc/Magpie that referenced this issue Mar 16, 2021
@fmigneault
pin sqlalchemy<1.4 (relates to kvesteri/sqlalchemy-utils#474 and kves…
633f750 
…teri/sqlalchemy-utils#505)
diegodelemos pushed a commit to diegodelemos/reana-db that referenced this issue Mar 17, 2021
installation: pin SQLAlchemy to fix installation
b784935 
* Issue caused by kvesteri/sqlalchemy-utils#505.
diegodelemos pushed a commit to diegodelemos/reana-db that referenced this issue Mar 17, 2021
installation: temporarily pin SQLAlchemy<1.4
221ee72 
* Issue caused by an imcompatibility between sqlalchemy-utils
  and latest SQLAlchemy 1.4 (see more here
  kvesteri/sqlalchemy-utils#505).
diegodelemos pushed a commit to diegodelemos/reana-commons that referenced this issue Mar 17, 2021
installation: upgrade pytest-reana
05e71dd 
* pytest-reana 0.7.1 depends on the latest REANA-DB 0.7.3
  which fixes an installation problem caused by
  kvesteri/sqlalchemy-utils#505.
@sphuber sphuber mentioned this issue Mar 17, 2021
Closed
@aprilahijriyan aprilahijriyan mentioned this issue Mar 17, 2021
Closed
@waghmareomkar
Copy link 

[2021-03-15T18:09:18.021Z] ../../../miniconda/envs/jenkins-jca_multibranch-PR-52-1/lib/python3.8/site-packages/sqlalchemy_utils/functions/orm.py:14: in <module>

[2021-03-15T18:09:18.021Z]     from sqlalchemy.orm.query import _ColumnEntity

[2021-03-15T18:09:18.021Z] E   ImportError: cannot import name '_ColumnEntity' from 'sqlalchemy.orm.query' (/home/jcauser/miniconda/envs/jenkins-jca_multibranch-PR-52-1/lib/python3.8/site-packages/sqlalchemy/orm/query.py)

it worked for me when i installed using conda instead of pip. Hope it works for you aswell.

@mgrandi
Copy link

mgrandi commented Mar 18, 2021

you can temporarily fix this by changing the imports in sqlalchemy_utils\functions\orm.py:

from sqlalchemy.orm.query import _ColumnEntity

to

from sqlalchemy.orm.context import _ColumnEntity

@lnielsen lnielsen mentioned this issue Mar 19, 2021
Closed
@matthiaswh matthiaswh mentioned this issue Mar 22, 2021
Closed
@mrjoes mrjoes mentioned this issue Mar 22, 2021
Closed
mrunge added a commit to mrunge/gnocchi that referenced this issue Mar 24, 2021
@mrunge
Pin sqlalchemy < 1.4.0
625305d 
see kvesteri/sqlalchemy-utils#505
mrunge added a commit to mrunge/gnocchi that referenced this issue Mar 24, 2021
@mrunge
Pin sqlalchemy < 1.4.0
f01d5b5 
see kvesteri/sqlalchemy-utils#505
@smnorris smnorris mentioned this issue Mar 25, 2021
Closed
@dpgaspar dpgaspar mentioned this issue Mar 26, 2021
Closed
6 tasks
@namelivia
Copy link

It seems that #506 is being in the works to fix this

@Sinclert Sinclert mentioned this issue Apr 1, 2021
Merged
@OzzieIsaacs OzzieIsaacs mentioned this issue Apr 2, 2021
Closed
@mrjoes mrjoes mentioned this issue Apr 6, 2021
Closed
@uranusjr uranusjr mentioned this issue Apr 6, 2021
Closed
@tvuotila tvuotila linked a pull request Apr 7, 2021 that will close this issue
SQLAlchemy 1.4 support + Move CI to GitHub workflows #506
Merged
@WolfgangFahl
Copy link

see sqlalchemy/sqlalchemy#6226 and https://stackoverflow.com/a/66648061/1497139

tiborsimko added a commit to tiborsimko/opendata.cern.ch that referenced this issue Jun 28, 2021
@tiborsimko
installation: pin SQLAlchemy
532d22d 
Pins SQLAlchemy to solve incompatibility of later versions with
sqlalchemy-utils. See
kvesteri/sqlalchemy-utils#505

Pins Flask-SQLAlchemy due to related apply_driver_hacks issues.
tiborsimko added a commit to tiborsimko/opendata.cern.ch that referenced this issue Jun 28, 2021
@tiborsimko
installation: pin SQLAlchemy
3f9acc8 
Pins SQLAlchemy to solve incompatibility of later versions with
sqlalchemy-utils. See
kvesteri/sqlalchemy-utils#505

Pins Flask-SQLAlchemy due to related apply_driver_hacks issues.
@wssheldon wssheldon mentioned this issue Apr 5, 2023
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

SQLAlchemy 1.4 support + Move CI to GitHub workflows nsoranzo/sqlalchemy-utils
10 participants
@mgrandi @jbvsmo @WolfgangFahl @namelivia @bahamut45 @nsoranzo @NakulK48 @sphuber @aduggirala28 @waghmareomkar