Comments (2)
I found a "cache lookup failed" related issue in sqlalchemy sqlalchemy/sqlalchemy#6645 . Maybe the 1 described behavior is not a GINO's bug. But I'm not sure about the 2 behavior.
from gino.
One more thing. I found that async sqlalchemy (with asyncpg driver) works as expected for me in 1 and 2 cases (full code in repo).
Dependencies:
asyncpg==0.25.0; python_full_version >= "3.6.0"
atomicwrites==1.4.0; python_version >= "3.7" and python_full_version < "3.0.0" and sys_platform == "win32" or sys_platform == "win32" and python_version >= "3.7" and python_full_version >= "3.4.0"
attrs==21.4.0; python_version >= "3.7" and python_full_version < "3.0.0" or python_full_version >= "3.5.0" and python_version >= "3.7"
click==8.1.3; python_version >= "3.7"
colorama==0.4.4; python_version >= "3.7" and python_full_version < "3.0.0" and sys_platform == "win32" and platform_system == "Windows" or sys_platform == "win32" and python_version >= "3.7" and python_full_version >= "3.5.0" and platform_system == "Windows"
greenlet==1.1.2; python_version >= "3" and python_full_version < "3.0.0" and (platform_machine == "aarch64" or platform_machine == "ppc64le" or platform_machine == "x86_64" or platform_machine == "amd64" or platform_machine == "AMD64" or platform_machine == "win32" or platform_machine == "WIN32") and (python_version >= "2.7" and python_full_version < "3.0.0" or python_full_version >= "3.6.0") or python_version >= "3" and (platform_machine == "aarch64" or platform_machine == "ppc64le" or platform_machine == "x86_64" or platform_machine == "amd64" or platform_machine == "AMD64" or platform_machine == "win32" or platform_machine == "WIN32") and (python_version >= "2.7" and python_full_version < "3.0.0" or python_full_version >= "3.6.0") and python_full_version >= "3.5.0"
iniconfig==1.1.1; python_version >= "3.7"
packaging==21.3; python_version >= "3.7"
pluggy==1.0.0; python_version >= "3.7"
py==1.11.0; python_version >= "3.7" and python_full_version < "3.0.0" or python_full_version >= "3.5.0" and python_version >= "3.7"
pyparsing==3.0.9; python_full_version >= "3.6.8" and python_version >= "3.7"
pytest-asyncio==0.18.3; python_version >= "3.7"
pytest==7.1.2; python_version >= "3.7"
sqlalchemy==1.4.36; (python_version >= "2.7" and python_full_version < "3.0.0") or (python_full_version >= "3.6.0")
tomli==2.0.1; python_version >= "3.7"
wait-for-it==2.2.1; python_version >= "3.7"
I see a newer version of sqlalchemy here: sqlalchemy==1.4.36
, so I tried to install this version, but the higher version of sqlalchemy is forbidden by gino constraint
$ poetry add "sqlalchemy^1.4.36"
Updating dependencies
Resolving dependencies... (0.3s)
SolverProblemError
Because gino (1.0.1) depends on SQLAlchemy (>=1.2.16,<1.4)
and no versions of gino match >1.0.1,<2.0.0, gino (>=1.0.1,<2.0.0) requires SQLAlchemy (>=1.2.16,<1.4).
So, because python-bug-reports depends on both gino (^1.0.1) and SQLAlchemy (^1.4.36), version solving failed.
I'm not 100% sure if sqlalchemy upgrade will solve the problem with enums, but I'd like to ask. What's the reason to deny a higher version of sqlalchemy?
P.S. I found the question on SO about 1 case (described in the first message). It looks like 1.4 sqlalchemy version upgrade won't totaly fix the problem. https://stackoverflow.com/questions/68000969/sqlalchemy-1-4-throws-internalservererror-cache-lookup-failed-for-type-3912040
UPD: found gino develop plans for future and integration with sqlalchemy here.
from gino.
Related Issues (20)
- Make a convenient way for GinoConnection to generate and execute DDLs HOT 1
- [Suggestion] Docs Translation HOT 1
- Reflect Via metadata failing HOT 2
- Pycharm IDE can not show some suggestions about Gino HOT 3
- I want to know how gino configures mysql HOT 1
- AttributeError: module 'sqlalchemy.sql.schema' has no attribute '_schema_getter' HOT 5
- Setting variables on connection HOT 3
- Add an easy way to do bulk update HOT 4
- Cannot install gino with fastapi HOT 2
- Many-to-many relation, adding property from association table
- SELECT ... FOR UPDATE SKIP LOCKED seems to not lock rows HOT 1
- Allow to pass hide_parameters into GinoEngine
- Following the tutorial 'Build a FastAPI Server' fails at the second step... HOT 1
- Gino 1.1b2 doesn't work on Python 3.10.2 and aiomysql
- TypeError while trying to initialize Gino db with MySQL
- DB initialisation with mangum
- Version bump of SQLAlchemy 1.4 HOT 4
- TypeError: expected str, got int
- Dependencies issue HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from gino.