8fce8496f03e_add_tcp_keepalive_settings_to_ps_.py

Go to the documentation of this file.

"""Add TCP keepalive settings to ps_transports
 
Revision ID: 8fce8496f03e
Revises: 74dc751dfe8e
Create Date: 2024-03-18 17:00:17.148018
 
"""
 
# revision identifiers, used by Alembic.
revision = '8fce8496f03e'
down_revision = '74dc751dfe8e'
 
from alembic import op
import sqlalchemy as sa
 
def upgrade():
    with op.batch_alter_table('ps_transports') as batch_op:
        batch_op.add_column(sa.Column('tcp_keepalive_enable', sa.Boolean(), nullable=True))
        batch_op.add_column(sa.Column('tcp_keepalive_idle_time', sa.Integer(), nullable=True))
        batch_op.add_column(sa.Column('tcp_keepalive_interval_time', sa.Integer(), nullable=True))
        batch_op.add_column(sa.Column('tcp_keepalive_probe_count', sa.Integer(), nullable=True))
 
def downgrade():
    with op.batch_alter_table('ps_transports') as batch_op:
        batch_op.drop_column('tcp_keepalive_enable')
        batch_op.drop_column('tcp_keepalive_idle_time')
        batch_op.drop_column('tcp_keepalive_interval_time')
        batch_op.drop_column('tcp_keepalive_probe_count')