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
|
# -*- coding: utf-8 -*-
# pylint: disable=R0904,C0103
# - Too many public methods
# - Invalid name XXX (should match YYY)
import unittest
import email
import datetime
from storm.exceptions import IntegrityError
from mailman.email.message import Message
from kittystore.storm import get_storm_store
from kittystore.storm.model import Email, Attachment
from kittystore.test import get_test_file
class FakeList(object):
# pylint: disable=R0903
# (Too few public methods)
def __init__(self, name):
self.fqdn_listname = name
self.display_name = None
class TestStormStore(unittest.TestCase):
def setUp(self):
self.store = get_storm_store("sqlite:")
def tearDown(self):
self.store.close()
def test_no_message_id(self):
msg = Message()
self.assertRaises(ValueError, self.store.add_to_list,
FakeList("example-list"), msg)
def test_no_date(self):
msg = Message()
msg["From"] = "dummy@example.com"
msg["Message-ID"] = "<dummy>"
msg.set_payload("Dummy message")
now = datetime.datetime.now()
try:
self.store.add_to_list(FakeList("example-list"), msg)
except IntegrityError, e:
self.fail(e)
stored_msg = self.store.db.find(Email).one()
self.assertTrue(stored_msg.date >= now)
def test_date_naive(self):
msg = Message()
msg["From"] = "dummy@example.com"
msg["Message-ID"] = "<dummy>"
msg["Date"] = "Fri, 02 Nov 2012 16:07:54"
msg.set_payload("Dummy message")
try:
self.store.add_to_list(FakeList("example-list"), msg)
except IntegrityError, e:
self.fail(e)
stored_msg = self.store.db.find(Email).one()
expected = datetime.datetime(2012, 11, 2, 16, 7, 54)
self.assertEqual(stored_msg.date, expected)
def test_attachment_insert_order(self):
"""Attachments must not be inserted in the DB before the email"""
# Re-activate foreign key support in sqlite
self.store.db._connection._raw_connection.isolation_level = 'IMMEDIATE'
self.store.db.execute("PRAGMA foreign_keys = ON")
self.store.db._connection._raw_connection.execute("PRAGMA foreign_keys = ON")
#print "*"*10, list(self.store.db.execute("PRAGMA foreign_keys"))
#self.store = get_storm_store("postgres://kittystore:kittystore@localhost/kittystore_test")
with open(get_test_file("attachment-1.txt")) as email_file:
msg = email.message_from_file(email_file, _class=Message)
try:
self.store.add_to_list(FakeList("example-list"), msg)
except IntegrityError, e:
self.fail(e)
self.assertEqual(self.store.db.find(Email).count(), 1)
self.assertEqual(self.store.db.find(Attachment).count(), 1)
#def test_non_ascii_payload(self):
# """add_to_list must handle non-ascii messages"""
# with open(get_test_file("non-ascii-payload.txt")) as email_file:
# msg = email.message_from_file(email_file)
# self.store.add_to_list("example-list", msg)
# try:
# self.store.session.flush()
# except ProgrammingError, e:
# self.fail(e)
# print msg.items()
# email_table = get_class_object(list_to_table_name("example-list"), 'email',
# self.store.metadata)
# emails = self.store.session.query(email_table).all()
# for e in emails:
# print e.content
#def test_non_ascii_headers(self):
# """add_to_list must handle non-ascii headers"""
# mbox = mailbox.mbox(get_test_file("non-ascii-headers.txt"))
# for msg in mbox:
# self.store.add_to_list("example-list", msg)
# self.store.session.flush()
# email_table = get_class_object(list_to_table_name("example-list"), 'email',
# self.store.metadata)
# for msg in self.store.session.query(email_table).all():
# print repr(msg.sender), repr(msg.subject)
# self.failIf("=?" in msg.sender,
# "From header not decoded: %s" % msg.sender)
# self.failIf("=?" in msg.subject,
# "Subject header not decoded: %s" % msg.sender)
|