Flask SqlAlchemy Store multiple values

Viewed 530

Let's say I have a class called users. A user can like posts. The like count is registered as a number on the post class. On the user class, the post's id is registered on it so that multiple likes can't be given. However, sql on flask only stores datatypes like integers and strings. How am I supposed to keep track of what posts a user has liked?

I have some code for a user like:

class Users(db.Model):
    id = db.Column("id", db.Integer, primary_key=True)
    name = db.Column(db.String(100))
    email = db.Column(db.String(100))
    password = db.Column(db.String(100))
    status = db.Column(db.String(100))
    about = db.Column(db.String(500))
    liked = db.Column(Something that would store integer ids of posts)

    def __init__(self, name, email, password, status):
        self.name = name
        self.email = email
        self.password = password
        self.status = status
        self.about = "Sample"
        self.liked_posts = []
0 Answers
Related