From a1b7ca4997671926ecde0ffb64976e5377cec0cb Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Ren=C3=A9=20=27Necoro=27=20Neumann?= Date: Sun, 10 Jan 2016 21:07:49 +0100 Subject: New table ConstExpenseGroup --- app/model.py | 13 +++++++++++-- 1 file changed, 11 insertions(+), 2 deletions(-) diff --git a/app/model.py b/app/model.py index b68dc57..248647c 100644 --- a/app/model.py +++ b/app/model.py @@ -138,6 +138,12 @@ class SingleExpense (UserModel, CategoryModel): self.month = d.month self.day = d.day +class ConstExpenseGroup (UserModel, CategoryModel): + description = ReqColumn(db.Unicode(50)) + start = ReqColumn(db.Date, index = True) + end = ReqColumn(db.Date, index = True) + + expenses = db.relationship("ConstExpense", back_populates = "group") class ConstExpense (UserModel, CategoryModel): description = Column(db.Unicode(50)) @@ -146,9 +152,12 @@ class ConstExpense (UserModel, CategoryModel): start = ReqColumn(db.Date, index = True) end = ReqColumn(db.Date, index = True) prev_id = Column(db.Integer, db.ForeignKey('constexpense.id')) + prev = db.relationship('ConstExpense', + remote_side = 'ConstExpense.id', uselist = False, + backref=db.backref('next', uselist = False)) - prev = db.relationship('ConstExpense', remote_side = 'ConstExpense.id', uselist = False, - backref=db.backref('next', uselist = False)) + group_id = Column(db.Integer, db.ForeignKey(ConstExpenseGroup.id), index = True) + group = db.relationship(ConstExpenseGroup, back_populates = "expenses") @property def monthly(self): -- cgit v1.2.3