class Statement(db.Model):
id = db.Column(db.Integer, primary_key=True)
source = db.Column(db.Unicode(64))
path = db.Column(db.Unicode(128))
status = db.Column(db.Unicode(16), default=StatementStatus.uploaded.value)
def __unicode__(self):
return self.name
class Record(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), nullable=False)
category_id = db.Column(db.Integer,
db.ForeignKey("category.id"),
nullable=True)
category = db.relationship("Category")
account = db.Column(db.String(255), nullable=False)
amount = db.Column(db.Numeric(precision=8, scale=2,
decimal_return_scale=2),
nullable=False)
comment = db.Column(db.Text(), nullable=False)
recorded_at = db.Column(db.DateTime(), nullable=False)
created_at = db.Column(db.DateTime(), nullable=False)
updated_at = db.Column(db.DateTime(), nullable=False)
is_confirmed = db.Column(db.Boolean, default=False)
tags = db.relationship(Tag, secondary="record_tag")
class Record(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), nullable=False)
category_id = db.Column(db.Integer,
db.ForeignKey('category.id'),
nullable=True)
category = db.relationship("Category")
account = db.Column(db.String(255), nullable=False)
amount = db.Column(db.Numeric(precision=8, scale=2,
decimal_return_scale=2),
nullable=False)
comment = db.Column(db.Text(), nullable=False)
recorded_at = db.Column(db.DateTime(), nullable=False)
created_at = db.Column(db.DateTime(), nullable=False)
updated_at = db.Column(db.DateTime(), nullable=False)
is_confirmed = db.Column(db.Boolean, default=False)
tags = db.relationship(Tag, secondary='record_tag')
__table_args__ = (UniqueConstraint('name',
'account',
'recorded_at',
'amount',
name='uix_1'), )
class Category(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), nullable=False)
def __repr__(self):
return self.name
class RecordTag(db.Model):
record_id = db.Column(db.Integer,
db.ForeignKey('record.id'),
primary_key=True)
tag_id = db.Column(db.Integer, db.ForeignKey('tag.id'), primary_key=True)