Re^3: regarding File::Find


Your skill will accomplish what the force of many cannot
	PerlMonks

Re^3: regarding File::Find

by Hofmator (Curate)

on Nov 17, 2006 at 09:46 UTC ( [id://584688]=note: print w/replies, xml )

Need Help??

in reply to Re^2: regarding File::Find
in thread regarding File::Find

I think the solution chromatic had in mind goes something like this (untested)

#!/usr/bin/perl
use strict;
use File::Find;
use DBI;

my $sql = q(insert into file_stat values(?,?,?,?,?,?,?,?,?,?,?,?,?,?))
+;
my $dbh = DBI->connect('dbi:ODBC:test','test','test123',{AutoCommit =>
+ 1,RaiseError => 1}) or die "error!!\n";
my $sth = $dbh->prepare($sql);

sub wanted {
    return unless /\.pl$/i;

    my @stats = stat $File::Find::name;
    $sth->execute(@stats, $File::Find::name);
}

# find files
find (\&wanted,".");
[download]

Update: fixed stupid mistake in code (return instead of next).

-- Hofmator

Code written by Hofmator and posted on PerlMonks is public domain. It is provided as is with no warranties, express or implied, of any kind. Posted code may not have been tested. Use of posted code is at your own risk.