Fix referential integrity in production database

openaustralia / morph

Take the hassle out of web scraping

https://morph.io

GNU Affero General Public License v3.0

461 stars 74 forks source link

Fix referential integrity in production database #1038

Closed mlandauer closed 8 years ago

mlandauer commented 8 years ago

There are definitely runs in the database (in production) that are not attached to any existing scrapers.

Fixing this I imagine would include:

[x] Writing a rake task to delete records that shouldn't be there anymore
[x] Adding cascading deletes to places where it makes sense
[x] Enforce referential integrity in the database... You know, like grown ups.

mlandauer commented 8 years ago

We haven't added the foreign key constraints that refer to the owners table because it didn't work in production because we didn't explicitly clear out bad entries for those.

This should be investigated some more though is not critical. So, we can close this one I think.