notify.py 23.4 KB
Newer Older
1
#!/usr/bin/env python3
2
3

import email.mime.text
4
5
import email.utils
import smtplib
6
7
8
9
import subprocess
import sys
import textwrap

Lukas Fleischer's avatar
Lukas Fleischer committed
10
11
import aurweb.config
import aurweb.db
Lukas Fleischer's avatar
Lukas Fleischer committed
12
import aurweb.l10n
13

Lukas Fleischer's avatar
Lukas Fleischer committed
14
aur_location = aurweb.config.get('options', 'aur_location')
15
16


17
18
19
def headers_cc(cclist):
    return {'Cc': str.join(', ', cclist)}

20

21
22
23
def headers_msgid(thread_id):
    return {'Message-ID': thread_id}

24

25
26
27
def headers_reply(thread_id):
    return {'In-Reply-To': thread_id, 'References': thread_id}

28

Lukas Fleischer's avatar
Lukas Fleischer committed
29
30
def username_from_id(conn, uid):
    cur = conn.execute('SELECT UserName FROM Users WHERE ID = ?', [uid])
31
32
    return cur.fetchone()[0]

33

Lukas Fleischer's avatar
Lukas Fleischer committed
34
35
36
def pkgbase_from_id(conn, pkgbase_id):
    cur = conn.execute('SELECT Name FROM PackageBases WHERE ID = ?',
                       [pkgbase_id])
37
38
    return cur.fetchone()[0]

39

Lukas Fleischer's avatar
Lukas Fleischer committed
40
41
42
def pkgbase_from_pkgreq(conn, reqid):
    cur = conn.execute('SELECT PackageBaseID FROM PackageRequests ' +
                       'WHERE ID = ?', [reqid])
43
44
    return cur.fetchone()[0]

45

46
class Notification:
Lukas Fleischer's avatar
Lukas Fleischer committed
47
48
49
    def __init__(self):
        self._l10n = aurweb.l10n.Translator()

50
51
52
53
54
55
    def get_refs(self):
        return ()

    def get_headers(self):
        return {}

Lukas Fleischer's avatar
Lukas Fleischer committed
56
    def get_body_fmt(self, lang):
57
        body = ''
Lukas Fleischer's avatar
Lukas Fleischer committed
58
        for line in self.get_body(lang).splitlines():
59
60
61
            if line == '-- ':
                body += '-- \n'
                continue
62
63
64
            body += textwrap.fill(line, break_long_words=False) + '\n'
        for i, ref in enumerate(self.get_refs()):
            body += '\n' + '[%d] %s' % (i + 1, ref)
Lukas Fleischer's avatar
Lukas Fleischer committed
65
        return body.rstrip()
66

Lukas Fleischer's avatar
Lukas Fleischer committed
67
    def send(self):
68
        sendmail = aurweb.config.get('notifications', 'sendmail')
69
70
        sender = aurweb.config.get('notifications', 'sender')
        reply_to = aurweb.config.get('notifications', 'reply-to')
71
72
73
        reason = self.__class__.__name__
        if reason.endswith('Notification'):
            reason = reason[:-len('Notification')]
74
75

        for recipient in self.get_recipients():
Lukas Fleischer's avatar
Lukas Fleischer committed
76
77
78
79
            to, lang = recipient
            msg = email.mime.text.MIMEText(self.get_body_fmt(lang),
                                           'plain', 'utf-8')
            msg['Subject'] = self.get_subject(lang)
80
81
            msg['From'] = sender
            msg['Reply-to'] = reply_to
Lukas Fleischer's avatar
Lukas Fleischer committed
82
            msg['To'] = to
83
            msg['X-AUR-Reason'] = reason
84
            msg['Date'] = email.utils.formatdate(localtime=True)
85
86
87
88

            for key, value in self.get_headers().items():
                msg[key] = value

