mscolab dbase migration script missing (documentation)

[ReimarBauer]

Older versions than MSS 8.0.0 don't have a difinition in the operations table of the "active" state.

We need to provide a migration script, or documentation how to update existing databases.

msui 8.0.0 can read older versions of the mscolab server and also new created databases on 8.0.0. We need only the step for updating an existing one.

We should introduce a section migrations and collect there changes for the different parts of open-mss.

[ReimarBauer]

see https://flask-migrate.readthedocs.io/en/latest/

mamba activate instance
cd ~/INSTANCE/config
export PYTHONPATH=`pwd`


cd ~/INSTANCE/wsgi



flask --app mscolab.py db init
flask --app mscolab.py db migrate -m "To version 8.0.0"
flask --app mscolab.py db upgrade

The output looks like

~/INSTANCE/wsgi$ flask --app mscolab.py db upgrade
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> b70961f58f94, To version 8.0.0

[ReimarBauer]

the created migration script contents of b70961f58f94_.py

""To version 8.0.0

Revision ID: b70961f58f94
Revises: 
Create Date: 2023-04-22 11:45:59.483834

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'b70961f58f94'
down_revision = None
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('operations', schema=None) as batch_op:
        batch_op.add_column(sa.Column('active', sa.Boolean(), nullable=True))
        batch_op.add_column(sa.Column('last_used', sa.DateTime(), nullable=True)
)

    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    with op.batch_alter_table('operations', schema=None) as batch_op:
        batch_op.drop_column('last_used')
        batch_op.drop_column('active')

    # ### end Alembic commands ###