# 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='视频内