Mercurial > libervia-backend
comparison libervia/backend/memory/migration/versions/610345f77e75_add_version_id_to_history.py @ 4152:23d21daed216
core (memory/sqla_mapping): add a `version_id` column to detect race conditions.
| author | Goffi <goffi@goffi.org> |
|---|---|
| date | Wed, 22 Nov 2023 14:52:00 +0100 |
| parents | |
| children | 0d7bb4df2343 |
comparison
equal
deleted
inserted
replaced
| 4151:18026ce0819c | 4152:23d21daed216 |
|---|---|
| 1 """add "version_id" to History | |
| 2 | |
| 3 Revision ID: 610345f77e75 | |
| 4 Revises: 2ab01aa1f686 | |
| 5 Create Date: 2023-11-20 17:33:53.544032 | |
| 6 | |
| 7 """ | |
| 8 from alembic import op | |
| 9 import sqlalchemy as sa | |
| 10 | |
| 11 | |
| 12 # revision identifiers, used by Alembic. | |
| 13 revision = '610345f77e75' | |
| 14 down_revision = '2ab01aa1f686' | |
| 15 branch_labels = None | |
| 16 depends_on = None | |
| 17 | |
| 18 | |
| 19 def upgrade(): | |
| 20 with op.batch_alter_table('history', schema=None) as batch_op: | |
| 21 batch_op.add_column(sa.Column('version_id', sa.Integer(), server_default=sa.text('1'), nullable=False)) | |
| 22 | |
| 23 | |
| 24 def downgrade(): | |
| 25 with op.batch_alter_table('history', schema=None) as batch_op: | |
| 26 batch_op.drop_column('version_id') |