from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()

class Dictionary(db.Model):
    __tablename__ = 'dictionary'
    id = db.Column(db.Integer, primary_key=True)
    word = db.Column(db.String(100))
    meaning = db.Column(db.String(200))
    detail = db.Column(db.String(250))
    user_id = db.Column(db.String(10))
    is_deleted = db.Column(db.String(2))
    
    def __repr__(self):
        return '<Dictionary %r>' % self.word
        
    @property
    def serialize(self):
        return {
            'id': self.id,
            'word': self.word,
            'meaning': self.meaning,
            'detail': self.detail,
            'user_id': self.user_id,
            'is_deleted': self.is_deleted,
        }

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