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

[Leo Lapworth]

Thanks Shlomi,

I'll have a play at the weekend.

Many thanks for your work on this.

Leo

2009/12/9 Shlomi Fish <shlomif at iglu.org.il>

> 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 dea=
d?
> >
> >  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/ )
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/perl-org-patches/attachments/200912=
09/002ccb63/attachment.htm