From da17dc4d751184b1b358757db63cd9a34222c219 Mon Sep 17 00:00:00 2001 From: Mark Michelson Date: Wed, 16 Dec 2015 11:25:13 -0600 Subject: Alembic: Add PJSIP global keep_alive_interval. The keep_alive_interval option was added about a year ago, but no alembic revision was created to add the appropriate column to the database. This commit fixes the problem and adds the column. This was discovered by running the testsuite with automatic conversion to realtime enabled. Change-Id: If3ef92a7c4f4844d08f8aae170d2178aec5c4c1a --- .../189a235b3fd7_add_keep_alive_interval.py | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 contrib/ast-db-manage/config/versions/189a235b3fd7_add_keep_alive_interval.py diff --git a/contrib/ast-db-manage/config/versions/189a235b3fd7_add_keep_alive_interval.py b/contrib/ast-db-manage/config/versions/189a235b3fd7_add_keep_alive_interval.py new file mode 100644 index 000000000..aa52171f8 --- /dev/null +++ b/contrib/ast-db-manage/config/versions/189a235b3fd7_add_keep_alive_interval.py @@ -0,0 +1,22 @@ +"""add_keep_alive_interval + +Revision ID: 189a235b3fd7 +Revises: 28ce1e718f05 +Create Date: 2015-12-16 11:23:16.994523 + +""" + +# revision identifiers, used by Alembic. +revision = '189a235b3fd7' +down_revision = '28ce1e718f05' + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + op.add_column('ps_globals', sa.Column('keep_alive_interval', sa.Integer)) + + +def downgrade(): + op.drop_column('ps_globals', 'keep_alive_interval') -- cgit v1.2.3 From 53bd5a539a52c93ebf23a7d0ce892c7a83b91159 Mon Sep 17 00:00:00 2001 From: Mark Michelson Date: Wed, 16 Dec 2015 11:28:14 -0600 Subject: Alembic: Increase column size of PJSIP AOR "contact". When running the PJSIP AMI "show_endpoint" test with automatic conversion to realtime, the test would fail. This was because the AOR "contact" column was sized at 40, and the configured contact was larger than that. This commit increases the size of the contact column to 255 characters. Change-Id: Ia65bc7fd37699b7c0eaef9629a1a31eab9a24ba1 --- .../2d078ec071b7_increaes_contact_column_size.py | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 contrib/ast-db-manage/config/versions/2d078ec071b7_increaes_contact_column_size.py diff --git a/contrib/ast-db-manage/config/versions/2d078ec071b7_increaes_contact_column_size.py b/contrib/ast-db-manage/config/versions/2d078ec071b7_increaes_contact_column_size.py new file mode 100644 index 000000000..2ade86f9f --- /dev/null +++ b/contrib/ast-db-manage/config/versions/2d078ec071b7_increaes_contact_column_size.py @@ -0,0 +1,22 @@ +"""increaes_contact_column_size + +Revision ID: 2d078ec071b7 +Revises: 189a235b3fd7 +Create Date: 2015-12-16 11:26:54.218985 + +""" + +# revision identifiers, used by Alembic. +revision = '2d078ec071b7' +down_revision = '189a235b3fd7' + +from alembic import op +import sqlalchemy as sa + + +def upgrade(): + op.alter_column('ps_aors', 'contact', type_=sa.String(255)) + + +def downgrade(): + op.alter_column('ps_aors', 'contact', type_=sa.String(40)) -- cgit v1.2.3