def do_upgrade(): """Implement your upgrades here.""" # First upgrade bwlWORKFLOW for proper foreign key creation with op.batch_alter_table("bwlWORKFLOW", recreate="always", table_kwargs={"mysql_engine": 'InnoDB'}) as batch_op: pass with op.batch_alter_table("bwlOBJECT", recreate="always", table_kwargs={"mysql_engine": 'InnoDB'}) as batch_op: batch_op.create_index('ix_bwlOBJECT_version', ['version']) batch_op.create_index('ix_bwlOBJECT_data_type', ['data_type']) batch_op.create_foreign_key("bwlOBJECT_ibfk_1", "bwlWORKFLOW", ["id_workflow"], ["uuid"], ondelete="CASCADE") op.create_foreign_key("bwlOBJECT_ibfk_2", "bwlOBJECT", "bwlOBJECT", ["id_parent"], ["id"], ondelete="CASCADE") with op.batch_alter_table("bwlWORKFLOWLOGGING", recreate="always", table_kwargs={"mysql_engine": 'InnoDB'}) as batch_op: batch_op.create_foreign_key("bwlWORKFLOWLOGGING_ibfk_1", "bwlWORKFLOW", ["id_object"], ["uuid"]) with op.batch_alter_table("bwlOBJECTLOGGING", recreate="always", table_kwargs={"mysql_engine": 'InnoDB'}) as batch_op: batch_op.create_foreign_key("bwlOBJECTLOGGING_ibfk_1", "bwlOBJECT", ["id_object"], ["id"])
def do_upgrade(): """Implement your upgrades here.""" with op.batch_alter_table("bwlWORKFLOWLOGGING") as batch_op: batch_op.alter_column( column_name='id_object', type_=db.String(36), nullable=False )
def do_upgrade(): """Implement your upgrades here.""" with op.batch_alter_table("UserEXT") as batch_op: batch_op.alter_column( column_name='id', type_=db.String(255), nullable=False )
def do_upgrade(): """Implement your upgrades here.""" with op.batch_alter_table("wtgTAG") as batch_op: batch_op.alter_column(column_name='id_usergroup', type_=db.Integer(15, unsigned=True), nullable=True) batch_op.alter_column(column_name='id_user', type_=db.Integer(15, unsigned=True), nullable=True)
def do_upgrade(): """Implement your upgrades here.""" with op.batch_alter_table("wtgTAG") as batch_op: batch_op.alter_column( column_name='id_usergroup', type_=db.Integer(15, unsigned=True), nullable=True ) batch_op.alter_column( column_name='id_user', type_=db.Integer(15, unsigned=True), nullable=True )
def do_upgrade(): """Perfrom upgrade.""" if op.has_table('usergroup'): op.rename_table(old_table_name='usergroup', new_table_name='group') with op.batch_alter_table("group") as batch_op: batch_op.drop_index('ix_usergroup_name') batch_op.create_index('ix_group_name', ['name'], unique=True) batch_op.alter_column('name', server_default=None) batch_op.add_column( db.Column('is_managed', db.Boolean(), nullable=False, default=False)) batch_op.alter_column(column_name='join_policy', new_column_name='privacy_policy', type_=db.String(length=1), nullable=False) batch_op.drop_index('login_method_name') batch_op.alter_column(column_name='login_method', new_column_name='subscription_policy', type_=db.String(length=1), nullable=False, server_default=None) batch_op.add_column( db.Column('created', db.DateTime(), nullable=False, default=datetime.now)) batch_op.add_column( db.Column('modified', db.DateTime(), nullable=False, default=datetime.now, onupdate=datetime.now)) else: op.create_table('group', db.Column('id', db.Integer(15, unsigned=True), nullable=False, autoincrement=True), db.Column('name', db.String(length=255), nullable=False, unique=True, index=True), db.Column('description', db.Text, nullable=True, default=''), db.Column('is_managed', db.Boolean(), default=False, nullable=False), db.Column('privacy_policy', db.String(length=1), nullable=False), db.Column('subscription_policy', db.String(length=1), nullable=False), db.Column('created', db.DateTime, nullable=False, default=datetime.now), db.Column('modified', db.DateTime, nullable=False, default=datetime.now, onupdate=datetime.now), db.PrimaryKeyConstraint('id'), mysql_charset='utf8', mysql_engine='MyISAM') if op.has_table('user_usergroup'): op.rename_table(old_table_name='user_usergroup', new_table_name='groupMEMBER') with op.batch_alter_table("groupMEMBER") as batch_op: batch_op.drop_index('id_usergroup') batch_op.alter_column('id_user', server_default=None) batch_op.alter_column(column_name='id_usergroup', new_column_name='id_group', existing_type=db.Integer(15, unsigned=True), nullable=False) batch_op.create_index('id_group', ['id_group']) batch_op.alter_column(column_name='user_status', new_column_name='state', type_=db.String(length=1), nullable=False) batch_op.drop_column('user_status_date') batch_op.add_column( db.Column('modified', db.DateTime(), nullable=False, default=datetime.now, onupdate=datetime.now)) batch_op.add_column( db.Column('created', db.DateTime(), nullable=False, default=datetime.now)) else: op.create_table('groupMEMBER', db.Column('id_user', db.Integer(15, unsigned=True), nullable=False), db.Column('id_group', db.Integer(15, unsigned=True)), db.Column('state', db.String(length=1), nullable=False), db.Column('created', db.DateTime(), nullable=False, default=datetime.now), db.Column('modified', db.DateTime(), nullable=False, default=datetime.now, onupdate=datetime.now), db.ForeignKeyConstraint( ['id_group'], [u'group.id'], ), db.ForeignKeyConstraint( ['id_user'], [u'user.id'], ), db.PrimaryKeyConstraint('id_user', 'id_group'), mysql_charset='utf8', mysql_engine='MyISAM') op.create_table('groupADMIN', db.Column('id', db.Integer(15, unsigned=True), nullable=False, autoincrement=True), db.Column('group_id', db.Integer(15, unsigned=True)), db.Column('admin_type', db.Unicode(255)), db.Column('admin_id', db.Integer), db.ForeignKeyConstraint( ['group_id'], [u'group.id'], ), db.PrimaryKeyConstraint('id', 'group_id'), mysql_charset='utf8', mysql_engine='MyISAM')
def do_upgrade(): """Implement your upgrades here.""" with op.batch_alter_table("bwlWORKFLOWLOGGING") as batch_op: batch_op.alter_column(column_name='id_object', type_=db.String(36), nullable=False)
def do_upgrade(): """Implement your upgrades here.""" with op.batch_alter_table("userEXT") as batch_op: batch_op.alter_column(column_name='id', type_=db.String(255), nullable=False)
def do_upgrade(): """Perfrom upgrade.""" if op.has_table('usergroup'): op.rename_table( old_table_name='usergroup', new_table_name='group' ) with op.batch_alter_table("group") as batch_op: batch_op.drop_index('ix_usergroup_name') batch_op.create_index('ix_group_name', ['name'], unique=True) batch_op.alter_column('name', server_default=None) batch_op.add_column(db.Column('is_managed', db.Boolean(), nullable=False, default=False)) batch_op.alter_column( column_name='join_policy', new_column_name='privacy_policy', type_=db.String(length=1), nullable=False ) batch_op.drop_index('login_method_name') batch_op.alter_column( column_name='login_method', new_column_name='subscription_policy', type_=db.String(length=1), nullable=False, server_default=None ) batch_op.add_column(db.Column('created', db.DateTime(), nullable=False, default=datetime.now)) batch_op.add_column(db.Column('modified', db.DateTime(), nullable=False, default=datetime.now, onupdate=datetime.now)) else: op.create_table( 'group', db.Column('id', db.Integer(15, unsigned=True), nullable=False, autoincrement=True), db.Column('name', db.String(length=255), nullable=False, unique=True, index=True), db.Column('description', db.Text, nullable=True, default=''), db.Column('is_managed', db.Boolean(), default=False, nullable=False), db.Column('privacy_policy', db.String(length=1), nullable=False), db.Column('subscription_policy', db.String(length=1), nullable=False), db.Column('created', db.DateTime, nullable=False, default=datetime.now), db.Column('modified', db.DateTime, nullable=False, default=datetime.now, onupdate=datetime.now), db.PrimaryKeyConstraint('id'), mysql_charset='utf8', mysql_engine='MyISAM' ) if op.has_table('user_usergroup'): op.rename_table( old_table_name='user_usergroup', new_table_name='groupMEMBER' ) with op.batch_alter_table("groupMEMBER") as batch_op: batch_op.drop_index('id_usergroup') batch_op.alter_column('id_user', server_default=None) batch_op.alter_column( column_name='id_usergroup', new_column_name='id_group', existing_type=db.Integer(15, unsigned=True), nullable=False ) batch_op.create_index('id_group', ['id_group']) batch_op.alter_column( column_name='user_status', new_column_name='state', type_=db.String(length=1), nullable=False ) batch_op.drop_column('user_status_date') batch_op.add_column(db.Column('modified', db.DateTime(), nullable=False, default=datetime.now, onupdate=datetime.now)) batch_op.add_column(db.Column('created', db.DateTime(), nullable=False, default=datetime.now)) else: op.create_table( 'groupMEMBER', db.Column('id_user', db.Integer(15, unsigned=True), nullable=False), db.Column('id_group', db.Integer(15, unsigned=True)), db.Column('state', db.String(length=1), nullable=False), db.Column('created', db.DateTime(), nullable=False, default=datetime.now), db.Column('modified', db.DateTime(), nullable=False, default=datetime.now, onupdate=datetime.now), db.ForeignKeyConstraint(['id_group'], [u'group.id'], ), db.ForeignKeyConstraint(['id_user'], [u'user.id'], ), db.PrimaryKeyConstraint('id_user', 'id_group'), mysql_charset='utf8', mysql_engine='MyISAM' ) op.create_table( 'groupADMIN', db.Column('id', db.Integer(15, unsigned=True), nullable=False, autoincrement=True), db.Column('group_id', db.Integer(15, unsigned=True)), db.Column('admin_type', db.Unicode(255)), db.Column('admin_id', db.Integer), db.ForeignKeyConstraint(['group_id'], [u'group.id'], ), db.PrimaryKeyConstraint('id', 'group_id'), mysql_charset='utf8', mysql_engine='MyISAM' )