<?xml version="1.0" encoding="windows-1252"?>
<node id="361850" title="demerphq's scratchpad" created="2004-06-06 22:47:17" updated="2005-08-15 05:47:59">
<type id="182711">
scratchpad</type>
<author id="108447">
demerphq</author>
<data>
<field name="doctext">
&lt;code&gt;
use Data::Consumer::Dir;
use Getopt::Long;

my ($db,$user,$name,$procs);
Getoptions(
  'db=s'        =&gt; $db,
  'user=s'      =&gt; $user,
  'name=s'      =&gt; $name,
  'procs=i'     =&gt; $procs
) or die "Bad args";

my $pid= $$;
fork while $procs--&gt;0 and $pid==$$;

my $feed= Data::Consumer::Dir-&gt;new( root =&gt; '/etc/drop/' );

my $DBH=DBI-&gt;connect($db,$user,$name) or die "...";

$feed-&gt;consume(sub {
  my ($f,$spec,$fh)= @_;
  while (&lt;$fh&gt;) {
      my @f=split/,/,$_;
      $dbh-&gt;do('insert into foo (date,height,width) values (?,?,?)',undef,@f);
  }
});
&lt;/code&gt;
</field>
</data>
</node>
