PostgreSQL. Database migration and seeds tool for postgres by using psycopg2 with python3.
Project description
WALK
Walk is a simple python migrations and seeds tool for postgres databases. The application is based on 'psycopg2' to run sql commands.
Installation
Download the this git repository and than inside the root folder of the repository.
pip install walk
Current Version
0.2.4
Configuration
Intialize default configurations file 'walk_config.json'.
walk --init
The default walk_config.json looks like this.
{
"test": [
"user=postgres",
"dbname=test"
],
"dev": [
"user=postgres",
"dbname=dev"
],
"prod": [
"user=postgres",
"dbname=prod",
"password=pw"
]
}
Passing db config parameters directly to the command. The config attributes in the config file which are also included in the command paramters list will be ignored.
"dev": {
"dbname=test"
}
walk -p dbname=prod -p password=pw -e dev
-> dbname=prod will be taken
For more configuration parameters look inside the documentation of the 'psycopg2' connection class. Here
Migrations sql file
To create a new migrations file inside the migrations folder. Use the following command. The default database environment is 'dev'.
walk --new test_file_name
Execute migrations
To execute the migration files for the 'dev' database enviroment use the following command.
walk --migrate --env dev
Seeds sql file
To create a new seed file inside the seeds folder. Use the following command. The default database environment is 'dev'.
walk --newseed test_seed_name
Execute seeds
To execute the seed files for the 'dev' database enviroment use the following command. You can also combine the seeds and the migrations. Migrations will be executed first so that seeds can also access current db changes.
walk --seed --env dev
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.