class EventLog(db.Model):
    __tablename__ = 'EventLog'

    id = db.Column(db.Integer, primary_key=True)
    timeOfEvent = db.Column(db.Integer, primary_key=True)
    eventName = db.Column(db.String(50), unique=True)
    message = db.Column(db.String(50), unique=True)
    agent_id = db.Column(db.Integer, db.ForeignKey('agent.id'))

    def __init__(self, timeOfEvent, eventName, message):
        self.timeOfEvent = timeOfEvent
        self.eventName = eventName
        self.message = message

    def __repr__(self):
        return '<Event Name %r' % self.eventName





class Agent(db.Model):
    __tablename__ = 'agent'

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50), unique=True)
    enabled = db.Column(db.Boolean, default=True)
    blackboard = db.Column(db.String())
    events = db.relationship("EventLog", backref='agent', lazy = 'dynamic')

    def __init__(self, name):
        self.name = name

    def to_dict(self):
        dict = {}
        print json.loads(self.blackboard)
        data = json.loads(self.blackboard)
        for key in data:
            dict[key] = data[key]
        return {
            "name": self.name,
            "enabled": self.enabled,
            "blackboard": dict
        }