1 """add prune_on_boot to ps_subscription_persistence
3 Revision ID: d3e4284f8707
5 Create Date: 2018-01-28 17:45:36.218123
10 revision =
'd3e4284f8707'
11 down_revision =
'52798ad97bdf'
13 from alembic
import op
14 import sqlalchemy
as sa
15 from sqlalchemy.dialects.postgresql
import ENUM
17 YESNO_NAME =
'yesno_values'
18 YESNO_VALUES = [
'yes',
'no']
26 yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=
False)
28 op.add_column(
'ps_subscription_persistence', sa.Column(
'prune_on_boot', yesno_values))
31 if op.get_context().bind.dialect.name ==
'mssql':
32 op.drop_constraint(
'ck_ps_subscription_persistence_prune_on_boot_yesno_values',
'ps_subscription_persistence')
33 op.drop_column(
'ps_subscription_persistence',
'prune_on_boot')