<p>George Joseph has uploaded this change for <strong>review</strong>.</p><p><a href="https://gerrit.asterisk.org/6435">View Change</a></p><pre style="font-family: monospace,monospace; white-space: pre-wrap;">Add prune contacts alembic script to 15.0<br><br>Change-Id: I4d1c14cdbffefdb5a62f735a80613ea5bb38dba6<br>---<br>A contrib/ast-db-manage/config/versions/f3d1c5d38b56_add_prune_on_boot.py<br>1 file changed, 28 insertions(+), 0 deletions(-)<br><br></pre><pre style="font-family: monospace,monospace; white-space: pre-wrap;">git pull ssh://gerrit.asterisk.org:29418/asterisk refs/changes/35/6435/1</pre><pre style="font-family: monospace,monospace; white-space: pre-wrap;">diff --git a/contrib/ast-db-manage/config/versions/f3d1c5d38b56_add_prune_on_boot.py b/contrib/ast-db-manage/config/versions/f3d1c5d38b56_add_prune_on_boot.py<br>new file mode 100644<br>index 0000000..fe9c35e<br>--- /dev/null<br>+++ b/contrib/ast-db-manage/config/versions/f3d1c5d38b56_add_prune_on_boot.py<br>@@ -0,0 +1,28 @@<br>+"""add_prune_on_boot<br>+<br>+Revision ID: f3d1c5d38b56<br>+Revises: 44ccced114ce<br>+Create Date: 2017-08-04 17:31:23.124767<br>+<br>+"""<br>+<br>+# revision identifiers, used by Alembic.<br>+revision = 'f3d1c5d38b56'<br>+down_revision = '44ccced114ce'<br>+<br>+from alembic import op<br>+import sqlalchemy as sa<br>+<br>+<br>+def upgrade():<br>+    ############################# Enums ##############################<br>+<br>+    # yesno_values have already been created, so use postgres enum object<br>+    # type to get around "already created" issue - works okay with mysql<br>+    yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=False)<br>+<br>+    op.add_column('ps_contacts', sa.Column('prune_on_boot', yesno_values))<br>+<br>+<br>+def downgrade():<br>+    op.drop_column('ps_contacts', 'prune_on_boot')<br></pre><p>To view, visit <a href="https://gerrit.asterisk.org/6435">change 6435</a>. To unsubscribe, 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/6435"/><meta itemprop="name" content="View Change"/></div></div>

<div style="display:none"> Gerrit-Project: asterisk </div>
<div style="display:none"> Gerrit-Branch: 15.0 </div>
<div style="display:none"> Gerrit-MessageType: newchange </div>
<div style="display:none"> Gerrit-Change-Id: I4d1c14cdbffefdb5a62f735a80613ea5bb38dba6 </div>
<div style="display:none"> Gerrit-Change-Number: 6435 </div>
<div style="display:none"> Gerrit-PatchSet: 1 </div>
<div style="display:none"> Gerrit-Owner: George Joseph <gjoseph@digium.com> </div>