Mercurial > libervia-backend

view libervia/backend/memory/migration/versions/610345f77e75_add_version_id_to_history.py @ 4160:6a0066ea5c97

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
core (memory/sqla): add `id` filter in `history_get`
author Goffi <goffi@goffi.org>
date Tue, 28 Nov 2023 17:26:45 +0100
parents 23d21daed216
children 0d7bb4df2343
line wrap: on
line source

"""add "version_id" to History

Revision ID: 610345f77e75
Revises: 2ab01aa1f686
Create Date: 2023-11-20 17:33:53.544032

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '610345f77e75'
down_revision = '2ab01aa1f686'
branch_labels = None
depends_on = None


def upgrade():
    with op.batch_alter_table('history', schema=None) as batch_op:
        batch_op.add_column(sa.Column('version_id', sa.Integer(), server_default=sa.text('1'), nullable=False))


def downgrade():
    with op.batch_alter_table('history', schema=None) as batch_op:
        batch_op.drop_column('version_id')