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
3
Example 1
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))
3
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)
3
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())
3
Example 4
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()
)
3
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')
)
3
Example 6
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)
)
3
Example 7
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())
3
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)
3
Example 9
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')
)
3
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')
)
3
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')
3
Example 12
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')
3
Example 13
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')
)
3
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')
3
Example 15
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))
3
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')
3
Example 17
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)
)
3
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)
)
3
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')
3
Example 20
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')
3
Example 21
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')
)
3
Example 22
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')
)
3
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')
3
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')
3
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')
3
Example 26
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')
)
3
Example 27
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')
)
3
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')
3
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)}))
3
Example 30
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')
)
3
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)
3
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
3
Example 33
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')
3
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')
3
Example 35
Project: kcsrv Source File: 83e8534880_ship_modern_fk_goes to_stats_not_resources.py
Function: downgrade
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')
3
Example 36
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')
)
3
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))
3
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)
3
Example 39
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))
)
3
Example 40
Project: stalker Source File: af869ddfdf9_entity_to_note_relation_is_now_many_to_many.py
Function: downgrade
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')
3
Example 41
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)
3
Example 42
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')
3
Example 43
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')
3
Example 44
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')
3
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)
3
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')
3
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')
)
3
Example 48
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')
3
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')
3
Example 50
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')
)