1"""Add peer_supported to 100rel
3Revision ID: 539f68bede2c
5Create Date: 2022-08-10 09:36:16.576049
10revision =
'539f68bede2c'
11down_revision =
'9f3692b1654b'
14from sqlalchemy.dialects.postgresql
import ENUM
15import sqlalchemy
as sa
18OLD_ENUM = [
'no',
'required',
'yes']
19NEW_ENUM = [
'no',
'required',
'peer_supported',
'yes']
21old_type = sa.Enum(*OLD_ENUM, name=
'pjsip_100rel_values')
22new_type = sa.Enum(*NEW_ENUM, name=
'pjsip_100rel_values_v2')
25 context = op.get_context()
28 if context.bind.dialect.name !=
'postgresql':
29 op.alter_column(
'ps_endpoints',
'100rel',
31 existing_type=old_type)
33 enum = ENUM(*NEW_ENUM, name=
'pjsip_100rel_values_v2')
34 enum.create(op.get_bind(), checkfirst=
False)
36 op.execute(
'ALTER TABLE ps_endpoints ALTER COLUMN "100rel" TYPE'
37 ' pjsip_100rel_values_v2 USING'
38 ' "100rel"::text::pjsip_100rel_values_v2')
40 ENUM(name=
"pjsip_100rel_values").drop(op.get_bind(), checkfirst=
False)
43 context = op.get_context()
45 if context.bind.dialect.name !=
'postgresql':
46 op.alter_column(
'ps_endpoints',
'100rel',
48 existing_type=new_type)
50 enum = ENUM(*OLD_ENUM, name=
'pjsip_100rel_values')
51 enum.create(op.get_bind(), checkfirst=
False)
53 op.execute(
'ALTER TABLE ps_endpoints ALTER COLUMN "100rel" TYPE'
54 ' pjsip_100rel_values USING'
55 ' "100rel"::text::pjsip_100rel_values')
57 ENUM(name=
"pjsip_100rel_values_v2").drop(op.get_bind(), checkfirst=
False)