Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^2: regarding File::Find

by xiaoyafeng (Chaplain)
on Nov 17, 2006 at 07:21 UTC ( #584675=note: print w/replies, xml ) Need Help??


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

Thanks for your reply!

I think my mention has some problems.

for 1, I mean "insert" and "find" are running in parallel.
for 2, if use execute,how declare sql_type?

Replies are listed 'Best First'.
Re^3: regarding File::Find
by Hofmator (Curate) on Nov 17, 2006 at 09:46 UTC
    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,".");

    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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://584675]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (2)
As of 2018-08-18 02:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Asked to put a square peg in a round hole, I would:









    Results (184 votes). Check out past polls.

    Notices?