def upgrade(migrate_engine): meta = MetaData(bind=migrate_engine) #939 core_device = Table(Device.__tablename__, meta, autoload=True) core_device.c.address.alter(type=String(255)) #1064 core_plugin_config = Table(PluginConfig.__tablename__, meta, autoload=True) if not database_utils.column_exists(migrate_engine, PluginConfig.__tablename__, 'id'): core_plugin_config.c.name.alter(name='id') #1110 core_device_type = Table(DeviceType.__tablename__, meta, autoload=True) core_device_type.c.name.alter(type=String(80)) #1061 core_device_stats = Table(DeviceStats.__tablename__, meta, autoload=True) if not database_utils.index_exists(migrate_engine, DeviceStats.__tablename__, 'ix_core_device_stats_skey'): Index('ix_core_device_stats_skey', core_device_stats.c.skey).create() #1274 core_device_stats = Table(DeviceStats.__tablename__, meta, autoload=True) if not database_utils.index_exists(migrate_engine, DeviceStats.__tablename__, 'ix_core_device_stats_date_skey_device_id'): Index('ix_core_device_stats_date_skey_device_id', core_device_stats.c.date, core_device_stats.c.skey, core_device_stats.c.device_id).create()
def upgrade(migrate_engine): meta = MetaData(bind=migrate_engine) #939 core_device = Table(Device.__tablename__, meta, autoload=True) core_device.c.address.alter(type=String(255)) #1064 core_plugin_config = Table(PluginConfig.__tablename__, meta, autoload=True) if not database_utils.column_exists(migrate_engine, PluginConfig.__tablename__, 'id'): core_plugin_config.c.name.alter(name='id') #1110 core_device_type = Table(DeviceType.__tablename__, meta, autoload=True) core_device_type.c.name.alter(type=String(80)) #1061 core_device_stats = Table(DeviceStats.__tablename__, meta, autoload=True) if not database_utils.index_exists(migrate_engine, DeviceStats.__tablename__, 'ix_core_device_stats_skey'): Index('ix_core_device_stats_skey', core_device_stats.c.skey).create() #1274 core_device_stats = Table(DeviceStats.__tablename__, meta, autoload=True) if not database_utils.index_exists( migrate_engine, DeviceStats.__tablename__, 'ix_core_device_stats_date_skey_device_id'): Index('ix_core_device_stats_date_skey_device_id', core_device_stats.c.date, core_device_stats.c.skey, core_device_stats.c.device_id).create()
def upgrade(migrate_engine): meta = MetaData(bind=migrate_engine) #1424 core_device_stats = Table(DeviceStats.__tablename__, meta, autoload=True) if not database_utils.index_exists(migrate_engine, DeviceStats.__tablename__, 'ix_core_device_stats_date'): Index('ix_core_device_stats_date', core_device_stats.c.date).create()
def upgrade(migrate_engine): meta = MetaData(bind=migrate_engine) #1424 core_device_stats = Table(DeviceStats.__tablename__, meta, autoload=True) if not database_utils.index_exists(migrate_engine, DeviceStats.__tablename__, 'ix_core_device_stats_date'): Index('ix_core_device_stats_date', core_device_stats.c.date).create()