Alright, I'm not going to say that it's finished but it's a lot better than it was...
foreach (<>) {
  my ($item_id, $upc) = split(",",$_);
  my $status = upsert($dbh, $table, $item_id, $upc);
  print "Item #: $item_id, UPC: $upc, Status: $status\n";
}

sub upsert {
  my ($rows, $rows2, $status);
  my $true = "0E0";
  my ($dbh, $table, $item_id, $upc) = @_;
  my $sth = $dbh->prepare("UPDATE $table SET upc=? WHERE item_id=?;") 
+or die $dbh->errstr;
  my $sth2 = $dbh->prepare("INSERT INTO $table (item_id, upc) VALUES(?
+, ?);") or die $dbh->errstr;
  $sth->execute($upc, $item_id);
  $rows = $sth->rows;
  ($rows == 0) ? $true : $rows;  # from DBI pod (using variable instea
+d of "0E0")
  print "rows is $rows\n" if ($DEBUG);
  if ($rows < 1) {
    print "Didn't update so trying to insert...\n" if ($DEBUG);
    $sth2->execute($item_id, $upc);
    $rows = $sth2->rows;
    ($rows == 0) ? $true : $rows;
    print "rows is $rows\n" if ($DEBUG);
    if ($rows < 1) {
      print "Didn't insert so giving up...\n" if ($DEBUG);
    }else{
      $status = "Inserted";
    }
  }else{
    $status = "Updated";
  }
  return $status;
}

[download]
Comments, suggests?
Matthew Musgrove
Who says that programmers can't work in the Marketing Department?
Or is that who says that Marketing people can't program?

In reply to Re: Database Update or Insert by Mr. Muskrat
in thread Database Update or Insert by Mr. Muskrat

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.