This release is a pre-release and may not be stable for production use.
Проект является форком yoyo-migrations https://ollycope.com/software/yoyo/latest/
Компонент позволяет работать с миграциями баз данных posgtresql и mssql с использованием файлов sql
Установка
При установке компонента для миграций в postgres, можно использовать команду
pip install classic-migrations[postgres]
для MSSQL
pip install classic-migrations[pymssql]
Настройка
Все настройки берутся из переменных окружения или .env файла
.env file:
#папка с файлами миграций
SOURCE=./migrations
#пакетный режим исполнения, при котором нет диалоговых вопросов
BATCH_MODE=on|off(default)
#уровень вывода информационных сообщений
VERBOSITY=0|1|2|3
#настройки подключения к базе
#драйвер
DATABASE_DRIVER=pymssql|postgres|pyodbc
#имя пользователя БД
DATABASE_USER=
#домен пользователя БД (опционально)
DATABASE_USER_DOMAIN=
#пароль
DATABASE_PASSWORD=
#хост
DATABASE_HOST=
#порт
DATABASE_PORT=
#имя БД
DATABASE_NAME=
Команды запуска
migrations list
migrations new –sql -m ‘комментарий, который будет добавлен к имени файла’
migrations apply
migrations rollback
Для выполнения команды rollback, должен иметься .sql файл миграции, у которого между именем оригинального фала и расширением имеется вставка .rollback
Примечания
В SQL файле миграции можно указать комментарий, который будет добавлен в таблицу истории миграций.
– comment: текст комментария
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file classic_migrations-0.1b0.tar.gz.
File metadata
- Download URL: classic_migrations-0.1b0.tar.gz
- Upload date:
- Size: 34.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
640e3b4ed834ed21619df0f317c6b4d419c9eb5654d70181ac0a1f98a5d77cc5
|
|
| MD5 |
625e065d13727c1d6df785082d2ee71d
|
|
| BLAKE2b-256 |
56af8d57a951a8f558b33983a1cd4b9927a4e41730ad6df3a0d8317854049836
|
Provenance
The following attestation bundles were made for classic_migrations-0.1b0.tar.gz:
Publisher:
publish.yml on variasov/classic-migrations
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
classic_migrations-0.1b0.tar.gz -
Subject digest:
640e3b4ed834ed21619df0f317c6b4d419c9eb5654d70181ac0a1f98a5d77cc5 - Sigstore transparency entry: 2465995378
- Sigstore integration time:
-
Permalink:
variasov/classic-migrations@8a845d41257868008ba46465732da19564d00526 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/variasov
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@8a845d41257868008ba46465732da19564d00526 -
Trigger Event:
push
-
Statement type:
File details
Details for the file classic_migrations-0.1b0-py3-none-any.whl.
File metadata
- Download URL: classic_migrations-0.1b0-py3-none-any.whl
- Upload date:
- Size: 46.8 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
3f39dcf2ccb8b2e888bb1f29d14fb36dca6f30e4525c37e35717e0dddd7cdb8b
|
|
| MD5 |
11dd972959e04ed428964a5e481a6934
|
|
| BLAKE2b-256 |
72b809cbecbe226f7fd8704b5aa493f359f392de5e4da7b26910dfe3e4ca4dd3
|
Provenance
The following attestation bundles were made for classic_migrations-0.1b0-py3-none-any.whl:
Publisher:
publish.yml on variasov/classic-migrations
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
classic_migrations-0.1b0-py3-none-any.whl -
Subject digest:
3f39dcf2ccb8b2e888bb1f29d14fb36dca6f30e4525c37e35717e0dddd7cdb8b - Sigstore transparency entry: 2465995448
- Sigstore integration time:
-
Permalink:
variasov/classic-migrations@8a845d41257868008ba46465732da19564d00526 -
Branch / Tag:
refs/heads/main - Owner: https://github.com/variasov
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@8a845d41257868008ba46465732da19564d00526 -
Trigger Event:
push
-
Statement type:
