res_pjsip_endpoint_identifier_ip: Add support for SRV lookups.
[asterisk/asterisk.git] / contrib / ast-db-manage / config / versions / 28ab27a7826d_add_srv_lookups_to_identify.py
1 """add srv_lookups to identify
2
3 Revision ID: 28ab27a7826d
4 Revises: 4468b4a91372
5 Create Date: 2017-01-06 14:53:38.829655
6
7 """
8
9 # revision identifiers, used by Alembic.
10 revision = '28ab27a7826d'
11 down_revision = '4468b4a91372'
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_endpoint_id_ips', sa.Column('srv_lookups', yesno_values))
28
29
30 def downgrade():
31     op.drop_column('ps_endpoint_id_ips', 'srv_lookups')