import json

from . import db

class Transaction(db.Model):

    id = db.Column(db.Integer(), primary_key=True)

    uuid = db.Column(db.String, unique=True, nullable=False)

    date = db.Column(db.DateTime)

    payee = db.Column(db.String())

    meta = db.Column(db.String())

    def as_dict(self):

        return dict(

            id=self.uuid,

            date=self.date,

            payee=self.payee,

            postings=[p.as_dict() for p in self.postings],

            metadata=json.loads(self.meta)

        )

class Posting(db.Model):

    id = db.Column(db.Integer(), primary_key=True)