def upgrade():
op.create_table(
'project_stats',
sa.Column('id', sa.Integer, primary_key=True),
sa.Column('project_id', sa.Integer, sa.ForeignKey('project.id',
ondelete='CASCADE')),
sa.Column('n_tasks', sa.Integer, default=0),
sa.Column('n_task_runs', sa.Integer, default=0),
sa.Column('n_results', sa.Integer, default=0),
sa.Column('n_volunteers', sa.Integer, default=0),
sa.Column('n_completed_tasks', sa.Integer, default=0),
sa.Column('overall_progress', sa.Integer, default=0),
sa.Column('average_time', sa.Float, default=0),
sa.Column('n_blogposts', sa.Integer, default=0),
sa.Column('last_activity', sa.Text, default=make_timestamp),
sa.Column('info', JSON, nullable=False)
)
python类create_table()的实例源码
d1add5e3e65e_projects_stats.py 文件源码
项目：FRG-Crowdsourcing
作者: 97amarnathk
项目源码
文件源码
阅读 28
收藏 0
点赞 0
评论 0
def upgrade():
op.create_table(
'accelerators',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uuid', sa.String(length=36), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.Column('description', sa.Text(), nullable=True),
sa.Column('project_id', sa.String(length=36), nullable=True),
sa.Column('user_id', sa.String(length=36), nullable=True),
sa.Column('device_type', sa.Text(), nullable=False),
sa.Column('acc_type', sa.Text(), nullable=False),
sa.Column('acc_capability', sa.Text(), nullable=False),
sa.Column('vendor_id', sa.Text(), nullable=False),
sa.Column('product_id', sa.Text(), nullable=False),
sa.Column('remotable', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_ENGINE='InnoDB',
mysql_DEFAULT_CHARSET='UTF8'
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('bit_facebook_daily_ad_insights_impression_device',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('account_id', sa.String(length=255), nullable=True),
sa.Column('campaign_id', sa.String(length=255), nullable=True),
sa.Column('adset_id', sa.String(length=255), nullable=True),
sa.Column('campaign_name', sa.String(length=255), nullable=True),
sa.Column('spend', sa.Numeric(), nullable=True),
sa.Column('cost_per_unique_click', sa.Numeric(), nullable=True),
sa.Column('unique_clicks', sa.Integer(), nullable=True),
sa.Column('unique_impressions', sa.Integer(), nullable=True),
sa.Column('unique_social_clicks', sa.Integer(), nullable=True),
sa.Column('unique_social_impressions', sa.Integer(), nullable=True),
sa.Column('website_clicks', sa.Integer(), nullable=True),
sa.Column('date_start', sa.DateTime(), nullable=True),
sa.Column('date_stop', sa.DateTime(), nullable=True),
sa.Column('impression_device', sa.String(length=255), nullable=True),
sa.Column('ad_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['ad_id'], ['bit_facebook_ad.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_bit_facebook_daily_ad_insights_impression_device_impression_device'), 'bit_facebook_daily_ad_insights_impression_device', ['impression_device'], unique=False)
# ### 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.Column('default', sa.Boolean(), nullable=True),
sa.Column('permissions', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_index(op.f('ix_roles_default'), 'roles', ['default'], unique=False)
op.create_table('users',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=164), nullable=True),
sa.Column('email', sa.String(length=164), nullable=True),
sa.Column('role_id', sa.Integer(), nullable=True),
sa.Column('password_hash', sa.String(length=164), nullable=True),
sa.ForeignKeyConstraint(['role_id'], ['roles.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_users_username'), 'users', ['username'], unique=True)
### end Alembic commands ###
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('episode',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(), nullable=False),
sa.Column('link', sa.String(), nullable=False),
sa.Column('description', sa.Text(), nullable=True),
sa.Column('published', sa.DateTime(), nullable=True),
sa.Column('enclosure', sa.String(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('podcast_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['podcast_id'], ['podcast.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('link'),
sa.UniqueConstraint('title')
)
op.create_index(op.f('ix_podcast_feed'), 'podcast', ['feed'], unique=True)
op.create_index(op.f('ix_podcast_name'), 'podcast', ['name'], unique=True)
### end Alembic commands ###
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('role',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=80), nullable=True),
sa.Column('description', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_table('user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('email', sa.String(length=255), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('confirmed_at', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email')
)
op.create_table('roles_users',
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('role_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['role_id'], ['role.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], )
)
### end Alembic commands ###
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('hot_books',
sa.Column('book_id', sa.Integer(), nullable=False),
sa.Column('book_author', sa.Text(), nullable=True),
sa.Column('book_cover', sa.Text(), nullable=True),
sa.Column('book_rate', sa.Integer(), nullable=True),
sa.Column('book_content', sa.Text(), nullable=True),
sa.Column('book_publish', sa.Text(), nullable=True),
sa.Column('book_last_number', sa.Integer(), nullable=True),
sa.Column('book_key', sa.String(length=13), nullable=True),
sa.Column('book_db_id', sa.Integer(), nullable=True),
sa.Column('book_title', sa.Text(), nullable=True),
sa.Column('book_place', sa.Text(), nullable=True),
sa.Column('detail_data', sa.Text(), nullable=True),
sa.Column('hot_id', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('book_id'),
sa.UniqueConstraint('book_db_id')
)
op.create_index(op.f('ix_hot_books_book_key'), 'hot_books', ['book_key'], unique=False)
# ### end Alembic commands ###
10d65e285a59_create_volume_mapping_table.py 文件源码
项目：zun
作者: openstack
项目源码
文件源码
阅读 32
收藏 0
点赞 0
评论 0
def upgrade():
op.create_table(
'volume_mapping',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uuid', sa.String(36), nullable=False),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('volume_id', sa.String(36), nullable=False),
sa.Column('volume_provider', sa.String(36), nullable=False),
sa.Column('container_uuid', sa.String(36), nullable=False),
sa.Column('container_path', sa.String(length=255), nullable=True),
sa.Column('connection_info', MediumText(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('uuid', name='uniq_volume0uuid'),
)
b6bfca998431_add_container_actions_events_table.py 文件源码
项目：zun
作者: openstack
项目源码
文件源码
阅读 34
收藏 0
点赞 0
评论 0
def upgrade():
op.create_table(
'container_actions_events',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('event', sa.String(length=255), nullable=True),
sa.Column('action_id', sa.Integer(), nullable=False),
sa.Column('start_time', sa.DateTime(), nullable=True),
sa.Column('finish_time', sa.DateTime(), nullable=True),
sa.Column('result', sa.String(length=255), nullable=True),
sa.Column('traceback', sa.Text(), nullable=True),
sa.Column('details', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['action_id'], ['container_actions.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
op.create_table(
'container',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('uuid', sa.String(length=36), nullable=True),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('image', sa.String(length=255), nullable=True),
sa.Column('command', sa.String(length=255), nullable=True),
sa.Column('status', sa.String(length=20), nullable=True),
sa.Column('environment', zun.db.sqlalchemy.models.JSONEncodedDict(),
nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('uuid', name='uniq_container0uuid')
)
def upgrade():
# commands auto generated by Alembic - please adjust! #
op.create_table(
'image',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('uuid', sa.String(length=36), nullable=True),
sa.Column('image_id', sa.String(length=255), nullable=True),
sa.Column('repo', sa.String(length=255), nullable=True),
sa.Column('tag', sa.String(length=255), nullable=True),
sa.Column('size', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('repo', 'tag', name='uniq_image0repotag'),
mysql_charset='utf8',
mysql_engine='InnoDB'
)
# end Alembic commands #
def upgrade():
op.create_table(
'capsule',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('capsule_version', sa.String(length=255), nullable=True),
sa.Column('kind', sa.String(length=36), nullable=True),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('restart_policy', sa.String(length=255), nullable=True),
sa.Column('host_selector', sa.String(length=255), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uuid', sa.String(length=36), nullable=False),
sa.Column('status', sa.String(length=255), nullable=True),
sa.Column('status_reason', sa.Text(), nullable=True),
sa.Column('message', models.JSONEncodedDict(), nullable=True),
sa.Column('spec', models.JSONEncodedDict(), nullable=True),
sa.Column('cpu', sa.Float(), nullable=True),
sa.Column('memory', sa.String(length=255), nullable=True),
sa.Column('meta_name', sa.String(length=255), nullable=True),
sa.Column('meta_labels', models.JSONEncodedList(), nullable=True),
sa.Column('containers_uuids', models.JSONEncodedList(), nullable=True),
sa.PrimaryKeyConstraint('id'),
)
def upgrade():
op.create_table(
'zun_service',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('report_count', sa.Integer(), nullable=False),
sa.Column('host', sa.String(length=255), nullable=True),
sa.Column('binary', sa.String(length=255), nullable=True),
sa.Column('disabled', sa.Boolean(), nullable=True),
sa.Column('disabled_reason', sa.String(length=255), nullable=True),
sa.Column('last_seen_up', sa.DateTime(), nullable=True),
sa.Column('forced_down', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('host', 'binary',
name='uniq_zun_service0host0binary')
)
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.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 upgrade():
op.create_table(
'apps',
sa.Column('id', sa.String(255), nullable=False),
sa.Column('project_id', sa.String(255), nullable=False),
sa.Column('description', sa.String(255), nullable=True),
sa.Column('created_at', sa.String(255)),
sa.Column('updated_at', sa.String(255)),
sa.Column('name', sa.String(255), nullable=False, primary_key=True),
)
op.create_table(
'routes',
sa.Column('project_id', sa.String(255), nullable=False),
sa.Column('path', sa.String(255), nullable=False, primary_key=True),
sa.Column('is_public', sa.Boolean(create_constraint=False), nullable=False),
sa.Column('app_name', sa.String(255), nullable=False, primary_key=True),
sa.Column('created_at', sa.String(255), nullable=False),
sa.Column('updated_at', sa.String(255), nullable=False),
)
574083c098fc_create_retrospective_items_table.py 文件源码
项目：retrospective-bot
作者: bayesimpact
项目源码
文件源码
阅读 29
收藏 0
点赞 0
评论 0
def upgrade():
op.create_table('sprints',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_name', sa.Unicode(), nullable=True),
sa.Column('creation_date', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('retrospective_items',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('sprint_id', sa.Integer(), nullable=False),
sa.Column('category', sa.Unicode(), nullable=True),
sa.Column('text', sa.Unicode(), nullable=True),
sa.Column('user_name', sa.Unicode(), nullable=True),
sa.Column('creation_date', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_retrospective_items'), 'retrospective_items', ['sprint_id', 'category'], unique=False)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('comments',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('body', sa.Text(), nullable=True),
sa.Column('body_html', sa.Text(), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('disabled', sa.Boolean(), nullable=True),
sa.Column('author_id', sa.Integer(), nullable=True),
sa.Column('post_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['author_id'], ['users.id'], ),
sa.ForeignKeyConstraint(['post_id'], ['posts.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index('ix_comments_timestamp', 'comments', ['timestamp'], unique=False)
### 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('username', sa.String(length=64), nullable=True),
sa.Column('role_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['role_id'], ['roles.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index('ix_users_username', 'users', ['username'], unique=True)
### 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 ###
def upgrade():
op.create_table('mastodon_instances',
sa.Column('instance', sa.String(), nullable=False),
sa.Column('popularity', sa.Float(), server_default='10', nullable=False),
sa.PrimaryKeyConstraint('instance', name=op.f('pk_mastodon_instances'))
)
op.execute("""
INSERT INTO mastodon_instances (instance, popularity) VALUES
('mastodon.social', 100),
('mastodon.cloud', 90),
('social.tchncs.de', 80),
('mastodon.xyz', 70),
('mstdn.io', 60),
('awoo.space', 50),
('cybre.space', 40),
('mastodon.art', 30)
;
""")
53489a9c1e2d_usage_ip_states_and_pd_states.py 文件源码
项目：kuberdock-platform
作者: cloudlinux
项目源码
文件源码
阅读 25
收藏 0
点赞 0
评论 0
def upgrade():
op.create_table('pd_states',
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('pd_name', sa.String(), nullable=False),
sa.Column('size', sa.Integer(), nullable=False),
sa.Column('start_time', sa.DateTime(), nullable=False),
sa.Column('end_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id']),
sa.PrimaryKeyConstraint('start_time'))
op.create_table('ip_states',
sa.Column('pod_id', postgresql.UUID(), nullable=False),
sa.Column('ip_address', sa.BigInteger(), nullable=False),
sa.Column('start_time', sa.DateTime(), nullable=False),
sa.Column('end_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['pod_id'], ['pods.id']),
sa.PrimaryKeyConstraint('pod_id', 'start_time'))
241a7b04a9ff_add_menurole_rm_pages.py 文件源码
项目：kuberdock-platform
作者: cloudlinux
项目源码
文件源码
阅读 29
收藏 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 upgrade():
op.create_table('artists',
sa.Column('id', sqlalchemy_utils.types.uuid.UUIDType(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('description', sa.String(), nullable=True),
sa.Column('search_vector', sqlalchemy_utils.types.ts_vector.TSVectorType(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('torrents',
sa.Column('id', sa.String(length=40), nullable=False),
sa.Column('info', sa.PickleType(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('albums',
sa.Column('id', sqlalchemy_utils.types.uuid.UUIDType(), nullable=False),
sa.Column('title', sa.String(), nullable=True),
sa.Column('tracks', sqlalchemy_utils.types.json.JSONType(), nullable=True),
sa.Column('search_vector', sqlalchemy_utils.types.ts_vector.TSVectorType(), nullable=True),
sa.Column('torrent_id', sa.String(length=40), nullable=True),
sa.Column('artist_id', sqlalchemy_utils.types.uuid.UUIDType(), nullable=True),
sa.ForeignKeyConstraint(['artist_id'], ['artists.id'], ),
sa.ForeignKeyConstraint(['torrent_id'], ['torrents.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('users',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('social_id', sa.String(length=64), nullable=False),
sa.Column('nickname', sa.String(length=256), nullable=False),
sa.Column('email', sa.String(length=256), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('social_id')
)
op.create_table('searches',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('search_terms', sa.String(length=64), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('searches',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('search_terms', sa.VARCHAR(length=64), nullable=False),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.Column('user_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('users',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('social_id', sa.VARCHAR(length=64), nullable=False),
sa.Column('nickname', sa.VARCHAR(length=64), nullable=False),
sa.Column('email', sa.VARCHAR(length=64), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('social_id')
)
### end Alembic commands ###
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('users',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('social_id', sa.String(length=64), nullable=False),
sa.Column('nickname', sa.String(length=64), nullable=False),
sa.Column('email', sa.String(length=64), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('social_id')
)
op.create_table('searches',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('search_terms', sa.String(length=64), nullable=False),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('housing_evals',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('uid', sa.VARCHAR(length=32), nullable=False),
sa.Column('social_attended', sa.TEXT(), nullable=False),
sa.Column('social_hosted', sa.TEXT(), nullable=False),
sa.Column('technical_attended', sa.TEXT(), nullable=False),
sa.Column('technical_hosted', sa.TEXT(), nullable=False),
sa.Column('projects', sa.TEXT(), nullable=False),
sa.Column('comments', sa.TEXT(), nullable=False),
sa.Column('points', sa.INTEGER(), nullable=False),
sa.Column('active', sa.BOOLEAN(), nullable=False),
sa.Column('date_created', sa.DATE(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
### end Alembic commands ###
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('schedule_info',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('last_changed_at', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('schedule_meta',
sa.Column('parent_id', sa.Integer(), nullable=False),
sa.Column('last_run_at', sa.DateTime(), nullable=True),
sa.Column('total_run_count', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['parent_id'], ['schedule_task.id'], ),
sa.PrimaryKeyConstraint('parent_id')
)
with op.batch_alter_table('schedule_task') as batch_op:
batch_op.drop_column('total_run_count')
batch_op.drop_column('last_run_at')
# ### end Alembic commands ###
52dfb338f74e_add_coverages_table.py 文件源码
项目：coverage2sql
作者: openstack
项目源码
文件源码
阅读 27
收藏 0
点赞 0
评论 0
def upgrade():
migration_context = context.get_context()
if migration_context.dialect.name == 'sqlite':
id_type = sa.Integer
else:
id_type = sa.BigInteger
op.create_table('coverages',
sa.Column('id', id_type, autoincrement=True,
primary_key=True),
sa.Column('project_name', sa.String(256), nullable=False),
sa.Column('coverage_rate', sa.Float()),
sa.Column('report_time', sa.DateTime()),
sa.Column('report_time_microsecond', sa.Integer(),
default=0),
mysql_engine='InnoDB')
op.create_index('ix_project_name', 'coverages', ['project_name'])
