goshawk 0.1.4

SQL Models for humans

goshawk

SQL Model Management for Humans

• Github repository: https://github.com/ebrassell/goshawk/
• Documentation https://ebrassell.github.io/goshawk/

Getting started with Goshawk

Installation

We recommend installing with pipx

pipx install gohawk

Or install with pip (you should always use a virtual environment)

pip install gohawk

Verify your installation

goshawk view-model-tree --schemas-only

This will display the DAG of the included sample schema

Set MODELS_PATH env var to the folder containing your models.

`-- models <-set MODELS_PATH to the path to this folder
     -- mydatabase
         -- schema_1
             -- model_1a.sql
             -- model_1b.sql
         -- schema_2
             -- model_2a.sql
             -- model_2b.sql

export MODELS_PATH=models

Create a dev environemnt

goshawk init-env [envname]

Test your changes (using your dev environment)

goshawk deploy-models --test --db-env [envname]

Deploy your changes to your dev environment

goshawk deploy-models --test --db-env [envname]

Destroy your dev environemnt

goshawk destroy-env [envname]