Python中sqlalchemy中ForeignKey的使用

2019-07-22

  • 例子：
  • 导入 from sqlalchemy import ForeignKey
class Company(Base):

   __tablename__ = 'company'

   name = Column(String(20), primary_key=True,autoincrement=True)
   location = Column(String(20))

   def __repr__(self):
       return "name:{0} location:{1}".format(self.name,self.location)


class Phone(Base):

   __tablename__ = 'phone'

   id = Column(Integer,primary_key=True,autoincrement=True)
   model = Column(String(32))
   price = Column(String(32))
   company_name = Column(String(32),ForeignKey("company.name"))
 
   def __repr__(self):
        return "{0} model:{1},sales:{2}  price:{3}".format(self.id,self.model,self.company_name,self.price)

评论