def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, "users", type_="foreignkey") op.drop_column("users", "team_id") op.drop_column("users", "shirt_size") op.drop_column("users", "allergies") op.drop_table("teams")
def downgrade(): connection = op.get_bind() # Create old AZ fields op.add_column('services', Column('availability_zone', String(length=255))) op.add_column('share_instances', Column('availability_zone', String(length=255))) # Migrate data az_table = utils.load_table('availability_zones', connection) share_instances_table = utils.load_table('share_instances', connection) services_table = utils.load_table('services', connection) for az in connection.execute(az_table.select()): op.execute( share_instances_table.update().where( share_instances_table.c.availability_zone_id == az.id ).values({'availability_zone': az.name}) ) op.execute( services_table.update().where( services_table.c.availability_zone_id == az.id ).values({'availability_zone': az.name}) ) # Remove AZ_id columns and AZ table op.drop_constraint('service_az_id_fk', 'services', type_='foreignkey') op.drop_column('services', 'availability_zone_id') op.drop_constraint('si_az_id_fk', 'share_instances', type_='foreignkey') op.drop_column('share_instances', 'availability_zone_id') op.drop_table('availability_zones')
def upgrade(): conn = op.get_bind() op.add_column('external_identities', sa.Column('local_user_id', sa.Integer())) external_identities_t = table('external_identities', sa.Column('local_user_name', sa.Unicode(50)), sa.Column('local_user_id', sa.Integer)) users_t = table('users', sa.Column('user_name', sa.Unicode(50)), sa.Column('id', sa.Integer)) stmt = external_identities_t.update().values(local_user_id=users_t.c.id). \ where(users_t.c.user_name == external_identities_t.c.local_user_name) conn.execute(stmt) op.drop_constraint('pk_external_identities', 'external_identities', type='primary') op.drop_constraint('fk_external_identities_local_user_name_users', 'external_identities', type='foreignkey') op.drop_column('external_identities', 'local_user_name') op.create_primary_key('pk_external_identities', 'external_identities', cols=['external_id', 'local_user_id', 'provider_name']) op.create_foreign_key(None, 'external_identities', 'users', remote_cols=['id'], local_cols=['local_user_id'], onupdate='CASCADE', ondelete='CASCADE')
def downgrade(): op.drop_column("metrics", "created_on") op.drop_column("metrics", "created_by_fk") op.drop_column("metrics", "changed_on") op.drop_column("metrics", "changed_by_fk") try: op.alter_column("url", "created_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("url", "changed_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("tables", "created_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("tables", "changed_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("table_columns", "created_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("table_columns", "changed_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("sql_metrics", "created_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("sql_metrics", "changed_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("slices", "created_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("slices", "changed_on", existing_type=sa.DATETIME(), nullable=False) op.drop_constraint(None, "metrics", type_="foreignkey") op.drop_constraint(None, "metrics", type_="foreignkey") op.alter_column("dbs", "created_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("dbs", "changed_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("datasources", "created_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("datasources", "created_by_fk", existing_type=sa.INTEGER(), nullable=False) op.alter_column("datasources", "changed_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("datasources", "changed_by_fk", existing_type=sa.INTEGER(), nullable=False) op.alter_column("dashboards", "created_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("dashboards", "changed_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("css_templates", "created_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("css_templates", "changed_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("columns", "created_on", existing_type=sa.DATETIME(), nullable=False) op.alter_column("columns", "changed_on", existing_type=sa.DATETIME(), nullable=False) except: pass
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'whoyoulookinat') op.create_unique_constraint(u'whoyoulookinat_user_id_looking_at_twitter_display_name_key', 'whoyoulookinat', [u'looking_at_twitter_display_name', u'user_id']) op.drop_constraint(None, 'twitter_friends_cache') op.create_unique_constraint(u'twitter_friends_cache_twitter_id_friend_twitter_id_key', 'twitter_friends_cache', [u'friend_twitter_id', u'twitter_id']) op.drop_table('received_transitory_glance')
def downgrade(): op.drop_constraint("reportunknownpackages_report_id_key", t) op.drop_constraint("reportunknownpackages_arch_id_fkey", t) op.add_column(t, sa.Column('running_epoch', sa.Integer(), nullable=True)) op.add_column(t, sa.Column('running_version', sa.String(64), nullable=True)) op.add_column(t, sa.Column('running_release', sa.String(64), nullable=True)) op.add_column(t, sa.Column('running_arch_id', sa.Integer(), sa.ForeignKey('archs.id'), nullable=True)) op.alter_column(t, "epoch", new_column_name="installed_epoch") op.alter_column(t, "version", new_column_name="installed_version") op.alter_column(t, "release", new_column_name="installed_release") op.alter_column(t, "arch_id", new_column_name="installed_arch_id") fields = ["report_id", "type", "name", "installed_epoch", "installed_version", "installed_release", "installed_arch_id", "running_epoch", "running_version", "running_release", "running_arch_id"] op.create_unique_constraint("reportunknownpackages_report_id_key", t, fields) op.create_foreign_key("reportunknownpackages_installed_arch_id_fkey", t, "archs", ["installed_arch_id"], ["id"])
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_column(u'tracks', 'location') op.drop_constraint(None, 'sponsors', type_='foreignkey') op.drop_column(u'sponsors', 'sponsor_type_id') op.drop_column(u'sponsors', 'description') op.drop_table('sponsor_type')
def downgrade(): """Downgrade database schema and/or data back to the previous revision.""" op.drop_constraint("fk_assessments_audits", "assessments", type_="foreignkey") op.drop_constraint("fk_issues_audits", "issues", type_="foreignkey") op.drop_column("assessments", "audit_id") op.drop_column("issues", "audit_id")
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(u'notes_section_id_fkey', 'notes', type_='foreignkey') op.drop_column('notes', 'section_id') op.drop_table('sections') op.add_column('notes', sa.Column('notebook_id', sa.Integer(), nullable=True)) op.create_foreign_key(None, 'notes', 'notebooks', ['notebook_id'], ['id'])
def upgrade(): # OpenStack has decided that "down" migrations are not supported. # The downgrade() method has been omitted for this reason. op.add_column('listener_statistics', sa.Column('amphora_id', sa.String(36), nullable=False) ) op.drop_constraint('fk_listener_statistics_listener_id', 'listener_statistics', type_='foreignkey') op.drop_constraint('PRIMARY', 'listener_statistics', type_='primary') op.create_primary_key('pk_listener_statistics', 'listener_statistics', ['listener_id', 'amphora_id']) op.create_foreign_key('fk_listener_statistics_listener_id', 'listener_statistics', 'listener', ['listener_id'], ['id']) op.create_foreign_key('fk_listener_statistic_amphora_id', 'listener_statistics', 'amphora', ['amphora_id'], ['id'])
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_index(op.f('ix_games_api_key'), 'games', ['api_key'], unique=True) op.drop_constraint(u'games_api_key_key', 'games', type_='unique') op.alter_column('users', 'game_id', existing_type=sa.INTEGER(), nullable=True)
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_constraint('releases_uniq', 'releases', type_='unique') op.create_unique_constraint('releases_name_group_id_posted_key', 'releases', ['name', 'group_id', 'posted']) op.drop_column('releases', 'uniqhash') op.drop_constraint('pres_uniq', 'pres', type_='unique') op.create_unique_constraint('pres_name_key', 'pres', ['name'])
def upgrade(): conn = op.get_bind() # Minimal examples of the tables we need to manipulate listener = sa.sql.table( 'listener', sa.sql.column('load_balancer_id', sa.String), sa.sql.column('default_pool_id', sa.String)) pool = sa.sql.table( 'pool', sa.sql.column('load_balancer_id', sa.String), sa.sql.column('id', sa.String)) # This foreign key does not need to be unique anymore. To remove the # uniqueness but keep the foreign key we have to do some juggling. op.drop_constraint('fk_listener_pool_id', 'listener', type_='foreignkey') op.drop_constraint('uq_listener_default_pool_id', 'listener', type_='unique') op.create_foreign_key('fk_listener_pool_id', 'listener', 'pool', ['default_pool_id'], ['id']) op.add_column(u'pool', sa.Column('load_balancer_id', sa.String(36), sa.ForeignKey('load_balancer.id'), nullable=True)) # Populate this new column appropriately select_obj = sa.select([listener.c.load_balancer_id, listener.c.default_pool_id]).where( listener.c.default_pool_id is not None) result = conn.execute(select_obj) for row in result: stmt = pool.update().values(load_balancer_id=row[0]).where( pool.c.id == row[1]) op.execute(stmt)
def downgrade(): op.drop_constraint( 'fk_environments_zone_id_zones', 'environments', type_='foreignkey' ) op.drop_column('environments', 'zone_id')
def upgrade(): # drop duplicate pres conn = op.get_bind() conn.execute(''' DELETE FROM pres WHERE id IN (SELECT id FROM (SELECT id, row_number() over (partition BY requestid, pretime, requestgroup ORDER BY id) AS rnum FROM pres) t WHERE t.rnum > 1); ''') ### commands auto generated by Alembic - please adjust! ### op.drop_constraint('pres_name_key', 'pres', type_='unique') op.create_unique_constraint('pres_uniq', 'pres', ['requestid', 'pretime', 'requestgroup']) op.add_column('releases', sa.Column('uniqhash', sa.String(length=40), nullable=True)) op.drop_constraint('releases_name_group_id_posted_key', 'releases', type_='unique') op.create_unique_constraint('releases_uniq', 'releases', ['uniqhash']) session = sessionmaker(bind=conn)() # update the hashes q = session.query(Release.id, Release.name, Release.group_id, Release.posted) for release in windowed_query(q, Release.id, 1000): uniqhash = hashlib.sha1( '{}.{}.{}'.format( release.name, release.group_id, release.posted, ).encode('utf-8') ).hexdigest() session.query(Release).filter(Release.id==release.id).update({Release.uniqhash: uniqhash}) session.commit()
def downgrade(): # Was unable to find a way to use op.alter_column() to remove the # unique index property. if op.get_context().bind.dialect.name == 'mssql': op.drop_constraint('uq_queue_members_uniqueid', 'queue_members') op.drop_column('queue_members', 'uniqueid') op.add_column('queue_members', sa.Column(name='uniqueid', type_=sa.String(80), nullable=False))
def downgrade(): if 'easfoldersync' in Base.metadata.tables: op.create_unique_constraint('account_id', 'easfoldersync', ['account_id', 'folder_name']) op.drop_constraint('uq_account_id_eas_folder_id', 'easfoldersync', type_='unique')
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.add_column('gene', sa.Column('reference_assembly_id', sa.Integer(), nullable=True)) op.create_unique_constraint('gene_within_assembly_unique', 'gene', ['name', 'reference_assembly_id']) op.drop_constraint('gene_reference_assemlby_id_fkey', 'gene', type_='foreignkey') op.create_foreign_key(None, 'gene', 'reference_assembly', ['reference_assembly_id'], ['id']) op.drop_column('gene', 'reference_assemlby_id')
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.add_column('gene', sa.Column('reference_assemlby_id', sa.INTEGER(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'gene', type_='foreignkey') op.create_foreign_key('gene_reference_assemlby_id_fkey', 'gene', 'reference_assembly', ['reference_assemlby_id'], ['id']) op.drop_constraint('gene_within_assembly_unique', 'gene', type_='unique') op.drop_column('gene', 'reference_assembly_id')
def upgrade(): op.drop_constraint('fk_organization_owners_id', 'organization', type_='foreignkey') op.create_foreign_key('organization_owners_id_fkey', 'organization', 'team', ['owners_id'], ['id']) op.add_column('organization', sa.Column('members_id', sa.Integer(), nullable=True)) op.create_foreign_key('organization_members_id_fkey', 'organization', 'team', ['members_id'], ['id']) op.add_column('team', sa.Column('domain', sa.Unicode(length=253), nullable=True)) op.create_index(op.f('ix_team_domain'), 'team', ['domain'], unique=False)
def downgrade(): op.drop_index(op.f('ix_team_domain'), table_name='team') op.drop_column('team', 'domain') op.drop_constraint('organization_members_id_fkey', 'organization', type_='foreignkey') op.drop_column('organization', 'members_id') op.drop_constraint('organization_owners_id_fkey', 'organization', type_='foreignkey') op.create_foreign_key('fk_organization_owners_id', 'organization', 'team', ['owners_id'], ['id'])
def downgrade(): op.drop_constraint( u'uix_filepath_username', 'files', schema='pgcontents', type_='unique' )
def upgrade(): op.create_table('risk_assessment_control_mappings', sa.Column('id', sa.Integer(), nullable=False), sa.Column('control_strength', sa.Text(), nullable=True), sa.Column('residual_risk', sa.Text(), nullable=True), sa.Column('risk_assessment_mapping_id', sa.Integer(), nullable=False), sa.Column('threat_id', sa.Integer(), nullable=False), sa.Column('control_id', sa.Integer(), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('modified_by_id', sa.Integer(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.Column('context_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['context_id'], ['contexts.id'], ), sa.ForeignKeyConstraint(['control_id'], ['controls.id'], ), sa.ForeignKeyConstraint(['risk_assessment_mapping_id'], ['risk_assessment_mappings.id'], ), sa.ForeignKeyConstraint(['threat_id'], ['threats.id'], ), sa.PrimaryKeyConstraint('id') ) op.drop_constraint( 'risk_assessment_mappings_ibfk_2', 'risk_assessment_mappings', type_='foreignkey') op.drop_column('risk_assessment_mappings', u'control_id') op.drop_column('risk_assessment_mappings', u'residual_risk') op.drop_column('risk_assessment_mappings', u'control_strength')
def upgrade(): if migration.schema_has_table('nsxv3_lbaas_l7rules'): op.drop_constraint('fk_nsxv3_lbaas_l7rules_id', 'nsxv3_lbaas_l7rules', 'foreignkey') op.drop_constraint('l7rule_id', 'nsxv3_lbaas_l7rules', 'primary') op.drop_column('nsxv3_lbaas_l7rules', 'loadbalancer_id') op.drop_column('nsxv3_lbaas_l7rules', 'l7rule_id') op.rename_table('nsxv3_lbaas_l7rules', 'nsxv3_lbaas_l7policies') if migration.schema_has_table('lbaas_l7policies'): op.create_foreign_key( 'fk_nsxv3_lbaas_l7policies_id', 'nsxv3_lbaas_l7policies', 'lbaas_l7policies', ['l7policy_id'], ['id'], ondelete='CASCADE') else: op.create_table( 'nsxv3_lbaas_l7policies', sa.Column('l7policy_id', sa.String(36), nullable=False), sa.Column('lb_rule_id', sa.String(36), nullable=False), sa.Column('lb_vs_id', sa.String(36), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('l7policy_id')) if migration.schema_has_table('lbaas_l7policies'): op.create_foreign_key( 'fk_nsxv3_lbaas_l7policies_id', 'nsxv3_lbaas_l7policies', 'lbaas_l7policies', ['l7policy_id'], ['id'], ondelete='CASCADE')
def remove_foreign_keys(table, foreign_keys): for fk in foreign_keys: op.drop_constraint( constraint_name=fk['name'], table_name=table, type_='foreignkey' )
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.alter_column('user', 'email', existing_type=sa.VARCHAR(length=254), nullable=False) op.drop_constraint('category_name_unique', 'category', type_='unique') op.drop_table('item')
def downgrade(): from inbox.ignition import main_engine engine = main_engine(pool_size=1, max_overflow=0) if not engine.has_table('easaccount'): return op.drop_constraint('easaccount_ibfk_2', 'easaccount', type_='foreignkey') op.drop_column('easaccount', 'password_id')
def index_cleanup(engine_names, table_name, uniq_name, columns, create, unique, limited): bind = op.get_bind() engine = bind.engine if engine.name not in engine_names: return if create: if limited and engine.name == 'mysql': # For some versions of mysql we can get an error # "Specified key was too long; max key length is 1000 bytes". # We should create an index by hand in this case with limited # length of columns. meta = sa.MetaData() meta.bind = engine table = sa.Table(table_name, meta, autoload=True) columns_mysql = ",".join((c + "(100)" for c in columns)) sql = ("create index %s ON %s (%s)" % (uniq_name, table, columns_mysql)) engine.execute(sql) else: op.create_index(uniq_name, table_name, columns, unique=unique) else: if unique: op.drop_constraint(uniq_name, table_name, type='unique') else: op.drop_index(uniq_name, table_name=table_name)
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.add_column(u'user', sa.Column('org_id', sa.INTEGER(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'user', type_='foreignkey') op.create_foreign_key(u'user_org_id_fkey', 'user', 'org', ['org_id'], ['id']) op.drop_column(u'user', 'team_id') op.drop_table('team')
def drop_foreign_key_constraint(table_name, fk_constraints): for fk in fk_constraints: op.drop_constraint( constraint_name=fk['name'], table_name=table_name, type_='foreignkey' )
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'users', type_='foreignkey') op.drop_index(op.f('ix_users_username'), table_name='users') op.drop_column('users', 'roles_id')
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'user', type_='unique') op.drop_index(op.f('ix_user_username'), table_name='user') op.create_index('ix_user_username', 'user', ['username'], unique=True) op.drop_column('user', 'social_id')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'todos', type_='foreignkey') op.drop_column('todos', 'list_id') op.drop_table('todolists')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'user_o2m_role', type_='foreignkey') op.drop_constraint(None, 'user_o2m_role', type_='foreignkey') op.drop_constraint(None, 'switch', type_='foreignkey') op.drop_constraint(None, 'server', type_='foreignkey') op.drop_constraint(None, 'role_o2m_permission', type_='foreignkey') op.drop_constraint(None, 'role_o2m_permission', type_='foreignkey') op.drop_constraint(None, 'cabinet', type_='foreignkey')
def downgrade(): op.drop_constraint(op.f('fk_admin_account_access_group_id_access_group'), 'admin_account', type_='foreignkey') op.drop_column('admin_account', 'access_group_id') op.drop_table('access_group')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint('job_names_must_be_unique_within_user', 'jobs', type_='unique')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'user', type_='unique')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint('seat_hall_id_fkey', 'seat', type_='foreignkey') op.create_foreign_key(None, 'seat', 'hall', ['hall_id'], ['hall_id']) op.create_unique_constraint('unique_ticket_seat_and_seance', 'ticket', ['seat_id', 'seance_id'])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'products', type_='foreignkey') op.drop_column('products', 'seller_id')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint('unique_ticket_seat_and_seance', 'ticket', type_='unique') op.drop_constraint(None, 'seat', type_='foreignkey') op.create_foreign_key('seat_hall_id_fkey', 'seat', 'hall', ['hall_id'], ['hall_id'], ondelete='CASCADE')
def upgrade(): op.add_column('core_plugin_config', sa.Column('type', sa.Unicode(length=30), nullable=False)) op.drop_constraint('PRIMARY', 'core_plugin_config', type_='primary') op.create_primary_key('prim', 'core_plugin_config', ['id', 'type', 'hostname', 'key'])
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'Clubs', type_='unique') op.drop_column('Clubs', 'public_id')
def downgrade(): op.drop_constraint("uq__token__refresh_token", "token")
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('post', sa.Column('user_id', sa.Integer(), nullable=True)) op.create_foreign_key(None, 'post', 'user', ['user_id'], ['user_id']) op.drop_constraint('user_posts_fkey', 'user', type_='foreignkey') op.drop_column('user', 'posts')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, "workflow", type_="foreignkey") op.drop_column("workflow", "project_id") op.drop_constraint(None, "term", type_="foreignkey") op.drop_column("term", "project_id") op.drop_constraint(None, "team_contact", type_="foreignkey") op.drop_column("team_contact", "project_id") op.drop_constraint(None, "tag_type", type_="foreignkey") op.drop_column("tag_type", "project_id") op.drop_constraint(None, "tag", type_="foreignkey") op.drop_column("tag", "project_id") op.drop_constraint(None, "service", type_="foreignkey") op.drop_column("service", "project_id") op.drop_constraint(None, "search_filter", type_="foreignkey") op.drop_column("search_filter", "project_id") op.drop_constraint(None, "plugin", type_="foreignkey") op.drop_column("plugin", "project_id") op.drop_constraint(None, "notification", type_="foreignkey") op.drop_column("notification", "project_id") op.drop_constraint(None, "individual_contact", type_="foreignkey") op.drop_column("individual_contact", "project_id") op.drop_constraint(None, "incident_type", type_="foreignkey") op.drop_column("incident_type", "project_id") op.drop_constraint(None, "incident_priority", type_="foreignkey") op.drop_column("incident_priority", "project_id") op.drop_constraint(None, "incident_cost_type", type_="foreignkey") op.drop_column("incident_cost_type", "project_id") op.drop_constraint(None, "incident_cost", type_="foreignkey") op.drop_column("incident_cost", "project_id") op.drop_constraint(None, "incident", type_="foreignkey") op.drop_column("incident", "project_id") op.drop_constraint(None, "document", type_="foreignkey") op.drop_column("document", "project_id") op.add_column( "dispatch_user", sa.Column("role", sa.VARCHAR(), autoincrement=False, nullable=False)) op.drop_constraint(None, "definition", type_="foreignkey") op.drop_column("definition", "project_id") op.drop_table("dispatch_user_projects") op.drop_index("ix_project_search_vector", table_name="project") op.drop_table("project") op.drop_table("dispatch_user_organizations") op.drop_index("ix_organization_search_vector", table_name="organization") op.drop_table("organization")
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'comments', type_='unique') op.drop_column('comments', 'report')
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'submission', type_='foreignkey') op.drop_column('submission', 'submittedVersionId')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'users', type_='foreignkey') op.drop_column('users', 'default_random_alias_domain_id')
def downgrade(): op.drop_constraint('games_ibfk_4', 'games', type_='foreignkey') op.drop_column('games', 'tournament_id') op.add_column('games', Column('tournament_game', Boolean, nullable=False))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, "doc_tag", type_="foreignkey") op.drop_constraint(None, "doc_tag", type_="foreignkey") op.create_foreign_key(None, "doc_tag", "doc", ["doc_id"], ["id"]) op.create_foreign_key(None, "doc_tag", "tag", ["tag_id"], ["id"])
def downgrade(): op.drop_constraint(None, 'dashboard_status_report', type_='foreignkey') op.drop_column('dashboard_status_report', 'electionId')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'games', type_='foreignkey') op.drop_column('games', 'user_id') op.drop_table('users')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'tx_county_aggregate', sa.Column('county_name', sa.VARCHAR(length=255), autoincrement=False, nullable=True)) op.drop_constraint(None, 'tx_county_aggregate', type_='unique') op.create_unique_constraint( 'tx_county_aggregate_fips_report_date_report_granularity_key', 'tx_county_aggregate', ['fips', 'report_date', 'report_granularity']) op.alter_column('tx_county_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=True) op.alter_column('tx_county_aggregate', 'report_date', existing_type=sa.DATE(), nullable=True) op.alter_column('tx_county_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=True) op.drop_column('tx_county_aggregate', 'facility_name') op.drop_index(op.f('ix_person_history_region'), table_name='person_history') op.drop_index(op.f('ix_person_history_external_id'), table_name='person_history') op.drop_constraint(None, 'ny_facility_aggregate', type_='unique') op.create_unique_constraint( 'ny_facility_aggregate_fips_report_date_report_granularity_key', 'ny_facility_aggregate', ['fips', 'report_date', 'report_granularity']) op.alter_column('ny_facility_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=True) op.alter_column('ny_facility_aggregate', 'report_date', existing_type=sa.DATE(), nullable=True) op.alter_column('ny_facility_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('ny_facility_aggregate', 'facility_name', existing_type=sa.VARCHAR(length=255), nullable=True) op.drop_constraint(None, 'ky_county_aggregate', type_='unique') op.create_unique_constraint( 'ky_county_aggregate_fips_report_date_report_granularity_key', 'ky_county_aggregate', ['fips', 'report_date', 'report_granularity']) op.alter_column('ky_county_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=True) op.alter_column('ky_county_aggregate', 'report_date', existing_type=sa.DATE(), nullable=True) op.alter_column('ky_county_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('ky_county_aggregate', 'facility_name', existing_type=sa.VARCHAR(length=255), nullable=True) op.drop_constraint(None, 'hi_facility_aggregate', type_='unique') op.create_unique_constraint( 'hi_facility_aggregate_fips_report_date_report_granularity_key', 'hi_facility_aggregate', ['fips', 'report_date', 'report_granularity']) op.alter_column('hi_facility_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=True) op.alter_column('hi_facility_aggregate', 'report_date', existing_type=sa.DATE(), nullable=True) op.alter_column('hi_facility_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('hi_facility_aggregate', 'facility_name', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('ga_county_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=True) op.alter_column('ga_county_aggregate', 'report_date', existing_type=sa.DATE(), nullable=True) op.alter_column('ga_county_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('ga_county_aggregate', 'county_name', existing_type=sa.VARCHAR(length=255), nullable=True) op.drop_constraint(None, 'fl_facility_aggregate', type_='unique') op.create_unique_constraint( 'fl_facility_aggregate_fips_report_date_report_granularity_key', 'fl_facility_aggregate', ['fips', 'report_date', 'report_granularity']) op.alter_column('fl_facility_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=True) op.alter_column('fl_facility_aggregate', 'report_date', existing_type=sa.DATE(), nullable=True) op.alter_column('fl_facility_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('fl_facility_aggregate', 'facility_name', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('fl_county_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=True) op.alter_column('fl_county_aggregate', 'report_date', existing_type=sa.DATE(), nullable=True) op.alter_column('fl_county_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('fl_county_aggregate', 'county_name', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('dc_facility_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=True) op.alter_column('dc_facility_aggregate', 'report_date', existing_type=sa.DATE(), nullable=True) op.alter_column('dc_facility_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=True) op.alter_column('dc_facility_aggregate', 'facility_name', existing_type=sa.VARCHAR(length=255), nullable=True) op.drop_table('ca_facility_aggregate')
def downgrade(): op.drop_constraint("asset_market_id_fkey", "asset", type_="foreignkey") op.drop_column("asset", "market_id")
def downgrade(): op.drop_constraint(u'unq_task_number', 'task', type_='unique') op.drop_column('task', 'number')
def upgrade(): op.drop_constraint('ft_billing_pkey', 'ft_billing', type_='primary') op.create_primary_key('ft_billing_pkey', 'ft_billing', [ 'bst_date', 'template_id', 'service_id', 'notification_type', 'provider', 'rate_multiplier', 'international', 'rate', 'postage' ])
def schema_downgrades(): """schema downgrade migrations go here.""" op.drop_constraint(None, 'devices', type_='foreignkey') op.drop_column('devices', 'dep_profile_id')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'ca_facility_aggregate', sa.Column('record_id', sa.Integer(), nullable=False), sa.Column('fips', sa.String(length=255), nullable=False), sa.Column('report_date', sa.Date(), nullable=False), # Set as string to force alembic to stop trying to re-create the enum # Will migrate to enum separately sa.Column('report_granularity', sa.String(length=255), nullable=False), sa.Column('jurisdiction_name', sa.String(length=255), nullable=True), sa.Column('facility_name', sa.String(length=255), nullable=True), sa.Column('average_daily_population', sa.String(length=255), nullable=True), sa.Column('unsentenced_male_adp', sa.String(length=255), nullable=True), sa.Column('unsentenced_female_adp', sa.String(length=255), nullable=True), sa.Column('sentenced_male_adp', sa.String(length=255), nullable=True), sa.Column('sentenced_female_adp', sa.String(length=255), nullable=True), sa.PrimaryKeyConstraint('record_id'), sa.UniqueConstraint('fips', 'facility_name', 'report_date', 'report_granularity')) op.alter_column('dc_facility_aggregate', 'facility_name', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('dc_facility_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('dc_facility_aggregate', 'report_date', existing_type=sa.DATE(), nullable=False) op.alter_column('dc_facility_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=False) op.alter_column('fl_county_aggregate', 'county_name', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('fl_county_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('fl_county_aggregate', 'report_date', existing_type=sa.DATE(), nullable=False) op.alter_column('fl_county_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=False) op.alter_column('fl_facility_aggregate', 'facility_name', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('fl_facility_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('fl_facility_aggregate', 'report_date', existing_type=sa.DATE(), nullable=False) op.alter_column('fl_facility_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=False) op.drop_constraint( 'fl_facility_aggregate_fips_report_date_report_granularity_key', 'fl_facility_aggregate', type_='unique') op.create_unique_constraint( None, 'fl_facility_aggregate', ['fips', 'facility_name', 'report_date', 'report_granularity']) op.alter_column('ga_county_aggregate', 'county_name', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('ga_county_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('ga_county_aggregate', 'report_date', existing_type=sa.DATE(), nullable=False) op.alter_column('ga_county_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=False) op.alter_column('hi_facility_aggregate', 'facility_name', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('hi_facility_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('hi_facility_aggregate', 'report_date', existing_type=sa.DATE(), nullable=False) op.alter_column('hi_facility_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=False) op.drop_constraint( 'hi_facility_aggregate_fips_report_date_report_granularity_key', 'hi_facility_aggregate', type_='unique') op.create_unique_constraint( None, 'hi_facility_aggregate', ['fips', 'facility_name', 'report_date', 'report_granularity']) op.alter_column('ky_county_aggregate', 'facility_name', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('ky_county_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('ky_county_aggregate', 'report_date', existing_type=sa.DATE(), nullable=False) op.alter_column('ky_county_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=False) op.drop_constraint( 'ky_county_aggregate_fips_report_date_report_granularity_key', 'ky_county_aggregate', type_='unique') op.create_unique_constraint( None, 'ky_county_aggregate', ['fips', 'facility_name', 'report_date', 'report_granularity']) op.alter_column('ny_facility_aggregate', 'facility_name', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('ny_facility_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('ny_facility_aggregate', 'report_date', existing_type=sa.DATE(), nullable=False) op.alter_column('ny_facility_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=False) op.drop_constraint( 'ny_facility_aggregate_fips_report_date_report_granularity_key', 'ny_facility_aggregate', type_='unique') op.create_unique_constraint( None, 'ny_facility_aggregate', ['fips', 'facility_name', 'report_date', 'report_granularity']) op.create_index(op.f('ix_person_history_external_id'), 'person_history', ['external_id'], unique=False) op.create_index(op.f('ix_person_history_region'), 'person_history', ['region'], unique=False) op.add_column( 'tx_county_aggregate', sa.Column('facility_name', sa.String(length=255), nullable=False)) op.alter_column('tx_county_aggregate', 'fips', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('tx_county_aggregate', 'report_date', existing_type=sa.DATE(), nullable=False) op.alter_column('tx_county_aggregate', 'report_granularity', existing_type=postgresql.ENUM('DAILY', 'WEEKLY', 'MONTHLY', name='report_granularity'), nullable=False) op.drop_constraint( 'tx_county_aggregate_fips_report_date_report_granularity_key', 'tx_county_aggregate', type_='unique') op.create_unique_constraint( None, 'tx_county_aggregate', ['fips', 'facility_name', 'report_date', 'report_granularity']) op.drop_column('tx_county_aggregate', 'county_name')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'fix_detail', type_='foreignkey') op.drop_constraint(None, 'fix', type_='foreignkey') op.drop_constraint(None, 'fix', type_='foreignkey') op.drop_constraint(None, 'employee', type_='foreignkey') op.drop_constraint(None, 'client', type_='foreignkey') op.drop_constraint(None, 'FixEmployee', type_='foreignkey') op.create_foreign_key(None, 'FixEmployee', 'user', ['fixid'], ['id']) op.drop_constraint(None, 'FixEmployee', type_='foreignkey')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'conta', type_='foreignkey') op.drop_column('conta', 'usuario_id')