def upgrade():
"""Migrations for the upgrade."""
# yapf:disable
connection = op.get_bind()
DbNode = table('db_dbnode', column('id', Integer), column('uuid', UUID), column('type', String),
column('attributes', JSONB))
nodes = connection.execute(
select([DbNode.c.id, DbNode.c.uuid]).where(
DbNode.c.type == op.inline_literal('node.data.array.trajectory.TrajectoryData.'))).fetchall()
for pk, uuid in nodes:
symbols = load_numpy_array_from_repository(uuid, 'symbols').tolist()
connection.execute(DbNode.update().where(DbNode.c.id == pk).values(
attributes=func.jsonb_set(DbNode.c.attributes, op.inline_literal('{"symbols"}'), cast(symbols, JSONB))))
def downgrade():
"""Migrations for the downgrade."""
# yapf:disable
connection = op.get_bind()
DbNode = table('db_dbnode', column('id', Integer), column('uuid', UUID), column('type', String),
column('attributes', JSONB))
nodes = connection.execute(
select([DbNode.c.id, DbNode.c.uuid]).where(
DbNode.c.type == op.inline_literal('node.data.array.trajectory.TrajectoryData.'))).fetchall()
for pk, uuid in nodes:
attributes = connection.execute(select([DbNode.c.attributes]).where(DbNode.c.id == pk)).fetchone()
symbols = numpy.array(attributes['symbols'])
utils.store_numpy_array_in_repository(uuid, 'symbols', symbols)
key = op.inline_literal('{"array|symbols"}')
connection.execute(DbNode.update().where(DbNode.c.id == pk).values(
attributes=func.jsonb_set(DbNode.c.attributes, key, cast(list(symbols.shape), JSONB))))