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
performance issues on my queries with nested
вторник, 14 марта 2017 г., 17:15:25 UTC+3 пользователь Mike Bayer написал:
>
>
>
> On 03/14/2017 10:02 AM, Антонио Антуан wrote:
> > Hi.
> > I use sqlalchemy 1.0.17, thanks for you great library :)
> >
> > I have such code:
> > |
> >
> >
> > classFlagsMixin(object):
> >
On 03/14/2017 10:02 AM, Антонио Антуан wrote:
Hi.
I use sqlalchemy 1.0.17, thanks for you great library :)
I have such code:
|
classFlagsMixin(object):
@hybrid_method
defexist_flag(self,flag):
ifnotself.flags ornotflag:
returnFalse
returnself.flags
Hi.
I use sqlalchemy 1.0.17, thanks for you great library :)
I have such code:
class FlagsMixin(object):
@hybrid_method
def exist_flag(self, flag):
if not self.flags or not flag:
return False
return self.flags & flag == flag
@exist_flag.expression
Thanks very much for pointing to right direction. So all i had to do is
using *sqlalchemy.ext.mutable *to make the *ARRAY *type mutable. I did a
little example code works fine with *psycopg2* -
import sqlalchemy as sa
import sqlalchemy.event as event
import sqlalchemy.orm as orm
import