2017-06-01 11:00:26 +01:00
|
|
|
"""empty message
|
|
|
|
|
|
2017-06-01 13:18:56 +01:00
|
|
|
Revision ID: 0089_govuk_sms_sender
|
|
|
|
|
Revises: 0088_add_schedule_serv_perm
|
2017-06-01 11:00:26 +01:00
|
|
|
Create Date: 2017-05-22 13:46:09.584801
|
|
|
|
|
|
|
|
|
|
"""
|
|
|
|
|
|
|
|
|
|
# revision identifiers, used by Alembic.
|
2023-08-29 14:54:30 -07:00
|
|
|
revision = "0089_govuk_sms_sender"
|
|
|
|
|
down_revision = "0088_add_schedule_serv_perm"
|
2017-06-01 11:00:26 +01:00
|
|
|
|
|
|
|
|
from alembic import op
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
def upgrade():
|
|
|
|
|
op.execute("UPDATE services SET sms_sender = 'GOVUK' where sms_sender is null")
|
2023-08-29 14:54:30 -07:00
|
|
|
op.execute(
|
|
|
|
|
"UPDATE services_history SET sms_sender = 'GOVUK' where sms_sender is null"
|
|
|
|
|
)
|
|
|
|
|
op.alter_column("services", "sms_sender", nullable=False)
|
|
|
|
|
op.alter_column("services_history", "sms_sender", nullable=False)
|
2017-06-01 11:00:26 +01:00
|
|
|
|
|
|
|
|
|
|
|
|
|
def downgrade():
|
2023-08-29 14:54:30 -07:00
|
|
|
op.alter_column("services_history", "sms_sender", nullable=True)
|
|
|
|
|
op.alter_column("services", "sms_sender", nullable=True)
|
