From 7d21dbe2d745fa81d19cd3bacbb0e1669d439638 Mon Sep 17 00:00:00 2001
From: Mark Sapiro
Date: Thu, 15 Dec 2016 21:05:09 -0800
Subject: Increase pendedkeyvalue table value column width. Also require
 docutils==0.12 to work around
 https://github.com/sphinx-doc/sphinx/issues/3212

---
 ...993b05703_increase_pendedkeyvalue_value_size.py | 27 ++++++++++++++++++++++
 src/mailman/model/pending.py                       |  4 ++--
 2 files changed, 29 insertions(+), 2 deletions(-)
 create mode 100644 src/mailman/database/alembic/versions/a46993b05703_increase_pendedkeyvalue_value_size.py

(limited to 'src')

diff --git a/src/mailman/database/alembic/versions/a46993b05703_increase_pendedkeyvalue_value_size.py b/src/mailman/database/alembic/versions/a46993b05703_increase_pendedkeyvalue_value_size.py
new file mode 100644
index 000000000..2fd934589
--- /dev/null
+++ b/src/mailman/database/alembic/versions/a46993b05703_increase_pendedkeyvalue_value_size.py
@@ -0,0 +1,27 @@
+"""increase pendedkeyvalue value size
+
+Revision ID: a46993b05703
+Revises: 448a93984c35
+Create Date: 2016-12-15 20:43:48.520837
+
+"""
+
+from alembic import op
+from mailman.database.types import SAUnicode, SAUnicodeLarge
+
+
+# revision identifiers, used by Alembic.
+revision = 'a46993b05703'
+down_revision = '448a93984c35'
+
+
+def upgrade():
+    # Adding another rule can make the rule Hits/Misses too long for MySQL
+    # SaUnicode.
+    with op.batch_alter_table('pendedkeyvalue') as batch_op:
+        batch_op.alter_column('value', type_=SAUnicodeLarge)
+
+
+def downgrade():
+    with op.batch_alter_table('pendedkeyvalue') as batch_op:
+        batch_op.alter_column('value', type_=SAUnicode)
diff --git a/src/mailman/model/pending.py b/src/mailman/model/pending.py
index 5889f9cc1..60be56e8f 100644
--- a/src/mailman/model/pending.py
+++ b/src/mailman/model/pending.py
@@ -23,7 +23,7 @@ from lazr.config import as_timedelta
 from mailman.config import config
 from mailman.database.model import Model
 from mailman.database.transaction import dbconnection
-from mailman.database.types import SAUnicode
+from mailman.database.types import SAUnicode, SAUnicodeLarge
 from mailman.interfaces.pending import (
     IPendable, IPended, IPendedKeyValue, IPendings)
 from mailman.utilities.datetime import now
@@ -47,7 +47,7 @@ class PendedKeyValue(Model):
 
     id = Column(Integer, primary_key=True)
     key = Column(SAUnicode, index=True)
-    value = Column(SAUnicode, index=True)
+    value = Column(SAUnicodeLarge, index=True)
     pended_id = Column(Integer, ForeignKey('pended.id'), index=True)
 
     def __init__(self, key, value):
-- 
cgit v1.2.3-70-g09d2