diff options
| author | Lukas Fleischer <lfleischer@archlinux.org> | 2015-11-10 19:26:57 +0100 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2016-02-07 10:39:22 +0100 |
| commit | 3412de21d32708b44d1fb3011649734e3cc67d9b (patch) | |
| tree | 8124b4cad4d68a01a0d8aeff90c9e8584d173541 /scripts | |
| parent | daee000604243b95e439167c97b3ee8cdc4f6ca3 (diff) | |
| download | aurweb-3412de21d32708b44d1fb3011649734e3cc67d9b.tar.xz | |
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-x | scripts/notify.py | 8 |
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()] |