def upgrade(): op.execute(""" ALTER TABLE job ADD COLUMN dirty_version BINARY(16) NOT NULL AFTER id, ADD COLUMN clean_version BINARY(16) NOT NULL AFTER dirty_version, ADD INDEX ix_job_dirty_clean_version (dirty_version, clean_version) """) op.execute("UPDATE job SET dirty_version = '1111111111111111'") op.add_column('system', sa.Column('loan_comment', sa.Unicode(1000))) op.create_table('disk', sa.Column('id', sa.Integer, primary_key=True), sa.Column('system_id', sa.Integer, sa.ForeignKey('system.id'), nullable=False), sa.Column('model', sa.Unicode(255)), sa.Column('size', sa.BigInteger), sa.Column('sector_size', sa.Integer), sa.Column('phys_sector_size', sa.Integer), mysql_engine='InnoDB' ) op.execute(""" DELETE FROM task USING task, task AS vtask WHERE task.id < vtask.id AND task.name = vtask.name """) op.alter_column('task', 'name', type_=sa.Unicode(255)) op.create_unique_constraint('name', 'task', ['name']) add_enum_value('job', 'result', 'None', nullable=False) add_enum_value('recipe_set', 'result', 'None', nullable=False) add_enum_value('recipe', 'result', 'None', nullable=False) add_enum_value('recipe_task', 'result', 'None', nullable=False) add_enum_value('recipe_task_result', 'result', 'None', nullable=False)
def upgrade(): op.execute(""" ALTER TABLE recipe_task ADD name VARCHAR(255) NOT NULL AFTER recipe_id, ADD version VARCHAR(255) AFTER name, ADD fetch_url VARCHAR(2048) AFTER version, ADD fetch_subdir VARCHAR(2048) NOT NULL DEFAULT '' AFTER fetch_url, MODIFY task_id INT, ADD INDEX (name), ADD INDEX (version), ADD INDEX (name, version) """) op.execute(""" UPDATE recipe_task SET name = (SELECT name FROM task WHERE id = recipe_task.task_id) """) add_enum_value('system_access_policy_rule', 'permission', 'view', nullable=True) op.execute(""" INSERT INTO system_access_policy (system_id) SELECT id FROM system WHERE NOT EXISTS (SELECT 1 FROM system_access_policy WHERE system_id = system.id) """) op.execute(""" INSERT INTO system_access_policy_rule (policy_id, user_id, group_id, permission) SELECT system_access_policy.id, NULL, NULL, 'view' FROM system_access_policy INNER JOIN system ON system_access_policy.system_id = system.id WHERE NOT EXISTS (SELECT 1 FROM system_access_policy_rule WHERE policy_id = system_access_policy.id AND user_id IS NULL AND group_id IS NULL AND permission = 'view') AND system.private = 0 """) op.add_column('command_queue', sa.Column('quiescent_period', sa.Integer)) op.create_index('status', 'command_queue', ['status']) op.add_column( 'power', sa.Column('power_quiescent_period', sa.Integer, nullable=False)) op.execute("UPDATE power SET power_quiescent_period = 5") op.alter_column('tg_user', 'password', type_=sa.UnicodeText()) op.execute("ALTER TABLE beaker_tag DROP PRIMARY KEY, ADD PRIMARY KEY (id)") # These tables were never used for anything, so they really can be safely dropped. op.drop_table('locked') op.drop_table('serial') op.drop_table('serial_type') op.drop_table('install')
def upgrade(): op.execute(""" ALTER TABLE recipe_task ADD name VARCHAR(255) NOT NULL AFTER recipe_id, ADD version VARCHAR(255) AFTER name, ADD fetch_url VARCHAR(2048) AFTER version, ADD fetch_subdir VARCHAR(2048) NOT NULL DEFAULT '' AFTER fetch_url, MODIFY task_id INT, ADD INDEX (name), ADD INDEX (version), ADD INDEX (name, version) """) op.execute(""" UPDATE recipe_task SET name = (SELECT name FROM task WHERE id = recipe_task.task_id) """) add_enum_value('system_access_policy_rule', 'permission', 'view', nullable=True) op.execute(""" INSERT INTO system_access_policy (system_id) SELECT id FROM system WHERE NOT EXISTS (SELECT 1 FROM system_access_policy WHERE system_id = system.id) """) op.execute(""" INSERT INTO system_access_policy_rule (policy_id, user_id, group_id, permission) SELECT system_access_policy.id, NULL, NULL, 'view' FROM system_access_policy INNER JOIN system ON system_access_policy.system_id = system.id WHERE NOT EXISTS (SELECT 1 FROM system_access_policy_rule WHERE policy_id = system_access_policy.id AND user_id IS NULL AND group_id IS NULL AND permission = 'view') AND system.private = 0 """) op.add_column('command_queue', sa.Column('quiescent_period', sa.Integer)) op.create_index('status', 'command_queue', ['status']) op.add_column('power', sa.Column('power_quiescent_period', sa.Integer, nullable=False)) op.execute("UPDATE power SET power_quiescent_period = 5") op.alter_column('tg_user', 'password', type_=sa.UnicodeText()) op.execute("ALTER TABLE beaker_tag DROP PRIMARY KEY, ADD PRIMARY KEY (id)") # These tables were never used for anything, so they really can be safely dropped. op.drop_table('locked') op.drop_table('serial') op.drop_table('serial_type') op.drop_table('install')
def upgrade(): add_enum_value('system_access_policy_rule', 'permission', 'view_power', nullable=False)
def upgrade(): add_enum_value('job', 'status', u'Installing', nullable=False) add_enum_value('recipe_set', 'status', u'Installing', nullable=False) add_enum_value('recipe', 'status', u'Installing', nullable=False) add_enum_value('recipe_task', 'status', u'Installing', nullable=False)
def upgrade(): add_enum_value('job', 'result', u'Skip', nullable=False) add_enum_value('recipe_set', 'result', u'Skip', nullable=False) add_enum_value('recipe', 'result', u'Skip', nullable=False) add_enum_value('recipe_task', 'result', u'Skip', nullable=False) add_enum_value('recipe_task_result', 'result', u'Skip', nullable=False)