sqlalchemy.INTEGER

Here are the examples of the python api sqlalchemy.INTEGER taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

129 Examples 7

Example 1

Project: kcsrv Source File: 699e07f138d7_add_expedition_cancelled_field.py
Function: upgrade
def upgrade():
### commands auto generated by Alembic - please adjust! ###
    op.alter_column('expedition', 'time_taken',
               existing_type=sa.INTEGER(),
               type_=sa.BigInteger(),
               existing_nullable=True)
    op.add_column('fleet', sa.Column('expedition_cancelled', sa.Boolean(), nullable=True))

Example 2

Project: socorro Source File: 3f007539efc_fixes_bug_1024666_add_raw_adi_table.py
def upgrade():
    op.create_table('raw_adi',
        sa.Column('adi_count', sa.INTEGER(), nullable=True),
        sa.Column('date', sa.DATE(), nullable=True),
        sa.Column('product_name', sa.TEXT(), nullable=True),
        sa.Column('product_os_platform', sa.TEXT(), nullable=True),
        sa.Column('product_os_version', sa.TEXT(), nullable=True),
        sa.Column('product_version', sa.TEXT(), nullable=True),
        sa.Column('build', sa.TEXT(), nullable=True),
        sa.Column('product_guid', sa.TEXT(), nullable=True),
        sa.Column('update_channel', sa.TEXT(), nullable=True),
        sa.Column('received_at', postgresql.TIMESTAMP(timezone=True), server_default='NOW()', nullable=True)
    )
    op.create_index('raw_adi_1_idx', 'raw_adi', ['date', 'product_name', 'product_version', 'product_os_platform', 'product_os_version'], unique=False)

Example 3

Project: ReadableWebProxy Source File: d50da91f4e86_.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('raw_web_pages', 'id',
               existing_type=sa.INTEGER(),
               type_=sa.BigInteger())
    op.alter_column('raw_web_pages_version', 'id',
               existing_type=sa.INTEGER(),
               type_=sa.BigInteger())

Example 4

