Asterisk - The Open Source Telephony Project  21.4.1
8fce8496f03e_add_tcp_keepalive_settings_to_ps_.py
1 """Add TCP keepalive settings to ps_transports
2 
3 Revision ID: 8fce8496f03e
4 Revises: 74dc751dfe8e
5 Create Date: 2024-03-18 17:00:17.148018
6 
7 """
8 
9 # revision identifiers, used by Alembic.
10 revision = '8fce8496f03e'
11 down_revision = '74dc751dfe8e'
12 
13 from alembic import op
14 import sqlalchemy as sa
15 
16 def upgrade():
17  with op.batch_alter_table('ps_transports') as batch_op:
18  batch_op.add_column(sa.Column('tcp_keepalive_enable', sa.Boolean(), nullable=True))
19  batch_op.add_column(sa.Column('tcp_keepalive_idle_time', sa.Integer(), nullable=True))
20  batch_op.add_column(sa.Column('tcp_keepalive_interval_time', sa.Integer(), nullable=True))
21  batch_op.add_column(sa.Column('tcp_keepalive_probe_count', sa.Integer(), nullable=True))
22 
23 def downgrade():
24  with op.batch_alter_table('ps_transports') as batch_op:
25  batch_op.drop_column('tcp_keepalive_enable')
26  batch_op.drop_column('tcp_keepalive_idle_time')
27  batch_op.drop_column('tcp_keepalive_interval_time')
28  batch_op.drop_column('tcp_keepalive_probe_count')