From 7efcca8de13f07a245beabbf892e045d2908f3dd Mon Sep 17 00:00:00 2001 From: Walter Doekes Date: Mon, 15 Sep 2014 10:49:12 +0000 Subject: contrib: Fix verifyi typo in alembic DB script ps_transport table. Reported by: Zogot (on IRC) Patches: tmp.diff uploaded by Zogot, cleaned up by me. ........ Merged revisions 423128 from http://svn.asterisk.org/svn/asterisk/branches/12 git-svn-id: https://origsvn.digium.com/svn/asterisk/branches/13@423129 65c4cc65-6c06-0410-ace0-fbb531ad65f3 --- .../5950038a6ead_fix_pjsip_verifiy_typo.py | 29 ++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 contrib/ast-db-manage/config/versions/5950038a6ead_fix_pjsip_verifiy_typo.py (limited to 'contrib/ast-db-manage/config') diff --git a/contrib/ast-db-manage/config/versions/5950038a6ead_fix_pjsip_verifiy_typo.py b/contrib/ast-db-manage/config/versions/5950038a6ead_fix_pjsip_verifiy_typo.py new file mode 100644 index 000000000..28ebc8b17 --- /dev/null +++ b/contrib/ast-db-manage/config/versions/5950038a6ead_fix_pjsip_verifiy_typo.py @@ -0,0 +1,29 @@ +"""Fix pjsip transports verify column + +Revision ID: 5950038a6ead +Revises: d39508cb8d8 +Create Date: 2014-09-15 06:21:35.047314 + +""" + +# revision identifiers, used by Alembic. +revision = '5950038a6ead' +down_revision = 'd39508cb8d8' + +from alembic import op +from sqlalchemy.dialects.postgresql import ENUM + +YESNO_NAME = 'yesno_values' +YESNO_VALUES = ['yes', 'no'] + + +def upgrade(): + yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=False) + op.alter_column('ps_transports', 'verifiy_server', type_=yesno_values, + new_column_name='verify_server') + + +def downgrade(): + yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=False) + op.alter_column('ps_transports', 'verify_server', type_=yesno_values, + new_column_name='verifiy_server') -- cgit v1.2.3