89
90
91
92
93
94
95
96
97
98
            sendmail = aurweb.config.get('notifications', 'sendmail')
            if sendmail:
                # send email using the sendmail binary specified in the
                # configuration file
                p = subprocess.Popen([sendmail, '-t', '-oi'],
                                     stdin=subprocess.PIPE)
                p.communicate(msg.as_bytes())
            else:
                # send email using smtplib; no local MTA required
                server_addr = aurweb.config.get('notifications', 'smtp-server')
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
                server_port = aurweb.config.getint('notifications', 'smtp-port')
                use_ssl = aurweb.config.getboolean('notifications', 'smtp-use-ssl')
                use_starttls = aurweb.config.getboolean('notifications', 'smtp-use-starttls')
                user = aurweb.config.get('notifications', 'smtp-user')
                passwd = aurweb.config.get('notifications', 'smtp-password')

                if use_ssl:
                    server = smtplib.SMTP_SSL(server_addr, server_port)
                else:
                    server = smtplib.SMTP(server_addr, server_port)

                if use_starttls:
                    server.ehlo()
                    server.starttls()
                    server.ehlo()

                if user and passwd:
                    server.login(user, passwd)
117
118

                server.set_debuglevel(0)
119
                server.sendmail(sender, to, msg.as_bytes())
120
                server.quit()
121
122
123
124


class ResetKeyNotification(Notification):
    def __init__(self, conn, uid):
125
126
127
128
        cur = conn.execute('SELECT UserName, Email, BackupEmail, ' +
                           'LangPreference, ResetKey ' +
                           'FROM Users WHERE ID = ?', [uid])
        self._username, self._to, self._backup, self._lang, self._resetkey = cur.fetchone()
Lukas Fleischer's avatar
Lukas Fleischer committed
129
        super().__init__()
130
131

    def get_recipients(self):
132
133
134
135
        if self._backup:
            return [(self._to, self._lang), (self._backup, self._lang)]
        else:
            return [(self._to, self._lang)]
136

Lukas Fleischer's avatar
Lukas Fleischer committed
137
138
    def get_subject(self, lang):
        return self._l10n.translate('AUR Password Reset', lang)
139

Lukas Fleischer's avatar
Lukas Fleischer committed
140
141
    def get_body(self, lang):
        return self._l10n.translate(
142
143
144
145
146
                'A password reset request was submitted for the account '
                '{user} associated with your email address. If you wish to '
                'reset your password follow the link [1] below, otherwise '
                'ignore this message and nothing will happen.',
                lang).format(user=self._username)
147
148
149
150
151
152

    def get_refs(self):
        return (aur_location + '/passreset/?resetkey=' + self._resetkey,)


class WelcomeNotification(ResetKeyNotification):
Lukas Fleischer's avatar
Lukas Fleischer committed
153
154
155
    def get_subject(self, lang):
        return self._l10n.translate('Welcome to the Arch User Repository',
                                    lang)
156

Lukas Fleischer's avatar
Lukas Fleischer committed
157
158
159
160
161
162
    def get_body(self, lang):
        return self._l10n.translate(
                'Welcome to the Arch User Repository! In order to set an '
                'initial password for your new account, please click the '
                'link [1] below. If the link does not work, try copying and '
                'pasting it into your browser.', lang)
163
164
165
166
167
168


class CommentNotification(Notification):
    def __init__(self, conn, uid, pkgbase_id, comment_id):
        self._user = username_from_id(conn, uid)
        self._pkgbase = pkgbase_from_id(conn, pkgbase_id)
Lukas Fleischer's avatar
Lukas Fleischer committed
169
170
        cur = conn.execute('SELECT DISTINCT Users.Email, Users.LangPreference '
                           'FROM Users INNER JOIN PackageNotifications ' +
171
172
173
174
175
                           'ON PackageNotifications.UserID = Users.ID WHERE ' +
                           'Users.CommentNotify = 1 AND ' +
                           'PackageNotifications.UserID != ? AND ' +
                           'PackageNotifications.PackageBaseID = ?',
                           [uid, pkgbase_id])
Lukas Fleischer's avatar
Lukas Fleischer committed
176
        self._recipients = cur.fetchall()
177
178
179
        cur = conn.execute('SELECT Comments FROM PackageComments WHERE ID = ?',
                           [comment_id])
        self._text = cur.fetchone()[0]
Lukas Fleischer's avatar
Lukas Fleischer committed
180
        super().__init__()
181
182

    def get_recipients(self):
Lukas Fleischer's avatar
Lukas Fleischer committed
183
        return self._recipients
