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)
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)
