Shell Programming and Scripting

STATUS REPORT FOR JOB: Ftp
Generated: 2007-04-26 19:38:34
Job start time=2007-04-14 13:50:21
Job end time=2007-04-14 13:50:29
Job elapsed time=00:00:08
Job status=1 (Finished OK)

The above report is application generated report.

can any provide me the script to insert the Bolded records into database while generating itself.

Pls.iam new to Shell script.

(or )


STATUS REPORT FOR JOB: Ftp
Generated: 2007-04-26 19:38:34
Job start time=2007-04-14 13:50:21
Job end time=2007-04-14 13:50:29
Job elapsed time=00:00:08
Job status=1 (Finished OK)

I would like to insert the BOLD items into the database.

Column names in the database are
1.JOB
2.Job start time
3.Job end time
4.Job elapsed time
5.Job status

assume sample data as it is, this is a crude awk way:

Code:

awk 'BEGIN{ FS = "[=:]" }
     /REPORT/ { ftp = $2 }
     /Generated/ { generated = sprintf("%s:%s:%s", $2,$3,$4)  }
     /elapsed/ { elapsed = sprintf("%s:%s:%s", $2,$3,$4)  }
     /start time/ {start =  sprintf("%s:%s:%s", $2,$3,$4) }
     /end time/ {end = sprintf("%s:%s:%s", $2,$3,$4) }
     /status/ { sub(/\(Finish.*/,"",$2); status=$2}     
END { 
      printf "insert table_name values(\"%s\", \"%s\" , \"%s\",\"%s\",\"%s\")\n" , ftp,start,end,elapsed,status
    }' "file"

Code works fine .

But i am not able to insert it into database.

can anyone provide me with connecting database and how it is inserting

through the printf statement.

please provide me all the things in a single script.