184

Lukas Fleischer's avatar
Lukas Fleischer committed
185
    def get_subject(self, lang):
186
187
        return self._l10n.translate('AUR Comment for {pkgbase}',
                                    lang).format(pkgbase=self._pkgbase)
188

Lukas Fleischer's avatar
Lukas Fleischer committed
189
190
    def get_body(self, lang):
        body = self._l10n.translate(
191
192
                '{user} [1] added the following comment to {pkgbase} [2]:',
                lang).format(user=self._user, pkgbase=self._pkgbase)
193
        body += '\n\n' + self._text + '\n\n-- \n'
Lukas Fleischer's avatar
Lukas Fleischer committed
194
195
196
197
        dnlabel = self._l10n.translate('Disable notifications', lang)
        body += self._l10n.translate(
                'If you no longer wish to receive notifications about this '
                'package, please go to the package page [2] and select '
198
                '"{label}".', lang).format(label=dnlabel)
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
        return body

    def get_refs(self):
        return (aur_location + '/account/' + self._user + '/',
                aur_location + '/pkgbase/' + self._pkgbase + '/')

    def get_headers(self):
        thread_id = '<pkg-notifications-' + self._pkgbase + \
                    '@aur.archlinux.org>'
        return headers_reply(thread_id)


class UpdateNotification(Notification):
    def __init__(self, conn, uid, pkgbase_id):
        self._user = username_from_id(conn, uid)
        self._pkgbase = pkgbase_from_id(conn, pkgbase_id)
Lukas Fleischer's avatar
Lukas Fleischer committed
215
216
        cur = conn.execute('SELECT DISTINCT Users.Email, ' +
                           'Users.LangPreference FROM Users ' +
217
218
219
220
221
222
                           'INNER JOIN PackageNotifications ' +
                           'ON PackageNotifications.UserID = Users.ID WHERE ' +
                           'Users.UpdateNotify = 1 AND ' +
                           'PackageNotifications.UserID != ? AND ' +
                           'PackageNotifications.PackageBaseID = ?',
                           [uid, pkgbase_id])
Lukas Fleischer's avatar
Lukas Fleischer committed
223
224
        self._recipients = cur.fetchall()
        super().__init__()
225
226

    def get_recipients(self):
Lukas Fleischer's avatar
Lukas Fleischer committed
227
        return self._recipients
228

Lukas Fleischer's avatar
Lukas Fleischer committed
229
    def get_subject(self, lang):
230
231
        return self._l10n.translate('AUR Package Update: {pkgbase}',
                                    lang).format(pkgbase=self._pkgbase)
232

Lukas Fleischer's avatar
Lukas Fleischer committed
233
    def get_body(self, lang):
234
235
236
237
        body = self._l10n.translate('{user} [1] pushed a new commit to '
                                    '{pkgbase} [2].', lang).format(
                                            user=self._user,
                                            pkgbase=self._pkgbase)
238
        body += '\n\n-- \n'
Lukas Fleischer's avatar
Lukas Fleischer committed
239
240
241
242
        dnlabel = self._l10n.translate('Disable notifications', lang)
        body += self._l10n.translate(
                'If you no longer wish to receive notifications about this '
                'package, please go to the package page [2] and select '
243
                '"{label}".', lang).format(label=dnlabel)
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
        return body

    def get_refs(self):
        return (aur_location + '/account/' + self._user + '/',
                aur_location + '/pkgbase/' + self._pkgbase + '/')

    def get_headers(self):
        thread_id = '<pkg-notifications-' + self._pkgbase + \
                    '@aur.archlinux.org>'
        return headers_reply(thread_id)


class FlagNotification(Notification):
    def __init__(self, conn, uid, pkgbase_id):
        self._user = username_from_id(conn, uid)
        self._pkgbase = pkgbase_from_id(conn, pkgbase_id)
Lukas Fleischer's avatar
Lukas Fleischer committed
260
261
        cur = conn.execute('SELECT DISTINCT Users.Email, ' +
                           'Users.LangPreference FROM Users ' +
262
263
264
265
266
267
                           'LEFT JOIN PackageComaintainers ' +
                           'ON PackageComaintainers.UsersID = Users.ID ' +
                           'INNER JOIN PackageBases ' +
                           'ON PackageBases.MaintainerUID = Users.ID OR ' +
                           'PackageBases.ID = PackageComaintainers.PackageBaseID ' +
                           'WHERE PackageBases.ID = ?', [pkgbase_id])
