Some more bugs tables need to be exportet (Was: Any chance to pg_dump UDD partially)
- To: Lucas Nussbaum <lucas@debian.org>
- Cc: debian-qa@lists.debian.org
- Subject: Some more bugs tables need to be exportet (Was: Any chance to pg_dump UDD partially)
- From: Andreas Tille <tille@debian.org>
- Date: Sun, 11 Nov 2012 08:54:53 +0100
- Message-id: <20121111075453.GB5362@an3as.eu>
- In-reply-to: <20120515132624.GA28554@xanadu.blop.info>
- References: <20120511092241.GA3759@an3as.eu> <20120514210304.GB10315@an3as.eu> <20120515132624.GA28554@xanadu.blop.info>
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
Reply to: