1021322 - Write a script to find and purge orphaned translations

Status: RESOLVED WONTFIX

(Marketplace Graveyard :: Code Quality, defect, P4)

Description

[Rob Hudson [:robhudson]]

As we're cleaning out the database of addons we are going to leave orphaned translations. At the end of it all we should write a script to clean out orphaned translations. This might be tricky but we can check if the translations.id is used in all of our FKs and if not, delete it.

This SQL shows all the contraints on translations:

SELECT
     k.table_name,
     k.constraint_name
FROM
     information_schema.KEY_COLUMN_USAGE k
WHERE
     k.CONSTRAINT_SCHEMA = 'zamboni' AND
     k.referenced_table_name IS NOT NULL AND
     k.referenced_table_name = 'translations'
ORDER BY
     k.table_name, k.constraint_name
;