Lukas Fleischer's avatar
Lukas Fleischer committed
268
        self._recipients = cur.fetchall()
269
270
271
        cur = conn.execute('SELECT FlaggerComment FROM PackageBases WHERE ' +
                           'ID = ?', [pkgbase_id])
        self._text = cur.fetchone()[0]
Lukas Fleischer's avatar
Lukas Fleischer committed
272
        super().__init__()
273
274

    def get_recipients(self):
Lukas Fleischer's avatar
Lukas Fleischer committed
275
        return self._recipients
276

Lukas Fleischer's avatar
Lukas Fleischer committed
277
    def get_subject(self, lang):
278
279
280
        return self._l10n.translate('AUR Out-of-date Notification for '
                                    '{pkgbase}',
                                    lang).format(pkgbase=self._pkgbase)
281

Lukas Fleischer's avatar
Lukas Fleischer committed
282
283
    def get_body(self, lang):
        body = self._l10n.translate(
284
285
286
                'Your package {pkgbase} [1] has been flagged out-of-date by '
                '{user} [2]:', lang).format(pkgbase=self._pkgbase,
                                            user=self._user)
287
288
289
290
291
292
293
294
295
296
297
298
        body += '\n\n' + self._text
        return body

    def get_refs(self):
        return (aur_location + '/pkgbase/' + self._pkgbase + '/',
                aur_location + '/account/' + self._user + '/')


class OwnershipEventNotification(Notification):
    def __init__(self, conn, uid, pkgbase_id):
        self._user = username_from_id(conn, uid)
        self._pkgbase = pkgbase_from_id(conn, pkgbase_id)
Lukas Fleischer's avatar
Lukas Fleischer committed
299
300
        cur = conn.execute('SELECT DISTINCT Users.Email, ' +
                           'Users.LangPreference FROM Users ' +
301
302
303
304
305
306
                           'INNER JOIN PackageNotifications ' +
                           'ON PackageNotifications.UserID = Users.ID WHERE ' +
                           'Users.OwnershipNotify = 1 AND ' +
                           'PackageNotifications.UserID != ? AND ' +
                           'PackageNotifications.PackageBaseID = ?',
                           [uid, pkgbase_id])
Lukas Fleischer's avatar
Lukas Fleischer committed
307
        self._recipients = cur.fetchall()
308
309
310
        cur = conn.execute('SELECT FlaggerComment FROM PackageBases WHERE ' +
                           'ID = ?', [pkgbase_id])
        self._text = cur.fetchone()[0]
Lukas Fleischer's avatar
Lukas Fleischer committed
311
        super().__init__()
312
313

    def get_recipients(self):
Lukas Fleischer's avatar
Lukas Fleischer committed
314
        return self._recipients
315

Lukas Fleischer's avatar
Lukas Fleischer committed
316
    def get_subject(self, lang):
317
318
        return self._l10n.translate('AUR Ownership Notification for {pkgbase}',
                                    lang).format(pkgbase=self._pkgbase)
319
320
321
322
323
324
325

    def get_refs(self):
        return (aur_location + '/pkgbase/' + self._pkgbase + '/',
                aur_location + '/account/' + self._user + '/')


class AdoptNotification(OwnershipEventNotification):
Lukas Fleischer's avatar
Lukas Fleischer committed
326
327
    def get_body(self, lang):
        return self._l10n.translate(
328
329
                'The package {pkgbase} [1] was adopted by {user} [2].',
                lang).format(pkgbase=self._pkgbase, user=self._user)
330
331
332


class DisownNotification(OwnershipEventNotification):
333
    def get_body(self, lang):
Lukas Fleischer's avatar
Lukas Fleischer committed
334
        return self._l10n.translate(
335
336
337
                'The package {pkgbase} [1] was disowned by {user} '
                '[2].', lang).format(pkgbase=self._pkgbase,
                                     user=self._user)
338
339
340
341
342


