From 22d02edbd858649e1c890621d72867d913f8dc57 Mon Sep 17 00:00:00 2001 From: rubenwardy Date: Sat, 18 Jan 2020 23:10:11 +0000 Subject: Add constraint for release tasks and approval --- app/models.py | 2 ++ 1 file changed, 2 insertions(+) (limited to 'app') diff --git a/app/models.py b/app/models.py index cd7a88a..3752363 100644 --- a/app/models.py +++ b/app/models.py @@ -732,6 +732,8 @@ class PackageRelease(db.Model): max_rel_id = db.Column(db.Integer, db.ForeignKey("minetest_release.id"), nullable=True, server_default=None) max_rel = db.relationship("MinetestRelease", foreign_keys=[max_rel_id]) + # If the release is approved, then the task_id must be null and the url must be present + CK_approval_valid = db.CheckConstraint("not approved OR (task_id IS NULL AND (url = '') IS NOT FALSE)") def getEditURL(self): return url_for("packages.edit_release", -- cgit v1.2.3