Barry Warsaw pushed to branch master at mailman / Mailman
Commits:
33a64ede by Aurélien Bompard at 2015-12-15T19:45:45Z
Add a couple indexes on Member
- - - - -
2 changed files:
- + src/mailman/database/alembic/versions/3e09bb4a5dc_member_indexes.py
- src/mailman/model/member.py
Changes:
=====================================
src/mailman/database/alembic/versions/3e09bb4a5dc_member_indexes.py
=====================================
--- /dev/null
+++ b/src/mailman/database/alembic/versions/3e09bb4a5dc_member_indexes.py
@@ -0,0 +1,25 @@
+"""Add indexes on the Member table.
+
+Revision ID: 3e09bb4a5dc
+Revises: 33bc0099223
+Create Date: 2015-12-11 19:16:57.030395
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = '3e09bb4a5dc'
+down_revision = '33bc0099223'
+
+from alembic import op
+
+
+def upgrade():
+ op.create_index(
+ op.f('ix_member_list_id'), 'member', ['list_id'], unique=False)
+ op.create_index(
+ op.f('ix_member_role'), 'member', ['role'], unique=False)
+
+
+def downgrade():
+ op.drop_index(op.f('ix_member_role'), table_name='member')
+ op.drop_index(op.f('ix_member_list_id'), table_name='member')
=====================================
src/mailman/model/member.py
=====================================
--- a/src/mailman/model/member.py
+++ b/src/mailman/model/member.py
@@ -53,8 +53,8 @@ class Member(Model):
id = Column(Integer, primary_key=True)
_member_id = Column(UUID)
- role = Column(Enum(MemberRole))
- list_id = Column(Unicode)
+ role = Column(Enum(MemberRole), index=True)
+ list_id = Column(Unicode, index=True)
moderation_action = Column(Enum(Action))
address_id = Column(Integer, ForeignKey('address.id'), index=True)
View it on GitLab:
https://gitlab.com/mailman/mailman/commit/33a64ede9aa2a6b6c5ebbbbbfbf789bc4d41e3f2
_______________________________________________
Mailman-checkins mailing list
Mailman-checkins@python.org
Unsubscribe:
https://mail.python.org/mailman/options/mailman-checkins/archive%40jab.org
