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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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) 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 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 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 User(db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=False, nullable=False) question_number = db.Column(db.SmallInteger, default=0) demostrative = db.Column(db.SmallInteger, default=0) rigid = db.Column(db.SmallInteger, default=0) pedantic = db.Column(db.SmallInteger, default=0) excitable = db.Column(db.SmallInteger, default=0) hyperten = db.Column(db.SmallInteger, default=0) dysthymic = db.Column(db.SmallInteger, default=0) alarming = db.Column(db.SmallInteger, default=0) cyclosilicate = db.Column(db.SmallInteger, default=0) exalted = db.Column(db.SmallInteger, default=0) emotive = db.Column(db.SmallInteger, default=0) def __repr__(self): return '<User %r>' % 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')