Clear out import queues for obsolete Ubuntu releases

Registered by Jeroen T. Vermeulen on 2008-12-18

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 on 2009-10-20
Completed by
Данило Шеган on 2009-11-05

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.