class Location(db.Model):
id = db.Column(db.Integer, primary_key=True)
location_name = db.Column(db.String(100), nullable=False, unique=True)
qty = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f"Location('{self.location_name}')"
class users(db.Model):
#defining the User table to have three columns; user id, username and password
user_id = db.Column(db.Integer,
db.Sequence('user_id_seq'),
primary_key=True)
username = db.Column(db.String(50), nullable=False)
password = db.Column(db.String(50), nullable=False)
def __init__(self, username, password):
self.user_id = user_id
self.username = username
self.password = password
self.is_anonymous = False
def is_authenticated(self):
return True
def is_anonymous(self):
return False
def is_active(self):
return True
def get_id(self):
return self.user_id
@classmethod
def get(cls, id):
return users.query.filter_by(user_id=id).first()
@classmethod
def get_by_username(cls, username):
return users.query.filter_by(username=username).first()
class Department(db.Model):
__tablename__ = 'departments'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text, nullable=False)
def __init__(self, name):
self.name = name
class Role(db.Model):
__tablename__ = 'roles'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), unique=True)
def __repr__(self):
return '<Role %r>' % self.name
class Instructor_files(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_file = db.Column(db.String(100),
nullable=False,
default='default.pdf')
def __repr__(self):
return f"'{self.user_file}'"
class Comment(db.Model):
comment_id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.Text, nullable=False)
timestamp = db.Column(db.DateTime, nullable=False)
def __init__(self, text, timestamp):
self.text = text
self.timestamp = timestamp
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), unique=True, index=True)
role_id = db.Column(db.Integer, db.ForeignKey('roles.id'))
def __repr__(self):
return '<User %r>' % self.username
class Product(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False, unique=True)
date_posted = db.Column(db.DateTime, nullable=False, default=datetime.now)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"Product('{self.title}', '{self.date_posted}')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
body = db.Column(db.String(140))
timestamp = db.Column(db.DateTime, index=True, default=datetime.now)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
def __repr__(self):
return '<Post {}>'.format(self.body)
class Employee(db.Model):
__tablename__ = 'employees'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text, nullable=False)
department_id = db.Column(db.Integer, db.ForeignKey('departments.id'))
def __init__(self, name):
self.name = name
class Role(db.Model):
__tablename__ = 'roles'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), unique=True)
users = db.relationship('User', backref='role', lazy='dynamic')
def __repr__(self):
return '<Role %r' % self.name
class User_instructor(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(20), nullable=False)
last_name = db.Column(db.String(20), nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
def __repr__(self):
return f"User('{self.first_name}', '{self.last_name}', '{self.email}')"
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
products = db.relationship('Product', backref='author', lazy=True)
def __repr__(self):
return f"User('{self.username}', '{self.email}', '{self.image_file}')"
class Couses(db.Model):
__tablename__ = 't_courses'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(255))
abstract = db.Column(db.String(255))
addtime = db.Column(db.DateTime)
k_id = db.Column(db.Integer, db.ForeignKey('t_kinds.id'))
# cascade='delete' 一对多关系中，父表数据删除，字表也跟着删除
videos = relationship('Videos', backref='courses', cascade='delete')
class User(db.Model): # backend for user module
id = db.Column(db.Integer, primary_key = True)
username = db.Column(db.String(20), nullable = False)
email = db.Column(db.String(100), unique = True, nullable = False)
password = db.Column(db.String(100), nullable = False)
posts = db.relationship('Post',backref='author', lazy = True)
def __repr__(self):
return f"User('{self.username}','{self.email}')"
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 Post(db.Model): # backend for post module
id = db.Column(db.Integer, primary_key = True)
title = db.Column(db.String(20), nullable = False)
time = db.Column(db.DateTime, default = datetime.utcnow(), nullable = False)
content = db.Column(db.String(200), nullable = False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable = False)
def __repr__(self):
return f"Post('{self.title}','{self.time}')"
class UserProfile(db.Model):
#defining the UserProfile table to have two columns; comment id and a json string
is_anonymous = False
comment_id = db.Column(db.Integer, db.Sequence('id_seq'), primary_key=True)
doc = db.Column(db.Text, nullable=True)
__table_args__ = (CheckConstraint('DOC IS JSON', name='ensure_json'), {})
def __init__(self, text):
self.doc = text
@classmethod
def get(cls, id):
return UserProfile.query.filter_by(comment_id=id).first()
class ModelWeights(db.Model):
__tablename__ = 'model_weights'
id = db.Column(db.Integer, primary_key=True)
participant_id = db.Column(db.Integer)
feedback_round = db.Column(db.Integer)
category = db.Column(db.String())
weights = db.Column(JSON)
def __repr__(self):
return '<id:{} part_id:{} fid:{} category:{} weights:{}>'.format(
self.id, self.participant_id, self.feedback_round, self.category,
self.weights)
class Superhero(db.Model):
__bind_key__ = 'two'
__tablename__ = 'superhero'
id = db.Column('superhero_id', db.Integer, primary_key = True)
name = db.Column(db.String(100))
power = db.Column(db.String(100))
level = db.Column(db.Integer)
def __init__(self, name, power, level):
self.name = name
self.power = power
self.level = level
def __repr__(self):
return '<id> {}'.format(self.id)
class BlogPost(db.Model):
__tablename__ = "posts"
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String, nullable=False)
description = db.Column(db.String, nullable=False)
author_id = db.Column(db.Integer, ForeignKey('users.id'))
def __init__(self, title, description):
self.title = title
self.description = description
def __repr__(self):
return '<{}>'.format(self.title)
class Person(db.Model):
__tablename__ = "person"
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(80))
last_name = db.Column(db.String(80))
age = db.Column(db.Integer)
def __init__(self, first_name, last_name, age):
self.first_name = first_name
self.last_name = last_name
self.age = age
def __repr__(self):
return '<Person %r>' % (self.first_name + self.last_name)
class Company(db.Model):
__bind_key__ = 'three'
__tablename__ = 'company'
id = db.Column('company_id', db.Integer, primary_key = True)
name = db.Column(db.String(100))
owner = db.Column(db.String(100))
year = db.Column(db.Integer)
revenue = db.Column(db.Integer)
def __init__(self, name, owner, year, revenue):
self.name = name
self.owner = owner
self.year = year
self.revenue = revenue
def __repr__(self):
return '<id> {}'.format(self.id)
class User(db.Model):
__tablename__ = "users"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String, nullable=False)
email = db.Column(db.String, nullable=False)
password = db.Column(db.String, nullable=False)
posts = relationship("BlogPost", backref="author")
def __init__(self, name, email, password):
self.name = name
self.email = email
self.password = bcrypt.generate_password_hash(password)
def __repr__(self):
return '<name {}'.format(self.name)
class Videos(db.Model):
__tablename__ = 't_videos'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(255))
time = db.Column(db.Integer)
hits = db.Column(db.Integer)
addtime = db.Column(db.DateTime)
abstract = db.Column(db.String(255))
t_id = db.Column(db.Integer)
c_id = db.Column(db.Integer, db.ForeignKey('t_courses.id'))
class User(UserMixin, db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(64), unique=True, index=True)
username = db.Column(db.String(64), unique=True, index=True)
role_id = db.Column(db.Integer, db.ForeignKey('roles.id'))
password_hash = db.Column(db.String(128))
@property
def password(self):
raise AttributeError('password is not a readable attribute')
@password.setter
def password(self, password):
self.password_hash = generate_password_hash(password)
def verify_password(self, password):
return check_password_hash(self.password_hash, password)
def __repr__(self):
return '<User %r>' % self.username
class Message(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20))
body = db.Column(db.String(200))
age = db.Column(db.Integer)
score = db.Column(db.Integer)
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
class ProductMovement(db.Model):
id = db.Column(db.Integer, primary_key=True)
ts = db.Column(db.DateTime, nullable=False, default=datetime.now)
from_location = db.Column(db.String(100))
to_location = db.Column(db.String(100))
pid = db.Column(db.Integer, nullable=False)
qty = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f"ProductMovement('{self.from_location}', '{self.to_location}', '{self.pid}', '{self.qty}')"
class User(UserMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), index=True, unique=True)
email = db.Column(db.String(120), index=True, unique=True)
password_hash = db.Column(db.String(128))
posts = db.relationship('Post', backref='author', lazy='dynamic')
about_me = db.Column(db.String(140))
last_seen = db.Column(db.DateTime, default=datetime.now)
followed = db.relationship('User',
secondary='followers',
primaryjoin=(followers.c.follower_id == id),
secondaryjoin=(followers.c.followed_id == id),
backref=db.backref('followers', lazy='dynamic'),
lazy='dynamic')
def set_password(self, password):
self.password_hash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password_hash, password)
def avatar(self, size):
digest = md5(self.email.lower().encode('utf-8')).hexdigest()
return 'https://www.gravatar.com/avatar/{}?d=identicon&s={}'.format(
digest, size)
def follow(self, user):
if not self.is_following(user):
self.followed.append(user)
def unfollow(self, user):
if self.is_following(user):
self.followed.remove(user)
def is_following(self, user):
return self.followed.filter(
followers.c.followed_id == user.id).count() > 0
def followed_posts(self):
followed = Post.query.join(
followers, (followers.c.followed_id == Post.user_id)).filter(
followers.c.follower_id == self.id)
own = Post.query.filter_by(user_id=self.id)
return followed.union(own).order_by(Post.timestamp.desc())
def __repr__(self):
return '<User {}>'.format(self.username)
class Kinds(db.Model):
__tablename__ = 't_kinds'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
couses = relationship('Couses', backref='kinds', cascade='delete')
