def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('nuccore',
sa.Column('id', mysql.INTEGER(display_width=11), nullable=False),
sa.Column('nuccore_uid', mysql.VARCHAR(length=50), nullable=True),
sa.Column('nuccore_link', mysql.TEXT(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
op.create_table('dataset_to_nuccore',
sa.Column('dataset_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('nuccore_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.ForeignKeyConstraint(['dataset_id'], [u'dataset.id'], name=u'dataset_to_nuccore_ibfk_1'),
sa.ForeignKeyConstraint(['nuccore_id'], [u'nuccore.id'], name=u'dataset_to_nuccore_ibfk_2'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
# ### end Alembic commands ###
python类TEXT的实例源码
d2ae31099d61_increase_text_size_for_mysql.py 文件源码
项目：incubator-airflow-old
作者: apache
项目源码
文件源码
阅读 21
收藏 0
点赞 0
评论 0
def downgrade():
if context.config.get_main_option('sqlalchemy.url').startswith('mysql'):
op.alter_column(table_name='variable', column_name='val', type_=mysql.TEXT)
eb64b7b3d4c2_add_view_count_column_in_posts.py 文件源码
项目：chihu
作者: yelongyu
项目源码
文件源码
阅读 21
收藏 0
点赞 0
评论 0
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('posts', sa.Column('body_html', mysql.TEXT(collation=u'utf8_unicode_ci'), nullable=True))
op.drop_column('posts', 'view_count')
### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('dataset', sa.Column('nuccore_link', mysql.TEXT(), nullable=True))
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(u'dataset', sa.Column('nuccore_uids', mysql.TEXT(), nullable=True))
op.drop_table('nuccore')
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('users',
sa.Column('id', mysql.INTEGER(display_width=11), nullable=False),
sa.Column('username', mysql.VARCHAR(length=100), nullable=False),
sa.Column('password_hash', mysql.TEXT(), nullable=False),
sa.Column('email', mysql.VARCHAR(length=200), nullable=False),
sa.Column('gender', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False),
sa.Column('desc', mysql.TEXT(), nullable=False),
sa.Column('credit', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False),
sa.Column('role', mysql.VARCHAR(length=20), nullable=False),
sa.Column('status', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False),
sa.Column('created_time', mysql.DATETIME(), nullable=False),
sa.Column('updated_time', mysql.DATETIME(), nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
op.create_table('posts',
sa.Column('id', mysql.INTEGER(display_width=11), nullable=False),
sa.Column('user_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('title', mysql.VARCHAR(length=100), nullable=False),
sa.Column('content', mysql.TEXT(), nullable=False),
sa.Column('views', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False),
sa.Column('status', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False),
sa.Column('created_time', mysql.DATETIME(), nullable=False),
sa.Column('updated_time', mysql.DATETIME(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='posts_ibfk_1'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
# ### end Alembic commands ###
def upgrade():
for prefix in TABLE_PREFIXES:
op.alter_column(prefix + '_comments', 'text',
existing_type=mysql.VARCHAR(charset='utf8mb4', collation='utf8mb4_bin', length=255),
type_=mysql.TEXT(collation='utf8mb4_bin'),
existing_nullable=False)
def downgrade():
for prefix in TABLE_PREFIXES:
op.alter_column(prefix + '_comments', 'text',
existing_type=mysql.TEXT(collation='utf8mb4_bin'),
type_=mysql.VARCHAR(charset='utf8mb4', collation='utf8mb4_bin', length=255),
existing_nullable=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('dataset', 'library_construction_method',
existing_type=mysql.TEXT(charset=u'utf8', collation=u'utf8_bin'),
type_=sa.String(length=20),
existing_nullable=True)
op.alter_column('dataset', 'library_screening_strategy',
existing_type=mysql.TEXT(charset=u'utf8', collation=u'utf8_bin'),
type_=sa.String(length=80),
existing_nullable=True)
op.alter_column('dataset', 'library_source',
existing_type=mysql.TEXT(),
type_=sa.String(length=50),
existing_nullable=True)
op.alter_column('dataset', 'library_strategy',
existing_type=mysql.TEXT(charset=u'utf8', collation=u'utf8_bin'),
type_=sa.String(length=50),
existing_nullable=True)
op.alter_column('dataset', 'sequencing_method',
existing_type=mysql.TEXT(charset=u'utf8', collation=u'utf8_bin'),
type_=sa.String(length=50),
existing_nullable=True)
op.alter_column('dataset', 'env_biome',
existing_type=mysql.TEXT(),
type_=sa.String(length=100),
existing_nullable=True)
op.alter_column('dataset', 'env_feature',
existing_type=mysql.TEXT(),
type_=sa.String(length=200),
existing_nullable=True)
op.alter_column('dataset', 'env_material',
existing_type=mysql.TEXT(),
type_=sa.String(length=150),
existing_nullable=True)
op.alter_column('dataset', 'env_package',
existing_type=mysql.TEXT(),
type_=sa.String(length=100),
existing_nullable=True)
op.alter_column('dataset', 'geo_loc_name',
existing_type=mysql.TEXT(),
type_=sa.String(length=100),
existing_nullable=True)
op.alter_column('dataset', 'instrument_model',
existing_type=mysql.TEXT(),
type_=sa.String(length=50),
existing_nullable=True)
op.alter_column('dataset', 'investigation_type',
existing_type=mysql.TEXT(),
type_=sa.String(length=80),
existing_nullable=True)
op.alter_column('dataset', 'study_type',
existing_type=mysql.TEXT(),
type_=sa.String(length=50),
existing_nullable=True)
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('dataset', 'sequencing_method',
existing_type=sa.String(length=50),
type_=mysql.TEXT(charset=u'utf8', collation=u'utf8_bin'),
existing_nullable=True)
op.alter_column('dataset', 'library_strategy',
existing_type=sa.String(length=50),
type_=mysql.TEXT(charset=u'utf8', collation=u'utf8_bin'),
existing_nullable=True)
op.alter_column('dataset', 'library_source',
existing_type=sa.String(length=50),
type_=mysql.TEXT(),
existing_nullable=True)
op.alter_column('dataset', 'library_screening_strategy',
existing_type=sa.String(length=80),
type_=mysql.TEXT(charset=u'utf8', collation=u'utf8_bin'),
existing_nullable=True)
op.alter_column('dataset', 'library_construction_method',
existing_type=sa.String(length=20),
type_=mysql.TEXT(charset=u'utf8', collation=u'utf8_bin'),
existing_nullable=True)
op.alter_column('dataset', 'study_type',
existing_type=sa.String(length=50),
type_=mysql.TEXT(),
existing_nullable=True)
op.alter_column('dataset', 'investigation_type',
existing_type=sa.String(length=80),
type_=mysql.TEXT(),
existing_nullable=True)
op.alter_column('dataset', 'instrument_model',
existing_type=sa.String(length=50),
type_=mysql.TEXT(),
existing_nullable=True)
op.alter_column('dataset', 'geo_loc_name',
existing_type=sa.String(length=100),
type_=mysql.TEXT(),
existing_nullable=True)
op.alter_column('dataset', 'env_package',
existing_type=sa.String(length=100),
type_=mysql.TEXT(),
existing_nullable=True)
op.alter_column('dataset', 'env_material',
existing_type=sa.String(length=150),
type_=mysql.TEXT(),
existing_nullable=True)
op.alter_column('dataset', 'env_feature',
existing_type=sa.String(length=200),
type_=mysql.TEXT(),
existing_nullable=True)
op.alter_column('dataset', 'env_biome',
existing_type=sa.String(length=100),
type_=mysql.TEXT(),
existing_nullable=True)
# ### end Alembic commands ###
