Merge lp:~nkarageuzian/mailman/pg_update into lp:mailman

[nicolask]

Added postgreSQL schema upgrade scripts

[lp:~nkarageuzian/mailman/pg_update]

7233. By nicolask on 2013-12-31

fixing update tag

[Barry Warsaw (barry)]

Thanks for the contribution and apologies for not reviewing this earlier. I'm only rejecting it now because the port to SQLAlchemy obsoletes it.

Unmerged revisions

7233. By nicolask on 2013-12-31

fixing update tag

7232. By Nico <email address hidden> on 2013-12-03

Postgresql migration scripts (for https://bugs.launchpad.net/mailman/+bug/1236297 and for listarchivers patch)

=== added file 'src/mailman/database/schema/mm_20131007000000.py'
--- src/mailman/database/schema/mm_20131007000000.py	1970-01-01 00:00:00 +0000
+++ src/mailman/database/schema/mm_20131007000000.py	2013-12-31 11:55:54 +0000
@@ -0,0 +1,45 @@
+# Copyright (C) 2012-2013 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/>.
+
+"""3.0b3 -> 3.0b4 schema migrations.
+
+Type changes:
+ * mailinglist.moderator_password: TEXT -> BYTEA
+"""
+
+from __future__ import absolute_import, print_function, unicode_literals
+
+__metaclass__ = type
+__all__ = [
+    'upgrade',
+    ]
+
+
+VERSION = '20131007000000'
+
+
+

+def upgrade(database, store, version, module_path):
+    if database.TAG == 'sqlite':
+        return
+    store.execute("""
+        ALTER TABLE mailinglist ALTER COLUMN moderator_password TYPE BYTEA
+            USING convert_to(moderator_password, 'SQL_ASCII');
+    """)
+    # Record the migration in the version table.
+    database.load_schema(store, version, None, module_path)
+

=== added file 'src/mailman/database/schema/mm_20131203000000.py'
--- src/mailman/database/schema/mm_20131203000000.py	1970-01-01 00:00:00 +0000
+++ src/mailman/database/schema/mm_20131203000000.py	2013-12-31 11:55:54 +0000
@@ -0,0 +1,75 @@
+# Copyright (C) 2012-2013 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/>.
+
+"""3.0b3 -> 3.0b4 schema migrations.
+
+Type changes:
+ * bounceevent.list_id (NEW COLUMN)
+ * per list archiver (NEW TABLE)
+"""
+
+from __future__ import absolute_import, print_function, unicode_literals
+
+__metaclass__ = type
+__all__ = [
+    'upgrade',
+    ]
+
+
+VERSION = '20131203000000'
+
+
+

+def upgrade(database, store, version, module_path):
+    if database.TAG == 'sqlite':
+        return
+    store.execute("""
+CREATE TABLE bounceevent_backup (
+    id SERIAL NOT NULL,
+    email TEXT,
+    "timestamp" TIMESTAMP,
+    message_id TEXT,
+    context INTEGER,
+    processed BOOLEAN,
+    PRIMARY KEY (id)
+    );
+    """)
+    store.execute("""
+INSERT INTO bounceevent_backup SELECT
+    id, email, "timestamp", message_id,
+    context, processed
+    FROM bounceevent;
+    """)
+    store.execute("""
+ALTER TABLE bounceevent_backup ADD COLUMN list_id TEXT;
+    """)
+    store.execute("""
+CREATE TABLE listarchiver (
+    id SERIAL NOT NULL,
+    mailing_list_id INTEGER NOT NULL,
+    name TEXT NOT NULL,
+    _is_enabled BOOLEAN,
+    PRIMARY KEY (id)
+    );
+    """)
+    store.execute("""
+CREATE INDEX ix_listarchiver_mailing_list_id
+    ON listarchiver(mailing_list_id);
+    """)
+    # Record the migration in the version table.
+    database.load_schema(store, version, None, module_path)
+