class ComaintainershipEventNotification(Notification):
    def __init__(self, conn, uid, pkgbase_id):
        self._pkgbase = pkgbase_from_id(conn, pkgbase_id)
Lukas Fleischer's avatar
Lukas Fleischer committed
343
344
345
346
        cur = conn.execute('SELECT Email, LangPreference FROM Users ' +
                           'WHERE ID = ?', [uid])
        self._to, self._lang = cur.fetchone()
        super().__init__()
347
348

    def get_recipients(self):
Lukas Fleischer's avatar
Lukas Fleischer committed
349
        return [(self._to, self._lang)]
350

Lukas Fleischer's avatar
Lukas Fleischer committed
351
    def get_subject(self, lang):
352
353
354
        return self._l10n.translate('AUR Co-Maintainer Notification for '
                                    '{pkgbase}',
                                    lang).format(pkgbase=self._pkgbase)
355
356
357
358
359
360

    def get_refs(self):
        return (aur_location + '/pkgbase/' + self._pkgbase + '/',)


class ComaintainerAddNotification(ComaintainershipEventNotification):
Lukas Fleischer's avatar
Lukas Fleischer committed
361
362
    def get_body(self, lang):
        return self._l10n.translate(
363
364
                'You were added to the co-maintainer list of {pkgbase} [1].',
                lang).format(pkgbase=self._pkgbase)
365
366
367


class ComaintainerRemoveNotification(ComaintainershipEventNotification):
Lukas Fleischer's avatar
Lukas Fleischer committed
368
369
    def get_body(self, lang):
        return self._l10n.translate(
370
371
                'You were removed from the co-maintainer list of {pkgbase} '
                '[1].', lang).format(pkgbase=self._pkgbase)
372
373
374
375
376
377
378
379
380
381


class DeleteNotification(Notification):
    def __init__(self, conn, uid, old_pkgbase_id, new_pkgbase_id=None):
        self._user = username_from_id(conn, uid)
        self._old_pkgbase = pkgbase_from_id(conn, old_pkgbase_id)
        if new_pkgbase_id:
            self._new_pkgbase = pkgbase_from_id(conn, new_pkgbase_id)
        else:
            self._new_pkgbase = None
Lukas Fleischer's avatar
Lukas Fleischer committed
382
383
        cur = conn.execute('SELECT DISTINCT Users.Email, ' +
                           'Users.LangPreference FROM Users ' +
384
385
386
387
388
                           'INNER JOIN PackageNotifications ' +
                           'ON PackageNotifications.UserID = Users.ID WHERE ' +
                           'PackageNotifications.UserID != ? AND ' +
                           'PackageNotifications.PackageBaseID = ?',
                           [uid, old_pkgbase_id])
Lukas Fleischer's avatar
Lukas Fleischer committed
389
390
        self._recipients = cur.fetchall()
        super().__init__()
391
392

    def get_recipients(self):
Lukas Fleischer's avatar
Lukas Fleischer committed
393
        return self._recipients
394

Lukas Fleischer's avatar
Lukas Fleischer committed
395
    def get_subject(self, lang):
396
397
        return self._l10n.translate('AUR Package deleted: {pkgbase}',
                                    lang).format(pkgbase=self._old_pkgbase)
398

Lukas Fleischer's avatar
Lukas Fleischer committed
399
    def get_body(self, lang):
400
        if self._new_pkgbase:
Lukas Fleischer's avatar
Lukas Fleischer committed
401
402
            dnlabel = self._l10n.translate('Disable notifications', lang)
            return self._l10n.translate(
403
                    '{user} [1] merged {old} [2] into {new} [3].\n\n'
404
                    '-- \n'
Lukas Fleischer's avatar
Lukas Fleischer committed
405
                    'If you no longer wish receive notifications about the '
406
407
408
                    'new package, please go to [3] and click "{label}".',
                    lang).format(user=self._user, old=self._old_pkgbase,
                                 new=self._new_pkgbase, label=dnlabel)
409
        else:
