创建两个数据关联的表
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String
from sqlalchemy.orm import sessionmaker
engine = create_engine("mysql+pymysql://usrname:password@localhost/test",
encoding='utf-8')
Base = declarative_base(engine) # 生成orm基类
class Student(Base):
__tablename__ = 'student' # 表名
id = Column(Integer, primary_key=True)
name = Column(String(32),nullable= False)
register_date = Column(String(32), nullable= False)
def __repr__(self):
return "id:%s name:%s register_date:%s " %(self.id, self.name,self.register_date)
class StudyRecord(Base):
__tablename__ = 'study_record'
id = Column(Integer,primary_key=True)
day = Column(Integer, nullable= False)
status = Column(String(32),nullable= False)