Closed Bug 1424370 Opened 5 years ago Closed 5 years ago

remove unused database views

Categories

(Socorro :: Database, task, P1)

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: willkg, Assigned: willkg)

References

Details

Attachments

(1 file)

Socorro has Postgres views in:

socorro/external/postgres/raw_sql/views/

Some/many/all of these views are no longer used and we should remove them.

This bug covers figuring out which are used and which aren't and then deleting the ones that aren't.
Making this a P1 and grabbing this to do soon. This should be a 1-day project and cleaning up views behooves us greatly because it makes other cleanup work easier.
Assignee: nobody → willkg
Status: NEW → ASSIGNED
Priority: -- → P1
I went through all the views and seems like none of them are being used.

I'm going to remove them all.
Commits pushed to master at https://github.com/mozilla-services/socorro

https://github.com/mozilla-services/socorro/commit/65dea66b3d882adb58f1a09ec0d4cfedeff52b40
fixes bug 1424370 - remove all the postgres views

None of these views are used, so I removed all the views and the
infrastructure for loading views.

https://github.com/mozilla-services/socorro/commit/884c826028bfcfddbb2ed1b9f544c0b8952d5c56
Merge pull request #4261 from willkg/1424370-views

fixes bug 1424370 - remove all the postgres views
Status: ASSIGNED → RESOLVED
Closed: 5 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.