class Book_Urls(BaseModel):
__tablename__ = 'book_urls'
id = Column(Integer, primary_key=True)
url = Column(String(50), unique=True)
book_id = Column(Integer, ForeignKey('book.id'))
def __repr__(self):
return "<Book_Urls(url='%s')>" % (self.url)
class Book(BaseModel):
__tablename__ = 'book'
id = Column(Integer, primary_key=True)
name = Column(String(30), unique=True)
author = Column(String(30), unique=True)
category = Column(String(30), default='')
urls = relationship("Book_Urls", backref="book")
introduction = Column(String(80), default='')
chapter_id = Column(Integer, ForeignKey('chapter.id'))
def __repr__(self):
return "<Book(name='%s', category='%s', author='%s')>" % (self.name, self.category, self.author)
在“多”的一方添加:
book_id = Column(Integer, ForeignKey('book.id'))
book.id中的book 似乎是 ”一“的一方的__tablename__ = 'book'
然后是在”一“的一方添加:
urls = relationship("Book_Urls", backref="book")
backref="book" 中的 book 指可以这样使用,同样意味着,在”多“的一方,可以这样获得”一“的一方:
book = Book_Urls().book
而在”一“的一方,可以这样获得多的一方:
urls = Book().urls