<p>George Joseph <strong>merged</strong> this change.</p><p><a href="https://gerrit.asterisk.org/10569">View Change</a></p><div style="white-space:pre-wrap">Approvals:
  Benjamin Keith Ford: Looks good to me, but someone else must approve
  Sean Bright: Looks good to me, but someone else must approve
  George Joseph: Looks good to me, approved; Approved for Submit

</div><pre style="font-family: monospace,monospace; white-space: pre-wrap;">alembic: Fix use_callerid_contact option add script.<br><br>ASTERISK-28087<br><br>Change-Id: I046d018015427d0916fab571b5a4f5367476f729<br>---<br>M contrib/ast-db-manage/config/versions/2bb1a85135ad_pjsip_add_use_callerid_contact.py<br>1 file changed, 10 insertions(+), 5 deletions(-)<br><br></pre><pre style="font-family: monospace,monospace; white-space: pre-wrap;"><span>diff --git a/contrib/ast-db-manage/config/versions/2bb1a85135ad_pjsip_add_use_callerid_contact.py b/contrib/ast-db-manage/config/versions/2bb1a85135ad_pjsip_add_use_callerid_contact.py</span><br><span>index 88c94f5..c4a9eab 100644</span><br><span>--- a/contrib/ast-db-manage/config/versions/2bb1a85135ad_pjsip_add_use_callerid_contact.py</span><br><span>+++ b/contrib/ast-db-manage/config/versions/2bb1a85135ad_pjsip_add_use_callerid_contact.py</span><br><span>@@ -14,21 +14,26 @@</span><br><span> import sqlalchemy as sa</span><br><span> from sqlalchemy.dialects.postgresql import ENUM</span><br><span> </span><br><span style="color: hsl(0, 100%, 40%);">-YESNO_NAME = 'yesno_values'</span><br><span style="color: hsl(0, 100%, 40%);">-YESNO_VALUES = ['yes', 'no']</span><br><span style="color: hsl(120, 100%, 40%);">+AST_BOOL_NAME = 'ast_bool_values'</span><br><span style="color: hsl(120, 100%, 40%);">+# We'll just ignore the n/y and f/t abbreviations as Asterisk does not write</span><br><span style="color: hsl(120, 100%, 40%);">+# those aliases.</span><br><span style="color: hsl(120, 100%, 40%);">+AST_BOOL_VALUES = [ '0', '1',</span><br><span style="color: hsl(120, 100%, 40%);">+                    'off', 'on',</span><br><span style="color: hsl(120, 100%, 40%);">+                    'false', 'true',</span><br><span style="color: hsl(120, 100%, 40%);">+                    'no', 'yes' ]</span><br><span> </span><br><span> </span><br><span> def upgrade():</span><br><span>     ############################# Enums ##############################</span><br><span> </span><br><span style="color: hsl(0, 100%, 40%);">-    # yesno_values have already been created, so use postgres enum object</span><br><span style="color: hsl(120, 100%, 40%);">+    # ast_bool_values has already been created, so use postgres enum object</span><br><span>     # type to get around "already created" issue - works okay with mysql</span><br><span style="color: hsl(0, 100%, 40%);">-    yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=False)</span><br><span style="color: hsl(120, 100%, 40%);">+    ast_bool_values = ENUM(*AST_BOOL_VALUES, name=AST_BOOL_NAME, create_type=False)</span><br><span> </span><br><span>     op.add_column('ps_globals', sa.Column('use_callerid_contact', yesno_values))</span><br><span> </span><br><span> </span><br><span> def downgrade():</span><br><span>     if op.get_context().bind.dialect.name == 'mssql':</span><br><span style="color: hsl(0, 100%, 40%);">-        op.drop_constraint('ck_ps_globals_use_callerid_contact_yesno_values','ps_globals')</span><br><span style="color: hsl(120, 100%, 40%);">+        op.drop_constraint('ck_ps_globals_use_callerid_contact_ast_bool_values', 'ps_globals')</span><br><span>     op.drop_column('ps_globals', 'use_callerid_contact')</span><br><span></span><br></pre><p>To view, visit <a href="https://gerrit.asterisk.org/10569">change 10569</a>. To unsubscribe, or for help writing mail filters, visit <a href="https://gerrit.asterisk.org/settings">settings</a>.</p><div itemscope itemtype="http://schema.org/EmailMessage"><div itemscope itemprop="action" itemtype="http://schema.org/ViewAction"><link itemprop="url" href="https://gerrit.asterisk.org/10569"/><meta itemprop="name" content="View Change"/></div></div>

<div style="display:none"> Gerrit-Project: asterisk </div>
<div style="display:none"> Gerrit-Branch: 16 </div>
<div style="display:none"> Gerrit-MessageType: merged </div>
<div style="display:none"> Gerrit-Change-Id: I046d018015427d0916fab571b5a4f5367476f729 </div>
<div style="display:none"> Gerrit-Change-Number: 10569 </div>
<div style="display:none"> Gerrit-PatchSet: 1 </div>
<div style="display:none"> Gerrit-Owner: Richard Mudgett <rmudgett@digium.com> </div>
<div style="display:none"> Gerrit-Reviewer: Benjamin Keith Ford <bford@digium.com> </div>
<div style="display:none"> Gerrit-Reviewer: George Joseph <gjoseph@digium.com> </div>
<div style="display:none"> Gerrit-Reviewer: Jenkins2 (1000185) </div>
<div style="display:none"> Gerrit-Reviewer: Sean Bright <sean.bright@gmail.com> </div>