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):
# bind the engine
meta = MetaData(bind=migrate_engine)
#reate the new table
if not database_utils.table_exists(migrate_engine, Command.__tablename__):
table = Command.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine, CommandParam.__tablename__):
table = CommandParam.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine, Sensor.__tablename__):
table = Sensor.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine, SensorHistory.__tablename__):
table = SensorHistory.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine, XplStat.__tablename__):
table = XplStat.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine, XplStatParam.__tablename__):
table = XplStatParam.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine, XplCommand.__tablename__):
table = XplCommand.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine, XplCommandParam.__tablename__):
table = XplCommandParam.__table__
table.create(bind=migrate_engine)
# device address make nullable
if database_utils.column_exists(migrate_engine, Device.__tablename__, 'address'):
dev = Table(Device.__tablename__, meta, autoload=True)
dev.c.address.alter(nullable=True)
# device device_type_id make nullable
if database_utils.column_exists(migrate_engine, Device.__tablename__, 'device_type_id'):
dev = Table(Device.__tablename__, meta, autoload=True)
dev.c.device_type_id.alter(nullable=True)
# set deviceType to Null for existing devices
Session = sessionmaker(bind=migrate_engine)
session = Session()
session.query(Device).update({'device_type_id': None})
session.commit()
session = None
Session = None
# delete feature and featureModels
if database_utils.table_exists(migrate_engine, "core_device_feature_association"):
migrate_engine.execute("DROP table core_device_feature_association")
if database_utils.table_exists(migrate_engine, "core_device_feature"):
migrate_engine.execute("DROP table core_device_feature")
if database_utils.table_exists(migrate_engine, "core_device_feature_model"):
migrate_engine.execute("DROP table core_device_feature_model")
# delete device usage
if database_utils.column_exists(migrate_engine, Device.__tablename__, 'address'):
dev = Table(Device.__tablename__, meta, autoload=True)
# drop the table
if database_utils.table_exists(migrate_engine, "core_device_usage"):
dev = Table(Device.__tablename__, meta, autoload=True)
devusage = Table(DeviceUsage.__tablename__, meta, autoload=True)
cons = ForeignKeyConstraint([dev.c.device_usage_id], [devusage.c.id], name='core_device_ibfk_1')
cons.drop()
duid = Column('device_usage_id', Unicode(80))
duid.drop(dev)
migrate_engine.execute("DROP table core_device_usage")
# technology to plugin renaming
#0- delete foreign key between device and device_type
fkey_do = database_utils.foreignkey_exists(migrate_engine, Device.__tablename__, "core_device_ibfk_2")
if fkey_do:
dev = Table(Device.__tablename__, meta, autoload=True)
devtype = Table(DeviceType.__tablename__, meta, autoload=True)
cons = ForeignKeyConstraint([dev.c.device_type_id], [devtype.c.id], name='core_device_ibfk_2')
cons.drop()
cons = None
dev = None
devtype = None
#1- delete device_type
if database_utils.table_exists(migrate_engine, "core_device_type"):
migrate_engine.execute("DROP table core_device_type")
#2- delete technology
if database_utils.table_exists(migrate_engine, "core_device_technology"):
migrate_engine.execute("DROP table core_device_technology")
#3- create device_type
if not database_utils.table_exists(migrate_engine, Plugin.__tablename__):
table = Plugin.__table__
table.create(bind=migrate_engine)
#5- create plugin
if not database_utils.table_exists(migrate_engine, DeviceType.__tablename__):
table = DeviceType.__table__
table.create(bind=migrate_engine)
#6- re-add the foreign key
if fkey_do:
dev = Table(Device.__tablename__, meta, autoload=True)
devtype = Table(DeviceType.__tablename__, meta, autoload=True)
cons = ForeignKeyConstraint([dev.c.device_type_id], [devtype.c.id], name='core_device_ibfk_2')
cons.create()
def upgrade(migrate_engine):
# bind the engine
meta = MetaData(bind=migrate_engine)
#reate the new table
if not database_utils.table_exists(migrate_engine, Command.__tablename__):
table = Command.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine,
CommandParam.__tablename__):
table = CommandParam.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine, Sensor.__tablename__):
table = Sensor.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine,
SensorHistory.__tablename__):
table = SensorHistory.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine, XplStat.__tablename__):
table = XplStat.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine,
XplStatParam.__tablename__):
table = XplStatParam.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine,
XplCommand.__tablename__):
table = XplCommand.__table__
table.create(bind=migrate_engine)
if not database_utils.table_exists(migrate_engine,
XplCommandParam.__tablename__):
table = XplCommandParam.__table__
table.create(bind=migrate_engine)
# device address make nullable
if database_utils.column_exists(migrate_engine, Device.__tablename__,
'address'):
dev = Table(Device.__tablename__, meta, autoload=True)
dev.c.address.alter(nullable=True)
# device device_type_id make nullable
if database_utils.column_exists(migrate_engine, Device.__tablename__,
'device_type_id'):
dev = Table(Device.__tablename__, meta, autoload=True)
dev.c.device_type_id.alter(nullable=True)
# set deviceType to Null for existing devices
Session = sessionmaker(bind=migrate_engine)
session = Session()
session.query(Device).update({'device_type_id': None})
session.commit()
session = None
Session = None
# delete feature and featureModels
if database_utils.table_exists(migrate_engine,
"core_device_feature_association"):
migrate_engine.execute("DROP table core_device_feature_association")
if database_utils.table_exists(migrate_engine, "core_device_feature"):
migrate_engine.execute("DROP table core_device_feature")
if database_utils.table_exists(migrate_engine,
"core_device_feature_model"):
migrate_engine.execute("DROP table core_device_feature_model")
# delete device usage
if database_utils.column_exists(migrate_engine, Device.__tablename__,
'address'):
dev = Table(Device.__tablename__, meta, autoload=True)
# drop the table
if database_utils.table_exists(migrate_engine, "core_device_usage"):
dev = Table(Device.__tablename__, meta, autoload=True)
devusage = Table(DeviceUsage.__tablename__, meta, autoload=True)
cons = ForeignKeyConstraint([dev.c.device_usage_id], [devusage.c.id],
name='core_device_ibfk_1')
cons.drop()
duid = Column('device_usage_id', Unicode(80))
duid.drop(dev)
migrate_engine.execute("DROP table core_device_usage")
# technology to plugin renaming
#0- delete foreign key between device and device_type
fkey_do = database_utils.foreignkey_exists(migrate_engine,
Device.__tablename__,
"core_device_ibfk_2")
if fkey_do:
dev = Table(Device.__tablename__, meta, autoload=True)
devtype = Table(DeviceType.__tablename__, meta, autoload=True)
cons = ForeignKeyConstraint([dev.c.device_type_id], [devtype.c.id],
name='core_device_ibfk_2')
cons.drop()
cons = None
dev = None
devtype = None
#1- delete device_type
if database_utils.table_exists(migrate_engine, "core_device_type"):
migrate_engine.execute("DROP table core_device_type")
#2- delete technology
if database_utils.table_exists(migrate_engine, "core_device_technology"):
migrate_engine.execute("DROP table core_device_technology")
#3- create device_type
if not database_utils.table_exists(migrate_engine, Plugin.__tablename__):
table = Plugin.__table__
table.create(bind=migrate_engine)
#5- create plugin
if not database_utils.table_exists(migrate_engine,
DeviceType.__tablename__):
table = DeviceType.__table__
table.create(bind=migrate_engine)
#6- re-add the foreign key
if fkey_do:
dev = Table(Device.__tablename__, meta, autoload=True)
devtype = Table(DeviceType.__tablename__, meta, autoload=True)
cons = ForeignKeyConstraint([dev.c.device_type_id], [devtype.c.id],
name='core_device_ibfk_2')
cons.create()