.filter(db.Tournament.is_active == True, db.User.id ==
> '9e53da4b-f506-46b1-a3be-c091585d704c')
> .options(contains_eager("member_of").contains_eager("tournament")))
>
> Hope that helps,
>
> Simon
>
> On Tue, Sep 24, 2019 at 4:17 PM ko
I've created SQL query which excludes not active tournaments, but I still
have no idea how to get a similar result by ORM where the list of
user.member_of keeps only active tournament records...
select u.*, t.*
from "user" u
join playeroftournament pt on pt.user_id = u.id
join tournament t on
Hello everyone!
I can't resolve my issue by myself, I really have no idea how to filter
desired results, I've m2m relationships between User and Tournament models
via table PlayerOfTournament, sometime I need to get User model which will
include a list of all related tournaments except not
=specific_lesson_id).
outerjoin(sq, sq.c.user_id==some_user_id)
On Monday, August 12, 2019 at 10:17:00 PM UTC+3, kosta wrote:
>
> Hello everyone!
>
> I've some trouble to construct right query by ORM, can someone help to
> construct appropriate subquery.
>
> class Lesson(BaseMi
Hello everyone!
I've some trouble to construct right query by ORM, can someone help to
construct appropriate subquery.
class Lesson(BaseMixin, TimeCreatedMixin, TimeUpdateMixin, Base):
users = relationship('User', secondary='lessonlist')
title = Column(String(128))
content = Column(Text)
order
Hello Simon!
Thank you a lot, your solution was helping me out.
среда, 29 мая 2019 г., 14:38:28 UTC+3 пользователь Simon King написал:
>
> On Wed, May 29, 2019 at 11:46 AM kosta >
> wrote:
> >
> > Hi everyone!
> >
> > I can't solve my issu
Hi everyone!
I can't solve my issue by myself, could anyone has advice on this.
I've models (simplified):
class Tournament(Base):
id = Column(UUID(as_uuid=True), primary_key=True)
owner_id = Column(UUID(as_uuid=True), ForeignKey('user.id', ondelete='
CASCADE'), nullable=False)
owner =
by" in
> User model for emitting the similar query, but I'm getting an empty list.
>
> take a look at SQL being emitted with echo=True
>
>
> >
> >
> > On Mar 20, 2019, at 12:55 AM, Mike Bayer > wrote:
> >
> > On Tue, Mar 19, 2019 at
понедельник, 18 марта 2019 г., 17:48:26 UTC+3 пользователь Mike Bayer
написал:
>
> On Sat, Mar 16, 2019 at 9:33 AM kosta >
> wrote:
> >
> > Hello everyone!
> >
> > I've designed invitation model
> > class User(Base):
> > __tablename_
Hello everyone!
I've designed invitation model
class User(Base):
__tablename__ = 'user'
id = Column(Integer, primary_key=True)
name = Column(String(64))
email = Column(String(64))
class Invitation(Base):
__tablename__ = 'invitation'
id = Column(Integer, primary_key=True)
sender_id =
10 matches
Mail list logo