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
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
# Copyright (C) 2012 by the Free Software Foundation, Inc.
#
# This file is part of GNU Mailman.
#
# GNU Mailman 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 3 of the License, or (at your option)
# any later version.
#
# GNU Mailman 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
# GNU Mailman. If not, see <http://www.gnu.org/licenses/>.
"""Test schema migrations."""
from __future__ import absolute_import, print_function, unicode_literals
__metaclass__ = type
__all__ = [
'TestMigration20120407',
]
import os
import shutil
import sqlite3
import tempfile
import unittest
from pkg_resources import resource_filename
from zope.component import getUtility
from mailman.config import config
from mailman.interfaces.domain import IDomainManager
from mailman.interfaces.listmanager import IListManager
from mailman.interfaces.mailinglist import IAcceptableAliasSet
from mailman.testing.helpers import configuration
from mailman.testing.layers import ConfigLayer
from mailman.utilities.modules import call_name
class TestMigration20120407(unittest.TestCase):
"""Test the dated migration (LP: #971013)
Circa: 3.0b1 -> 3.0b2
table mailinglist:
* news_moderation -> newsgroup_moderation
* news_prefix_subject_too -> nntp_prefix_subject_too
* ADD archive_policy
* REMOVE archive
* REMOVE archive_private
* REMOVE archive_volume_frequency
* REMOVE nntp_host
"""
layer = ConfigLayer
def setUp(self):
self._tempdir = tempfile.mkdtemp()
def tearDown(self):
shutil.rmtree(self._tempdir)
def test_sqlite_base(self):
# Test that before the migration, the old table columns are present
# and the new database columns are not.
url = 'sqlite:///' + os.path.join(self._tempdir, 'mailman.db')
database_class = config.database['class']
database = call_name(database_class)
with configuration('database', url=url):
database.initialize()
# Load all the database SQL to just before ours.
database.load_migrations('20120406999999')
# Verify that the database has not yet been migrated.
for missing in ('archive_policy',
'nntp_prefix_subject_too'):
self.assertRaises(sqlite3.OperationalError,
database.store.execute,
'select {0} from mailinglist;'.format(missing))
for present in ('archive',
'archive_private',
'archive_volume_frequency',
'news_moderation',
'news_prefix_subject_too',
'nntp_host'):
# This should not produce an exception. Is there some better test
# that we can perform?
database.store.execute(
'select {0} from mailinglist;'.format(present))
def test_sqlite_migration(self):
# Test that after the migration, the old table columns are missing
# and the new database columns are present.
url = 'sqlite:///' + os.path.join(self._tempdir, 'mailman.db')
database_class = config.database['class']
database = call_name(database_class)
with configuration('database', url=url):
database.initialize()
# Load all the database SQL to just before ours.
database.load_migrations('20120406999999')
# Load all migrations, up to and including this one.
database.load_migrations('20120407000000')
# Verify that the database has been migrated.
for present in ('archive_policy',
'nntp_prefix_subject_too'):
# This should not produce an exception. Is there some better test
# that we can perform?
database.store.execute(
'select {0} from mailinglist;'.format(present))
for missing in ('archive',
'archive_private',
'archive_volume_frequency',
'news_moderation',
'news_prefix_subject_too',
'nntp_host'):
self.assertRaises(sqlite3.OperationalError,
database.store.execute,
'select {0} from mailinglist;'.format(missing))
def test_data_after_migration(self):
# Ensure that the existing data and foreign key references are
# preserved across a migration. Unfortunately, this requires sample
# data, which kind of sucks.
dst = os.path.join(self._tempdir, 'mailman.db')
src = resource_filename('mailman.database.tests.data', 'mailman_01.db')
shutil.copyfile(src, dst)
url = 'sqlite:///' + dst
database_class = config.database['class']
database = call_name(database_class)
with configuration('database', url=url):
# Initialize the database and perform the migrations.
database.initialize()
database.load_migrations('20120407000000')
# Check that the domains survived the migration. This table was
# not touched so it should be fine.
domains = list(getUtility(IDomainManager))
self.assertEqual(len(domains), 1)
self.assertEqual(domains[0].mail_host, 'example.com')
# There should be exactly one mailing list defined.
mlists = list(getUtility(IListManager).mailing_lists)
self.assertEqual(len(mlists), 1)
# Get the mailing list object and check its acceptable aliases.
# This tests that foreign keys continue to work.
aliases_set = IAcceptableAliasSet(mlists)
self.assertEqual(set(aliases_set.aliases),
set(['foo@example.com', 'bar@example.com']))
|
