Casey Wise projects and web archive/sandbox

My very first bash shell script

So at work, I do some "glue" work. I'm learning all sorts of things at once. At any time during the day, I'm confident with what I'm doing or a humiliated greenhorn. Often times, where I fall short in my lack of knowledge, I shore up with a different area where I'm less dumber.  It definitely makes for a rainbow of emotions.

Today I wrote my first bash shell script and it felt really good. The code is below, but here's what it does:

1. Queries our dotCMS database to find where we have outstanding records (that's my Java greenhorns creating those records)
2. If records are found:
   1. SQL dumps the 2 tables to my local Ubuntu desktop
   2. Restores the data into my local data base
   3. Sends mail making use of the "mailx" software to myself and our sysadmin, notifying him to access some PHP generated SQL to run against our production dotCMS database

The PHP was generated a while ago which parses pipe-delimited data in to an ad-hoc SQL query.  This script runs hourly as a cron job.

Here's the code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

#!/bin/sh
 
to="test@test.com"
 
dbh="database host path"
dbu="database user"
dpw="database password"
dbn="database name"
 
ldbh="local database host"
ldbu="local database user"
lpw="local database password"
ldb="local database name"
 
mysql -N -h $ldbh -u $ldbu -p$lpw $ldb << EOT > /tmp/t$$
select blah blah from blah blah where blah blah = blah blah blah
EOT
 
VAR=`cat /tmp/t$$`
if [ "$VAR" != "" ]; then
        echo "yes, we have unreported records\r\n$VAR"
        mysqldump --single-transaction -u $dbu -p$dpw -h $dbh $dbn table1 table2  > /tmp/tmp.sql
        mysql -u $ldbu $lbu -p$lpw $ldb &lt; /tmp/tmp.sql
        echo "Sysadmin, we have unreported records:\n$VAR\n\nCan you please run the following SQL against the prod dotCMS db?\nhttp://xxxx/xxxx.php" | mailx -s "Unreported Records" $to
fi