Lukas Fleischer's avatar
Lukas Fleischer committed
410
            return self._l10n.translate(
411
                    '{user} [1] deleted {pkgbase} [2].\n\n'
Lukas Fleischer's avatar
Lukas Fleischer committed
412
                    'You will no longer receive notifications about this '
413
414
                    'package.', lang).format(user=self._user,
                                             pkgbase=self._old_pkgbase)
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444

    def get_refs(self):
        refs = (aur_location + '/account/' + self._user + '/',
                aur_location + '/pkgbase/' + self._old_pkgbase + '/')
        if self._new_pkgbase:
            refs += (aur_location + '/pkgbase/' + self._new_pkgbase + '/',)
        return refs


class RequestOpenNotification(Notification):
    def __init__(self, conn, uid, reqid, reqtype, pkgbase_id, merge_into=None):
        self._user = username_from_id(conn, uid)
        self._pkgbase = pkgbase_from_id(conn, pkgbase_id)
        cur = conn.execute('SELECT DISTINCT Users.Email FROM PackageRequests ' +
                           'INNER JOIN PackageBases ' +
                           'ON PackageBases.ID = PackageRequests.PackageBaseID ' +
                           'INNER JOIN Users ' +
                           'ON Users.ID = PackageRequests.UsersID ' +
                           'OR Users.ID = PackageBases.MaintainerUID ' +
                           'WHERE PackageRequests.ID = ?', [reqid])
        self._to = aurweb.config.get('options', 'aur_request_ml')
        self._cc = [row[0] for row in cur.fetchall()]
        cur = conn.execute('SELECT Comments FROM PackageRequests WHERE ID = ?',
                           [reqid])
        self._text = cur.fetchone()[0]
        self._reqid = int(reqid)
        self._reqtype = reqtype
        self._merge_into = merge_into

    def get_recipients(self):
Lukas Fleischer's avatar
Lukas Fleischer committed
445
        return [(self._to, 'en')]
446

Lukas Fleischer's avatar
Lukas Fleischer committed
447
    def get_subject(self, lang):
448
449
450
        return '[PRQ#%d] %s Request for %s' % \
               (self._reqid, self._reqtype.title(), self._pkgbase)

Lukas Fleischer's avatar
Lukas Fleischer committed
451
    def get_body(self, lang):
452
453
454
455
456
        if self._merge_into:
            body = '%s [1] filed a request to merge %s [2] into %s [3]:' % \
                   (self._user, self._pkgbase, self._merge_into)
            body += '\n\n' + self._text
        else:
457
458
459
            an = 'an' if self._reqtype[0] in 'aeiou' else 'a'
            body = '%s [1] filed %s %s request for %s [2]:' % \
                   (self._user, an, self._reqtype, self._pkgbase)
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
            body += '\n\n' + self._text
        return body

    def get_refs(self):
        refs = (aur_location + '/account/' + self._user + '/',
                aur_location + '/pkgbase/' + self._pkgbase + '/')
        if self._merge_into:
            refs += (aur_location + '/pkgbase/' + self._merge_into + '/',)
        return refs

    def get_headers(self):
        thread_id = '<pkg-request-' + str(self._reqid) + '@aur.archlinux.org>'
        # Use a deterministic Message-ID for the first email referencing a
        # request.
        headers = headers_msgid(thread_id)
        headers.update(headers_cc(self._cc))
        return headers


class RequestCloseNotification(Notification):
    def __init__(self, conn, uid, reqid, reason):
        self._user = username_from_id(conn, uid) if int(uid) else None
        cur = conn.execute('SELECT DISTINCT Users.Email FROM PackageRequests ' +
                           'INNER JOIN PackageBases ' +
                           'ON PackageBases.ID = PackageRequests.PackageBaseID ' +
                           'INNER JOIN Users ' +
                           'ON Users.ID = PackageRequests.UsersID ' +
                           'OR Users.ID = PackageBases.MaintainerUID ' +
                           'WHERE PackageRequests.ID = ?', [reqid])
        self._to = aurweb.config.get('options', 'aur_request_ml')
        self._cc = [row[0] for row in cur.fetchall()]
