Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: SQL script processor and executor

by hbm (Hermit)
on Jul 27, 2012 at 13:38 UTC ( #984030=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

  1. or download this
        if ($shpath) {    
          #print SH "chmod 700 $shpath/shell_$\n";
                     qq[plink -batch -pw "${passwd}" ${user}\@${server} -m
    + "${sh}" >> "${output}" 2>${outerr}\n];
        } else {
  2. or download this
          #if ($sqlline =~ /^=/) {        # Convert the output to record v
    +iew if prefixed by =
          #  $sqlline =~ s/^=//;          # trim off the =
          if ($sqlline =~ s/^=//) {       # trim off '=' and convert recor
    +d view if prefixed by =
            $rsql = 1;
  3. or download this
        #$server   =~ s/\s+.*//;
        #$user     =~ s/\s+.*//;
        #$dbpasswd =~ s/\s+.*//;
        #$shpath   =~ s/\s+.*// if $shpath;
        map{$_ && s/\s.*//} $server,$user,$passwd,$dbconn,$dbuser,$dbpassw

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://984030]
[shmem]: Lady_Aleena: perl -MMP3::Tag -MFile::Find -le 'find(sub{if($File ::Find::name=~/\. mp3$/){$sum+=MP3:: Tag->new($_)-> interpolate("\%S ")} }, "Music"); print "total seconds: $sum"'
[Lady_Aleena]: shmem, sorry I was outside for a moment moving my car out of hubby's way.
[Lady_Aleena]: shmem, there is ONE song which throws a wrench in the works for both MP3::Info and MP3::Tag.
[shmem]: Lady_Aleena: fix it, or delete it ;-)

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (4)
As of 2017-04-23 22:06 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (432 votes). Check out past polls.