class Course_Sign(db.Model):
__tablename__ = 'Course_Sign'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
SignId = db.Column(db.Integer, db.ForeignKey('Pos_SignData.SignId'))
CourseId = db.Column(db.Integer, db.ForeignKey('Course.CourseId'))
Studentid = db.Column(db.Integer, db.ForeignKey('Student.Studentid'))
longitude = db.Column(db.Numeric)
latitude = db.Column(db.Numeric)
SignTime = db.Column(db.String(255))
Status = db.Column(db.String(255))
def __init__(self, SignId, CourseId, Studentid, longitude, latitude,
Status):
self.SignId = SignId
self.CourseId = CourseId
self.Studentid = Studentid
self.longitude = longitude
self.latitude = latitude
self.Status = Status
def to_json(self):
json_data = {
'SignId': self.SignId,
'CourseId': self.CourseId,
'Studentid': self.Studentid,
'longitude': self.longitude,
'latitude': self.latitude,
'SignTime': self.SignTime,
'Status': self.Status,
}
return json.dumps(json_data)
class Course_Sign(db.Model):
__tablename__ = 'Course_Sign'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
SignId = db.Column(db.Integer, db.ForeignKey('SignData.SignId'))
CourseId = db.Column(db.Integer, db.ForeignKey('Course.CourseId'))
Studentid = db.Column(db.Integer, db.ForeignKey('STUDENT.Studentid'))
Place = db.Column(db.String(255))
SignData = db.Column(db.String(255))
Status = db.Column(db.String(255))
def __init__(self, SignId, CourseId, Studentid, Place, Status):
self.SignId = SignId
self.CourseId = CourseId
self.Studentid = Studentid
self.Place = Place
self.Status = Status
def to_json(self):
json_data = {
'SignId': self.SignId,
'CourseId': self.CourseId,
'Studentid': self.Studentid,
'Place': self.Place,
'SignData': self.SignData,
'Status': self.Status,
}
return json.dumps(json_data)
class Course_Student(db.Model):
__tablename__ = 'Course_Student'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
CourseId = db.Column(db.Integer, db.ForeignKey(Course.CourseId))
Studentid = db.Column(db.Integer, db.ForeignKey(STUDENT.Studentid))
def to_json(self):
json_data = {
'CourseId': self.CourseId,
'Studentid': self.Studentid,
}
return json.dumps(json_data)
class Secmanager(db.Model):
_tablename_ = "secmanager"
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
project_id = db.Column(db.Integer, db.ForeignKey('project.id'))
device_name = db.Column(db.String(20))
specification = db.Column(db.String(20))
number = db.Column(db.Integer)
project = db.relationship('Project')
def __init__(self, project_id, device_name, specification, number):
super(Secmanager, self).__init__()
self.project_id = project_id
self.device_name = device_name
self.specification = specification
self.number = number
def to_json(self):
json_data = {
'id': self.id,
'project_id': self.project_id,
'device_name': self.device_name,
'specification': self.specification,
'number': self.number,
'project': self.project.to_json()
}
return json_data
class CookieAuth(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.ForeignKey("user.username"))
cookie = db.Column(db.String(4096), nullable=False)
def __repr__(self):
return "<CookieAuth {}>".format(self.cookie)
class STUDENT(db.Model):
__tablename__ = 'Student'
Studentid = db.Column(db.Integer, primary_key=True, autoincrement=True)
Studentname = db.Column(db.String(255))
StudentNumber = db.Column(db.Integer, unique=True)
Major = db.Column(db.String(255))
Schooling = db.Column(db.String(255))
Userid = db.Column(db.Integer, db.ForeignKey('User.Userid'))
Class = db.Column(db.String(255))
def __init__(self, Studentname, StudentNumber, Major, Schooling, Userid,
Class):
self.Studentname = Studentname
self.StudentNumber = StudentNumber
self.Major = Major
self.Schooling = Schooling
self.Userid = Userid
self.Class = Class
def to_json(self):
json_data = {
'Studentid': self.Studentid,
'Studentname': self.Studentname,
'StudentNumber': self.StudentNumber,
'Major': self.Major,
'Schooling': self.Schooling,
'Userid': self.Userid,
'Class': self.Class,
}
return json.dumps(json_data)
class Pos_SignData(db.Model):
__tablename__ = 'Pos_SignData'
SignId = db.Column(db.Integer, primary_key=True, autoincrement=True)
CourseId = db.Column(db.Integer, db.ForeignKey('Course.CourseId'))
password = db.Column(db.Integer)
StartData = db.Column(db.DateTime)
longitude = db.Column(db.Numeric)
latitude = db.Column(db.Numeric)
def __init__(self, CourseId, password, StartData, longitude, latitude):
self.CourseId = CourseId
self.password = password
self.StartData = StartData
self.longitude = longitude
self.latitude = latitude
def to_json(self):
json_data = {
'SignId': self.SignId,
'CourseId': self.CourseId,
'password': self.password,
'StartData': self.StartData,
'longitude': self.longitude,
'latitude': self.latitude
}
return json.dumps(json_data)
class RoleRightRelation(db.Model):
__tablename__ = 'RoleMeaurelation'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
Roleid = db.Column(db.Integer, db.ForeignKey('Role.Roleid'))
Rightid = db.Column(db.Integer, db.ForeignKey('Right.Rightid'))
def __init__(self, Roleid, Rightid):
self.Roleid = Roleid
self.Rightid = Rightid
def to_json(self):
json_data = {
'Roleid': self.Roleid,
'Rightid': self.Rightid,
}
return json.dumps(json_data)
class Teacher(db.Model):
__tablename__ = 'Teacher'
TeachId = db.Column(db.Integer, primary_key=True, autoincrement=True)
TeachName = db.Column(db.String(255), unique=True)
TeachNumber = db.Column(db.Integer)
Userid = db.Column(db.Integer, db.ForeignKey('User.Userid'))
def __init__(self, TeachName, TeachNumber, Userid):
self.TeachName = TeachName
self.TeachNumber = TeachNumber
self.Userid = Userid
def to_json(self):
json_data = {
'TeachId': self.TeachId,
'TeachName': self.TeachName,
'TeachNumber': self.TeachNumber,
'Userid': self.Userid
}
return json.dumps(json_data)
def get_TeachName_TeachNumber(self):
return str(self.TeachName), str(self.TeachNumber)
def get_TeachId(self):
return int(self.TeachId)
class Post(db.Model):
id = db.Column(db.Integer, primary_key = True)
title = db.Column(db.String(100), nullable = False)
date_posted = db.Column(db.DateTime, nullable = False, default = datetime.utcnow)
content = db.Column(db.Text, nullable = False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable = False)
def __repr__(self):
return f"Post('{self.title}', '{self.date_posted}')"
class PersonalInfoTable(db.Model):
"""个人信息"""
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.ForeignKey("user.username"))
sex = db.Column(db.String(128), default="2")
age = db.Column(db.Integer, default=0)
height = db.Column(db.Integer, default=0)
wetght = db.Column(db.Integer, default=0)
def __repr__(self):
return "<personalInfo {}>".format(self.name)
class SignData(db.Model):
__tablename__ = 'SignData'
SignId = db.Column(db.Integer, primary_key=True, autoincrement=True)
CourseId = db.Column(db.Integer, db.ForeignKey('Course.CourseId'))
StartData = db.Column(db.DateTime)
def __init__(self, CourseId, StartData):
self.CourseId = CourseId
self.StartData = StartData
def to_json(self):
json_data = {
'SignId': self.SignId,
'CourseId': self.CourseId,
'StartData': self.StartData
}
return json.dumps(json_data)
class Right(db.Model):
__tablename__ = 'Right'
Rightid = db.Column(db.Integer, primary_key=True, autoincrement=True)
Rightname = db.Column(db.String(255))
Rightdescribe = db.Column(db.String(255))
Menuid = db.Column(db.String(255), db.ForeignKey(MENU.Menuid))
def __init__(self, Rightname, Rightdescribe, Menuid):
self.Rightname = Rightname
self.Rightdescribe = Rightdescribe
self.Menuid = Menuid
def to_json(self):
json_data = {
'Rightid': self.Rightid,
'Rightname': self.Rightname,
'Rightdescribe': self.Rightdescribe,
'Menuid': self.Menuid,
}
return json.dumps(json_data)
class DictionaryDetail(db.Model):
__tablename__ = 'DictionaryDetail'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
DictionaryID = db.Column(db.Integer, db.ForeignKey('Dictionary.id'))
ItemValue = db.Column(db.String(32), nullable=False)
position = db.Column(db.Integer, nullable=False)
isDefault = db.Column(db.Integer, nullable=False)
def __init__(self, DictionaryID, ItemValue, position, isDefault):
self.DictionaryID = DictionaryID
self.ItemValue = ItemValue
self.position = position
self.isDefault = isDefault
def to_json(self):
json_data = {
'id': self.id,
'DictionaryID': self.DictionaryID,
'ItemValue': self.ItemValue,
'position': self.position,
'isDefault': self.isDefault
}
return json.dumps(json_data)
class Course(db.Model):
__tablename__ = 'Course'
CourseId = db.Column(db.Integer, primary_key=True, autoincrement=True)
CourseName = db.Column(db.String(255), unique=True)
TeachId = db.Column(db.Integer, db.ForeignKey('Teacher.TeachId'))
CourseWeek = db.Column(db.String(255)) #课程学时
CourseDay = db.Column(db.String(255)) #课程周序
CourseTime = db.Column(db.String(255)) #课程节次
CoursePlace = db.Column(db.String(255)) #课程地点
Layout = db.Column(db.String(255)) #课程布局
def __init__(self, CourseName, TeachId, CourseWeek, CourseDay, CourseTime,
CoursePlace, Layout):
self.CourseName = CourseName
self.TeachId = TeachId
self.CourseWeek = CourseWeek
self.CourseDay = CourseDay
self.CourseTime = CourseTime
self.CoursePlace = CoursePlace
self.Layout = Layout
def to_json(self):
TeacherName, TeachNumber = Teacher.query.filter_by(
TeachId=self.TeachId).first().get_TeachName_TeachNumber()
json_data = {
'CourseId': self.CourseId,
'CourseName': self.CourseName,
'TeachNumber': TeachNumber,
'TeacherName': TeacherName,
'CourseWeek': self.CourseWeek,
'CourseDay': self.CourseDay,
'CourseTime': self.CourseTime,
'CoursePlace': self.CoursePlace,
'Layout': self.Layout
}
return json.dumps(json_data)