bugzilla.mozilla.org has resumed normal operation. Attachments prior to 2014 will be unavailable for a few days. This is tracked in Bug 1475801.
Please report any other irregularities here.

Write a script to find and purge orphaned translations

RESOLVED WONTFIX

Status

Marketplace
Code Quality
P4
normal
RESOLVED WONTFIX
4 years ago
2 years ago

People

(Reporter: robhudson, Unassigned)

Tracking

Avenir
x86
Mac OS X
Points:
---

Details

(Whiteboard: [repoman][clean-up][marketplace-transition])

(Reporter)

Description

4 years ago
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
;

Updated

4 years ago
Priority: -- → P4
Status: NEW → RESOLVED
Last Resolved: 2 years ago
Resolution: --- → WONTFIX
Whiteboard: [repoman][clean-up] → [repoman][clean-up][marketplace-transition]
You need to log in before you can comment on or make changes to this bug.