16 lines
874 B
Python
16 lines
874 B
Python
# 与数据库的表进行关联
|
|
# 导入database文件,这里已经创建基类
|
|
from sqlalchemy import Column, Integer, ForeignKey, String
|
|
from sqlalchemy.orm import relationship
|
|
from sqlalchemy_fastapi_demo_1.database import Base
|
|
# 关联数据库中的teacher表
|
|
class Teacher(Base):
|
|
__tablename__ = 'teacher'
|
|
teacher_id = Column(Integer, primary_key=True)
|
|
class_id = Column(Integer,ForeignKey('c_lass.class_id'),nullable=False)
|
|
teacher_name = Column(String(50),nullable=False)
|
|
job_name=Column(String(50),nullable=False,comment='主讲、班主任、助教')
|
|
is_deleted = Column(Integer, default=0, nullable=False)
|
|
classes=relationship("Classinfo",back_populates="teachers")
|
|
def __repr__(self):
|
|
return f"<Teacher(teacher_id={self.teacher_id},class_id={self.class_id},teacher_name='{self.teacher_name}',job_name='{self.job_name}')>" |