issues
search
Police-Data-Accessibility-Project
/
prod-to-dev-migration
Regularly migrates production database and schema to development database
1
stars
0
forks
source link
Update `data_requests` schema and related constraints/triggers
#28
Closed
maxachis
closed
2 months ago
maxachis
commented
2 months ago
Fixes
Fixes
https://github.com/Police-Data-Accessibility-Project/data-sources-app/issues/355
Description
Updates schema to description as provided in above issue.
Testing
Run migration script in
automation.pdap.io
. Confirm migration runs successfully and expected changes occur.
Performance
Increase in number of columns in
data_requests
table
Triggers and defaults add slight overhead to insertion and other transactions.
Other impacts marginal.
Docs
Comments added to relevant tables, triggers, constraints, and enums.
Breaking Changes
Scripts which rely on the names of columns that are now either renamed or removed may be impacted.
Similarly, pre-existing insertion logic might run afoul of constraints.
However, no scripts at the moment appear to be impacted by this.
Fixes
Description
Testing
automation.pdap.io
. Confirm migration runs successfully and expected changes occur.Performance
data_requests
tableDocs
Breaking Changes