5944649257
89%

Ran 22 Aug 2023 10:28PM UTC

Jobs 1

Files 90

Run time 3s

Badge

Embed ▾

Committed 22 Aug 2023 10:23PM UTC coverage: 89.041% (+0.01%) from 89.029%

Build # 5944649257

Build Type

push

github

Committed by

web-flow

Commit Message

Address sql alchemy warning (#1036)

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

## Description of Changes
Address the warnings that pop up when populating rows in the DB by
giving the foreign key constraints names. The warning no longer shows up
when running `make dev`. I named the foreign keys according to the motif
that they were given by default:
<img width="368" alt="Screenshot 2023-08-22 at 3 31 50 PM"
src="https://github.com/lucyparsons/OpenOversight/assets/5885605/4682dfaa-7d35-4a9f-9ccb-dac9073a5d99">

```zsh
/usr/src/app/OpenOversight/app/../migrations/env.py:75: SAWarning: Cannot correctly sort tables; there are unresolvable cycles between tables "departments, users", which is usually caused by mutually dependent foreign key constraints.  Foreign key constraints involving these tables will not be considered; this warning may raise an error in a future release.
  context.run_migrations()
```

## Tests and linting
 - [x] This branch is up-to-date with the `develop` branch.
 - [x] `pytest` passes on my local development environment.
 - [x] `pre-commit` passes on my local development environment.
- [x] Ran `make dev` to create tables and populate data to validate
changes to migrations.

Run Details

8312 of 9335 relevant lines covered (89.04%)

0.89 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	5944649257.1	22 Aug 2023 10:28PM UTC	0	89.04	GitHub Action Run

Source Files on build 5944649257

Detailed source file information is not available for this build.

lucyparsons / OpenOversight / 5944649257
89%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 5944649257

lucyparsons / OpenOversight / 5944649257 89%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 5944649257

lucyparsons / OpenOversight / 5944649257
89%

README BADGES
x