Project: funnel Source File: 316aaa757c8c_coaster_models.py
Function: downgrade
def downgrade():
    op.create_table(u'tag',
    sa.Column(u'id', sa.INTEGER(), server_default="nextval('tag_id_seq'::regclass)", nullable=False),
    sa.Column(u'created_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
    sa.Column(u'updated_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
    sa.Column(u'name', sa.VARCHAR(length=80), autoincrement=False, nullable=False),
    sa.Column(u'title', sa.VARCHAR(length=80), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint(u'id', name=u'tag_pkey')
    )
    op.create_table(u'proposal_tags',
    sa.Column(u'tag_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column(u'proposal_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.PrimaryKeyConstraint()
    )

Example 5

Project: open-event-orga-server Source File: 5aea50727992_.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('user', 'created_date')
    op.create_table('sessions_speakers',
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('speaker_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('session_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['session_id'], [u'session.id'], name=u'sessions_speakers_session_id_fkey'),
    sa.ForeignKeyConstraint(['speaker_id'], [u'speaker.id'], name=u'sessions_speakers_speaker_id_fkey'),
    sa.PrimaryKeyConstraint('id', name=u'sessions_speakers_pkey')
    )

Example 6

Project: stalker Source File: 2aeab8b376dc_fg_color_bg_color.py
Function: downgrade
def downgrade():
    op.add_column(
        'Statuses', sa.Column('fg_color', sa.INTEGER(), nullable=True)
    )
    op.add_column(
        'Statuses', sa.Column('bg_color', sa.INTEGER(), nullable=True)
    )

Example 7

Project: socorro Source File: 2b285e76f71d_bug_803209_add_garag.py
Function: upgrade
def upgrade():
    op.add_column(u'tcbs', sa.Column(u'is_gc_count', sa.INTEGER()))
    op.alter_column(u'tcbs', u'is_gc_count', server_default='0')
    op.add_column(u'tcbs_build', sa.Column(u'is_gc_count', sa.INTEGER()))
    op.alter_column(u'tcbs_build', u'is_gc_count', server_default='0')
    app_path=os.getcwd()
    procs = [
        'backfill_matviews.sql',
        'update_tcbs.sql'
    ]
    for myfile in [app_path + '/socorro/external/postgresql/raw_sql/procs/' + line for line in procs]:
        with open(myfile, 'r') as file:
            op.execute(file.read())

Example 8

Project: gamification-engine Source File: 16b4a243d41d_nullable.py
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('achievements_rewards', 'achievement_id',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.alter_column('achievements_rewards', 'reward_id',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.alter_column('goals', 'achievement_id',
               existing_type=sa.INTEGER(),
               nullable=False)

Example 9

Project: koschei Source File: 3770b40e6ef8_remove_packagestatec.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table(u'package_change',
    sa.Column(u'id', sa.INTEGER(), server_default="nextval('package_change_id_seq'::regclass)", nullable=False),
    sa.Column(u'prev_state', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column(u'curr_state', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column(u'applied_in_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column(u'package_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['applied_in_id'], [u'build.id'], name=u'package_change_applied_in_id_fkey'),
    sa.ForeignKeyConstraint(['package_id'], [u'package.id'], name=u'package_change_package_id_fkey'),
    sa.PrimaryKeyConstraint(u'id', name=u'package_change_pkey')
    )

Example 10

Project: grano Source File: 1b1b7e728dc4_single_schema_entity.py
def downgrade():
    op.add_column('grano_property', sa.Column('schema_id', sa.INTEGER(), nullable=True))
    op.drop_index('ix_grano_entity_schema_id', table_name='grano_entity')
    op.drop_column('grano_entity', 'schema_id')
    
    op.create_table('grano_entity_schema',
    sa.Column('entity_id', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.Column('schema_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['entity_id'], [u'grano_entity.id'], name=u'entity_schema_entity_id_fkey'),
    sa.ForeignKeyConstraint(['schema_id'], [u'grano_schema.id'], name=u'entity_schema_schema_id_fkey')
    )

Example 11

Project: synnefo Source File: 5adc52055209_alter_versions_avail.py
def upgrade():
    op.add_column('versions', sa.Column('temp', sa.INTEGER))

    v = sa.sql.table(
        'versions',
        sa.sql.column('available', sa.Boolean),
        sa.sql.column('temp', sa.Integer))

    u = v.update().values({'temp': sa.case([(v.c.available ==
                                             sa.sql.expression.true(), 1)],
                                           else_=0)})
    op.execute(u)

    op.drop_column('versions', 'available')
    op.add_column('versions', sa.Column('available', sa.INTEGER))
    u = v.update().values({'available': v.c.temp})
    op.execute(u)

    op.drop_column('versions', 'temp')

Example 12

Project: open-event-orga-server Source File: 752be2444e8d_.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column(u'orders', sa.Column('quantity', sa.INTEGER(), autoincrement=False, nullable=True))
    op.add_column(u'orders', sa.Column('ticket_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.create_foreign_key(u'orders_ticket_id_fkey', 'orders', 'ticket', ['ticket_id'], ['id'])
    op.drop_table('orders_tickets')

Example 13

Project: WatchPeopleCode Source File: 1f8165cd3c06_.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('subscription',
    sa.Column('stream_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('subscriber_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['stream_id'], [u'stream.id'], name=u'subscription_stream_id_fkey'),
    sa.ForeignKeyConstraint(['subscriber_id'], [u'subscriber.id'], name=u'subscription_subscriber_id_fkey')
    )

Example 14

Project: funnel Source File: 4aedc1062818_session_edits.py
def downgrade():
    op.alter_column('session', 'venue_room_id',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.alter_column('session', 'start', new_column_name='start_datetime')
    op.alter_column('session', 'end', new_column_name='end_datetime')

Example 15

Project: szurubooru Source File: ed6dd16a30f3_delete_post_columns.py
Function: downgrade
def downgrade():
    for column_name in [
            'auto_note_count',
            'auto_feature_time',
            'auto_fav_time',
            'auto_score',
            'auto_comment_count',
            'auto_feature_count',
            'auto_comment_creation_time',
            'auto_fav_count',
            'auto_comment_edit_time']:
        op.add_column(
            'post',
            sa.Column(
                column_name,
                sa.INTEGER(),
                autoincrement=False,
                nullable=False))

Example 16

Project: socorro Source File: 1f235c84eaed_bug_1025987_normalize_correlations_table.py
def upgrade():
    load_stored_proc(op, ['update_correlations_module.sql'])
    op.execute(""" TRUNCATE correlations_module """)
    op.create_table('modules',
    sa.Column('module_id', sa.INTEGER(), nullable=False),
    sa.Column('name', sa.TEXT(), nullable=False),
    sa.Column('version', sa.TEXT(), nullable=False),
    sa.PrimaryKeyConstraint('module_id', 'name', 'version')
    )
    op.add_column(u'correlations_module', sa.Column('module_id', sa.INTEGER(), nullable=False))
    op.drop_column(u'correlations_module', 'module_name')
    op.drop_column(u'correlations_module', 'module_version')

Example 17

Project: stalker Source File: a6598cde6b_versions_are_not_mix.py
Function: downgrade
def downgrade():
    op.add_column(
        'Versions', sa.Column('status_id', sa.INTEGER(), nullable=False)
    )
    op.add_column(
        'Versions', sa.Column('status_list_id', sa.INTEGER(), nullable=False)
    )

Example 18

Project: socorro Source File: 31168908ac42_fixes_bug_1053956_deprecate_raw_adu_in_.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('raw_adu',
        sa.Column('adu_count', sa.INTEGER(), autoincrement=False, nullable=True),
        sa.Column('date', sa.DATE(), autoincrement=False, nullable=True),
        sa.Column('product_name', sa.TEXT(), autoincrement=False, nullable=True),
        sa.Column('product_os_platform', sa.TEXT(), autoincrement=False, nullable=True),
        sa.Column('product_os_version', sa.TEXT(), autoincrement=False, nullable=True),
        sa.Column('product_version', sa.TEXT(), autoincrement=False, nullable=True),
        sa.Column('build', sa.TEXT(), autoincrement=False, nullable=True),
        sa.Column('build_channel', sa.TEXT(), autoincrement=False, nullable=True),
        sa.Column('product_guid', sa.TEXT(), autoincrement=False, nullable=True),
        sa.Column('received_at', postgresql.TIMESTAMP(timezone=True), server_default=sa.text(u'now()'), autoincrement=False, nullable=True),
        sa.Column('update_channel', sa.TEXT(), autoincrement=False, nullable=True)
    )

Example 19

Project: rootio_web Source File: 423f8bc6e44_telephony_message.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column(u'telephony_message', sa.Column(u'to_phonenumber_id', sa.INTEGER(), nullable=True))
    op.add_column(u'telephony_message', sa.Column(u'from_phonenumber_id', sa.INTEGER(), nullable=True))
    op.drop_column(u'telephony_message', 'to_phonenumber')
    op.drop_column(u'telephony_message', 'from_phonenumber')
    op.add_column(u'telephony_call', sa.Column(u'end_time', postgresql.TIMESTAMP(), nullable=True))
    op.drop_column(u'telephony_call', 'duration')

Example 20

Project: koschei Source File: 3532a68d11c9_change_dependency_fk.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('dependency', sa.Column('repo_id', sa.INTEGER(), autoincrement=False, nullable=False))
    op.add_column('dependency', sa.Column('package_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.drop_constraint(None, 'dependency', type_='foreignkey')
    op.create_foreign_key(u'dependency_package_id_fkey', 'dependency', 'package', ['package_id'], ['id'], ondelete=u'CASCADE')
    op.create_index('ix_dependency_composite', 'dependency', ['package_id', 'repo_id'], unique=False)
    op.drop_index(op.f('ix_dependency_build_id'), table_name='dependency')
    op.drop_column('dependency', 'build_id')

Example 21

Project: open-event-orga-server Source File: 217c21289729_.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('sponsors', sa.Column('sponsor_type_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.create_foreign_key(u'sponsors_sponsor_type_id_fkey', 'sponsors', 'sponsor_type', ['sponsor_type_id'], ['id'], ondelete=u'CASCADE')
    op.drop_column('sponsors', 'sponsor_type')
    op.create_table('sponsor_type',
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('event_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['event_id'], [u'events.id'], name=u'sponsor_type_event_id_fkey', ondelete=u'CASCADE'),
    sa.PrimaryKeyConstraint('id', name=u'sponsor_type_pkey')
    )

Example 22

Project: open-event-orga-server Source File: 26a83ff1e6ad_.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('session', sa.Column('language_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.create_foreign_key(u'session_language_id_fkey', 'session', 'language', ['language_id'], ['id'])
    op.create_table('language',
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.Column('label_en', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.Column('label_de', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.Column('event_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name=u'language_pkey')
    )

Example 23

Project: rootio_web Source File: 54d62f4942f6_fase1_change.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column(u'content_uploads', sa.Column(u'uploaded_by', sa.INTEGER(), nullable=True))
    op.add_column(u'content_uploads', sa.Column(u'uri', sa.VARCHAR(length=200), nullable=True))
    op.add_column(u'content_uploads', sa.Column(u'track_id', sa.INTEGER(), nullable=True))
    op.add_column(u'content_uploads', sa.Column(u'title', sa.VARCHAR(length=100), nullable=True))
    op.add_column(u'content_track', sa.Column(u'name', sa.VARCHAR(length=100), nullable=True))
    op.add_column(u'content_track', sa.Column(u'description', sa.TEXT(), nullable=True))
    op.add_column(u'content_track', sa.Column(u'uploaded_by', sa.INTEGER(), nullable=True))
    op.add_column(u'content_track', sa.Column(u'content_id', sa.INTEGER(), nullable=True))
    op.create_table(u'radio_content_type',
    sa.Column(u'created_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
    sa.Column(u'updated_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
    sa.Column(u'id', sa.INTEGER(), server_default="nextval('radio_content_type_id_seq'::regclass)", nullable=False),
    sa.Column(u'name', sa.VARCHAR(length=100), autoincrement=False, nullable=False),
    sa.Column(u'description', sa.TEXT(), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint(u'id', name=u'radio_content_type_pkey')
    )
    op.drop_table(u'radio_contenttype')

Example 24

Project: open-event-orga-server Source File: 6415c74704d9_.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('ticket', 'sales_start',
               existing_type=postgresql.TIMESTAMP(),
               nullable=False)
    op.alter_column('ticket', 'sales_end',
               existing_type=postgresql.TIMESTAMP(),
               nullable=False)
    op.alter_column('ticket', 'quantity',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.alter_column('ticket', 'name',
               existing_type=sa.VARCHAR(),
               nullable=False)
    op.drop_column('ticket', 'type')

Example 25

Project: grano Source File: 2b65d3dfa1de_foreign_keys_for_project.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('schema', 'project_id')
    op.drop_column('relation', 'project_id')
    op.drop_column('relation', 'author_id')
    op.drop_column('property', 'author_id')
    op.add_column('project', sa.Column('owner_id', sa.INTEGER(), nullable=True))
    op.drop_column('project', 'author_id')
    op.drop_column('entity', 'project_id')
    op.drop_column('entity', 'author_id')

Example 26

Project: open-event-orga-server Source File: ffb21f7a6e61_.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('format',
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.Column('label_en', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('event_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name=u'format_pkey')
    )

Example 27

Project: open-event-orga-server Source File: c87273102cfb_.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('session', sa.Column('level_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.create_foreign_key(u'session_level_id_fkey', 'session', 'level', ['level_id'], ['id'])
    op.create_table('level',
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('label_en', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.Column('event_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name=u'level_pkey')
    )

Example 28

Project: pittsburgh-purchasing-suite Source File: 3c8dbc9ebf7e_more_robust_opportunities.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column(u'opportunity', sa.Column('created_by', sa.INTEGER(), autoincrement=False, nullable=False, server_default=sa.schema.DefaultClause('1')))
    op.add_column(u'opportunity', sa.Column('docuement', sa.VARCHAR(length=255), autoincrement=False, nullable=True))
    op.add_column(u'opportunity', sa.Column('docuements_needed', postgresql.ARRAY(sa.INTEGER()), autoincrement=False, nullable=True))
    op.add_column(u'opportunity', sa.Column('docuement_href', sa.VARCHAR(length=255), autoincrement=False, nullable=True))
    op.drop_constraint('opportunity_created_by_id_user_id_fkey', 'opportunity', type_='foreignkey')
    op.create_foreign_key(u'opportunity_created_by_user_id_fkey', 'opportunity', 'users', ['created_by'], ['id'])
    op.alter_column(u'opportunity', 'planned_open',
               existing_type=postgresql.TIMESTAMP(),
               nullable=True)
    op.alter_column(u'opportunity', 'planned_deadline',
               existing_type=postgresql.TIMESTAMP(),
               nullable=True)
    op.drop_column(u'opportunity', 'vendor_docuements_needed')
    op.drop_column(u'opportunity', 'planned_advertise')
    op.drop_column(u'opportunity', 'created_by_id')
    op.drop_index(op.f('ix_opportunity_docuement_id'), table_name='opportunity_docuement')
    op.drop_table('opportunity_docuement')

Example 29

Project: funnel Source File: 2d55f804a4ed_remove_proposal_space_id_from_sync_.py
def downgrade():
    op.add_column('sync_ticket', sa.Column('proposal_space_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.create_foreign_key('sync_ticket_proposal_space_id_fkey', 'sync_ticket', 'proposal_space', ['proposal_space_id'], ['id'])
    op.drop_constraint('sync_ticket_ticket_client_id_order_no_ticket_no_key', 'sync_ticket', type_='unique')
    op.create_unique_constraint('sync_ticket_proposal_space_id_order_no_ticket_no_key', 'sync_ticket', ['proposal_space_id', 'order_no', 'ticket_no'])
    # restore proposal_space_ids
    sync_ticket = table('sync_ticket', column('proposal_space_id'), column('ticket_client_id'))
    ticket_client = table('ticket_client', column('id'), column('proposal_space_id'))
    op.execute(
        sync_ticket.update().values({'proposal_space_id': select([ticket_client.c.proposal_space_id]).where(ticket_client.c.id == sync_ticket.c.ticket_client_id)}))

Example 30

Project: rootio_web Source File: 8a9a570b16e_remove_blockedprogra.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table(u'radio_blockedprogram',
    sa.Column(u'id', sa.INTEGER(), nullable=False),
    sa.Column(u'station_id', sa.INTEGER(), nullable=True),
    sa.Column(u'program_id', sa.INTEGER(), nullable=True),
    sa.Column(u'block_id', sa.INTEGER(), nullable=True),
    sa.ForeignKeyConstraint(['block_id'], [u'radio_scheduledblock.id'], ),
    sa.ForeignKeyConstraint(['program_id'], [u'radio_program.id'], ),
    sa.ForeignKeyConstraint(['station_id'], [u'radio_station.id'], ),
    sa.PrimaryKeyConstraint(u'id')
    )

Example 31

Project: funnel Source File: 4aedc1062818_session_edits.py
def upgrade():
    op.alter_column('session', 'start_datetime', new_column_name='start')
    op.alter_column('session', 'end_datetime', new_column_name='end')
    op.alter_column('session', 'venue_room_id',
               existing_type=sa.INTEGER(),
               nullable=True)

Example 32

Project: stalker Source File: 101a789e38ad_created_task_responsible.py
def downgrade():
    try:
        op.drop_column('Tasks', 'responsible_id')
        op.add_column('Sequences',
                      sa.Column('lead_id', sa.INTEGER(), nullable=True))
    except sa.exc.OperationalError:
        pass

Example 33

Project: hasjob Source File: 41d839fcecb4_colnames.py
Function: downgrade
def downgrade():
    op.add_column('jobpost', sa.Column('reviewer', sa.INTEGER(), nullable=True))
    op.drop_column('jobpost', 'user_id')
    op.drop_column('jobpost', 'updated_at')
    op.alter_column('jobpost', 'created_at', new_column_name='created_datetime')

    op.alter_column('reportcode', 'name', new_column_name='slug')
    op.drop_column('reportcode', 'updated_at')
    op.drop_column('reportcode', 'created_at')

    op.alter_column('jobtype', 'name', new_column_name='slug')
    op.drop_column('jobtype', 'updated_at')
    op.drop_column('jobtype', 'created_at')

    op.alter_column('jobcategory', 'name', new_column_name='slug')
    op.drop_column('jobcategory', 'updated_at')
    op.drop_column('jobcategory', 'created_at')

Example 34

Project: rootio_web Source File: 285ff6ea690b_editing_content_tabl.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column(u'content_uploads', sa.Column(u'contenttrack_id', sa.INTEGER(), nullable=True))
    op.add_column(u'content_uploads', sa.Column(u'content_contenttypeid', sa.INTEGER(), nullable=True))
    op.add_column(u'content_uploads', sa.Column(u'expiration_date', postgresql.TIMESTAMP(timezone=True), nullable=True))
    op.drop_column(u'content_uploads', 'type_id')
    op.drop_column(u'content_uploads', 'track_id')
    op.drop_column(u'content_uploads', 'expiry_date')
    op.create_table(u'radio_contenttype',
    sa.Column(u'created_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
    sa.Column(u'updated_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
    sa.Column(u'id', sa.INTEGER(), server_default="nextval('radio_contenttype_id_seq'::regclass)", nullable=False),
    sa.Column(u'name', sa.VARCHAR(length=100), autoincrement=False, nullable=False),
    sa.Column(u'description', sa.TEXT(), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint(u'id', name=u'radio_contenttype_pkey')
    )
    op.drop_table(u'content_type')

Example 35

Project: kcsrv Source File: 83e8534880_ship_modern_fk_goes to_stats_not_resources.py
Function: downgrade
def downgrade():
### commands auto generated by Alembic - please adjust! ###
    op.add_column('ship', sa.Column('modern_resources_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.drop_constraint(None, 'ship', type_='foreignkey')
    op.create_foreign_key('ship_modern_resources_id_fkey', 'ship', 'resources', ['modern_resources_id'], ['id'])
    op.create_index('ix_ship_modern_resources_id', 'ship', ['modern_resources_id'], unique=False)
    op.drop_index(op.f('ix_ship_modern_stats_id'), table_name='ship')
    op.drop_column('ship', 'modern_stats_id')

Example 36

Project: stalker Source File: 6297277da38_added_vacation_class.py
Function: downgrade
def downgrade():
    op.create_table(
        'User_Vacations',
        sa.Column('user_id', sa.INTEGER(), autoincrement=False,
                  nullable=False),
        sa.Column('vacation_id', sa.INTEGER(),
                  autoincrement=False, nullable=False),
        sa.ForeignKeyConstraint(['user_id'], ['Users.id'],
                                name='User_Vacations_user_id_fkey'),
        sa.ForeignKeyConstraint(['vacation_id'], ['Vacations.id'],
                                name='User_Vacations_vacation_id_fkey'),
        sa.PrimaryKeyConstraint('user_id', 'vacation_id',
                                name='User_Vacations_pkey')
    )

Example 37

Project: socorro Source File: 26521f842be2_bug_1030218_group_correlations_by_reason.py
def upgrade():
    load_stored_proc(op, ['update_correlations_addon.sql',
                          'update_correlations_core.sql',
                          'update_correlations_module.sql'])
    op.execute(""" TRUNCATE correlations_addon, correlations_core, correlations_module""")
    op.add_column(u'correlations_addon', sa.Column('reason_id', sa.INTEGER(), nullable=False))
    op.add_column(u'correlations_core', sa.Column('reason_id', sa.INTEGER(), nullable=False))
    op.add_column(u'correlations_module', sa.Column('reason_id', sa.INTEGER(), nullable=False))

Example 38

Project: alembic Source File: test_autogen_diffs.py
    def test_integer(self):
        t1 = Integer()
        t2 = SmallInteger()
        t3 = BIGINT()
        t4 = String()
        t5 = INTEGER()
        t6 = BigInteger()

        impl = self._fixture()
        is_(impl.compare_type(Column('x', t5), Column('x', t1)), False)
        is_(impl.compare_type(Column('x', t3), Column('x', t1)), True)
        is_(impl.compare_type(Column('x', t3), Column('x', t6)), False)
        is_(impl.compare_type(Column('x', t3), Column('x', t2)), True)
        is_(impl.compare_type(Column('x', t5), Column('x', t2)), True)
        is_(impl.compare_type(Column('x', t1), Column('x', t4)), True)

Example 39

Project: socorro Source File: 2c03d8ea0a50_adding_in_a_suspicio.py
Function: upgrade
def upgrade():
    op.create_table(u'suspicious_crash_signatures',
        sa.Column(u'suspicious_crash_signature_id', sa.INTEGER()),
        sa.Column(u'signature_id', sa.INTEGER()),
        sa.Column(u'report_date', sa.TIMESTAMP(timezone=True))
    )

Example 40

Project: stalker Source File: af869ddfdf9_entity_to_note_relation_is_now_many_to_many.py
Function: downgrade
def downgrade():
    op.add_column(
        'Notes',
        sa.Column('entity_id', sa.INTEGER(), nullable=True)
    )

    # restore data
    op.execute("""
        UPDATE
           "Notes"
        SET
            entity_id = "Entity_Notes".entity_id
        FROM "Entity_Notes"
        WHERE "Notes".id = "Entity_Notes".note_id
    """)

    op.drop_table('Entity_Notes')

Example 41

Project: socorro Source File: 3e872b0759f0_bug_1025987_bigint_is_overkill.py
Function: upgrade
def upgrade():
    op.alter_column(u'correlations_addon', u'total',
               type_=sa.INTEGER(),
               nullable=False)
    op.alter_column(u'correlations_core', u'total',
               type_=sa.INTEGER(),
               nullable=False)
    op.alter_column(u'correlations_module', u'total',
               type_=sa.INTEGER(),
               nullable=False)

Example 42

Project: rootio_web Source File: 15d91338011f_call_change.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column(u'telephony_call', sa.Column(u'to_phonenumber_id', sa.INTEGER(), nullable=True))
    op.add_column(u'telephony_call', sa.Column(u'from_phonenumber_id', sa.INTEGER(), nullable=True))
    op.drop_column(u'telephony_call', 'to_phonenumber')
    op.drop_column(u'telephony_call', 'from_phonenumber')

Example 43

Project: koschei Source File: 21bcf7db927c_change_group_key.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('package_group_relation', sa.Column('package_id', sa.INTEGER(), autoincrement=False, nullable=False))
    op.create_foreign_key(u'package_group_relation_package_id_fkey', 'package_group_relation', 'package', ['package_id'], ['id'], ondelete=u'CASCADE')
    op.drop_index('ix_package_group_relation_package_name', table_name='package_group_relation')
    op.drop_index('ix_package_group_relation_group_id', table_name='package_group_relation')
    op.drop_column('package_group_relation', 'package_name')

Example 44

Project: open-event-orga-server Source File: 1b34cefe5f92_.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('session_type', sa.Column('session_id', sa.INTEGER(), autoincrement=False, nullable=True))
    op.create_foreign_key(u'session_type_session_id_fkey', 'session_type', 'session', ['session_id'], ['id'])
    op.drop_constraint(None, 'session', type_='foreignkey')
    op.drop_column('session', 'session_type_id')

Example 45

Project: gamification-engine Source File: 16b4a243d41d_nullable.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('goals', 'achievement_id',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('achievements_rewards', 'reward_id',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('achievements_rewards', 'achievement_id',
               existing_type=sa.INTEGER(),
               nullable=True)

Example 46

Project: pygotham Source File: 4a435efab65_add_event_id_to_announcements_and_.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.alter_column('sponsor_levels', 'event_id',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.alter_column('announcements', 'event_id',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.drop_constraint(op.f('sponsor_levels_event_id_fkey'), 'sponsor_levels', type_='foreignkey')
    op.drop_column('sponsor_levels', 'event_id')
    op.drop_constraint(op.f('announcements_event_id_fkey'), 'announcements', type_='foreignkey')
    op.drop_column('announcements', 'event_id')

Example 47

Project: rootio_web Source File: 1e09e4b69a8c_remove_redundant_rel.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('onair_program', sa.Column('scheduledepisode_id', sa.INTEGER(), nullable=True))
    op.drop_column('onair_program', 'scheduledprogram_id')
    op.drop_column('onair_program', 'episode_id')
    op.create_table('radio_content_type',
    sa.Column('created_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
    sa.Column('updated_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
    sa.Column('id', sa.INTEGER(), server_default="nextval('radio_content_type_id_seq'::regclass)", nullable=False),
    sa.Column('name', sa.VARCHAR(length=100), autoincrement=False, nullable=False),
    sa.Column('description', sa.TEXT(), autoincrement=False, nullable=False),
    sa.PrimaryKeyConstraint('id', name=u'radio_content_type_pkey')
    )

Example 48

Project: rootio_web Source File: 571474b47435_introduce_network_us.py
Function: downgrade
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table(u'radio_networkadmins',
    sa.Column(u'user_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column(u'network_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['network_id'], [u'radio_network.id'], name=u'radio_networkadmins_network_id_fkey'),
    sa.ForeignKeyConstraint(['user_id'], [u'user_user.id'], name=u'radio_networkadmins_user_id_fkey'),
    sa.PrimaryKeyConstraint()
    )
    op.drop_table(u'radio_networkusers')

Example 49

Project: pittsburgh-purchasing-suite Source File: 27c899412dc7_better_nigp_codes.py
def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column(u'category', sa.Column('nigp_code', sa.INTEGER(), autoincrement=False, nullable=True))
    op.drop_column(u'category', 'nigp_codes')
    op.drop_column(u'category', 'examples_tsv')
    op.drop_column(u'category', 'examples')
    op.drop_column(u'category', 'category_friendly_name')

Example 50

Project: open-event-orga-server Source File: dbb79ff12e45_.py
Function: upgrade
def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('social_link',
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('name', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('link', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('event_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['event_id'], [u'events.id'], name=u'social_link_event_id_fkey'),
    sa.PrimaryKeyConstraint('id', name=u'social_link_pkey')
    )
See More Examples - Go to Next Page
Page 1 Selected Page 2 Page 3