def upgrade():
table_prefix = context.config.get_main_option('table_prefix')
op.drop_table(table_prefix + 'template')
table_name = table_prefix + 'environment_schema_values'
with op.batch_alter_table(table_name) as batch:
batch.drop_constraint(table_name + '_schema_id_fkey', 'foreignkey')
batch.alter_column(
'schema_id',
new_column_name='resource_definition_id',
existing_type=sa.Integer(),
)
op.rename_table(table_name, table_prefix + 'resource_values')
op.rename_table(table_prefix + 'schema',
table_prefix + 'resource_definition')
with op.batch_alter_table(table_prefix + 'resource_definition') as batch:
batch.drop_column('namespace_id')
op.drop_table(table_prefix + 'namespace')
table_name = table_prefix + 'resource_values'
with op.batch_alter_table(table_name) as batch:
batch.create_foreign_key(
table_name + '_resource_definition_id_fkey',
table_prefix + 'resource_definition',
['resource_definition_id'],
['id'],
)
python类drop_table()的实例源码
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('table_columns')
op.drop_table('sql_metrics')
op.drop_index(op.f('ix_bit_etl_tables_name'), table_name='bit_etl_tables')
op.drop_table('bit_etl_tables')
op.drop_table('tables')
op.drop_table('slice_user')
op.drop_table('saved_query')
op.drop_index('ti_user_id_changed_on', table_name='query')
op.drop_index(op.f('ix_query_results_key'), table_name='query')
op.drop_table('query')
op.drop_table('dashboard_user')
op.drop_table('dashboard_slices')
op.drop_table('url')
op.drop_table('slices')
op.drop_table('logs')
op.drop_table('favstar')
op.drop_table('dbs')
op.drop_table('dashboards')
op.drop_table('css_templates')
op.drop_table('access_request')
op.drop_table('keyvalue')
op.drop_table('bit_etl_table_metrics')
# ### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('privatemessages',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('user_id', sa.INTEGER(), nullable=False),
sa.Column('from_user_id', sa.INTEGER(), nullable=True),
sa.Column('to_user_id', sa.INTEGER(), nullable=True),
sa.Column('subject', sa.VARCHAR(length=255), nullable=True),
sa.Column('message', sa.TEXT(), nullable=True),
sa.Column('date_created', sa.DATETIME(), nullable=True),
sa.Column('trash', sa.BOOLEAN(), nullable=False),
sa.Column('draft', sa.BOOLEAN(), nullable=False),
sa.Column('unread', sa.BOOLEAN(), nullable=False),
sa.ForeignKeyConstraint(['from_user_id'], [u'users.id'], ),
sa.ForeignKeyConstraint(['to_user_id'], [u'users.id'], ),
sa.ForeignKeyConstraint(['user_id'], [u'users.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.drop_table('messages')
op.drop_table('conversations')
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('forums')
op.drop_table('reports')
op.drop_table('topics')
op.drop_table('topicsread')
op.drop_table('privatemessages')
op.drop_table('posts')
op.drop_table('moderators')
op.drop_table('forumsread')
op.drop_table('groups_users')
op.drop_table('topictracker')
op.drop_table('users')
op.drop_table('settings')
op.drop_table('settingsgroup')
op.drop_table('categories')
op.drop_table('groups')
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('privatemessages',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('user_id', sa.INTEGER(), nullable=False),
sa.Column('from_user_id', sa.INTEGER(), nullable=True),
sa.Column('to_user_id', sa.INTEGER(), nullable=True),
sa.Column('subject', sa.VARCHAR(length=255), nullable=True),
sa.Column('message', sa.TEXT(), nullable=True),
sa.Column('date_created', sa.DATETIME(), nullable=True),
sa.Column('trash', sa.BOOLEAN(), nullable=False),
sa.Column('draft', sa.BOOLEAN(), nullable=False),
sa.Column('unread', sa.BOOLEAN(), nullable=False),
sa.ForeignKeyConstraint(['from_user_id'], [u'users.id'], ),
sa.ForeignKeyConstraint(['to_user_id'], [u'users.id'], ),
sa.ForeignKeyConstraint(['user_id'], [u'users.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.drop_table('messages')
op.drop_table('conversations')
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('forums')
op.drop_table('reports')
op.drop_table('topics')
op.drop_table('topicsread')
op.drop_table('privatemessages')
op.drop_table('posts')
op.drop_table('moderators')
op.drop_table('forumsread')
op.drop_table('groups_users')
op.drop_table('topictracker')
op.drop_table('users')
op.drop_table('settings')
op.drop_table('settingsgroup')
op.drop_table('categories')
op.drop_table('groups')
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('privatemessages',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('user_id', sa.INTEGER(), nullable=False),
sa.Column('from_user_id', sa.INTEGER(), nullable=True),
sa.Column('to_user_id', sa.INTEGER(), nullable=True),
sa.Column('subject', sa.VARCHAR(length=255), nullable=True),
sa.Column('message', sa.TEXT(), nullable=True),
sa.Column('date_created', sa.DATETIME(), nullable=True),
sa.Column('trash', sa.BOOLEAN(), nullable=False),
sa.Column('draft', sa.BOOLEAN(), nullable=False),
sa.Column('unread', sa.BOOLEAN(), nullable=False),
sa.ForeignKeyConstraint(['from_user_id'], [u'users.id'], ),
sa.ForeignKeyConstraint(['to_user_id'], [u'users.id'], ),
sa.ForeignKeyConstraint(['user_id'], [u'users.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.drop_table('messages')
op.drop_table('conversations')
### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_likes_timestamp'), table_name='likes')
op.drop_table('likes')
op.drop_index(op.f('ix_comments_timestamp'), table_name='comments')
op.drop_table('comments')
op.drop_index(op.f('ix_posts_timestamp'), table_name='posts')
op.drop_table('posts')
op.drop_table('follows')
op.drop_index(op.f('ix_conversations_timestamp'), table_name='conversations')
op.drop_table('conversations')
op.drop_index(op.f('ix_users_nickname'), table_name='users')
op.drop_index(op.f('ix_users_email'), table_name='users')
op.drop_table('users')
op.drop_index(op.f('ix_roles_default'), table_name='roles')
op.drop_table('roles')
op.drop_index(op.f('ix_admin_timestamp'), table_name='admin')
op.drop_table('admin')
# ### end Alembic commands ###
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('roles',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_table('users',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('email', sa.String(length=64), nullable=True),
sa.Column('username', sa.String(length=64), nullable=True),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.Column('role_id', sa.Integer(), nullable=True),
sa.Column('confirmed', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(['role_id'], ['roles.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_users_email'), 'users', ['email'], unique=True)
op.create_index(op.f('ix_users_username'), 'users', ['username'], unique=True)
op.drop_table('Products')
### end Alembic commands ###
241a7b04a9ff_add_menurole_rm_pages.py 文件源码
项目:kuberdock-platform
作者: cloudlinux
项目源码
文件源码
阅读 27
收藏 0
点赞 0
评论 0
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('menuitem_roles',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('menuitem_id', sa.Integer(), nullable=True),
sa.Column('role_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['menuitem_id'], ['menus_items.id'], ),
sa.ForeignKeyConstraint(['role_id'], ['rbac_role.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.drop_constraint(u'menus_created_by_id_fkey', 'menus', type_='foreignkey')
op.drop_column('menus', 'created_by_id')
op.drop_column('menus', 'ts')
op.drop_constraint(u'menus_items_created_by_id_fkey', 'menus_items', type_='foreignkey')
op.drop_constraint(u'menus_items_page_id_fkey', 'menus_items', type_='foreignkey')
op.drop_column('menus_items', 'created_by_id')
op.drop_column('menus_items', 'is_group_label')
op.drop_column('menus_items', 'page_id')
op.drop_column('menus_items', 'roles')
op.drop_column('menus_items', 'ts')
op.drop_column('menus_items', 'is_public')
op.drop_table('pages')
### end Alembic commands ###
def downgrade():
op.drop_table('un_playlistusers')
op.drop_table('un_playlisttracks')
op.drop_table('un_playlist_images')
op.drop_table('un_trackratings')
op.drop_index('scrobble_user_index', table_name='un_scrobbles')
op.drop_table('un_scrobbles')
op.drop_table('un_roles')
op.drop_table('un_playqueues')
op.drop_table('un_playlists')
op.drop_table('un_playcounts')
op.drop_table('un_config')
op.drop_table('un_artistratings')
op.drop_table('un_albumratings')
op.drop_table('un_users')
op.drop_table('un_dbinfo')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('member_seminar_attendance')
op.drop_table('member_hm_attendance')
op.drop_table('member_committee_attendance')
op.drop_table('freshman_seminar_attendance')
op.drop_table('freshman_hm_attendance')
op.drop_table('freshman_committee_attendance')
op.drop_table('technical_seminars')
op.drop_table('spring_evals')
op.drop_table('settings')
op.drop_table('onfloor_datetime')
op.drop_table('major_projects')
op.drop_table('housing_evals')
op.drop_table('house_meetings')
op.drop_table('freshman_eval_data')
op.drop_table('freshman_accounts')
op.drop_table('current_coops')
op.drop_table('conditional')
op.drop_table('committee_meetings')
### end Alembic commands ###
e3a246e0dc1_current_schema.py 文件源码
项目:incubator-airflow-old
作者: apache
项目源码
文件源码
阅读 24
收藏 0
点赞 0
评论 0
def downgrade():
op.drop_table('known_event')
op.drop_table('chart')
op.drop_table('variable')
op.drop_table('user')
op.drop_index('ti_state_lkp', table_name='task_instance')
op.drop_index('ti_pool', table_name='task_instance')
op.drop_index('ti_dag_state', table_name='task_instance')
op.drop_table('task_instance')
op.drop_table('slot_pool')
op.drop_table('sla_miss')
op.drop_table('log')
op.drop_table('known_event_type')
op.drop_index('job_type_heart', table_name='job')
op.drop_table('job')
op.drop_table('import_error')
op.drop_table('dag_pickle')
op.drop_table('dag')
op.drop_table('connection')
op.drop_table('xcom')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_user_mix_details_refresh_date'), table_name='user_mix_details')
op.drop_table('user_mix_details')
op.drop_index(op.f('ix_queued_player_added'), table_name='queued_player')
op.drop_table('queued_player')
op.drop_table('profile_scan_info')
op.drop_table('player_in_match')
op.drop_table('permissions')
op.drop_index(op.f('ix_user_nickname'), table_name='user')
op.drop_table('user')
op.drop_table('user_permission')
op.drop_index(op.f('ix_match_status'), table_name='match')
op.drop_index(op.f('ix_match_created'), table_name='match')
op.drop_table('match')
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('potocas')
op.drop_index('ix_comments_timestamp', 'comments')
op.drop_table('comments')
op.drop_table('usertocas')
op.drop_index('ix_questions_timestamp', 'questions')
op.drop_table('questions')
op.drop_table('follows')
op.drop_index('ix_users_username', 'users')
op.drop_index('ix_users_email', 'users')
op.drop_table('users')
op.drop_table('categories')
op.drop_index('ix_roles_default', 'roles')
op.drop_table('roles')
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.alter_column(u'users', 'user_id',
existing_type=sa.VARCHAR(length=100),
nullable=True)
op.alter_column(u'users', 'updated_at',
existing_type=postgresql.TIMESTAMP(),
nullable=True)
op.alter_column(u'users', 'name',
existing_type=sa.VARCHAR(length=100),
nullable=True)
op.alter_column(u'users', 'last_name',
existing_type=sa.VARCHAR(length=200),
nullable=True)
op.alter_column(u'users', 'email',
existing_type=sa.VARCHAR(length=150),
nullable=True)
op.alter_column(u'users', 'created_at',
existing_type=postgresql.TIMESTAMP(),
nullable=True)
op.drop_table('request_referral')
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('distributed_query_result')
op.drop_table('status_log')
op.drop_table('result_log')
op.drop_table('query_tags')
op.drop_table('query_packs')
op.drop_table('pack_tags')
op.drop_table('node_tags')
op.drop_table('file_path_tags')
op.drop_table('distributed_query')
op.drop_table('tag')
op.drop_table('query')
op.drop_table('pack')
op.drop_table('node')
op.drop_table('file_path')
### end Alembic commands ###
e3b840e64e53_init.py 文件源码
项目:fuel-nailgun-extension-iac
作者: openstack
项目源码
文件源码
阅读 29
收藏 0
点赞 0
评论 0
def downgrade():
table_prefix = context.config.get_main_option('table_prefix')
op.drop_table(table_prefix + 'repos')
8736ad38ca31_add_whitelist_table.py 文件源码
项目:fuel-nailgun-extension-iac
作者: openstack
项目源码
文件源码
阅读 22
收藏 0
点赞 0
评论 0
def downgrade():
table_prefix = context.config.get_main_option('table_prefix')
op.drop_table(table_prefix + 'changes_whitelist')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('answers')
op.drop_table('questions')
op.drop_table('users')
# ### end Alembic commands ###
280d0531befe_create_user_subscription_to_thread_tags.py 文件源码
项目:BookCloud
作者: livro-aberto
项目源码
文件源码
阅读 20
收藏 0
点赞 0
评论 0
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('user_subscription')
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('likes')
op.drop_table('user_tag')
op.drop_table('free_tag')
op.drop_table('file_tag')
op.drop_table('custom_tag')
op.drop_table('comment')
op.drop_table('thread')
op.drop_table('named_tag')
op.drop_table('branch')
op.drop_table('project')
op.drop_table('user')
# ### end Alembic commands ###
d838fb3c676d_add_user_thread_relation_to_store_read.py 文件源码
项目:BookCloud
作者: livro-aberto
项目源码
文件源码
阅读 20
收藏 0
点赞 0
评论 0
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('user_read_thread')
# ### end Alembic commands ###
def downgrade():
op.drop_table('network_interfaces')
op.drop_index(op.f('ix_devices_labels'), table_name='labels')
op.drop_table('labels')
op.drop_table('network_devices')
op.drop_table('hosts')
op.drop_index(op.f('ix_networks_region_id'), table_name='networks')
op.drop_index(op.f('ix_networks_cloud_id'), table_name='networks')
op.drop_index(op.f('ix_networks_project_id'), table_name='networks')
op.drop_index(op.f('ix_networks_cell_id'), table_name='networks')
op.drop_table('networks')
op.drop_index(op.f('ix_devices_region_id'), table_name='devices')
op.drop_index(op.f('ix_devices_cloud_id'), table_name='devices')
op.drop_index(op.f('ix_devices_project_id'), table_name='devices')
op.drop_index(op.f('ix_devices_cell_id'), table_name='devices')
op.drop_table('devices')
op.drop_index(op.f('ix_cells_region_id'), table_name='cells')
op.drop_index(op.f('ix_cells_cloud_id'), table_name='cells')
op.drop_index(op.f('ix_cells_project_id'), table_name='cells')
op.drop_table('cells')
op.drop_index(op.f('ix_users_project_id'), table_name='users')
op.drop_index(op.f('ix_regions_project_id'), table_name='regions')
op.drop_index(op.f('ix_regions_cloud_id'), table_name='regions')
op.drop_table('regions')
op.drop_index(op.f('ix_clouds_project_id'), table_name='clouds')
op.drop_table('clouds')
op.drop_table('users')
op.drop_table('projects')
op.drop_index(op.f('ix_variable_keys'), table_name='variables')
op.drop_table('variables')
op.drop_table('variable_association')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('inpatientlocation')
op.drop_table('subscription')
op.drop_table('result')
op.drop_table('patientidentifier')
op.drop_table('patient')
op.drop_table('merge')
op.drop_table('inpatientepisode')
op.drop_table('allergy')
op.drop_table('glossolaliareference')
op.drop_table('error')
### end Alembic commands ###
def upgrade():
op.drop_table('inpatientlocation')
op.drop_table('inpatientepisode')
op.create_table('inpatientadmission',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('updated', sa.DateTime(), nullable=True),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('datetime_of_admission', sa.DateTime(), nullable=False),
sa.Column('datetime_of_discharge', sa.DateTime(), nullable=True),
sa.Column('visit_number', sa.String(length=250), nullable=False),
sa.Column('admission_diagnosis', sa.String(length=250), nullable=True),
sa.Column('gloss_reference_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['gloss_reference_id'], ['glossolaliareference.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('inpatientlocation',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('updated', sa.DateTime(), nullable=True),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('inpatient_admission_id', sa.Integer(), nullable=True),
sa.Column('datetime_of_transfer', sa.DateTime(), nullable=True),
sa.Column('ward_code', sa.String(length=250), nullable=True),
sa.Column('room_code', sa.String(length=250), nullable=True),
sa.Column('bed_code', sa.String(length=250), nullable=True),
sa.ForeignKeyConstraint(['inpatient_admission_id'], ['inpatientadmission.id'], ),
sa.PrimaryKeyConstraint('id')
)
### end Alembic commands ###
def downgrade():
op.drop_table('inpatientlocation')
op.drop_table('inpatientadmission')
op.create_table('inpatientepisode',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('updated', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.Column('created', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.Column('datetime_of_admission', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
sa.Column('datetime_of_discharge', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.Column('visit_number', sa.VARCHAR(length=250), autoincrement=False, nullable=False),
sa.Column('admission_diagnosis', sa.VARCHAR(length=250), autoincrement=False, nullable=True),
sa.Column('gloss_reference_id', sa.INTEGER(), autoincrement=False, nullable=True),
sa.ForeignKeyConstraint(['gloss_reference_id'], [u'glossolaliareference.id'], name=u'inpatientepisode_gloss_reference_id_fkey'),
sa.PrimaryKeyConstraint('id', name=u'inpatientepisode_pkey')
)
op.create_table('inpatientlocation',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('updated', sa.DateTime(), nullable=True),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('inpatient_episode_id', sa.Integer(), nullable=True),
sa.Column('datetime_of_transfer', sa.DateTime(), nullable=True),
sa.Column('ward_code', sa.String(length=250), nullable=True),
sa.Column('room_code', sa.String(length=250), nullable=True),
sa.Column('bed_code', sa.String(length=250), nullable=True),
sa.ForeignKeyConstraint(['inpatient_episode_id'], ['inpatientepisode.id'], ),
sa.PrimaryKeyConstraint('id')
)
### end Alembic commands ###
920578f0de9c_table_task_taskrun_counts.py 文件源码
项目:FRG-Crowdsourcing
作者: 97amarnathk
项目源码
文件源码
阅读 23
收藏 0
点赞 0
评论 0
def downgrade():
op.drop_table('counter')
d1add5e3e65e_projects_stats.py 文件源码
项目:FRG-Crowdsourcing
作者: 97amarnathk
项目源码
文件源码
阅读 23
收藏 0
点赞 0
评论 0
def downgrade():
op.drop_table('project_stats')
ca9164362ca2_create_announcement_table.py 文件源码
项目:FRG-Crowdsourcing
作者: 97amarnathk
项目源码
文件源码
阅读 25
收藏 0
点赞 0
评论 0
def downgrade():
op.drop_table('announcement')