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