| Message ID | db82058ccf26bba0e812db47b8648dbc85892540.camel@bertptrs.nl |
|---|---|
| State | New |
| Headers | show |
| Series | Send request notifications to co-maintainers | expand |
diff --git a/aurweb/scripts/notify.py b/aurweb/scripts/notify.py index 7f8e7168..e815e4c3 100755 --- a/aurweb/scripts/notify.py +++ b/aurweb/scripts/notify.py @@ -435,9 +435,12 @@ class RequestOpenNotification(Notification): cur = conn.execute('SELECT DISTINCT Users.Email FROM PackageRequests ' + 'INNER JOIN PackageBases ' + 'ON PackageBases.ID = PackageRequests.PackageBaseID ' + + 'INNER JOIN PackageComaintainers ' + + 'ON PackageComaintainers.PackageBaseID = PackageRequests.PackageBaseID ' + 'INNER JOIN Users ' + 'ON Users.ID = PackageRequests.UsersID ' + 'OR Users.ID = PackageBases.MaintainerUID ' +
This is in addition to the current recipients. Co-maintainers should also be made aware when their package has pending requests. --- aurweb/scripts/notify.py | 6 ++++++ 1 file changed, 6 insertions(+) + 'OR Users.ID = PackageComaintainers.UsersID ' + 'WHERE PackageRequests.ID = ? AND ' + 'Users.Suspended = 0', [reqid]) self._to = aurweb.config.get('options', 'aur_request_ml') @@ -492,9 +495,12 @@ class RequestCloseNotification(Notification): cur = conn.execute('SELECT DISTINCT Users.Email FROM PackageRequests ' + 'INNER JOIN PackageBases ' + 'ON PackageBases.ID = PackageRequests.PackageBaseID ' + + 'INNER JOIN PackageComaintainers ' + + 'ON PackageComaintainers.PackageBaseID = PackageRequests.PackageBaseID ' + 'INNER JOIN Users ' + 'ON Users.ID = PackageRequests.UsersID ' + 'OR Users.ID = PackageBases.MaintainerUID ' + + 'OR Users.ID = PackageComaintainers.UsersID ' + 'WHERE PackageRequests.ID = ? AND ' + 'Users.Suspended = 0', [reqid]) self._to = aurweb.config.get('options', 'aur_request_ml')