aiida.storage.sqlite_zip.migrations.versions package#
Submodules#
Initial main branch schema
This schema is mainly equivalent to the main_0001 schema of the psql_dos backend. The difference are:
Data types: the replacement of
JSONB
withJSON
, andUUID
withCHAR(32)
.Some more fields are nullable, to allow migrations from legacy to main. The nullable fields are then filled with default values, and set to non-nullable, in subsequent migrations.
Revision ID: main_0000 Revises: Create Date: 2021-02-02
- aiida.storage.sqlite_zip.migrations.versions.main_0000_initial.downgrade()[source]#
Migrations for the downgrade.
- aiida.storage.sqlite_zip.migrations.versions.main_0000_initial.upgrade()[source]#
Migrations for the upgrade.
Replace null values with defaults
Revision ID: main_0000a Revises: main_0000 Create Date: 2022-03-04
- aiida.storage.sqlite_zip.migrations.versions.main_0000a_replace_nulls.downgrade()[source]#
Downgrade database schema.
- aiida.storage.sqlite_zip.migrations.versions.main_0000a_replace_nulls.upgrade()[source]#
Convert null values to default values.
This migration is performed in preparation for the next migration, which will make these fields non-nullable.
Alter columns to be non-nullable (to bring inline with psql_dos main_0001).
Revision ID: main_0000b Revises: main_0000a Create Date: 2022-03-04
- aiida.storage.sqlite_zip.migrations.versions.main_0000b_non_nullable.downgrade()[source]#
Downgrade database schema.
- aiida.storage.sqlite_zip.migrations.versions.main_0000b_non_nullable.upgrade()[source]#
Upgrade database schema.
Bring schema inline with psql_dos main_0001
Revision ID: main_0001 Revises: Create Date: 2021-02-02