def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('user', sa.Column('joined_teams', mysql.LONGTEXT(), nullable=False)) op.add_column('team', sa.Column('members', mysql.LONGTEXT(), nullable=False)) op.add_column('team', sa.Column('admins', mysql.LONGTEXT(), nullable=False)) op.drop_index(op.f('ix_team_member_is_admin'), table_name='team_member') op.drop_table('team_member')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('user', sa.Column('phone', mysql.VARCHAR(length=32), nullable=True)) op.add_column('user', sa.Column('user_about', mysql.LONGTEXT(), nullable=True)) op.add_column('user', sa.Column('phone_is_validate', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True)) op.alter_column('user', 'is_active', existing_type=sa.Boolean(), type_=mysql.TINYINT(display_width=1), existing_nullable=True) op.alter_column('user', 'email_is_validate', existing_type=sa.Boolean(), type_=mysql.TINYINT(display_width=1), existing_nullable=True) op.drop_column('user', 'about') op.alter_column('post', 'visibility', existing_type=mysql.VARCHAR(length=16), comment=None, existing_comment='文章可见性:私密/公开', existing_nullable=True) op.alter_column('post', 'comments', existing_type=mysql.INTEGER(), comment=None, existing_comment='评论数量', existing_nullable=True) op.alter_column('post', 'article', existing_type=mysql.LONGTEXT(), comment=None, existing_comment='文章内容', existing_nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('subscriber', 'subscription', existing_type=sa.String(length=1000), type_=mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=100), existing_nullable=False) op.alter_column('page_version', 'notes', existing_type=sa.Text(length=5000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page_version', 'body', existing_type=sa.Text(length=10000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page', 'notes', existing_type=sa.Text(length=5000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page', 'body', existing_type=sa.Text(length=10000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column( 'page', 'body', existing_type=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), type_=sa.Text(length=10000000), existing_nullable=True) op.alter_column( 'page', 'notes', existing_type=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), type_=sa.Text(length=5000000), existing_nullable=True) op.alter_column( 'page_version', 'body', existing_type=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), type_=sa.Text(length=10000000), existing_nullable=True) op.alter_column( 'page_version', 'notes', existing_type=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), type_=sa.Text(length=5000000), existing_nullable=True) op.add_column('record', sa.Column('action', sa.String(length=150), nullable=False))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( "userinfo", sa.Column( "id", mysql.INTEGER(display_width=11), autoincrement=False, nullable=False ), sa.Column("username", mysql.TEXT(), nullable=False), sa.Column("password", mysql.TEXT(), nullable=False), sa.Column("name", mysql.TEXT(), nullable=False), sa.Column("avatar", sa.BLOB(), nullable=False), sa.Column( "favorites", mysql.LONGTEXT(charset="utf8mb4", collation="utf8mb4_bin"), nullable=False, ), sa.Column( "history", mysql.LONGTEXT(charset="utf8mb4", collation="utf8mb4_bin"), nullable=False, ), mysql_default_charset="utf8", mysql_engine="InnoDB", ) op.drop_index(op.f("ix_user_username"), table_name="user") op.drop_table("user")
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'workflow_variable', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=200), nullable=False), sa.Column('description', mysql.LONGTEXT(), nullable=True), sa.Column('type', sa.Enum('DATETIME', 'INTEGER', 'BINARY', 'TEXT', 'FLOAT', 'TIMESTAMP', 'DATE', 'LAT_LONG', 'FILE', 'TIME', 'CHARACTER', 'DECIMAL', 'ENUM', 'LONG', 'VECTOR', 'DOUBLE', name='DataTypeEnumType'), nullable=False), sa.Column('multiplicity', sa.Integer(), nullable=False), sa.Column('suggested_widget', sa.String(length=200), nullable=True), sa.Column('default_value', mysql.LONGTEXT(), nullable=True), sa.Column('workflow_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['workflow_id'], ['workflow.id'], ), sa.PrimaryKeyConstraint('id')) op.drop_index('fk_task_group_id', table_name='task')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'platform_plugin', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=200), nullable=False), sa.Column('description', sa.String(length=200), nullable=True), sa.Column('version', sa.String(length=200), nullable=True), sa.Column('copyright', sa.String(length=200), nullable=True), sa.Column('status', sa.Enum('OUTDATED', 'DISABLED', 'ERROR', 'PENDING', 'INSTALLED', name='PluginStatusEnumType'), nullable=True), sa.Column('message', mysql.LONGTEXT(), nullable=True), sa.Column('manifest', mysql.LONGTEXT(), nullable=True), sa.Column('ids_offset', sa.Integer(), nullable=False), sa.Column('uuid', sa.String(length=200), nullable=False), sa.Column('url', sa.String(length=200), nullable=True), sa.Column('use_compiler', sa.Boolean(), nullable=False), sa.Column('use_executor', sa.Boolean(), nullable=False), sa.Column('platform_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['platform_id'], ['platform.id'], ), sa.PrimaryKeyConstraint('id')) op.add_column('platform', sa.Column('plugin', sa.Boolean(), nullable=False)) op.add_column('platform', sa.Column('version', sa.String(length=200), nullable=True)) op.drop_column('workflow', 'publishing_enabled')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('product', 'ghost_link') op.alter_column('page_version', 'sidebar', existing_type=sa.String(length=5000), type_=mysql.TEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page_version', 'notes', existing_type=sa.Text(length=5000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page_version', 'body', existing_type=sa.Text(length=10000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page', 'sidebar', existing_type=sa.String(length=5000), type_=mysql.TEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page', 'notes', existing_type=sa.Text(length=5000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page', 'body', existing_type=sa.Text(length=10000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('record', 'minutes', existing_type=sa.Float(), type_=mysql.INTEGER(display_width=11), existing_nullable=True) op.alter_column('page_version', 'notes', existing_type=sa.Text(length=5000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page_version', 'body', existing_type=sa.Text(length=10000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page', 'notes', existing_type=sa.Text(length=5000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True) op.alter_column('page', 'body', existing_type=sa.Text(length=10000000), type_=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), existing_nullable=True)
def upgrade(): engine = op.get_bind() if engine.dialect.dialect_description.startswith('mysql'): with op.batch_alter_table('session') as batch_op: batch_op.alter_column('description', type_=sa_mysql.LONGTEXT()) with op.batch_alter_table('environment') as batch_op: batch_op.alter_column('description', type_=sa_mysql.LONGTEXT()) with op.batch_alter_table('environment-template') as batch_op: batch_op.alter_column('description', type_=sa_mysql.LONGTEXT())
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('bugs', 'replys', existing_type=mysql.LONGTEXT(), nullable=False, comment=None, existing_comment='漏洞评论') op.alter_column('bugs', 'wybug_author', existing_type=mysql.VARCHAR(length=50), nullable=False, comment=None, existing_comment='漏洞作者') op.alter_column('bugs', 'wybug_date', existing_type=mysql.VARCHAR(length=50), nullable=False, comment=None, existing_comment='漏洞提交时间') op.alter_column('bugs', 'wybug_detail', existing_type=mysql.LONGTEXT(), nullable=False, comment=None, existing_comment='漏洞详情') op.alter_column('bugs', 'wybug_id', existing_type=mysql.VARCHAR(length=50), nullable=False, comment=None, existing_comment='漏洞编号') op.alter_column('bugs', 'wybug_level', existing_type=mysql.VARCHAR(length=20), nullable=False, comment=None, existing_comment='危害等级') op.alter_column('bugs', 'wybug_reply', existing_type=mysql.LONGTEXT(), nullable=False, comment=None, existing_comment='漏洞回应') op.alter_column('bugs', 'wybug_title', existing_type=mysql.VARCHAR(length=150), nullable=False, comment=None, existing_comment='漏洞标题') op.alter_column('bugs', 'wybug_type', existing_type=mysql.VARCHAR(length=50), nullable=False, comment=None, existing_comment='漏洞类型') op.drop_index('bugs_wybug_id', table_name='bugs')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'comment', sa.Column('id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('name', sa.String(length=100), nullable=False), sa.Column('email', sa.String(length=150), nullable=True), sa.Column('body', sa.String(length=5000), nullable=False), sa.Column('reaction', sa.String(length=50), nullable=True), sa.Column('rating', sa.Integer(), nullable=True), sa.Column('reply_id', sa.Integer(), nullable=True), sa.Column('page_id', sa.Integer(), nullable=True), sa.Column('product_id', sa.Integer(), nullable=True), sa.Column('ip', sa.String(length=40), nullable=False), sa.Column('session_id', sa.String(length=200), nullable=True), sa.Column('created', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['page_id'], ['page.id'], ), sa.ForeignKeyConstraint( ['product_id'], ['product.id'], ), sa.ForeignKeyConstraint( ['reply_id'], ['comment.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id')) op.alter_column( 'page', 'body', existing_type=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), type_=sa.Text(length=10000000), existing_nullable=True) op.alter_column( 'page', 'notes', existing_type=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), type_=sa.Text(length=5000000), existing_nullable=True) op.alter_column( 'page_version', 'body', existing_type=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), type_=sa.Text(length=10000000), existing_nullable=True) op.alter_column( 'page_version', 'notes', existing_type=mysql.LONGTEXT(collation='utf8mb4_unicode_ci'), type_=sa.Text(length=5000000), existing_nullable=True) op.add_column('user', sa.Column('name', sa.String(length=100), nullable=True))
def do_upgrade(): try: op.alter_column(u'bibrec', 'additional_info', existing_type=mysql.TEXT(), type_=mysql.LONGTEXT(), nullable=True) except OperationalError: op.add_column( 'bibrec', sa.Column('additional_info', mysql.LONGTEXT(), nullable=True))
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table( 'reports', sa.Column('report_id', sa.Integer(), nullable=False), sa.Column('original_text', mysql.LONGTEXT(), nullable=True), sa.Column('original_language', mysql.TEXT(), nullable=True), sa.Column('translated_text', mysql.LONGTEXT(), nullable=True), sa.Column('category', mysql.TEXT(), nullable=True), sa.Column('radlex_annotations', mysql.LONGTEXT(), nullable=True), sa.Column('creation_date', sa.DateTime(timezone=True), nullable=True), sa.PrimaryKeyConstraint('report_id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('metric_value', sa.Column('id', sa.Integer(), nullable=False), sa.Column('sent_time', sa.DateTime(), nullable=True), sa.Column('time', sa.DateTime(), nullable=False), sa.Column('probe_id', sa.Integer(), nullable=False), sa.Column('resource_id', sa.Integer(), nullable=False), sa.Column('data', mysql.LONGTEXT(), nullable=False), sa.Column('tma_data', mysql.LONGTEXT(), nullable=True), sa.Column('item', sa.String(length=200), nullable=True), sa.Column('sent', sa.String(length=200), nullable=False), sa.PrimaryKeyConstraint('id') )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('user', sa.Column('id', mysql.INTEGER(display_width=11), nullable=False), sa.Column('username', mysql.VARCHAR(length=80), nullable=False), sa.Column('email', mysql.VARCHAR(length=120), nullable=False), sa.Column('obj', mysql.LONGTEXT(charset=u'utf8mb4', collation=u'utf8mb4_bin'), nullable=True), sa.PrimaryKeyConstraint('id'), mysql_default_charset=u'utf8mb4', mysql_engine=u'InnoDB') op.create_table('post', sa.Column('id', mysql.INTEGER(display_width=11), nullable=False), sa.Column('date', sa.DATE(), nullable=True), sa.Column('content', mysql.VARCHAR(length=500), nullable=True), sa.Column('category', mysql.VARCHAR(length=20), nullable=True), sa.PrimaryKeyConstraint('id'), mysql_default_charset=u'utf8mb4', mysql_engine=u'InnoDB')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### if is_mysql(): parameters_col = sa.Column('parameters', mysql.LONGTEXT(), nullable=False) op.execute( "ALTER TABLE `stand`.`job_result` CHANGE `type` `type` " "ENUM('VISUALIZATION','HTML','TEXT','OTHER','MODEL','METRIC')") else: parameters_col = sa.Column('parameters', sa.Text(), nullable=False) values = ['VISUALIZATION', 'HTML', 'TEXT', 'OTHER', 'MODEL', 'METRIC'] all_commands = [[ get_psql_enum_alter_commands(['job_result'], ['type'], 'ResultTypeEnumType', values, 'TEXT'), None ]] op.create_table( 'cluster_flavor', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=200), nullable=False), sa.Column('enabled', sa.String(length=200), nullable=False), parameters_col, sa.Column('cluster_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['cluster_id'], ['cluster.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): op.add_column('data_source', sa.Column('command', mysql.LONGTEXT(), nullable=True)) op.get_bind().execute( text( "ALTER TABLE `limonero`.`data_source` CHANGE `format` `format` " "ENUM('XML_FILE','NETCDF4','HDF5','SHAPEFILE','TEXT','CUSTOM','JSON'," "'CSV','PICKLE','GEO_JSON','JDBC') CHARSET utf8 " "COLLATE utf8_unicode_ci NOT NULL;")) op.get_bind().execute( text(""" ALTER TABLE storage CHANGE `type` `type` ENUM('HDFS', 'OPHIDIA','ELASTIC_SEARCH','MONGODB', 'POSTGIS','HBASE','CASSANDRA','JDBC') CHARSET utf8 COLLATE utf8_unicode_ci NOT NULL;""" )) op.add_column( 'storage', sa.Column('enabled', sa.Boolean(), nullable=False, server_default=sa.schema.DefaultClause("1"), default=1)) op.add_column( 'data_source', sa.Column('updated', sa.DateTime(), nullable=False, server_default='2018-01-01'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('ascii_table', sa.Column('title', sa.String(length=512), nullable=False), sa.Column('art', mysql.LONGTEXT(), nullable=True), sa.Column('date_created', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('title'))
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_index(op.f('ix_track_artist'), table_name='track') op.alter_column('page', 'content', existing_type=mysql.LONGTEXT(), nullable=True)
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.alter_column('page', 'content', existing_type=mysql.LONGTEXT(), nullable=False) op.create_index(op.f('ix_track_artist'), 'track', ['artist'], unique=False)
class Instance(db.Model): id = db.Column(db.BigInteger, primary_key=True) package_id = db.Column(db.BigInteger, db.ForeignKey('package.id'), nullable=False) hash = db.Column(db.String(64), nullable=False) created_at = db.Column(db.DateTime, default=db.func.utc_timestamp(), nullable=False) created_by = db.Column(USERNAME_TYPE, nullable=False) updated_at = db.Column(db.DateTime, default=db.func.utc_timestamp(), onupdate=db.func.utc_timestamp(), nullable=False) updated_by = db.Column(USERNAME_TYPE, nullable=False) # Contents can be a potentially large JSON blob, so store it as # LONGTEXT rather than VARCHAR, and load lazily. contents = deferred( db.Column(mysql.LONGTEXT(collation=UTF8_BIN), nullable=False)) package = db.relationship('Package', back_populates='instances') versions = db.relationship('Version', back_populates='instance') tags = db.relationship('Tag', back_populates='instance') blobs = db.relationship('S3Blob', secondary=InstanceBlobAssoc)
def upgrade(migrate_engine): if migrate_engine.name != 'mysql': return meta = sqlalchemy.MetaData(bind=migrate_engine) raw_template = sqlalchemy.Table('raw_template', meta, autoload=True) raw_template.c.template.alter(type=mysql.LONGTEXT())
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('storage', sa.Column('client_url', sa.String(length=1000), nullable=True)) if is_mysql(): op.add_column('storage', sa.Column('extra_params', mysql.LONGTEXT(), nullable=True)) op.add_column('data_source', sa.Column('is_lookup', sa.Boolean(), nullable=False, server_default='0')) else: op.add_column('storage', sa.Column('extra_params', sa.Text(), nullable=True)) op.add_column('data_source', sa.Column('is_lookup', sa.Boolean(), nullable=False, server_default='false')) if is_mysql(): op.execute(""" ALTER TABLE `storage` CHANGE `type` `type` ENUM( 'CASSANDRA','ELASTIC_SEARCH','HDFS','HIVE', 'HIVE_WAREHOUSE', 'JDBC','LOCAL','MONGODB' ) CHARSET utf8 COLLATE utf8_unicode_ci NOT NULL;""") elif is_psql(): storage_values = ['CASSANDRA','ELASTIC_SEARCH','HDFS', 'HIVE', 'HIVE_WAREHOUSE', 'JDBC','LOCAL','MONGODB'] all_commands = [ [ get_psql_enum_alter_commands(['storage'], ['type'], 'StorageTypeEnumType', storage_values, 'HDFS'), None ] ] upgrade_actions(all_commands)
def do_upgrade(): """Do upgrade.""" op.alter_column(u'remoteACCOUNT', 'extra_data', existing_type=mysql.TEXT(), type_=mysql.LONGTEXT(), nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('global_settings', 'events_per_page') op.alter_column('event', 'description', existing_type=mysql.LONGTEXT(), nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('job_step_log', 'message', existing_type=mysql.LONGTEXT(), nullable=True) op.drop_table('cluster_platform')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('cluster_platform', sa.Column('id', sa.Integer(), nullable=False), sa.Column('platform_id', sa.Integer(), nullable=False), sa.Column('cluster_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['cluster_id'], ['cluster.id'], ), sa.PrimaryKeyConstraint('id')) if is_mysql(): op.alter_column('job_step_log', 'message', existing_type=mysql.LONGTEXT(), nullable=False) op.execute(""" ALTER TABLE cluster CHANGE `type` `type` ENUM('MESOS','YARN','SPARK_LOCAL','KUBERNETES') CHARSET utf8 COLLATE utf8_general_ci NOT NULL; """) elif is_sqlite(): pass # No enum support in sqlite else: op.alter_column('job_step_log', 'message', existing_type=sa.Text(), nullable=False) values = ['MESOS', 'YARN', 'SPARK_LOCAL', 'KUBERNETES'] all_commands = [[ get_psql_enum_alter_commands(['cluster'], ['type'], 'ClusterTypeEnumType', values, 'SPARK_LOCAL'), None ]]
class Scraper(db.Model): __tablename__ = 'rss_feed_scrapped' id = db.Column(BigInteger, primary_key=True, autoincrement=True) # not sure if required now the below field # scraper_name = db.Column(mysql_t.TEXT(), nullable=False) rss_feed_id = db.Column( BigInteger, ForeignKey('rss_feed.id', onupdate='CASCADE', ondelete='CASCADE')) uri = db.Column(mysql_t.MEDIUMTEXT(), nullable=False) headline = db.Column(mysql_t.MEDIUMTEXT(), nullable=False) story_kicker = db.Column(mysql_t.MEDIUMTEXT()) article = db.Column(mysql_t.LONGTEXT()) created_at = db.Column(mysql_t.TIMESTAMP(fsp=6), nullable=False, server_default=current_timestamp(6)) # not that important in the context # updated_at = db.Column(mysql_t.TIMESTAMP(fsp=6), nullable=False, # server_default=current_timestamp(6), server_onupdate=current_timestamp(6)) def __repr__(self): return { 'id': self.id, 'rss_feed_id': self.rss_feed_id, 'uri': self.uri, 'headline': self.headline, 'story_kicker': self.story_kicker, 'article': self.article, 'created_at': self.created_at }
def upgrade(migrate_engine): if migrate_engine.name != 'mysql': return meta = sqlalchemy.MetaData(bind=migrate_engine) stack = sqlalchemy.Table('stack', meta, autoload=True) stack.c.parameters.alter(type=mysql.LONGTEXT()) resource = sqlalchemy.Table('resource', meta, autoload=True) resource.c.rsrc_metadata.alter(type=mysql.LONGTEXT()) watch_rule = sqlalchemy.Table('watch_rule', meta, autoload=True) watch_rule.c.rule.alter(type=mysql.LONGTEXT()) watch_data = sqlalchemy.Table('watch_data', meta, autoload=True) watch_data.c.data.alter(type=mysql.LONGTEXT())