commit: a0e5f8b3559f243236d9dd1170a00d4405042631 Author: Mart Raudsepp <leio <AT> gentoo <DOT> org> AuthorDate: Sun Dec 4 06:24:39 2016 +0000 Commit: Mart Raudsepp <leio <AT> gentoo <DOT> org> CommitDate: Sun Dec 4 06:24:39 2016 +0000 URL: https://gitweb.gentoo.org/proj/grumpy.git/commit/?id=a0e5f8b3
models: Add association table and ORM relationship between projects and members backend/lib/models.py | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/backend/lib/models.py b/backend/lib/models.py index bc6cd20..f842a8a 100644 --- a/backend/lib/models.py +++ b/backend/lib/models.py @@ -31,6 +31,11 @@ class PackageVersion(db.Model): def __repr__(self): return "<PackageVersion '%s/%s-%s'>" % (self.package.category.name, self.package.name, self.version) +maintainer_project_membership_rel_table = db.Table('maintainer_project_membership_rel', + db.Column('project_id', db.Integer, db.ForeignKey('maintainer.id')), + db.Column('maintainer_id', db.Integer, db.ForeignKey('maintainer.id')), +) + class Maintainer(db.Model): id = db.Column(db.Integer, primary_key=True) email = db.Column(db.Unicode(50), nullable=False, unique=True) @@ -39,5 +44,12 @@ class Maintainer(db.Model): url = db.Column(db.Unicode()) description = db.Column(db.Unicode(500)) + members = db.relationship("Maintainer", + secondary=maintainer_project_membership_rel_table, + primaryjoin=id==maintainer_project_membership_rel_table.c.project_id, + secondaryjoin=id==maintainer_project_membership_rel_table.c.maintainer_id, + backref='projects') + # projects relationship backref ^^ + def __repr__(self): return "<Maintainer %s '%s'>" % ("project" if self.is_project else "individual", self.email)