Functions
	downgrade ()

	upgrade ()

Variables
str	down_revision = '7197536bb68d'

str	PJSIP_INCOMING_CALL_OFFER_PREF_NAME = 'pjsip_incoming_call_offer_pref_values'

list	PJSIP_INCOMING_CALL_OFFER_PREF_VALUES

str	PJSIP_OUTGOING_CALL_OFFER_PREF_NAME = 'pjsip_outgoing_call_offer_pref_values'

list	PJSIP_OUTGOING_CALL_OFFER_PREF_VALUES

str	revision = '9f3692b1654b'

Function Documentation

◆ downgrade()

downgrade ( )

Definition at line 43 of file 9f3692b1654b_add_stir_shaken_profile_and_codec_.py.

def downgrade():
    context = op.get_context()
 
    if context.bind.dialect.name == 'mssql':
        op.drop_constraint('ck_ps_endpoints_incoming_call_offer_pref_pjsip_incoming_call_offer_pref_values', 'ps_endpoints')
        op.drop_constraint('ck_ps_endpoints_outgoing_call_offer_pref_pjsip_outgoing_call_offer_pref_values', 'ps_endpoints')
 
    op.drop_column('ps_endpoints', 'outgoing_call_offer_pref')
    op.drop_column('ps_endpoints', 'incoming_call_offer_pref')
    op.drop_column('ps_endpoints', 'stir_shaken_profile')
 
    enums = [PJSIP_INCOMING_CALL_OFFER_PREF_NAME, PJSIP_OUTGOING_CALL_OFFER_PREF_NAME]
 
    if context.bind.dialect.name == 'postgresql':
        for e in enums:
            ENUM(name=e).drop(op.get_bind(), checkfirst=False)

◆ upgrade()

upgrade ( )

Definition at line 25 of file 9f3692b1654b_add_stir_shaken_profile_and_codec_.py.

def upgrade():
    context = op.get_context()
 
    if context.bind.dialect.name == 'postgresql':
        enum_in = ENUM(*PJSIP_INCOMING_CALL_OFFER_PREF_VALUES, name=PJSIP_INCOMING_CALL_OFFER_PREF_NAME)
        enum_out = ENUM(*PJSIP_OUTGOING_CALL_OFFER_PREF_VALUES, name=PJSIP_OUTGOING_CALL_OFFER_PREF_NAME)
 
        enum_in.create(op.get_bind(), checkfirst=False)
        enum_out.create(op.get_bind(), checkfirst=False)
 
    op.add_column('ps_endpoints', sa.Column('incoming_call_offer_pref',
            sa.Enum(*PJSIP_INCOMING_CALL_OFFER_PREF_VALUES, name=PJSIP_INCOMING_CALL_OFFER_PREF_NAME)))
 
    op.add_column('ps_endpoints', sa.Column('outgoing_call_offer_pref',
            sa.Enum(*PJSIP_OUTGOING_CALL_OFFER_PREF_VALUES, name=PJSIP_OUTGOING_CALL_OFFER_PREF_NAME)))
 
    op.add_column('ps_endpoints', sa.Column('stir_shaken_profile', sa.String(80)))
 