class Message(db.Model): __tablename__ = 'Message' id = db.Column(db.Integer, primary_key=True) # id(主键) course_name = db.Column(db.String(50), db.ForeignKey('Course.name')) # 消息对应的课程 title = db.Column(db.String(50)) # 消息的标题 info = db.Column(db.String(1000)) # 消息的内容
class User(db.Model, UserMixin): # 表名将会是 user(自动生成,小写处理) email = db.Column(db.String(50), primary_key=True) # 邮箱, 主键 password_hash = db.Column(db.String(128)) # 密码哈希 # confirmed = db.Column(db.Boolean, default=False) # def generate_confirmation_token(self, expiration=3600): # s = Serializer(app.config['SECRET_KEY'], expiration) # return s.dumps({'confirm': self.email}) # @staticmethod # def check_activate_token(self, token): # s = Serializer(app.config['SECRET_KEY']) # try: # data = s.loads(token) # 解码 # except Exception: # return False # user = User.query.get(email=data.get('confirm')) # if user is None: # return False # if not user.confirmed: # user.confirmed = True # db.session.add(user) # return True def set_password(self, password): self.password_hash = generate_password_hash(password) def validate_password(self, password): return check_password_hash(self.password_hash, password) def get_id(self): return self.email
class User(db.Model, UserMixin): __tablename__ = "user" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20)) username = db.Column(db.String(20)) password_hash = db.Column(db.String(128)) @property def is_authenticated(self): return True @property def is_active(self): return True @property def is_anonymous(self): return False def get_id(self): return str(self.id) # python 3 def __repr__(self): return '<User %r>' % self.nickname def set_password(self, password): self.password_hash = generate_password_hash(password) def validate_password(self, password): return check_password_hash(self.password_hash, password)
class Movie(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(60)) year = db.Column(db.String(4)) flower = db.Column(db.Integer, default=0) version = db.Column(db.Integer, default=0) teacherId = db.Column(db.Integer, default=0)
class User(db.Model, UserMixin): # 表名将会是 user(自动生成,小写处理) id = db.Column(db.Integer, primary_key=True) # 主键 name = db.Column(db.String(20)) username = db.Column(db.String(20)) # 用户名 password_hash = db.Column(db.String(300)) # 密码散列值 def set_password(self, password): # 用来设置密码的方法,接受密码作为参数 self.password_hash = generate_password_hash(password) # 将生成的密码保持到对应字段 def validate_password(self, password): # 用于验证密码的方法,接受密码作为参数 return check_password_hash(self.password_hash, password) # 返回布尔值 def set_name(self, name): self.name = name def set_username(self, username): self.username = username def valid_username(self, username): valid_length = 0 < len(username) and len(username) <= 20 ret = valid_length and username.isalnum() # 内置函数,判断字符串是否只含字母和数字 return ret def valid_password(self, password): valid_length = 0 < len(password) and len(password) <= 20 ret = valid_length and password.isalnum() # 判断字符串是否为字母和数字组合 return ret
class Movie(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(60)) year = db.Column(db.String(4)) def __repr__(self): return '<Movie {}>'.format(self.title)
class GPU(db.Model): __tablename__ = 'GPU' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) # gpu的名称 info = db.Column(db.String(1000)) # gpu是否空闲 course_name = db.Column(db.String(50), db.ForeignKey('Course.name')) # gpu对应的课程
class Articles(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(20)) # 博文名称 content = db.Column(db.String(50000)) # 博文内容 author = db.Column(db.String(20)) # 作者 pubdate = db.Column(db.DateTime, default=datetime.datetime.now) # 创建时间 updated = db.Column(db.DateTime, default=datetime.datetime.now, onupdate=datetime.datetime.now) # 更新时间 user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20)) username = db.Column(db.String(20)) # 用户名 password_hash = db.Column(db.String(128)) # 密码散列值 def set_password(self, password): # 用来设置密码的方法,接受密码作为参数 self.password_hash = generate_password_hash(password) # 将生成的密码保持到对应字段 def validate_password(self, password): # 用于验证密码的方法,接受密码作为参数 return check_password_hash(self.password_hash, password) # 返回布尔值
class Article(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(32)) content = db.Column(db.Text, nullable=False) tag = db.Column(db.String(64), nullable=True) create_time = db.Column(db.DateTime, nullable=True, default=datetime.now) def __repr__(self): return '<User %r>' % self.title
class Movie(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) year = db.Column(db.String(4)) def __repr__(self): return '<Movie(id={}, title={}, year={})>'.format( self.id, self.title, self.year )
class Usage(db.Model): __tablename__ = 'Usage' id = db.Column(db.Integer, primary_key=True) # id(主键) user_name = db.Column(db.String(50), db.ForeignKey('User.username')) # 用户名 course_name = db.Column(db.String(50), db.ForeignKey('Course.name')) # 进程对应的课程 gpu_name = db.Column(db.String(50), db.ForeignKey('GPU.name')) # gpu name submit_num = db.Column(db.Integer, default=0) # 总提交进程数 last_time = db.Column(db.DateTime, default=datetime.utcnow) # 最后一次提交进程的时间
class ScoreRecord(db.Model): def __init__(self, *record): if len(record) == 0: self.date = datetime.datetime.now().strftime('%Y-%m-%d') self.week = strftime("%a", localtime(time())) self.baby = 0 self.EarlyToBed = 0 self.Drink = 0 self.JL = 0 self.Eat = 0 self.WashRoom = 0 self.Coding = 0 self.LearnDaily = 0 self.Eng = 0 self.Efficiency = 0 self.HZ = 0 self.Score = 0 self.Comments = ' ' self.Review = 0 else: self.id = record[0][0] self.date = record[0][1] self.week = record[0][2] self.baby = record[0][3] self.EarlyToBed = record[0][4] self.Drink = record[0][5] self.JL = record[0][6] self.Eat = record[0][7] self.WashRoom = record[0][8] self.Coding = record[0][9] self.LearnDaily = record[0][10] self.Eng = record[0][11] self.Efficiency = record[0][12] self.HZ = record[0][13] self.Score = record[0][14] self.Comments = record[0][15] self.Review = record[0][16] id = db.Column(db.Integer, primary_key=True) date = db.Column(db.String(20)) week = db.Column(db.String(20)) baby = db.Column(db.Integer) EarlyToBed = db.Column(db.Integer) JL = db.Column(db.Integer) Drink = db.Column(db.Integer) Eat = db.Column(db.Integer) WashRoom = db.Column(db.Integer) Coding = db.Column(db.Integer) LearnDaily = db.Column(db.Integer) Eng = db.Column(db.Integer) Efficiency = db.Column(db.Integer) HZ = db.Column(db.Integer) Score = db.Column(db.Integer) Sports = db.Column(db.Integer) Comments = db.Column(db.Integer) Review = db.Column(db.Integer)
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20)) username = db.Column(db.String(20)) password_hash = db.Column(db.String(128)) def set_password(self, password): self.password_hash = generate_password_hash(password) def validate_password(self, password): return check_password_hash(self.password_hash, password)
class Process(db.Model): __tablename__ = 'Process' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) # 程序的名称 info = db.Column(db.String(300)) # 程序的信息 result = db.Column(db.String(1000)) # 程序的结果 code = db.Column(db.String(10000)) # 存储代码,方便以后编辑代码 gpu_name = db.Column(db.String(50), db.ForeignKey('GPU.name')) # 程序在哪个gpu上跑的
class Ariticles(db.Model): id = db.Column(db.Integer, primary_key=True) # 主键 title = db.Column(db.String(50)) #标题 content = db.Column(db.Text) #内容 author = db.Column(db.String(20)) #作者 pubdate = db.Column( db.String(30), index=True, default=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")) #发布时间
class Course(db.Model): __tablename__ = 'Course' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50)) teacher = db.Column(db.String(50)) time = db.Column(db.String(50)) info = db.Column(db.String(300)) message = db.Column(db.String(300)) istaken = db.Column(db.Boolean, default=False)
class User(db.Model, UserMixin): # 表名将会是 user(自动生成,小写处理) id = db.Column(db.Integer, primary_key=True) # 主键 name = db.Column(db.String(20)) # 名字 username = db.Column(db.String(20)) # 用户名 password_hash = db.Column(db.String(128)) # 密码散列值 def set_password(self, password): # 设置密码方法,接受密码作为参数 self.password_hash = generate_password_hash(password) # 将生成的密码保存到对应的字段 def validate_password(self, password): # 用于验证密码的方法,接受密码作为参数 return check_password_hash(self.password_hash, password) # 返回布尔值
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20)) password_hash = db.Column(db.String(128)) movies = db.relationship('Movie', backref='user') def set_password(self, password): self.password_hash = generate_password_hash(password) def validate_password(self, password): return check_password_hash(self.password_hash, password)
class User(db.Model, UserMixin): # 表名将会是 user(自动生成,小写处理) id = db.Column(db.Integer, primary_key=True) # 主键 name = db.Column(db.String(20)) # 名字 username = db.Column(db.String(20)) # 用户名 password_hash = db.Column(db.String(128)) # 密码散列值 def set_password(self, password): self.password_hash = generate_password_hash(password) def validate_password(self, password): return check_password_hash(self.password_hash, password)
class User(db.Model, UserMixin): # user模型,继承db.Model而来,表名为user(小写,自动生成) id = db.Column(db.Integer, primary_key=True) # 每一个字段要实例化db.Column,传入字段类型 name = db.Column(db.String(20)) user_name = db.Column(db.String(20)) # 用户名 password_hash = db.Column(db.String(128)) # 密码散列值 def set_password(self, password): self.password_hash = generate_password_hash(password) def validate_password(self, password): return check_password_hash(self.password_hash, password)
class User(db.Model, UserMixin): __tablename__ = "wl_user" # 数据库表名,未定义则默认是类名 id = db.Column(db.Integer, primary_key=True) # flask中主键必须显示定义,自增长类型 name = db.Column(db.String(20)) username = db.Column(db.String(20)) password_hash = db.Column(db.String(128)) def set_password(self, password): self.password_hash = generate_password_hash(password) def validate_password(self, password): return check_password_hash(self.password_hash, password)
class User(db.Model, UserMixin): """docstring for ClassName""" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20)) username = db.Column(db.String(20)) password_hash = db.Column(db.String(128)) # 密码散列 def set_password(self, password): # 设置密码方法,接收密码作为参数 self.password_hash = generate_password_hash(password) def validate_password(self, password): # 验证密码方法, 接收密码作为参数 return check_password_hash(self.password_hash, password) # 返回布尔值
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True, nullable=True) name = db.Column(db.String(20)) # 昵称 username = db.Column(db.String(20)) # 用户名 password_hash = db.Column(db.String(128)) # 密码散列值 articles = db.relationship("Articles", backref="user") # 连接博文信息表 def set_password(self, password): self.password_hash = generate_password_hash(password) def validate_password(self, password): return check_password_hash(self.password_hash, password)
class GPU(db.Model): __tablename__ = 'GPU' id = db.Column(db.Integer, primary_key=True) # id(主键) name = db.Column(db.String(30)) # gpu的名称 info = db.Column(db.String(1000)) # gpu是否空闲 # 配置和操作需要使用的参数 ip = db.Column(db.String(20)) # ip port = db.Column(db.Integer) # port username = db.Column(db.String(40)) # username password = db.Column(db.String(40)) # password
class User(db.Model, UserMixin): #模型类,数据库表的对象关系映射。 id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20)) username = db.Column(db.String(20)) password_hash = db.Column(db.String(128)) def set_password(self, password): self.password_hash = generate_password_hash( password) #将密码进行hash加密后保存变量 def validate_password(self, password) -> bool: return check_password_hash(self.password_hash, password) #返回bool值
class User(db.Model, UserMixin): # 表名将会是user(自动生成,小写处理) id = db.Column(db.Integer, primary_key=True) # 主键 name = db.Column(db.String(20)) # 名字 username = db.Column(db.String(20)) #用户名 password_hash = db.Column(db.String(128)) # 密码Hash值 def set_password(self, password): # 用来设置密码到方法,接受密码作为参数,将生成到密码保持到对应字段 self.password_hash = generate_password_hash(password) def validate_password(self, password): # 用于验证密码到方法,接受密码作为参数,返回布尔值 return check_password_hash(self.password_hash, password)
class User(db.Model, UserMixin): # 数据库表,表名为user id = db.Column(db.Integer, primary_key=True) # 主键,个人理解应该是序号 name = db.Column(db.String(20)) # 名字 username = db.Column(db.String(20)) # 用户名 password_hash = db.Column(db.String(128)) # 密码散列值 def set_password(self, password): """用来生成密码的散列值""" self.password_hash = generate_password_hash(password) def validate_password(self, password): """验证输入密码与散列值是否一致""" return check_password_hash(self.password_hash, password)
class User(db.Model, UserMixin): """表名自动生成,为user, id与name分别为主键名与列名""" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20)) username = db.Column(db.String(20)) # 用户名 password_hash = db.Column(db.String(128)) # 密码hash值 def set_password(self, password): """生成密码散列值,参数为密码""" self.password_hash = generate_password_hash(password) def validate_password(self, password): """验证密码, 密码为参数""" return check_password_hash(self.password_hash, password)
class Comment(db.Model): __tablename__ = "comment" id = db.Column(db.Integer, primary_key=True) comment_id = db.Column(db.String(255)) user_id = db.Column(db.String(255)) news_id = db.Column(db.String(255)) post_time = db.Column(db.String(255)) content = db.Column(db.String(10000)) like_count = db.Column(db.Integer) rank_a = db.Column(db.Integer, default=0) rank_b = db.Column(db.Integer, default=0) rank_c = db.Column(db.Integer, default=0) rank = db.Column(db.Integer, default=0)