I'm not interested in regexps as I'm not working with strings. This is being used to update database fields, so unless you're doing some really fancy tie-ing, regexps aren't gonna fly :)
For reference, the heart of the code that uses this snippet looks like this:
my $db = DBI->connect( $DSN, 'user', 'sekret', {AutoCommit => 0})
or die "Couldn't connect to database $DSN: ${\DBI->errstr}\n";
END { $db and $db->disconnect }
my $ss = $db->prepare( q{update t set department = ? where department
+= ?});
die unless $ss;
my $ok = 1;
REPLACE: for my $r( @order ) {
for my $key( keys %$r ) {
print "$key -> $r->{$key}\n";
if( !$ss->execute( $r->{$key}, $key )) {
warn "cannot update $key to $r->{$key}\n${\$ss->errstr}\n"
+;
$ok = 0;
last REPLACE;
}
}
}
$ok ? $db->commit : $db->rollback;
NB: The above code is condensed from production code. I have excised things that have no relevance to the example, so it just may or may not compile :)
print@_{sort keys %_},$/if%_=split//,'= & *a?b:e\f/h^h!j+n,o@o;r$s-t%t#u'
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
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, 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, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Outside of code tags, you may need to use entities for some characters:
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
|
|