Python drop_enum_valueの例

コード例 #1

ファイル: 2f38ab976d17_015_to_016.py プロジェクト: pombredanne/beaker-2

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

コード例 #2

ファイル: 442672570b8f_011_to_012.py プロジェクト: pombredanne/beaker-1

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)

コード例 #3

ファイル: 29c945bb5b0f_add_installing_status.py プロジェクト: beaker-project/beaker

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)

コード例 #4

ファイル: 29c945bb5b0f_add_installing_status.py プロジェクト: pombredanne/beaker-2

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)

コード例 #5

ファイル: 2f38ab976d17_015_to_016.py プロジェクト: omps/beaker

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

コード例 #6

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)

コード例 #7

ファイル: 38cfd9b8ce52_add_skip_result.py プロジェクト: beaker-project/beaker

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)

コード例 #8

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)