Python3-sqlalchemy-orm 创建关联表带外键并插入数据

#-*-coding:utf-8-*-
#__author__ = "logan.xu"

import sqlalchemy
from sqlalchemy import create_engine,func
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column,Integer,String,ForeignKey,DATE
from sqlalchemy.orm import sessionmaker,relationship


engine=create_engine("mysql+pymysql://root:12345678@localhost/news",encoding='utf-8',echo=True)
Base=declarative_base()

class Student(Base):
    __tablename__='student'
    id=Column(Integer,primary_key=True)
    name=Column(String(32),nullable=False)
    register_date=Column(DATE,nullable=False)

    def __repr__(self):
        return "<%s name:%s>" % (self.id,self.name)

class StudyRecord(Base):
     __tablename__ = 'study_record'
     id = Column(Integer, primary_key=True)
     day = Column(Integer,nullable=False)
     status = Column(String(32),nullable=False)
     stu_id = Column(Integer,ForeignKey("student.id"))

     def __repr__(self):
        return "<%s name:%s>" % (self.id,self.day)

#---------------1.创建表-----------------#

Base.metadata.create_all(engine)
#---------------------------------------#

Session_class = sessionmaker(bind=engine)
Session = Session_class()

#---------------2.写入数据-----------------#

s1=Student(name='Alex',register_date="2019-01-09")
s2=Student(name='Jack',register_date="2019-01-09")
s3=Student(name='Rain',register_date="