diff mbox series

[v2] Send request notifications to co-maintainers

Message ID 20210711144106.20521-1-bert@bertptrs.nl
State New
Headers show
Series [v2] Send request notifications to co-maintainers | expand

Commit Message

Bert Peters July 11, 2021, 2:41 p.m. UTC 
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 mbox series

Patch

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