diff options
author | René 'Necoro' Neumann <necoro@necoro.net> | 2016-01-10 21:07:49 +0100 |
---|---|---|
committer | René 'Necoro' Neumann <necoro@necoro.net> | 2016-07-08 23:35:29 +0200 |
commit | a1b7ca4997671926ecde0ffb64976e5377cec0cb (patch) | |
tree | fe4e5d35c695d8c72c9609deab0d8f1117766eb4 /app/model.py | |
parent | 08f0356358348cc3242a7bb45e3f008d66cf70f8 (diff) | |
download | kosten-a1b7ca4997671926ecde0ffb64976e5377cec0cb.tar.gz kosten-a1b7ca4997671926ecde0ffb64976e5377cec0cb.tar.bz2 kosten-a1b7ca4997671926ecde0ffb64976e5377cec0cb.zip |
New table ConstExpenseGroup
Diffstat (limited to '')
-rw-r--r-- | app/model.py | 13 |
1 files 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): |