Installing SQLAlchemy with Poetry causes an AttributeErrorr

Question

When installing with pip, pip install sqlalchemy all is ok.

When installing with poetry I am getting the error

➜  backend poetry add sqlalchemy
Using version ^1.4.23 for SQLAlchemy

Updating dependencies
Resolving dependencies... (0.1s)

  AttributeError

  'EmptyConstraint' object has no attribute 'allows'

  at ~/.poetry/lib/poetry/_vendor/py3.8/poetry/core/version/markers.py:291 in validate
      287│
      288│         if self._name not in environment:
      289│             return True
      290│
    → 291│         return self._constraint.allows(self._parser(environment[self._name]))
      292│
      293│     def without_extras(self):  # type: () -> MarkerTypes
      294│         return self.exclude("extra")
      295│
➜  backend

This looks like it is a solved bug. Maybe stackoverflow is not the best place for it though? — AntonOfTheWoods, Aug 24 '21 at 08:37

score 12 · Accepted Answer · answered Aug 22 '21 at 13:34

12

Try poetry self update, then poetry update.

answered Aug 22 '21 at 13:34

fl_

152
6

score 2 · Answer 2 · answered Aug 19 '21 at 18:55

2

If you use

poetry add sqlalchemy=1.4.22

This will solve your problem

answered Aug 19 '21 at 18:55

Ntjs95

128
1
8

This works but it is a stub. The same thing is with `alembic`. – Andrew Lubochkn Aug 20 '21 at 12:18
It seems like something sql alchemy introduced in their newest release. I assume constraining alembic would also be a temporary fix. – Ntjs95 Aug 20 '21 at 16:26

Evgeny · Answer 3 · 2021-08-19T18:12:41.660

1

Try upgrading poetry itself: pip install -U poetry. Worked for me to resolve SQLAlchemy issue.

edited Aug 19 '21 at 18:12

answered Aug 19 '21 at 18:04

Evgeny

4,173
2
19
39

score 0 · Answer 4 · answered Aug 23 '21 at 19:59

I tried fl_'s answer but poetry self update itself failed for me with an error saying:

ModuleNotFoundError: No module named 'poetry.console'

From a stackoverflow answer to a different question I learned that I had poetry installed using the older, now deprecated, get-poetry.py.

So I uninstalled poetry like so:

curl https://raw.githubusercontent.com/python-poetry/poetry/master/get-poetry.py > get-poetry

python get-poetry --uninstall

Then reinstalled it with the newer install-poetry.py as per official installation instructions.

This finally made the original AttributeError go away.

score 0 · Answer 5 · answered Aug 24 '21 at 05:18

0

Same here, it seems to be a very recent problem. The good news is that "poetry self update" fixes the issue

answered Aug 24 '21 at 05:18

ak-empiak

41
1

score 0 · Answer 6 · answered Sep 22 '21 at 10:40

0

Upgrading poetry to 1.1.8 may solve the issue.

e.g. use poetry self update (related docs)

Check related poetry issue too:

https://github.com/python-poetry/poetry/issues/4410#issuecomment-902144234

answered Sep 22 '21 at 10:40

zerocewl

11,401
6
27
53

Installing SQLAlchemy with Poetry causes an AttributeErrorr

6 Answers6