Some more bugs tables need to be exportet (Was: Any chance to pg_dump UDD partially)

[Andreas Tille <tille@debian.org>]

Hi Lucas,

some time ago you created a job that drops the content of bugs_* tables
in
    http://udd.debian.org/udd-bugs.sql.gz

Did you commited the code that does this somewhere?  I realised that I
also do need the information of

   archived_bugs
   archived_bugs_packages
   archived_bugs_merged_with
   archived_bugs_found_in
   archived_bugs_fixed_in
   archived_bugs_tags
   archived_bugs_blocks
   archived_bugs_blockedby

I could volunteer to send you a patch about these in case you might have
time constraints.

Kind regards

         Andreas.

On Tue, May 15, 2012 at 09:26:24AM -0400, Lucas Nussbaum wrote:
> On 14/05/12 at 23:03 +0200, Andreas Tille wrote:
> > 
> > #!/bin/sh
> > 
> > GETFROMHOST=udd.debian.org
> > TABLES="bugs \
> >         bugs_blockedby \
> >         bugs_blocks \
> >         bugs_fixed_in \
> >         bugs_found_in \
> >         bugs_merged_with \
> >         bugs_packages \
> >         bugs_tags \
> >         bugs_usertags"
> > 
> > for tab in $TABLES ; do
> >    psql udd -c "DROP TABLE IF EXISTS ${tab};"
> >    ssh $GETFROMHOST "pg_dump --no-owner --format=custom --table ${tab} udd | bzip2" | \
> >      bunzip2 | \
> >      pg_restore --no-owner --format=custom --table ${tab} --dbname=udd
> > done
> > 
> > ...
> 
> I don't see anything fundamentally unreasonable about what you are
> proposing.


-- 
http://fam-tille.de