class Comment(db.Model):
__tablename__ = 'comments'
users = db.relationship(User)
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
post_id = db.Column(db.Integer, db.ForeignKey('blogpost.id'), nullable=False)
text = db.Column(db.String(140))
timestamp = db.Column(db.DateTime(), default=datetime.utcnow, index=True)
class Answer(db.Model):
id = db.Column(db.Integer, primary_key=True)
question_id = db.Column(db.Integer,
db.ForeignKey('question.id', ondelete='CASCADE'))
question = db.relationship('Question', backref=db.backref('answer_set', ))
content = db.Column(db.Text(), nullable=False)
create_date = db.Column(db.DateTime(), nullable=False)
user_id = db.Column(db.Integer,
db.ForeignKey('users.id', ondelete='CASCADE'),
nullable=False)
user = db.relationship('User', backref=db.backref('answer_set'))
modify_date = db.Column(db.DateTime(), nullable=True)
voter = db.relationship('User',
secondary=answer_voter,
backref=db.backref('answer_voter_set'))
class BlogPost(db.Model):
users = db.relationship(User)
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
title = db.Column(db.String(140), nullable=False)
text = db.Column(db.Text, nullable=False)
class Comment(db.Model):
blog_post = db.relationship(BlogPost)
users = db.relationship(User)
id = db.Column(db.Integer, primary_key=True)
body = db.Column(db.String(140), nullable=False)
timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
post_id = db.Column(db.Integer,
db.ForeignKey('blog_post.id'),
nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
def __init__(self, body, post_id, user_id):
self.body = body
self.post_id = post_id
self.user_id = user_id
def __repr__(self):
return f"Post ID: {self.id}---userid:{self.user_id} --Date:{self.timestamp}---{self.body}"
class TextOutput(db.Model):
users = db.relationship(User)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.String(1000))
sa_score = db.Column(db.Integer)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
def __init__(self, text, user_id, sa_score):
self.user_id = user_id
self.text = text
self.sa_score = sa_score
class Post(db.Model):
users = db.relationship(User)
slug = db.Column(db.Integer, nullable=False)
id = db.Column(db.Integer, primary_key=True)
meta_title = db.Column(db.String(60), nullable=False)
meta_desc = db.Column(db.String(160), nullable=False)
category = db.Column(db.String(160), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
heading = db.Column(db.String(140), nullable=False)
post = db.Column(db.Text, nullable=False)
class BlogPost():
users = db.relationship(User)
id = db.Column(db.Integer, primary_key=True)
userId = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
title = db.Column(db.String(160), nullable=False)
text = db.Column(db.Text, nullable=False)
def __init__(self, title, text, userId):
self.title = title
self.text = text
self.userId = userId
def __repr__(self):
f"Post Id { self.id } -- Date: { self.date } -----{ self.title }"
class BlogPost(db.Model):
users = db.relationship(User)
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
title = db.Column(db.String(140), nullable=False)
text = db.Column(db.Text, nullable=False)
def __init__(self, title, text, user_id):
self.title = title
self.text = text
self.user_id =user_id
def __repr__(self):
return f"Post Id: {self.id} --- Date posted: {self.date} --- Title of the text: {self.title}"
class Question(db.Model):
id = db.Column(db.Integer, primary_key=True)
subject = db.Column(db.String(200), nullable=False)
content = db.Column(db.Text(), nullable=False)
create_date = db.Column(db.DateTime(), nullable=False)
user_id = db.Column(db.Integer,
db.ForeignKey('users.id', ondelete='CASCADE'),
nullable=False)
user = db.relationship('User', backref=db.backref('question_set'))
modify_date = db.Column(db.DateTime(), nullable=True)
voter = db.relationship('User',
secondary=question_voter,
backref=db.backref('question_voter_set'))
class BlogPost(db.Model, UserMixin):
users = db.relationship(User)
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
title = db.Column(db.String(140), nullable=False)
text = db.Column(db.Text, nullable=False)
def __init__(self, title, text, user_id):
self.title = title
self.text = text
self.user_id = user_id
def __repr__(self):
return f'POST_ID: {self.id} : DATE {self.date} : TITLE {self.title}'
class BlogPost(db.Model):
# Setup the relationship to the User table
users = db.relationship(User)
# Model for the Blog Posts on Website
id = db.Column(db.Integer, primary_key=True)
# Notice how we connect the BlogPost to a particular author
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
title = db.Column(db.String(140), nullable=False)
text = db.Column(db.Text, nullable=False)
def __init__(self, title, text, user_id):
self.title = title
self.text = text
self.user_id = user_id
def __repr__(self):
return f"Post Id: {self.id} --- Date: {self.date} --- Title: {self.title}"
class BlogPost(db.Model):
users = db.relationship(User)
id = db.Column(db.Integer, primary_key=True)
event_image = db.Column(
db.Text,
nullable=False,
default='https://' + str(app.config['AWS_BUCKET']) +
'.s3-ap-northeast-1.amazonaws.com/default_profile.png')
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
title = db.Column(db.String(140), nullable=False)
event_date = db.Column(db.DateTime, default=datetime.utcnow)
event_time = db.Column(db.Time, default=datetime.utcnow)
organizer = db.Column(db.String(140), nullable=False)
place = db.Column(db.String(140), nullable=False)
entry = db.Column(db.Text, nullable=False)
way = db.Column(db.Text, nullable=False)
cost = db.Column(db.String(140), nullable=False)
contact = db.Column(db.String(140), nullable=False)
text = db.Column(db.Text, nullable=False)
comments = db.relationship('Comment', backref='title', lazy=True)
likes = db.relationship('PostLike', backref='post', lazy='dynamic')
def __init__(self, organizer, place, title, event_date, event_time, entry,
text, way, user_id, cost, event_image, contact):
self.title = title
self.text = text
self.event_date = event_date
self.event_time = event_time
self.user_id = user_id
self.event_image = event_image
self.organizer = organizer
self.place = place
self.entry = entry
self.way = way
self.cost = cost
self.contact = contact
def __repr__(self):
return f"Post ID: {self.id} --Date:{self.date} --- {self.title}"
class BlogPost(db.Model):
__tablename__ = 'blogpost'
users = db.relationship(User)
id = db.Column(db.Integer,primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
comments = db.relationship('Comment', backref='post', lazy=True)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
title = db.Column(db.String(140),nullable=False, unique=True)
text = db.Column(db.Text,nullable=False)
slug = db.Column(db.String(140), nullable=False)
tags = db.relationship(
'Tag', secondary=post_tag,
backref=db.backref('posts', lazy='dynamic'), lazy='dynamic'
)
def __init__(self,title,text,user_id, slug):
self.title = title
self.text = text
self.user_id = user_id
self.slug = slug
def __repr__(self):
return "Post ID: {}".format(self.id)
def tag(self, tag):
if not self.tagged(tag):
self.tags.append(tag)
def untag(self, tag):
if self.tagged(tag):
self.tags.remove(tag)
def tagged(self, tag):
return self.tags.filter(
post_tag.c.tag_id == tag.id).count() > 0
class BlogPost(db.Model):
users = db.relationship(User)
id = db.Column(db.Integer, primary_key=True)
meta_title = db.Column(db.String(60), nullable=False)
meta_desc = db.Column(db.String(160), nullable=False)
category = db.Column(db.String(160), nullable=False)
keywords = db.Column(db.String(160), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
title = db.Column(db.String(140), nullable=False)
text = db.Column(db.Text, nullable=False)
def __init__(self, title, text, user_id, meta_title, meta_desc, category,
keywords):
self.title = title
self.text = text
self.user_id = user_id
self.meta_title = meta_title
self.meta_desc = meta_desc
self.category = category
self.keywords = keywords
def __repr__(self):
return f"Post ID: {self.id}"
comments = db.relationship('Comment', backref='author', lazy=True)
def __init__(self,email,username,password):
self.email = email
self.username = username
self.password_hash = generate_password_hash(password)
def check_password(self,password):
return check_password_hash(self.password_hash,password)
def __repr__(self):
return "Username {}".format(self.username)
post_tag = db.Table('post_tag',
db.Column('blogpost_id', db.Integer, db.ForeignKey('blogpost.id'), primary_key=True),
db.Column('tag_id', db.Integer, db.ForeignKey('tag.id'), primary_key=True)
)
class BlogPost(db.Model):
__tablename__ = 'blogpost'
users = db.relationship(User)
id = db.Column(db.Integer,primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
comments = db.relationship('Comment', backref='post', lazy=True)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
text = db.Column(db.Text, nullable=False)
def __init__(self, title, text, userid):
self.title = title
self.text = text
self.user_id = userid
def __repr__(self):
return f"Post ID : {self.id} -- Date : {self.date}"
question_voter = db.Table(
'question_voter',
db.Column('user_id',
db.Integer,
db.ForeignKey('users.id', ondelete='CASCADE'),
primary_key=True),
db.Column('question_id',
db.Integer,
db.ForeignKey('question.id', ondelete='CASCADE'),
primary_key=True),
)
answer_voter = db.Table(
'answer_voter',
db.Column('user_id',
db.Integer,
db.ForeignKey('users.id', ondelete='CASCADE'),
primary_key=True),
db.Column('answer_id',
db.Integer,
class PostLike(db.Model):
__tablename__ = 'post_like'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('users.id'))
post_id = db.Column(db.Integer, db.ForeignKey('blog_post.id'))
def load_user(user_id):
return User.query.get(user_id)
# login = LoginManager(app)
#
#
#
# @login.user_loader
# def load_user(user_id):
# return User.query.get(user_id)
followers = db.Table(
'followers', db.Column('follower_id', db.Integer,
db.ForeignKey('users.id')),
db.Column('followed_id', db.Integer, db.ForeignKey('users.id')))
###################################################
#######User Model################################
###################################################
class User(db.Model, UserMixin):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
profile_image = db.Column(
db.Text,
nullable=False,
default='https://' + str(app.config['AWS_BUCKET']) +
'.s3-ap-northeast-1.amazonaws.com/default_profile.png')