491
492
493
494
495
496
497
498
        cur = conn.execute('SELECT PackageRequests.ClosureComment, ' +
                           'RequestTypes.Name, ' +
                           'PackageRequests.PackageBaseName ' +
                           'FROM PackageRequests ' +
                           'INNER JOIN RequestTypes ' +
                           'ON RequestTypes.ID = PackageRequests.ReqTypeID ' +
                           'WHERE PackageRequests.ID = ?', [reqid])
        self._text, self._reqtype, self._pkgbase = cur.fetchone()
499
500
501
502
        self._reqid = int(reqid)
        self._reason = reason

    def get_recipients(self):
Lukas Fleischer's avatar
Lukas Fleischer committed
503
        return [(self._to, 'en')]
504

Lukas Fleischer's avatar
Lukas Fleischer committed
505
    def get_subject(self, lang):
506
507
508
509
        return '[PRQ#%d] %s Request for %s %s' % (self._reqid,
                                                  self._reqtype.title(),
                                                  self._pkgbase,
                                                  self._reason.title())
510

Lukas Fleischer's avatar
Lukas Fleischer committed
511
    def get_body(self, lang):
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
        if self._user:
            body = 'Request #%d has been %s by %s [1]' % \
                   (self._reqid, self._reason, self._user)
        else:
            body = 'Request #%d has been %s automatically by the Arch User ' \
                   'Repository package request system' % \
                   (self._reqid, self._reason)
        if self._text.strip() == '':
            body += '.'
        else:
            body += ':\n\n' + self._text
        return body

    def get_refs(self):
        if self._user:
            return (aur_location + '/account/' + self._user + '/',)
        else:
            return ()

    def get_headers(self):
        thread_id = '<pkg-request-' + str(self._reqid) + '@aur.archlinux.org>'
        headers = headers_reply(thread_id)
        headers.update(headers_cc(self._cc))
        return headers


class TUVoteReminderNotification(Notification):
    def __init__(self, conn, vote_id):
        self._vote_id = int(vote_id)
Lukas Fleischer's avatar
Lukas Fleischer committed
541
        cur = conn.execute('SELECT Email, LangPreference FROM Users ' +
542
543
544
                           'WHERE AccountTypeID IN (2, 4) AND ID NOT IN ' +
                           '(SELECT UserID FROM TU_Votes ' +
                           'WHERE TU_Votes.VoteID = ?)', [vote_id])
Lukas Fleischer's avatar
Lukas Fleischer committed
545
546
        self._recipients = cur.fetchall()
        super().__init__()
547
548

    def get_recipients(self):
Lukas Fleischer's avatar
Lukas Fleischer committed
549
        return self._recipients
550

Lukas Fleischer's avatar
Lukas Fleischer committed
551
    def get_subject(self, lang):
552
553
        return self._l10n.translate('TU Vote Reminder: Proposal {id}',
                                    lang).format(id=self._vote_id)
554

Lukas Fleischer's avatar
Lukas Fleischer committed
555
556
    def get_body(self, lang):
        return self._l10n.translate(
557
558
559
                'Please remember to cast your vote on proposal {id} [1]. '
                'The voting period ends in less than 48 hours.',
                lang).format(id=self._vote_id)
560
561
562

    def get_refs(self):
        return (aur_location + '/tu/?id=' + str(self._vote_id),)
563
564


565
def main():
566
567
    action = sys.argv[1]
    action_map = {
568
569
570
571
572
573
574
575
576
577
578
579
580
        'send-resetkey': ResetKeyNotification,
        'welcome': WelcomeNotification,
        'comment': CommentNotification,
        'update': UpdateNotification,
        'flag': FlagNotification,
        'adopt': AdoptNotification,
        'disown': DisownNotification,
        'comaintainer-add': ComaintainerAddNotification,
        'comaintainer-remove': ComaintainerRemoveNotification,
        'delete': DeleteNotification,
        'request-open': RequestOpenNotification,
        'request-close': RequestCloseNotification,
        'tu-vote-reminder': TUVoteReminderNotification,
581
582
    }

Lukas Fleischer's avatar
Lukas Fleischer committed
583
    conn = aurweb.db.Connection()
584

585
586
    notification = action_map[action](conn, *sys.argv[2:])
    notification.send()
587

Lukas Fleischer's avatar
Lukas Fleischer committed
588
589
    conn.commit()
    conn.close()
590
591
592
593


if __name__ == '__main__':
    main()