python类alter_column()的实例源码

def upgrade():
    op.alter_column('app', 'long_description', type_=sa.UnicodeText)
    pass

def downgrade():
    op.alter_column('app', 'long_description', type_=sa.Unicode)
    pass

def upgrade():
    query = 'UPDATE app SET category_id=(SELECT id FROM category ORDER BY id asc limit 1) WHERE app.category_id is NULL;'
    op.execute(query)
    op.alter_column('app', 'category_id', nullable=False)

def upgrade():
    op.add_column('project', sa.Column('published', sa.Boolean, default=False))
    query = 'UPDATE "project" SET published=false;'
    op.execute(query)
    op.alter_column('project', 'published', nullable=False)
    query = """UPDATE "project" SET published=true
               WHERE project.id IN
               (SELECT project.id FROM project, task WHERE
               project.id=task.project_id AND
               (project.info->>'task_presenter') IS NOT NULL AND
               (project.info->>'task_presenter')!=''
               GROUP BY project.id);"""
    op.execute(query)

def upgrade():
    op.alter_column('component_update', 'time', existing_type=sa.Integer(), type_=sa.Float(precision=53))
    op.alter_column('component_update', 'lifetime', existing_type=sa.Integer(), type_=sa.Float(precision=53))

def downgrade():
    op.alter_column('component_update', 'time', existing_type=sa.Float(precision=53), type_=sa.Integer())
    op.alter_column('component_update', 'lifetime', existing_type=sa.Float(precision=53), type_=sa.Integer())

def upgrade():
    op.alter_column('trait_int', "value", type_=sa.BigInteger)

def upgrade():
    op.alter_column('evaluations', 'example_frequency', new_column_name='as_of_date_frequency')
    op.alter_column('models', 'train_label_window', new_column_name='training_label_timespan')
    op.alter_column('predictions', 'test_label_window', new_column_name='test_label_timespan')
    op.alter_column('list_predictions', 'test_label_window', new_column_name='test_label_timespan')

def downgrade():
    op.alter_column('evaluations', 'as_of_date_frequency', new_column_name='example_frequency')
    op.alter_column('models', 'training_label_timespan', new_column_name='train_label_window')
    op.alter_column('predictions', 'test_label_timespan', new_column_name='test_label_window')
    op.alter_column('list_predictions', 'test_label_timespan', new_column_name='test_label_window')

def upgrade():
    op.alter_column(
        table_name='individual_importances',
        column_name='importance_score',
        type_=sa.Float(),
        schema='results',
        postgresql_using='importance_score::double precision'
    )

def downgrade():
    op.alter_column(
        table_name='individual_importances',
        column_name='importance_score',
        type_=sa.Text(),
        schema='results'
    )

def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('event', 'description',
               existing_type=sa.VARCHAR(),
               nullable=False)
    op.create_unique_constraint(None, 'event', ['description'])
    # ### end Alembic commands ###

def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(None, 'event', type_='unique')
    op.alter_column('event', 'description',
               existing_type=sa.VARCHAR(),
               nullable=True)
    # ### end Alembic commands ###

def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('person', 'email',
               existing_type=sa.VARCHAR(),
               nullable=True)
    # ### end Alembic commands ###

def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('person', 'email',
               existing_type=sa.VARCHAR(),
               nullable=False)
    # ### end Alembic commands ###

def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('episode', 'title',
               existing_type=sa.VARCHAR(),
               nullable=True)
    ### end Alembic commands ###

def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('episode', 'title',
               existing_type=sa.VARCHAR(),
               nullable=False)
    ### end Alembic commands ###

def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('episode', 'title',
               existing_type=sa.VARCHAR(),
               nullable=False)
    op.create_index(op.f('ix_episode_link'), 'episode', ['link'], unique=True)
    op.drop_constraint('episode_link_key', 'episode', type_='unique')
    ### end Alembic commands ###

def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_unique_constraint('episode_link_key', 'episode', ['link'])
    op.drop_index(op.f('ix_episode_link'), table_name='episode')
    op.alter_column('episode', 'title',
               existing_type=sa.VARCHAR(),
               nullable=True)
    ### end Alembic commands ###

def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('upload', 'hash',
               existing_type=sa.VARCHAR(),
               nullable=False)
    op.alter_column('upload', 'path',
               existing_type=sa.VARCHAR(),
               nullable=False)
    op.alter_column('upload', 'shorthash',
               existing_type=sa.VARCHAR(),
               nullable=False)
    ### end Alembic commands ###