lucyparsons / OpenOversight / 12800900175
89%

DEFAULT BRANCH: develop
Ran
Jobs 1
Files 100
Run time 1min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
coverage: 89.126%. Remained the same
12800900175

push

github

web-flow 
Add DB diagram function to `Makefile` (#1146)

## Fixes issue
https://github.com/lucyparsons/OpenOversight/issues/1060

## Description of Changes
Added a command to the `Makefile` that generates a DB relationship
diagram.

## Tests and Linting
- [x] This branch is up-to-date with the `develop` branch.
- [x] Ran `make create_db_diagram` command.
- [x] `pytest` passes on my local development environment.
- [x] `pre-commit` passes on my local development environment.
- [x] Validated edge cases for `make create_db_diagram`.

```console
(env) michaelp@Mac OpenOversight % rm database/schema.dot
(env) michaelp@Mac OpenOversight % make create_db_diagram
# Create new dot file showing current version of schema
eralchemy -i postgresql://openoversight:terriblepassword@localhost/openoversight-dev -o database/schema.new.dot
# Sort new version of schema file
sort database/schema.new.dot -o schema.new.dot.sorted
# Create old schema file if it does not exist and then sort it
touch database/schema.dot
sort database/schema.dot -o schema.dot.sorted
# Create a new diagram if there are changes, otherwise clean up files
Detected schema changes, making new DB relationship diagram!
# Remove all sorted files
rm schema.dot.sorted schema.new.dot.sorted
(env) michaelp@Mac OpenOversight % make create_db_diagram
# Create new dot file showing current version of schema
eralchemy -i postgresql://openoversight:terriblepassword@localhost/openoversight-dev -o database/schema.new.dot
# Sort new version of schema file
sort database/schema.new.dot -o schema.new.dot.sorted
# Create old schema file if it does not exist and then sort it
touch database/schema.dot
sort database/schema.dot -o schema.dot.sorted
# Create a new diagram if there are changes, otherwise clean up files
No schema changes detected!
# Remove all sorted files
rm schema.dot.sorted schema.new.dot.sorted
(env) michaelp@Mac OpenOversight %
```

8836 of 9914 relevant lines covered (89.13%)

0.89 hits per line

Jobs
ID Job ID Ran Files Coverage
1 12800900175.1 100
89.13
 GitHub Action Run
Source Files on build 12800900175