267471 - Ability to export attachments meeting certain criteria to the filesystem

Status: NEW

(Bugzilla :: Bug Import/Export & Moving, enhancement, P4)

Description

[Brandon Macdonald]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.0; rv:1.7.3) Gecko/20040913 Firefox/0.10.1
Build Identifier: 

A script allowing for the export of attachments meeting certain criteria to the
filesystem would be very useful.  For me, what I am looking for is the ability
to dump all non-obsolete attachments for bugs that are flagged a certain way. 
Specifically, I want to be able to export all non-obsolete attachments to a
folder for bugs that have been flagged as ? for "Application to Testing Server"
(Or Production for that matter).  This makes preparing for a rollout trivial as
opposed to the current system which requires me to go through each relevant bug
and manually download the attachments to my PC.  If there are 15 bugs to be
included in this rollout, some of which may have as much as 10 or more
non-obsolete attachments it is horrifically time consuming to prepare.

Ideally they could be dumped to a structure of <BUG_ID>/<FILENAME>.   The SQL I
would use to get all relevant information would come from:

select a.filename, a.bug_id as directory, a.thedata
from attachments a, flags f, flagtypes ft
where a.bug_id = f.bug_id
and f.type_id = ft.id
and a.isobsolete = 0
and ft.name = <flag_name>
and f.status = <flat_status>;

I'm sure there could be many other options for such an export utility, but those
are the ones I am interested in.

Reproducible: Always
Steps to Reproduce:

Comment 1

[Dave Miller [:justdave]]

Reassigning bugs that I'm not actively working on to the default component owner
in order to try to make some sanity out of my personal buglist.  This doesn't
mean the bug isn't being dealt with, just that I'm not the one doing it.  If you
are dealing with this bug, please assign it to yourself.