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)
