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:

  1. Data types: the replacement of JSONB with JSON, and UUID with CHAR(32).

  2. 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

aiida.storage.sqlite_zip.migrations.versions.main_0001.downgrade()[source]

Migrations for the downgrade.

aiida.storage.sqlite_zip.migrations.versions.main_0001.upgrade()[source]

Migrations for the upgrade.

previous

aiida.storage.sqlite_zip.migrations.legacy package

next

aiida.tools package