class Post(db.Model):
""" Create a blog table """
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer(), primary_key=True)
title = db.Column(db.String(), nullable=False)
summary = db.Column(db.String(), nullable=False)
content = db.Column(db.String(), nullable=False)
image_path = db.Column(db.String(), nullable=True)
image_feature1 = db.Column(db.String(), nullable=True)
image_feature2 = db.Column(db.String(), nullable=True)
image_feature3 = db.Column(db.String(), nullable=True)
view_count = db.Column(db.Integer(), nullable=False, default=0)
comment_count = db.Column(db.Integer(), nullable=False, default=0)
published = db.Column(db.Boolean(), nullable=False, default=False)
publish_date = db.Column(db.DateTime())
created = db.Column(db.DateTime(), nullable=False)
updated = db.Column(db.DateTime(), default=datetime.utcnow())
comments = db.relationship(
'Comment', backref='post', lazy=True, cascade="all, delete-orphan")
tags = db.relationship('Tag',
secondary='posts_tags',
lazy='subquery',
backref=db.backref('post', lazy=True))
author_id = db.Column(
db.Integer(), db.ForeignKey('user.id'), nullable=False)
author = db.relationship('User')
def __repr__(self):
return '<Post %r>' % (self.title)
class Booking(db.Model):
""" Create a Booking table """
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer(), primary_key=True)
arrival = db.Column(db.DateTime(), nullable=False)
departure = db.Column(db.DateTime(), nullable=False)
adults = db.Column(db.Integer(), nullable=False)
children = db.Column(db.Integer(), nullable=False, default=0)
rooms = db.relationship(
'Room', backref='booking', lazy=True, cascade="all, delete-orphan")
def __repr__(self):
return '<Booking %r>' % (self.id)
class User(db.Model, UserMixin):
""" Create a User table """
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer(), primary_key=True)
username = db.Column(db.String(), unique=True)
password = db.Column(db.String(), nullable=False)
email = db.Column(db.String(), nullable=False)
registered_on = db.Column(db.DateTime, nullable=False)
confirmed = db.Column(db.Boolean(), nullable=False)
active = db.Column(db.Boolean(), nullable=False)
cancelled = db.Column(db.Boolean(), nullable=False, default=False)
# nullable columns
first_name = db.Column(db.String(), nullable=True)
last_name = db.Column(db.String(), nullable=True)
address = db.Column(db.String(), nullable=True)
city = db.Column(db.String(), nullable=True)
state = db.Column(db.String(), nullable=True)
zipcode = db.Column(db.String(), nullable=True)
confirmed_on = db.Column(db.DateTime(), nullable=True)
# relations
posts = db.relationship('Post', backref='user', lazy=True)
rooms = db.relationship('Room', backref='room', lazy=True)
roles = db.relationship('Role', secondary='users_roles', lazy='subquery',
backref=db.backref('user', lazy=True))
def validate(self, password):
""" validate password """
return password == self.password
# return sha.verify(password, self.password)
def __repr__(self):
return '<User: {}>'.format(self.username)
class Tag(db.Model):
""" Create a tags table """
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(), nullable=False)
date = db.Column(db.DateTime(), default=datetime.utcnow())
def __repr__(self):
return '<Tag %r>' % (self.name)
class Comment(db.Model):
""" Create a Comment table """
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(), nullable=False)
email = db.Column(db.String(), nullable=False)
content = db.Column(db.String(), nullable=False)
date = db.Column(db.DateTime(), default=datetime.utcnow())
post_id = db.Column(
db.Integer(), db.ForeignKey('post.id'), nullable=False)
def __repr__(self):
return '<Comment %r>' % (self.name)