Mercurial > libervia-backend

comparison sat/memory/migration/script.py.mako @ 3582:71516731d0aa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
core (memory/sqla): database migration using Alembic: Alembic database migration tool, which is the recommended one for SQLAlchemy has been integrated. When a database is created, it will be used to stamp to current (head) revision, otherwise, DB will be checked to see if it needs to be updated, and upgrade will be triggered if necessary.
author Goffi <goffi@goffi.org>
date Fri, 25 Jun 2021 17:55:23 +0200
parents
children
comparison
equal deleted inserted replaced
3581:84ea57a8d6b3 3582:71516731d0aa
1 """${message}
2
3 Revision ID: ${up_revision}
4 Revises: ${down_revision | comma,n}
5 Create Date: ${create_date}
6
7 """
8 from alembic import op
9 import sqlalchemy as sa
10 ${imports if imports else ""}
11
12 # revision identifiers, used by Alembic.
13 revision = ${repr(up_revision)}
14 down_revision = ${repr(down_revision)}
15 branch_labels = ${repr(branch_labels)}
16 depends_on = ${repr(depends_on)}
17
18
19 def upgrade():
20 ${upgrades if upgrades else "pass"}
21
22
23 def downgrade():
24 ${downgrades if downgrades else "pass"}