"""empty message

Revision ID: 0028_fix_reg_template_history
Revises: 0027_update_provider_rates
Create Date: 2016-06-13 11:04:15.888017

"""

# revision identifiers, used by Alembic.
from datetime import datetime

revision = "0028_fix_reg_template_history"
down_revision = "0027_update_provider_rates"

import sqlalchemy as sa
from alembic import op

service_id = "d6aa2c68-a2d9-4437-ab19-3ae8eb202553"
user_id = "6af522d0-2915-4e52-83a3-3690455a5fe6"


def upgrade():
    op.get_bind()
    op.execute("delete from templates_history where name = 'Notify email verification code'")

    template_history_insert = """INSERT INTO templates_history (id, name, template_type, created_at,
                                                                content, archived, service_id,
                                                                subject, created_by_id, version)
                                 VALUES ('{}', '{}', '{}', '{}', '{}', False, '{}', '{}', '{}', 1)
                              """
    email_verification_content = (
        """Hi ((name)),\n\nTo complete your registration for GOV.UK Notify please click the link below\n\n((url))"""
    )
    op.execute(
        template_history_insert.format(
            "ece42649-22a8-4d06-b87f-d52d5d3f0a27",
            "Notify email verification code",
            "email",
            datetime.utcnow(),
            email_verification_content,
            service_id,
            "Confirm GOV.UK Notify registration",
            user_id,
        )
    )


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    pass
    ### end Alembic commands ###
