Re: [sqlalchemy] self relationship via intermediate table

Sure, thanks! пятница, 22 марта 2019 г., 19:39:06 UTC+3 пользователь Mike Bayer написал: > > On Fri, Mar 22, 2019 at 10:53 AM Konstantin Naumov > wrote: > > > > Great, thank you! > > > > I thought that I can use a field of relationship() - “invited_by" in > User model for emitting the simi

Re: [sqlalchemy] self relationship via intermediate table

On Fri, Mar 22, 2019 at 10:53 AM Konstantin Naumov wrote: > > Great, thank you! > > I thought that I can use a field of relationship() - “invited_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,

Re: [sqlalchemy] self relationship via intermediate table

Great, thank you! I thought that I can use a field of relationship() - “invited_by" in User model for emitting the similar query, but I'm getting an empty list. > On Mar 20, 2019, at 12:55 AM, Mike Bayer wrote: > > On Tue, Mar 19, 2019 at 10:23 AM kosta > wrote: >>

Re: [sqlalchemy] self relationship via intermediate table

On Tue, Mar 19, 2019 at 10:23 AM kosta wrote: > > Hello Mike, > Thank you for your response! > > > First of all, I'm apologize, I have lack knowledge in sql. I guess my SQL > should be as: > Get all users invited by specific user: > > SELECT u.name AS "sender", i.name AS "invitee" > FROM invitati

Re: [sqlalchemy] self relationship via intermediate table

Hello Mike, Thank you for your response! First of all, I'm apologize, I have lack knowledge in sql. I guess my SQL should be as: Get all users invited by specific user: SELECT u.name AS "sender", i.name AS "invitee" FROM invitation inv LEFT JOIN user u ON inv.sender_id=u.id LEFT JOIN user i ON

Re: [sqlalchemy] self relationship via intermediate table

On Sat, Mar 16, 2019 at 9:33 AM kosta wrote: > > 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__ = 'invitati

[sqlalchemy] self relationship via intermediate table

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 = Column(Integ