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
--
To UNSUBSCRIBE, email to debian-qa-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/20121111075453.gb5...@an3as.eu
