[PATCH] Send request notifications to co-maintainers

Bert Peters bert at bertptrs.nl
Sat Jul 10 09:10:50 UTC 2021


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(+)

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 '
+
+                           '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')
-- 
2.32.0

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: This is a digitally signed message part
URL: <https://lists.archlinux.org/pipermail/aur-dev/attachments/20210710/7df24b66/attachment.sig>


More information about the aur-dev mailing list