基于Python实现英语在线练习系统【优质毕业设计、课程设计项目】.zip

# coding:utf-8 import random from datetime import datetime from sqlalchemy import text,TIMESTAMP from api.models.models import Base_model from api.exts import db from sqlalchemy.dialects.mysql import DOUBLE,LONGTEXT # 个人信息 class xuesheng(Base_model): __doc__ = u'''xuesheng''' __tablename__ = 'xuesheng' __loginUser__='xuehao' __authTables__={'xuehao':'xuesheng',} __authPeople__='是' __authSeparate__='否' __thumbsUp__='否' __intelRecom__='否' __browseClick__='否' __foreEndListAuth__='否' __foreEndList__='否' __isAdmin__='否' id = db.Column(db.BigInteger, primary_key=True,autoincrement=False,comment='主键') addtime = db.Column(TIMESTAMP, server_default=text('CURRENT_TIMESTAMP'), server_onupdate=text('CURRENT_TIMESTAMP')) xuehao=db.Column( db.VARCHAR(255),nullable=False,unique=True,comment='学号' ) mima=db.Column( db.VARCHAR(255),nullable=False, unique=False,comment='密码' ) xueshengxingming=db.Column( db.VARCHAR(255),nullable=False, unique=False,comment='学生姓名' ) xingbie=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='性别' ) touxiang=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='头像' ) nianji=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='年级' ) banji=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='班级' ) lianxidianhua=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='联系电话' ) class jiaoshi(Base_model): __doc__ = u'''jiaoshi''' __tablename__ = 'jiaoshi' __loginUser__='gonghao' __authTables__={'gonghao':'jiaoshi',} __authPeople__='是' __authSeparate__='否' __thumbsUp__='否' __intelRecom__='否' __browseClick__='否' __foreEndListAuth__='否' __foreEndList__='是' __isAdmin__='否' id = db.Column(db.BigInteger, primary_key=True,autoincrement=False,comment='主键') addtime = db.Column(TIMESTAMP, server_default=text('CURRENT_TIMESTAMP'), server_onupdate=text('CURRENT_TIMESTAMP')) gonghao=db.Column( db.VARCHAR(255),nullable=False,unique=True,comment='工号' ) mima=db.Column( db.VARCHAR(255),nullable=False, unique=False,comment='密码' ) jiaoshixingming=db.Column( db.VARCHAR(255),nullable=False, unique=False,comment='教师姓名' ) xingbie=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='性别' ) touxiang=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='头像' ) zhicheng=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='职称' ) weixin=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='微信' ) shouji=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='手机' ) class xueshengzuoye(Base_model): __doc__ = u'''xueshengzuoye''' __tablename__ = 'xueshengzuoye' __authTables__={'gonghao':'jiaoshi',} __authPeople__='否' __authSeparate__='否' __thumbsUp__='否' __intelRecom__='否' __browseClick__='否' __foreEndListAuth__='否' __foreEndList__='是' __isAdmin__='否' id = db.Column(db.BigInteger, primary_key=True,autoincrement=False,comment='主键') addtime = db.Column(TIMESTAMP, server_default=text('CURRENT_TIMESTAMP'), server_onupdate=text('CURRENT_TIMESTAMP')) zuoyebianhao=db.Column( db.VARCHAR(255), nullable=True,unique=True,comment='作业编号' ) zuoyemingcheng=db.Column( db.VARCHAR(255),nullable=False, unique=False,comment='作业名称' ) leibie=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='类别' ) tupian=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='图片' ) zuoyeyaoqiu=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='作业要求' ) zuoyeneirong=db.Column( db.Text, nullable=True, unique=False,comment='作业内容' ) fujian=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='附件' ) beizhu=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='备注' ) fabushijian=db.Column( db.Date, nullable=True, unique=False,comment='发布时间' ) gonghao=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='工号' ) jiaoshixingming=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='教师姓名' ) class zuoyedati(Base_model): __doc__ = u'''zuoyedati''' __tablename__ = 'zuoyedati' __authTables__={'xuehao':'xuesheng',} __authPeople__='否' __authSeparate__='否' __thumbsUp__='否' __intelRecom__='否' __browseClick__='否' __foreEndListAuth__='否' __foreEndList__='否' __isAdmin__='否' id = db.Column(db.BigInteger, primary_key=True,autoincrement=False,comment='主键') addtime = db.Column(TIMESTAMP, server_default=text('CURRENT_TIMESTAMP'), server_onupdate=text('CURRENT_TIMESTAMP')) zuoyebianhao=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='作业编号' ) zuoyemingcheng=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='作业名称' ) tupian=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='图片' ) zuoyeyaoqiu=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='作业要求' ) datineirong=db.Column( db.Text, nullable=True, unique=False,comment='答题内容' ) datifujian=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='答题附件' ) tijiaoshijian=db.Column( db.Date, nullable=True, unique=False,comment='提交时间' ) xuehao=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='学号' ) xueshengxingming=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='学生姓名' ) nianji=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='年级' ) banji=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='班级' ) sfsh=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='是否审核' ) shhf=db.Column( db.Text, nullable=True, unique=False,comment='审核回复' ) class kewaituozhan(Base_model): __doc__ = u'''kewaituozhan''' __tablename__ = 'kewaituozhan' __authTables__={} __authPeople__='否' __authSeparate__='否' __thumbsUp__='否' __intelRecom__='否' __browseClick__='否' __foreEndListAuth__='否' __foreEndList__='是' __isAdmin__='否' id = db.Column(db.BigInteger, primary_key=True,autoincrement=False,comment='主键') addtime = db.Column(TIMESTAMP, server_default=text('CURRENT_TIMESTAMP'), server_onupdate=text('CURRENT_TIMESTAMP')) mingcheng=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='名称' ) leixing=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='类型' ) tupian=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='图片' ) neirongxiangqing=db.Column( db.Text, nullable=True, unique=False,comment='内容详情' ) faburiqi=db.Column( db.Date, nullable=True, unique=False,comment='发布日期' ) class mingshifudao(Base_model): __doc__ = u'''mingshifudao''' __tablename__ = 'mingshifudao' __authTables__={} __authPeople__='否' __authSeparate__='否' __thumbsUp__='否' __intelRecom__='否' __browseClick__='否' __foreEndListAuth__='否' __foreEndList__='是' __isAdmin__='否' id = db.Column(db.BigInteger, primary_key=True,autoincrement=False,comment='主键') addtime = db.Column(TIMESTAMP, server_default=text('CURRENT_TIMESTAMP'), server_onupdate=text('CURRENT_TIMESTAMP')) biaotimingcheng=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='标题名称' ) leixing=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='类型' ) fengmian=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='封面' ) shipinneirong=db.Column( db.VARCHAR(255), nullable=True, unique=False,comment='视频内