quart-db
quart-db copied to clipboard
pgjones
Quart extension that provides managed connection(s) to postgresql database(s).
This may apply to any postgres functions. I am calling particular ones that return jsonb payloads. result = await g.connection.execute( query="SELECT * FROM public.my_function(:a, :b, :c)", values={"a":"foo", "b":"bar","c": 99} )...
Which are then forwarded into asyncpg connection which raises an error like: > quart.testing.app.LifespanError: Error during startup connect() got an unexpected keyword argument 'min_size' https://github.com/pgjones/quart-db/blob/abd22793a86b55b45ca8f2ba1be6f2eb3a2e77f9/src/quart_db/backends/asyncpg.py#L198
This is the other major postgresql DB engine in Python. As I've been seeing odd behaviour with asyncpg this will be quite helpful in tracking it down. At the time...
If there are multiple Quart workers for example
Apparently, the code does not accept an array of values ( https://github.com/pgjones/quart-db/blob/main/src/quart_db/backends/asyncpg.py ln 150 return render(query, **(values or {}))),whereas buildpg assume an array as an input https://github.com/samuelcolvin/buildpg/blob/master/tests/test_query.py lns. 55-74.
Hi, I need to access asyncpg's `fetchmany()` functionality. That is, a `fetchall()` but providing the method with a list of `ValueObject`s rather than just one. This is supported in the...
