Asterisk - The Open Source Telephony Project
GIT-master-f36a736
contrib
ast-db-manage
config
versions
f638dbe2eb23_symmetric_transport.py
Go to the documentation of this file.
1
"""symmetric_transport
2
3
Revision ID: f638dbe2eb23
4
Revises: 15db7b91a97a
5
Create Date: 2017-03-09 09:38:59.513479
6
7
"""
8
9
# revision identifiers, used by Alembic.
10
revision =
'f638dbe2eb23'
11
down_revision =
'15db7b91a97a'
12
13
from
alembic
import
op
14
import
sqlalchemy
as
sa
15
from
sqlalchemy.dialects.postgresql
import
ENUM
16
17
YESNO_NAME =
'yesno_values'
18
YESNO_VALUES = [
'yes'
,
'no'
]
19
20
def
upgrade
():
21
############################# Enums ##############################
22
23
# yesno_values have already been created, so use postgres enum object
24
# type to get around "already created" issue - works okay with mysql
25
yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=
False
)
26
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)))
29
30
def
downgrade
():
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'
)
f638dbe2eb23_symmetric_transport.upgrade
def upgrade()
Definition:
f638dbe2eb23_symmetric_transport.py:20
f638dbe2eb23_symmetric_transport.downgrade
def downgrade()
Definition:
f638dbe2eb23_symmetric_transport.py:30
Generated on Wed Dec 18 2024 20:04:15 for Asterisk - The Open Source Telephony Project by
1.9.4