"""plv8_url_encode

Revision ID: 64feec3da586
Revises: e5e21700527d
Create Date: 2020-06-25 14:12:09.639366

"""

# revision identifiers, used by Alembic.
revision = '64feec3da586'
down_revision = 'e5e21700527d'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.execute('''
    CREATE EXTENSION if not exists plv8;

    CREATE or replace FUNCTION url_encode(str text) RETURNS text
    AS $$
        return encodeURIComponent(str)
    $$ LANGUAGE plv8 IMMUTABLE STRICT;
        ''')


def downgrade():
    op.execute('drop function  url_encode(text)')