Due date today, things are happening.  We're currently kicking it at Denny's.  Contractions started yesterday mornings and something appears afoot.  This morning Amber indicated that the pain level with her contractions is greater than it was yesterday and she's just updated me that their frequency is increasing.  I'm gonna go out on a limb and wager that this will be the last time we come to Denny's requesting a table for 2

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

My daily commute is 50 minutes each way in good and uneventful traffic.  My mobile too greatly divides my attention and I gotta kid on the way.  With voice actions, I can fire up GPS, text, or call anyone in my contact list or off Google Maps without pushing more than a button or two.  Seems like the voice recognition is even faster and more accurate since the 2.2 update.

This video lays it out beautifully.

A little nugget I've already found not mentioned in the video is the directions Voice Action.  As a previous iPhone user I like making use of the more familiar directions versus navigation in Android.  Navigation takes control of the phone and is a tad bit obtrusive when I'm trying to do more than merely get from point "a" to point "b."   Directions is a more standard/common implementation of Google Maps based GPS and easier to mix in with other stuff whilst multitasking.

To make use of directions, give this one a whirl:
"directions to the Canton Akron Airport Ohio"

For those of you who are hip to the QR codes, see below.  Here's a direct download link to this most excellent application (for Android powered devices only) in the Android Marketplace.

This post is password protected. To view it please enter your password below:

Password:

1. I've been wanting to mess with FeedBurner for a while.  Not entirely sure what this is all about yet.
2. My brother is on an epic motorcycle journey (EMJ) across the United States.  He doing a round trip from Ohio to Vancouver BC. He's regularly tweeting and got Google Latitude activated.
3. My mother wants to follow along, but is what we'll call "technically pure"  She doesn't quite get the whole twitter thing yet and really wants to follow along on the EMJ.

I'm looking to combine 1 & 2 to accomplish 3:

This post is password protected. To view it please enter your password below:

Password: