Re: Need perl/shell/php script: PostgreSQL Media

On Jul 31, 2009, at 12:20 PM, Josh Berkus wrote:

> We could use a script which goes through a specified subdirectory  
> tree for media.postgresql.org and produces a wiki page with:
>
> filename  filesize   format
>
> This will greatly aid us in getting videos where people can see them.

#!/usr/bin/perl -w

use strict;
use warnings;
use File::Find;
use MIME::Types;

my $types = MIME::Types->new;
sub file_info {    print $File::Find::name, "\t",          -s, "\t",          $types->mimeTypeOf($_) ||
'application/octet-stream',$/        if -f;
 
}

find \&file_info, @ARGV;

Best,

David