1 """Add allow_reload to ps_transports
3 Revision ID: 3bcc0b5bc2c9
5 Create Date: 2016-02-05 17:43:39.183785
10 revision =
'3bcc0b5bc2c9'
11 down_revision =
'dbc44d5a908'
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']
21 yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=
False)
22 op.add_column(
'ps_transports', sa.Column(
'allow_reload', yesno_values))
25 if op.get_context().bind.dialect.name ==
'mssql':
26 op.drop_constraint(
'ck_ps_transports_allow_reload_yesno_values',
'ps_transports')
27 op.drop_column(
'ps_transports',
'allow_reload')