class ViewModel(ViewMixin, db.Model):
__tablename__ = 'views'
user_id = db.Column(db.Integer(), db.ForeignKey('users.id'))
post_id = db.Column(db.Integer(), db.ForeignKey('posts.id'))
test_model = TestViewModel
class TheaterTicketModel(TheaterTicketMixin, db.Model):
__tablename__ = 'theater_tickets'
test_model = TestTheaterTicketModel
showtime_id = db.Column(db.Integer(), db.ForeignKey('showtimes.id'))
theater_id = db.Column(db.Integer(), db.ForeignKey('theaters.id'))
class CommentModel(CommentMixin, db.Model):
__tablename__ = 'comments'
user_id = db.Column(db.Integer(), db.ForeignKey('users.id'))
post_id = db.Column(db.Integer(), db.ForeignKey('posts.id'))
parent_id = db.Column(db.Integer(), nullable=True)
test_model = TestCommentModel
class TheaterMixin:
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
cinema_id = db.Column(db.Integer())
title = db.Column(db.String(10))
seat = db.Column(db.Integer())
def __init__(self, cinema_id=None, title=None, seat=None):
self.cinema_id = cinema_id
self.title = title
self.seat = seat
class TheaterTicketMixin:
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
showtime_id = db.Column(db.Integer())
x = db.Column(db.Integer())
y = db.Column(db.Integer())
def __init__(self, theater_id=None, showtime_id=None, x=None, y=None):
self.theater_id = theater_id
self.showtime_id = showtime_id
self.x = x
self.y = y
class TestTheaterModel(TheaterMixin, db.Model):
__tablename__ = 'test_theaters'
cinema_id = db.Column(db.Integer(), db.ForeignKey('test_cinemas.id'))
theater_tickets = db.relationship('TestTheaterTicketModel',
backref='theater')
class TheaterTicketModel(TheaterTicketMixin, db.Model):
__tablename__ = 'theater_tickets'
__table_args__ = {'extend_existing': True}
test_model = TestTheaterTicketModel
theater_id = db.Column(db.Integer(), db.ForeignKey('theaters.id'))
class PostModel(PostMixin, db.Model):
__tablename__ = 'posts'
user_id = db.Column(db.Integer(), db.ForeignKey('users.id'))
tags = db.relationship('TagModel', backref='post')
test_model = TestPostModel
class TheaterMixin:
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
title = db.Column(db.String(10))
seat = db.Column(db.Integer())
class TheaterTicketMixin:
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
x = db.Column(db.Integer())
y = db.Column(db.Integer())
class TagModel(TagMixin, db.Model):
__tablename__ = 'tags'
post_id = db.Column(db.Integer(), db.ForeignKey('posts.id'))
test_model = TestTagModel
