3 Revision ID: f638dbe2eb23
5 Create Date: 2017-03-09 09:38:59.513479
10 revision =
'f638dbe2eb23'
11 down_revision =
'15db7b91a97a'
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']
25 yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=
False)
27 op.add_column(
'ps_transports', sa.Column(
'symmetric_transport', yesno_values))
28 op.add_column(
'ps_subscription_persistence', sa.Column(
'contact_uri', sa.String(256)))
31 op.drop_column(
'ps_subscription_persistence',
'contact_uri')
32 if op.get_context().bind.dialect.name ==
'mssql':
33 op.drop_constraint(
'ck_ps_transports_symmetric_transport_yesno_values',
'ps_transports')
34 op.drop_column(
'ps_transports',
'symmetric_transport')