summaryrefslogtreecommitdiff
path: root/scripts
diff options
context:
space:
mode:
authorLukas Fleischer <lfleischer@archlinux.org>2015-11-10 19:26:57 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2016-02-07 10:39:22 +0100
commit3412de21d32708b44d1fb3011649734e3cc67d9b (patch)
tree8124b4cad4d68a01a0d8aeff90c9e8584d173541 /scripts
parentdaee000604243b95e439167c97b3ee8cdc4f6ca3 (diff)
Rename the CommentNotify table to PackageNotifications
As a preparatory step to adding support for package notifications on events other than comments, rename the database table accordingly. Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'scripts')
-rwxr-xr-xscripts/notify.py8
1 files changed, 4 insertions, 4 deletions
diff --git a/scripts/notify.py b/scripts/notify.py
index 7b10efb..08cdda8 100755
--- a/scripts/notify.py
+++ b/scripts/notify.py
@@ -88,10 +88,10 @@ def get_maintainer_email(cur, pkgbase_id):
def get_recipients(cur, pkgbase_id, uid):
cur.execute('SELECT DISTINCT Users.Email FROM Users ' +
- 'INNER JOIN CommentNotify ' +
- 'ON CommentNotify.UserID = Users.ID WHERE ' +
- 'CommentNotify.UserID != %s AND ' +
- 'CommentNotify.PackageBaseID = %s', [uid, pkgbase_id])
+ 'INNER JOIN PackageNotifications ' +
+ 'ON PackageNotifications.UserID = Users.ID WHERE ' +
+ 'PackageNotifications.UserID != %s AND ' +
+ 'PackageNotifications.PackageBaseID = %s', [uid, pkgbase_id])
return [row[0] for row in cur.fetchall()]