Clear out import queues for obsolete Ubuntu releases

Registered by Jeroen T. Vermeulen

Once an Ubuntu release is obsolete, there's no need whatsoever to keep its import queue entries around. Delete them with:

DELETE FROM TranslationImportQueueEntry Entry
USING Distribution Ubuntu, DistroSeries
WHERE
    Ubuntu.name = 'ubuntu' AND
    DistroSeries.distribution = Ubuntu.id AND
    DistroSeries.id = Entry.distroseries AND
    -- Status 6 is OBSOLETE.
    DistroSeries.releasestatus = %(obsolete)s;

Blueprint information

Status:
Complete
Approver:
None
Priority:
Medium
Drafter:
Jeroen T. Vermeulen
Direction:
Approved
Assignee:
Jeroen T. Vermeulen
Definition:
Approved
Series goal:
None
Implementation:
Implemented
Milestone target:
milestone icon 3.1.10
Started by
Jeroen T. Vermeulen
Completed by
Данило Шеган

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.