def downgrade(): drop_fk('recipe_task', ['task_id']) op.execute(""" ALTER TABLE recipe_task DROP name, DROP version, DROP fetch_url, DROP fetch_subdir, MODIFY task_id INT NOT NULL """) op.create_foreign_key(None, 'recipe_task', 'task', ['task_id'], ['id']) op.execute( "DELETE FROM system_access_policy_rule WHERE permission = 'view'") drop_enum_value('system_access_policy_rule', 'permission', 'view', nullable=False) op.drop_column('command_queue', 'quiescent_period') drop_index('command_queue', ['status']) op.drop_column('power', 'power_quiescent_period') op.alter_column('tg_user', 'password', type_=sa.Unicode(40)) op.execute( "ALTER TABLE beaker_tag DROP PRIMARY KEY, ADD PRIMARY KEY (id, tag)") op.create_table('locked', sa.Column('id', sa.Integer(), primary_key=True)) op.create_table('serial', sa.Column('id', sa.Integer(), primary_key=True)) op.create_table('serial_type', sa.Column('id', sa.Integer(), primary_key=True)) op.create_table('install', sa.Column('id', sa.Integer(), primary_key=True))
def downgrade(): op.execute("ALTER TABLE job DROP COLUMN dirty_version, DROP COLUMN clean_version") op.drop_column('system', 'loan_comment') op.drop_table('disk') op.drop_index('name', 'task') op.alter_column('task', 'name', type_=sa.Unicode(2048)) drop_enum_value('job', 'result', 'None', nullable=False) drop_enum_value('recipe_set', 'result', 'None', nullable=False) drop_enum_value('recipe', 'result', 'None', nullable=False) drop_enum_value('recipe_task', 'result', 'None', nullable=False) drop_enum_value('recipe_task_result', 'result', 'None', nullable=False)
def downgrade(): op.execute(""" UPDATE job SET status = 'Running' WHERE status = 'Installing' """) op.execute(""" UPDATE recipe_set SET status = 'Running' WHERE status = 'Installing' """) op.execute(""" UPDATE recipe SET status = 'Running' WHERE status = 'Installing' """) # It should be impossible for recipe_task status to be Installing but let's # do it for completeness... op.execute(""" UPDATE recipe_task SET status = 'Running' WHERE status = 'Installing' """) drop_enum_value('job', 'status', u'Installing', nullable=False) drop_enum_value('recipe_set', 'status', u'Installing', nullable=False) drop_enum_value('recipe', 'status', u'Installing', nullable=False) drop_enum_value('recipe_task', 'status', u'Installing', nullable=False)
def downgrade(): op.execute(""" ALTER TABLE recipe_task DROP name, DROP version, DROP fetch_url, DROP fetch_subdir, MODIFY task_id INT NOT NULL """) op.execute("DELETE FROM system_access_policy_rule WHERE permission = 'view'") drop_enum_value('system_access_policy_rule', 'permission', 'view', nullable=False) op.drop_column('command_queue', 'quiescent_period') op.drop_index('status', 'command_queue') op.drop_column('power', 'power_quiescent_period') op.alter_column('tg_user', 'password', type_=sa.Unicode(40)) op.execute("ALTER TABLE beaker_tag DROP PRIMARY KEY, ADD PRIMARY KEY (id, tag)") op.create_table('locked', sa.Column('id', sa.Integer(), primary_key=True)) op.create_table('serial', sa.Column('id', sa.Integer(), primary_key=True)) op.create_table('serial_type', sa.Column('id', sa.Integer(), primary_key=True)) op.create_table('install', sa.Column('id', sa.Integer(), primary_key=True))
def downgrade(): op.execute("DELETE FROM system_access_policy_rule WHERE permission = 'view_power'") drop_enum_value('system_access_policy_rule', 'permission', 'view_power', nullable=True)
def downgrade(): drop_enum_value('job', 'result', u'Skip', nullable=False) drop_enum_value('recipe_set', 'result', u'Skip', nullable=False) drop_enum_value('recipe', 'result', u'Skip', nullable=False) drop_enum_value('recipe_task', 'result', u'Skip', nullable=False) drop_enum_value('recipe_task_result', 'result', u'Skip', nullable=False)