1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
# Copyright (C) 2007 by the Free Software Foundation, Inc.
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301,
# USA.
"""Implementations of the IRequests and IListRequests interfaces."""
from datetime import timedelta
from elixir import *
from zope.interface import implements
from Mailman.configuration import config
from Mailman.database.types import EnumType
from Mailman.interfaces import IListRequests, IPendable, IRequests, RequestType
MAILINGLIST_KIND = 'Mailman.database.model.mailinglist.MailingList'
__metaclass__ = type
__all__ = [
'Requests',
]
class DataPendable(dict):
implements(IPendable)
class ListRequests:
implements(IListRequests)
def __init__(self, mailing_list):
self.mailing_list = mailing_list
@property
def count(self):
return _Request.query.filter_by(mailing_list=self.mailing_list).count()
def count_of(self, request_type):
return _Request.query.filter_by(mailing_list=self.mailing_list,
type=request_type).count()
@property
def held_requests(self):
results = _Request.query.filter_by(mailing_list=self.mailing_list)
for request in results:
yield request
def of_type(self, request_type):
results = _Request.query.filter_by(mailing_list=self.mailing_list,
type=request_type)
for request in results:
yield request
def hold_request(self, request_type, key, data=None):
if request_type not in RequestType:
raise TypeError(request_type)
if data is None:
data_hash = None
else:
# We're abusing the pending database as a way of storing arbitrary
# key/value pairs, where both are strings. This isn't ideal but
# it lets us get auxiliary data almost for free. We may need to
# lock this down more later.
pendable = DataPendable()
pendable.update(data)
token = config.db.pendings.add(pendable, timedelta(days=5000))
data_hash = token
# XXX This would be a good other way to do it, but it causes the
# select_by()'s in .count and .held_requests() to fail, even with
# flush()'s.
## result = _Request.table.insert().execute(
## key=key, type=request_type,
## mailing_list=self.mailing_list,
## data_hash=data_hash)
## row_id = result.last_inserted_ids()[0]
## return row_id
result = _Request(key=key, type=request_type,
mailing_list=self.mailing_list,
data_hash=data_hash)
# XXX We need a handle on last_inserted_ids() instead of requiring a
# flush of the database to get a valid id.
config.db.flush()
return result.id
def get_request(self, request_id):
result = _Request.get(request_id)
if result is None:
return None
if result.data_hash is None:
return result.key, result.data_hash
pendable = config.db.pendings.confirm(result.data_hash, expunge=False)
data = dict()
data.update(pendable)
return result.key, data
def delete_request(self, request_id):
result = _Request.get(request_id)
if result is None:
raise KeyError(request_id)
# Throw away the pended data.
config.db.pendings.confirm(result.data_hash)
result.delete()
class Requests:
implements(IRequests)
def get_list_requests(self, mailing_list):
return ListRequests(mailing_list)
class _Request(Entity):
"""Table for mailing list hold requests."""
key = Field(Unicode)
type = Field(EnumType)
data_hash = Field(Unicode)
# Relationships
mailing_list = ManyToOne(MAILINGLIST_KIND)
|
