$ python3 -m venv .venv
$ source .venv/bin/activate
$ pip install -r requirements.txt
https://docs.sqlalchemy.org/en/14/index.html https://docs.sqlalchemy.org/en/14/orm/quickstart.html https://docs.sqlalchemy.org/en/14/orm/queryguide.html https://docs.sqlalchemy.org/en/14/orm/mapping_styles.html
https://alembic.sqlalchemy.org/en/latest/tutorial.html https://alembic.sqlalchemy.org/en/latest/autogenerate.html
Tabela | Coluna |
---|---|
alembic_version | version_num |
- Criar classe em
models/
herdendo demodels/base.py
. - Adicionar a nova classe no
models/__init__.py
.
$ alembic revision --autogenerate
Usando o Makefile:
$ make db-migrate
$ alembic upgrade head
Usando o Makefile:
$ make db-upgrade
Se a revisão for "ae1027a6acf" pode ser rodado o comando:
$ alembic upgrade ae1
$ alembic upgrade +2
$ alembic downgrade base
Usando o Makefile:
$ make db-downgrade
$ alembic downgrade -1
Usando o Makefile:
$ make db-downgrade-last
$ alembic upgrade head --sql
$ alembic downgrade head:base --sql