Polars read_database with an existing async session object about polars HOT 5 CLOSED

theres this #15162 PR but even if i use the engine it still doesnt work

from polars.

o right.. need to install nest_asyncio first

pdm add nest_asyncio then engine works but you still cant pass a session to it?

from polars.

I'll try and repro this at home and take a look, as I believe this should indeed work (pretty sure I tested with AsyncSession, but seems I missed something, hmm) - thanks for the sample code ;)

from polars.

if this works for you im gonna go slit my wrists with a piece of paper. cheers for all the work you put into it already

from polars.

if this works for you im gonna go slit my wrists with a piece of paper. cheers for all the work you put into it already

Got a fix incoming: "don't go towards the light..." ;)

Also, it turns out that there are actually two issues here - one is a bug (for which I'm about to land a fix), but the other is an enhancement. We currently don't support automatically unpacking SQLAlchemy ORM models (eg: the CountriesTable base object) into their component columns. I think we should do this, but currently we don't - however, that's separate from the bug so I'll address it in a follow-up.

Once the fix lands you can work around that by passing the compiled query to read_database instead of the Selectable. Something like this should work: pl.read_database(str(stmt.compile()), conn).

from polars.