from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class Idioms(db.Model):
    __tablename__ = "idioms"
    id = db.Column(db.Integer, primary_key=True)
    idiom = db.Column(db.String(500))
    meaning = db.Column(db.String(500))
    user_id = db.Column(db.String(10))
    is_deleted = db.Column(db.String(2))

    def __repr__(self):
        return '<Idioms %r>' % self.idiom

    @property
    def serialize(self):
        return {
            'id': self.id,
            'idiom': self.idiom,
            'meaning': self.meaning,
            'user_id': self.user_id,
            'is_deleted': self.is_deleted,
        }

    @staticmethod
    def serialize_list(l):
        return [m.serialize for m in l]