Re: [sqlalchemy] struggling with postgres json related query using sqlalchemy -- sqlalchemy bug or issue with query?

2017-03-15 Thread Lukas Siemon
Monkey patching seems to do the trick: # Patch alias self_group kwargs def patched_alias_self_group(self, target=None, **kwargs): return original_alias_self_group(self, target=target) original_alias_self_group = Alias.self_group Alias.self_group = patched_alias_self_group On Wednesday, 15

Re: [sqlalchemy] struggling with postgres json related query using sqlalchemy -- sqlalchemy bug or issue with query?

2017-03-15 Thread Lukas Siemon
Was the underlying issue ever resolved? Running into the same error here, but my query generation is automatic, so taking it apart will take a little longer... On Thursday, 17 November 2016 07:57:56 UTC-8, Mike Bayer wrote: > > Hi Darin - > > That's definitely a bug because all self_group()

Re: [sqlalchemy] Error while using return_defaults with insert

2017-03-15 Thread mike bayer
that's not SQLAlchemy, you're using this: https://github.com/aio-libs/aiopg/blob/master/aiopg/sa/result.py#L205 On 03/15/2017 04:13 AM, Christian Barra wrote: Hello, I am trying to fetch the result of a query after an insert. SQLAlchemy 1.16 and PostgreSQL 9.6 This is the code:

Re: [sqlalchemy] IN() Relationship Eager Loading Strategy

2017-03-15 Thread mike bayer
On 03/15/2017 01:12 AM, Paul Brown wrote: tl;dr: I'm looking for an elegant way to eager load related rows using separate IN() queries, because MySQL is "Using temporary; Using filesort" when I try subquery eager loading. My first attempt used joined eager loading, but that was causing

[sqlalchemy] Error while using return_defaults with insert

2017-03-15 Thread Christian Barra
Hello, I am trying to fetch the result of a query after an insert. SQLAlchemy 1.16 and PostgreSQL 9.6 This is the code: engine = self.request.app['db'] async with engine.acquire() as conn: query = models.User.insert().values(email=email, first_name= first_name,