Python inverse_relationship示例

示例#1

文件： entities.py 项目： dodycs/TVShowProject

class Like(Base):
    __tablename__ = 'tvshow_like'
    id = Column(Integer, primary_key=True)

    user_id = Column(Integer, ForeignKey('user.id'))
    user = relationship(User, backref=inverse_relationship('likes'))

    tvshow_id = Column(Integer, ForeignKey('tvshow.id'))
    tvshow = relationship(TVShow, backref=inverse_relationship('like_by'))

示例#2

文件： models.py 项目： sudiarth/LoginAndRegistration

class Like(Base):
    __tablename__ = 'likes'
    id = Column(Integer, primary_key=True)

    user_id = Column(Integer, ForeignKey('users.id'))
    user = relationship(User, backref=inverse_relationship('users'))

    movie_id = Column(Integer, ForeignKey('movies.id'))
    movie = relationship(Movie, backref=inverse_relationship('movies'))

    created_at = Column(DateTime, default=func.now())
    updated_at = Column(DateTime, default=func.now(), onupdate=func.now())

示例#3

class Like(Base):
    __tablename__ = 'likes'
    id = Column(Integer, primary_key=True)

    user_id = Column(Integer, ForeignKey('users.id'))
    user = relationship(User, backref=inverse_relationship('likes_shows'))

    show_id = Column(Integer, ForeignKey('shows.id'))
    show = relationship(Show, backref=inverse_relationship('has_followers'))

    uid_to_sid = Column(String, unique=True)

    created_at = Column(DateTime, default=func.now())
    updated_at = Column(DateTime, default=func.now(), onupdate=func.now())

示例#4

文件： models.py 项目： dodycs/coderemote-lilquote

class Quote(Base):
   __tablename__ = 'quote'

   id = Column(Integer, primary_key=True)
   content = Column(String)

   user_id = Column(Integer, ForeignKey('user.id'))
   user = relationship(User, backref = inverse_relationship('quotes'))

示例#5

文件： models.py 项目： wahyupratamaputra/Python_Flask_TvMazeAPI

class Like(Base):
    __tablename__ = 'likes'
    id = Column(Integer, primary_key=True)
    user_id = Column(Integer)

    film_id = Column(Integer, ForeignKey('films.id'))
    film = relationship(Film, backref=inverse_relationship('films'))
    
    created_at = Column(DateTime, default=func.now())
    updated_at = Column(DateTime, default=func.now(), onupdate=func.now())

示例#6

class Quote(Base):
    __tablename__ = 'quotes'

    id = Column(Integer, primary_key=True)
    content = Column(String, nullable=False)

    user_id = Column(Integer, ForeignKey('users.id'))
    user = relationship(User, backref=inverse_relationship('users'))

    created_at = Column(DateTime, default=func.now())
    updated_at = Column(DateTime, default=func.now(), onupdate=func.now())