60
def _parse_message(message):
61
"""Get a date and dict of an RFC822 message."""
62
parsed = email.parser.Parser().parsestr(message)
65
for key in ('from', 'to', 'subject', 'message-id'):
66
value = parsed.get(key, None)
68
message_dict[key] = value
70
date = parsed.get('date')
73
pdate = parsedate_tz(date)
74
date = datetime.datetime(
76
tzinfo=dateutil.tz.tzoffset('', pdate[9]))
79
message_dict['date'] = date.isoformat() if date is not None else None
81
return date, message_dict
84
def _utc_datetime(dt):
85
return dt.astimezone(dateutil.tz.tzutc())
88
def _utc_timestamp(dt):
89
return calendar.timegm(_utc_datetime(dt).timetuple())
92
def _utc_timeuuid(dt, lowest_val=True):
93
return convert_time_to_uuid(_utc_timestamp(dt), lowest_val)
96
def _cmp_timeuuid(a, b):
98
return cmp(a.time, b.time)
102
def _bound_timeuuid(a, b, max=False):
103
if a == '' or _cmp_timeuuid(b, a) == (1 if max else -1):
108
def _make_bounds(memo, range_start, range_finish, backward):
111
memo = uuid.UUID(memo)
116
if range_start is not None:
117
start = _bound_timeuuid(
118
start, _utc_timeuuid(range_start), max=True)
119
if range_finish is not None:
120
finish = _bound_timeuuid(
121
finish, _utc_timeuuid(range_finish, lowest_val=False))
122
return memo, start, finish
125
LEGAL_HEADERS = set([
126
'date', 'from', 'subject', 'message-id',
130
def _format_message(message, headers=[], include_raw=False):
134
assert not set(headers).difference(LEGAL_HEADERS)
136
for header in headers:
137
hdict[header] = message.get(header)
138
data['headers'] = hdict
141
data['raw'] = message['raw']
54
146
class CassandraConnection(object):
56
def __init__(self, keyspace, host):
148
def __init__(self, keyspace, hosts):
57
149
self._keyspace = keyspace
59
151
self._connection = self._connect()
152
self._pool = self._connect()
60
153
self.messages = self._column_family('message')
61
154
self.archive_messages = self._column_family('archive_message')
63
156
def _connect(self):
64
return pycassa.connect(self._keyspace, self._host)
157
return pycassa.pool.ConnectionPool(self._keyspace, self._hosts)
66
159
def _column_family(self, name):
67
return pycassa.ColumnFamily(self._connection, name)
160
return pycassa.ColumnFamily(self._pool, name)
69
162
def add_message(self, archive_uuid, message):
70
163
message_uuid = uuid.uuid4()
71
parsed = email.parser.Parser().parsestr(message)
72
date = parsed.get('date')
75
pdate = parsedate_tz(date)
76
date = datetime.datetime(
78
tzinfo=dateutil.tz.tzoffset('', pdate[9]))
83
{'date_created': datetime.datetime.utcnow().isoformat() + 'Z',
85
'from': parsed.get('From'),
86
'to': parsed.get('To'),
87
'subject': parsed.get('Subject'),
88
'date': date.isoformat() if date is not None else None,
89
'message_id': parsed.get('Message-ID'),
164
message_date, message_dict = _parse_message(message)
165
message_dict['raw'] = message
166
message_dict['date_created'] = (
167
datetime.datetime.utcnow().isoformat() + 'Z')
168
self.messages.insert(message_uuid, message_dict)
91
169
self.archive_messages.insert(
93
{date.astimezone(dateutil.tz.tzutc()): message_uuid})
171
{_utc_timestamp(message_date): message_uuid})
95
'Imported %s into %s' % (parsed.get('Message-ID'), archive_uuid))
173
'Imported %s into %s'
174
% (message_dict.get('message-id', None), archive_uuid))
96
175
return message_uuid
98
def _format_message(self, message):
100
'date': message['date'],
101
'from': message['from'],
102
'subject': message['subject'],
105
def get_messages(self, archive_uuid, order, count, start):
177
def _trim(self, sequence, end):
178
"""Return the sequence with one of the ends trimmed.
180
:param end: if true, remove the last element. otherwise remove
188
def get_messages(self, archive_uuid, order, count, memo, backward=False,
189
start_date=None, finish_date=None, format='all',
190
headers=['from', 'date', 'subject', 'message-id']):
106
191
if order in ("date", "-date"):
107
192
reversed = order[0] == '-'
109
194
raise AssertionError("Unsupported order.")
196
memo, start, finish = _make_bounds(
197
memo, start_date, finish_date, backward)
199
# Get up to n+1 messages from the memo: the last item of the
200
# previous batch (because that's where the memo starts) + this
110
202
pairs = self.archive_messages.get(
111
archive_uuid, column_count=count + 1,
112
column_start=start, column_reversed=reversed).items()
203
archive_uuid, column_count=count + 1, column_start=start,
204
column_finish=finish, column_reversed=reversed).items()
206
if len(pairs) and memo and pairs[0][0] <= memo:
207
# The memo (from the previous batch) was included in the result.
209
pairs = self._trim(pairs, False ^ backward)
210
elif len(pairs) > count:
211
# There was no memo in the result, so the n+1th element is
212
# unnecessary. Kill it.
213
pairs = self._trim(pairs, True ^ backward)
216
return (None, [], None)
218
assert 0 < len(pairs) <= count
220
# We've narrowed down the message references. Fetch the messages.
113
221
ids = [v for k, v in pairs]
114
messages = self.messages.multiget(
115
ids, columns=['date', 'from', 'subject'])
116
actual_count = len(pairs)
117
if len(pairs) > count:
118
assert len(pairs) == count + 1
120
next_memo = str(pairs[count][0])
222
formatter = functools.partial(
223
_format_message, headers=headers, include_raw=True)
224
# XXX: No need to get all columns. Restrict based on format.
225
messages = self.messages.multiget(ids)
124
[self._format_message(messages[id]) for id in ids[:actual_count]],
229
[formatter(messages[id]) for id in ids],