diff options
| -rw-r--r-- | src/mailman/database/alembic/versions/a46993b05703_increase_pendedkeyvalue_value_size.py | 27 | ||||
| -rw-r--r-- | src/mailman/model/pending.py | 4 | ||||
| -rw-r--r-- | tox.ini | 1 |
3 files changed, 30 insertions, 2 deletions
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): @@ -43,6 +43,7 @@ commands = python setup.py build_sphinx deps: sphinx + docutils==0.12 [coverage] rcfile = {toxinidir}/coverage.ini |