[Perl-org-patches] lists.perl.org - a start and help needed

[Shlomi Fish]

Hi all!

On Monday 23 Nov 2009 22:34:09 Leo Lapworth wrote:
> Hi,
> 
> 2009/11/23 Shlomi Fish <shlomif at iglu.org.il>
> 
> >  MySQL-only SQL file and the table is MyISAM.
> 
> Feel free to change it to any MySQL type, even if CSV is fine
> 
> > http://www.perlfoundation.org/perl5/index.cgi?lost_mailing_lists
> >
> > Should we remove them from the SQL too?
> 
> Could you add a column 'defunct' and flag those in the SQL that are dead?
> 
>  The SQL may give me some idea about how to structure the table
> 
> > appropriately.
> > Seems like the identifier of the table is the "name" column.
> 
> Yep
> 
> > In any case, I'll try to get it tomorrow.
> 
> Fantastic - thanks
> 

Well, sorry for the long delay, but I have something a bit more ready:

http://www.shlomifish.org/Files/files/test_perl5_mailing_lists.dump.gz

I got it by using this code:

https://svn.berlios.de/svnroot/repos/web-cpan/perl.org-work/trunk

And running:

$ perl collect-mailing-lists.pl
$ perl setup.pl # Run once to create the database.
$ perl process-db.pl

It doesn't populate all the tables yet, but hopefully I'll work on it. You'll 
need http://search.cpan.org/dist/DBIx-Simple/ for it and YAML-XS naturally.

Regards,

	Shlomi Fish

-- 
-----------------------------------------------------------------
Shlomi Fish       http://www.shlomifish.org/
"The Human Hacking Field Guide" - http://shlom.in/hhfg

Bzr is slower than Subversion in combination with Sourceforge. 
( By: http://dazjorz.com/ )