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)