2016-09-01 14:31:01 +01:00
|
|
|
"""empty message
|
|
|
|
|
|
2016-09-06 12:53:57 +01:00
|
|
|
Revision ID: 0053_cancelled_job_status
|
|
|
|
|
Revises: 0052_drop_jobs_status
|
2016-09-01 14:31:01 +01:00
|
|
|
Create Date: 2016-09-01 14:34:06.839381
|
|
|
|
|
|
|
|
|
|
"""
|
|
|
|
|
|
|
|
|
|
# revision identifiers, used by Alembic.
|
2023-08-29 14:54:30 -07:00
|
|
|
revision = "0053_cancelled_job_status"
|
|
|
|
|
down_revision = "0052_drop_jobs_status"
|
2016-09-01 14:31:01 +01:00
|
|
|
|
|
|
|
|
import sqlalchemy as sa
|
2023-12-08 21:43:52 -05:00
|
|
|
from alembic import op
|
2016-09-01 14:31:01 +01:00
|
|
|
from sqlalchemy.dialects import postgresql
|
|
|
|
|
|
2023-08-29 14:54:30 -07:00
|
|
|
|
2016-09-01 14:31:01 +01:00
|
|
|
def upgrade():
|
|
|
|
|
op.execute("INSERT INTO job_status VALUES ('cancelled')")
|
|
|
|
|
|
2023-08-29 14:54:30 -07:00
|
|
|
|
2016-09-01 14:31:01 +01:00
|
|
|
def downgrade():
|
|
|
|
|
op.execute("UPDATE jobs SET job_status = 'finished' WHERE job_status = 'cancelled'")
|
|
|
|
|
op.execute("DELETE FROM job_status WHERE name = 'cancelled';")
|
