class PostLikes(db.Model):
__tablename__ = 'post_likes'
id = db.Column(db.Integer, primary_key=True)
post_id = db.Column(db.Integer, db.ForeignKey('post.post_id'))
user_id = db.Column(db.Integer, db.ForeignKey('user.user_id'))
class Followers(db.Model):
__tablename__ = 'follower'
follow_id = db.Column(db.Integer, primary_key=True)
followed_id = db.Column(db.Integer, db.ForeignKey('user.user_id'))
follower_id = db.Column(db.Integer, db.ForeignKey('user.user_id'))
class PostComment(db.Model, CreatedMixin):
__tablename__ = 'post_comments'
id = db.Column(db.Integer, primary_key=True)
message = db.Column(db.String(20), nullable=False)
post_id = db.Column(db.Integer, db.ForeignKey('post.post_id'))
class Chat(db.Model, CreatedMixin):
__tablename__ = 'chat'
chat_id = db.Column(db.Integer, primary_key=True)
partner_id = db.Column(db.Integer, db.ForeignKey('user.user_id'))
partner = db.relationship('User',
backref=backref('chat'),
foreign_keys=[partner_id])
messages = db.relationship('ChatMessages', back_populates='chat')
class ChatMessages(db.Model, CreatedMixin):
__tablename__ = 'chat_messages'
message_id = db.Column(db.Integer, primary_key=True)
# nullable cambiado a mmessage
message = db.Column(db.String(50), nullable=True)
chat_id = db.Column(db.Integer, db.ForeignKey('chat.chat_id'))
#image = db.Column(db.Integer, db.ForeignKey('chat_image.chat_id'), nullable=True)
chat = db.relationship('Chat', back_populates='messages')
#class Image(CreatedMixin):
# @declared_attr
# def image_id(self):
# return Column(Integer, primary_key=True)
# @declared_attr
# def image(self):
# return Column(String(), nullable=False)
#class ChatImage(db.Model, Image):
# __tablename__ = 'chat_image'
# chat_id = db.Column(db.Integer, db.ForeignKey('chat.chat_id'))
#class PostImage(db.Model, Image):
# __tablename__ = 'post_image'
# post_id = db.Column(db.Integer, db.ForeignKey('post.post_id'))
#class ProfileImage(db.Model):
# __tablename__ = 'profile_image'
# image_id = db.Column(Integer, primary_key=True)
# image = db.Column(String(), nullable=False)
# created_on = db.Column(db.DateTime, default=datetime.datetime.now(), nullable=False)
# class NotificationLike(db.Model, CreatedMixin):
# __tablename__ = 'notification_like'
# notification_id = db.Column(db.Integer, primary_key=True)
# post_id = db.Column(db.Integer, db.ForeignKey('post_likes.id'))
# receiver_id = db.Column(db.Integer, db.ForeignKey('user.user_id'))
# receiver = db.relationship('User', back_populates='like_notifications', foreign_keys=[receiver_id,CreatedMixin.created_by_fk])
# class NotificationComment(db.Model, CreatedMixin):
# __tablename__ = 'notification_comment'
# notification_id = db.Column(db.Integer, primary_key=True)
# receiver_id = db.Column(db.Integer, db.ForeignKey('user.user_id'))
# receiver = db.relationship('User',backref=backref('notification_comment'),foreign_keys=[receiver_id])
# comment_id = db.Column(db.Integer, db.ForeignKey('post_comments.id'))
# class NotificationFollow(db.Model,CreatedMixin):
# __tablename__ = 'notification_follow'
# notification_id = db.Column(db.Integer, primary_key=True)
# type = db.Column(db.String(10), nullable=False)
# receiver_id = db.Column(db.Integer, db.ForeignKey('follower.followed_id'))
# receiver = db.relationship('User', back_populates='follow_notifications')