src/mailman/database/alembic/versions/15401063d4e3_roster_visibility.py

   1 """roster_visibility
   2
   3 Revision ID: 15401063d4e3
   4 Revises: b2e694dfde35
   5 Create Date: 2019-01-20 20:45:50.773097
   6
   7 """
   8
   9 # revision identifiers, used by Alembic.
  10
  11 import sqlalchemy as sa
  12
  13 from alembic import op
  14 from mailman.database.helpers import exists_in_db, is_sqlite
  15
  16 revision = '15401063d4e3'
  17 down_revision = 'b2e694dfde35'
  18
  19
  20 def upgrade():
  21     # ### commands auto generated by Alembic - please adjust! ###
  22     if not exists_in_db(
  23             op.get_bind(), 'mailinglist', 'member_roster_visibility'):
  24         op.add_column(                                       # pragma: nocover
  25             'mailinglist',
  26             sa.Column('member_roster_visibility', sa.Integer(), nullable=True))
  27
  28
  29 def downgrade():
  30     # ### commands auto generated by Alembic - please adjust! ###
  31     if not is_sqlite(op.get_bind()):
  32         op.drop_column('mailinglist', 'member_roster_visibility')   # noqa: E501 # pragma: nocover