"""Update ACLs descriptions

Revision ID: 21292448a775
Revises: 3237fc64b306
Create Date: 2017-10-12 16:55:05.066340

"""

# revision identifiers, used by Alembic.
revision = '21292448a775'
down_revision = '3237fc64b306'

from alembic import op
import sqlalchemy as sa

ACLS = {
    'create_project': 'Create a new project',
    'fork_project': 'Fork a project',
    'issue_assign': 'Assign issue to someone',
    'issue_create': 'Create a new ticket',
    'issue_change_status': 'Change the status of a ticket',
    'issue_comment': 'Comment on a ticket',
    'pull_request_close': 'Close a pull-request',
    'pull_request_comment': 'Comment on a pull-request',
    'pull_request_flag': 'Flag a pull-request',
    'pull_request_merge': 'Merge a pull-request',
    'issue_subscribe': 'Subscribe the user with this token to an issue',
    'issue_update': 'Update an issue, status, comments, custom fields...',
    'issue_update_custom_fields': 'Update the custom fields of an issue',
    'issue_update_milestone': 'Update the milestone of an issue',
    'modify_project': 'Modify an existing project',
    'generate_acls_project': 'Generate the Gitolite ACLs on a project'
}

def upgrade():
    """ Update the ACLs description stored in the database to be more
    generic.
    """
    for acl in ACLS:
        op.execute(
            "UPDATE acls SET description='%s' WHERE name='%s';" % (
                ACLS[acl], acl)
        )


def downgrade():
    """ There isn't really anything to back out, so just keep going. """
    pass