class Link(db.Model):
__tablename__ = 'link'
__bind_key__ = 'blog2'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100))
link = db.Column(db.String(100))
description = db.Column(db.String(200))
order_id = db.Column(db.Integer)
def __repr__(self):
return '<link %r>' % self.name
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 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):
__tablename__ = "post"
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.now)
content = db.Column(db.Text, nullable=False)
# connect used_id to id col from user table
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"Post({self.title}, {self.date})"
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.String(10),
nullable=False,
default=datetime.utcnow().date())
content = db.Column(db.Text, nullable=False)
u_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self): #how objects are printed
return ("User('{}','{}')".format(self.title, self.date_posted))
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)
img_file = db.Column(db.String(20), nullable=False, default='default.png')
password = db.Column(db.String(60), nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
def __repr__(self):
return "User('{}','{}','{}')".format(self.username, self.email,
self.img_file)
class Comments(db.Model):
id = db.Column(db.Integer(), primary_key=True)
post_id = db.Column(db.Integer(), db.ForeignKey('post.id'), nullable=False)
author_id = db.Column(db.Integer(),
db.ForeignKey('user.id'),
nullable=False)
content = db.Column(db.Text, nullable=False)
date_posted = db.Column(db.DateTime, nullable=False, default=datetime.now)
def __repr__(self):
return f"Comments('{self.id}', '{self.post_id}', '{self.author_id}')"
class Page(db.Model):
"""
Class for highest level web page.
"""
path_name = db.Column(db.String(30), primary_key=True)
page_name = db.Column(db.TEXT, nullable=False)
author_id = db.Column(db.ForeignKey(User.uid), nullable=False)
created_at = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
author = db.relationship(User, lazy="joined", backref="page")
class User(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
neckname = db.Column(db.String(50),
index=True,
unique=True,
nullable=False)
email = db.Column(db.String(100), index=True, unique=True)
role = db.Column(db.SmallInteger, default=ROLE_ADMIN)
posts = db.relationship('Post', backref='user', lazy='dynamic')
def __repr__(self):
return '<User %s>' % self.neckname
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 is lowercase as we refer to the user tablename and id column name
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"User('{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)
content = db.Column(db.Text, nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
comments = db.relationship('Comment', backref='original_post', lazy=True)
def __repr__(self):
return f"Post('{self.Title}','{self.date_posted}')"
class Tag(db.Model):
__tablename__ = 'tag'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64))
slug = db.Column(db.String(64), unique=True)
def __init__(self, *args, **kwargs):
super(Tag, self).__init__(*args, **kwargs)
self.slug = slugify(self.name)
def __repr__(self):
return '<Tag: %s>' % self.name
class Tag(db.Model):
__tablename__ = 'tag'
__bind_key__ = 'blog2'
id = db.Column(db.Integer, primary_key=True)
tag = db.Column(db.String(30))
articles = db.relationship('Article',
secondary=articles_tags,
backref='articles')
def __repr__(self):
return '<tag %r>' % self.tag
class Plan(db.Model):
# __tablename__ = 'plans'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
date_start = db.Column(db.Date, nullable=False, default=date.today())
date_end = db.Column(db.Date,
nullable=False,
default=date.today().replace(year=date.today().year +
1))
content = db.Column(db.Text, nullable=False)
candidates = db.relationship('Candidate', backref='plan', lazy=True)
class User(db.Model):
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)
profileImage = db.Column(db.String(20),
nullable=False,
default='default.jpg')
password = db.Column(db.String(60), nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
def __repr__(self):
return f"User('{self.username}', '{self.email}', '{self.image_file}')"
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)
#Here using lower case User because this refers to the table name
def __repr__(self):
return f"Post('{self.title}','{self.date_posted}')"
class Comment(db.Model):
__tablename__ = 'comment'
id = db.Column(db.Integer, primary_key=True)
author = db.Column(db.String(50))
post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
date_posted = db.Column(db.DateTime(),
nullable=False,
default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
def __repr__(self):
return f"Comment('{self.content}', '{self.date_posted}', '{self.author}')"
class Post(SearchableMixin, db.Model):
"""Defines the various fields and methods for the Post database table"""
id = db.Column(db.Integer, primary_key=True)
body = db.Column(db.String(140))
timestamp = db.Column(db.DateTime, default=datetime.utcnow, index=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
language = db.Column(db.String(5))
__searchable__ = ['body']
def __repr__(self):
"""Defines how new post instance is represented for debugging"""
return '<Post {}>'.format(self.body)
class Post(db.Model):
id = db.Column(db.Integer(), primary_key=True)
title = db.Column(db.String(32))
content = db.Column(db.Text())
date = db.Column(db.DateTime(), default=datetime.datetime.now())
author_id = db.Column(db.Integer(), db.ForeignKey('user.id'))
def __repr__(self):
return "<Post {}>".format(self.title)
class Category(db.Model):
__tablename__ = 'category'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(32), nullable=False)
def __init__(self, name):
self.name = name
def __repr__(self):
print(f'Category: {self.name}')
class User(db.Model, UserMixin):
__tablename__ = 'b_user'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(10), unique=True)
password = db.Column(db.String(16))
def __init__(self, username, password):
self.username = username
self.password = password
def __repr__(self):
return '<User %r>' % self.username
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(30), unique=True, nullable=False)
password = db.Column(db.String(30), unique=True, nullable=False)
email = db.Column(db.Text(50), unique=True, nullable=False)
posts = db.relationship('Post', backref='author', lazy=True)
def __repr__(self):
return f'{self.__class__.__name__}({self.username}-{self.email})'
def __str__(self):
return self.username
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.Text(30), nullable=False, unique=True)
content = db.Column(db.Text(900), nullable=False)
date = db.Column(db.DateTime, default=datetime.datetime.now)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f'{self.__class__.__name__}({self.id}-{self.title}-{self.date})'
def __str__(self):
return self.content[:40]
class Category(db.Model): __tablename__ = 'b_category' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(20), unique=True) content = db.Column(db.String(100)) def __init__(self, title, content): self.title = title self.content = content def __repr__(self): return '<Category %r>' % self.title
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
post = db.Column(db.String(200), nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
comments = db.relationship('Comment', backref='commenter', lazy=True)
def __repr__(self):
return f"Pitch('{self.pitch}, {self.date_posted}')"
class User(db.Model):
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)
profile_pic = db.Column(db.String(20), default="default.jpg")
password = db.Column(db.String(60), nullable=False)
# A relationship is not a column,
# creates additional query to get posts from table "post"
posts = db.relationship("Post", backref="author", lazy=True)
def __repr__(self):
return f"User('{self.username}', '{self.email}', '{self.profile_pic}')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
content = db.Column(db.Text, nullable=False)
date_posted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow())
# The User class is "user" table in db, so lowercase user.id below
user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False)
def __repr__(self):
return f"User('{self.title}', '{self.date_posted}')"
class Post(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(160), nullable=False)
date_posted = db.Column(
db.DateTime, nullable=False, default=datetime.utcnow
) # datetime.utcnow is actually a function. we are passing in a function as our default
content = db.Column(db.Text, nullable=False)
user_id = db.Column(
db.Integer, db.ForeignKey('user.id'), nullable=False
) # when we link to foreignkey, we refer to the table name 'user' which is in lower case, id is the column
def __repr__(self):
return "Post('{}', '{}')".format(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)
datePosted = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
#Here, user.id references the user table and the id column.
userID = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False)
#Post is represented as Post(Title, DatePosted)
def __repr__(self):
return f"Post('{self.title}', '{self.datePosted}')"
class Follow(db.Model):
__tablename__ = 'follows'
follower_id = db.Column(db.Integer,
db.ForeignKey('users.id'),
primary_key=True)
followed_id = db.Column(db.Integer,
db.ForeignKey('users.id'),
primary_key=True)
timestamp = db.Column(db.DateTime, default=datetime.utcnow)
