Functions
def	downgrade ()

def	upgrade ()

Variables
string	down_revision = 'dac2b4c328b8'

string	PJSIP_TRANSPORT_METHOD_NEW_NAME = 'pjsip_transport_method_values_v2'

	PJSIP_TRANSPORT_METHOD_NEW_TYPE

list	PJSIP_TRANSPORT_METHOD_NEW_VALUES

string	PJSIP_TRANSPORT_METHOD_OLD_NAME = 'pjsip_transport_method_values'

	PJSIP_TRANSPORT_METHOD_OLD_TYPE

list	PJSIP_TRANSPORT_METHOD_OLD_VALUES

string	revision = '37a5332640e2'

Function Documentation

◆ downgrade()

def downgrade ( )

Definition at line 43 of file 37a5332640e2_update_pjsip_tls_method_list.py.

def downgrade():
    # First we need to ensure that columns are not using the enum values
    # that are going away.
    op.execute("UPDATE ps_transports SET method = 'tlsv1' WHERE method IN ('tlsv1_1', 'tlsv1_2', 'tlsv1_3')")
 
    if op.get_context().bind.dialect.name == 'postgresql':
        enum = PJSIP_TRANSPORT_METHOD_OLD_TYPE
        enum.create(op.get_bind(), checkfirst=False)
 
    op.alter_column('ps_transports', 'method',
                    type_=PJSIP_TRANSPORT_METHOD_OLD_TYPE,
                    existing_type=PJSIP_TRANSPORT_METHOD_NEW_TYPE,
                    postgresql_using='method::text::' + PJSIP_TRANSPORT_METHOD_OLD_NAME)
 
    if op.get_context().bind.dialect.name == 'postgresql':
        ENUM(name=PJSIP_TRANSPORT_METHOD_NEW_NAME).drop(op.get_bind(), checkfirst=False)

◆ upgrade()

def upgrade ( )

Definition at line 30 of file 37a5332640e2_update_pjsip_tls_method_list.py.

def upgrade():
    if op.get_context().bind.dialect.name == 'postgresql':
        enum = PJSIP_TRANSPORT_METHOD_NEW_TYPE
        enum.create(op.get_bind(), checkfirst=False)
 
    op.alter_column('ps_transports', 'method',
                    type_=PJSIP_TRANSPORT_METHOD_NEW_TYPE,
                    existing_type=PJSIP_TRANSPORT_METHOD_OLD_TYPE,
                    postgresql_using='method::text::' + PJSIP_TRANSPORT_METHOD_NEW_NAME)
 
    if op.get_context().bind.dialect.name == 'postgresql':
        ENUM(name=PJSIP_TRANSPORT_METHOD_OLD_NAME).drop(op.get_bind(), checkfirst=False)
 

Variable Documentation

◆ down_revision

string down_revision = 'dac2b4c328b8'

Definition at line 11 of file 37a5332640e2_update_pjsip_tls_method_list.py.

◆ PJSIP_TRANSPORT_METHOD_NEW_NAME

string PJSIP_TRANSPORT_METHOD_NEW_NAME = 'pjsip_transport_method_values_v2'

Definition at line 18 of file 37a5332640e2_update_pjsip_tls_method_list.py.

◆ PJSIP_TRANSPORT_METHOD_NEW_TYPE

PJSIP_TRANSPORT_METHOD_NEW_TYPE

Initial value:

1= sa.Enum(*PJSIP_TRANSPORT_METHOD_NEW_VALUES,

2 name=PJSIP_TRANSPORT_METHOD_NEW_NAME)

Definition at line 28 of file 37a5332640e2_update_pjsip_tls_method_list.py.

◆ PJSIP_TRANSPORT_METHOD_NEW_VALUES

list PJSIP_TRANSPORT_METHOD_NEW_VALUES

Initial value:

=  ['default', 'unspecified',
                                     'tlsv1', 'tlsv1_1', 'tlsv1_2', 'tlsv1_3',
                                     'sslv2', 'sslv23', 'sslv3']