src/utils/qa/updateTimes.csh 1.28
1.28 2010/03/17 19:39:24 rhead
Added labels to the output lines!
Index: src/utils/qa/updateTimes.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/updateTimes.csh,v
retrieving revision 1.27
retrieving revision 1.28
diff -b -B -U 4 -r1.27 -r1.28
--- src/utils/qa/updateTimes.csh 16 Mar 2010 18:09:02 -0000 1.27
+++ src/utils/qa/updateTimes.csh 17 Mar 2010 19:39:24 -0000 1.28
@@ -55,39 +55,36 @@
echo "============="
set first=`hgsql -N -e 'SHOW TABLE STATUS LIKE "'$table'"' $db \
| awk '{print $14, $15}'`
- if ( $status ) then
- echo "."
- continue
+ if ( "$first" == "" ) then # put some spaces in so labels line up
+ set first=" "
endif
set second=`hgsql -h $sqlbeta -N -e 'SHOW TABLE STATUS LIKE "'$table'"' $db \
| awk '{print $14, $15}'`
- if ( $status ) then
- echo "."
- continue
+ if ( "$second" == "" ) then
+ set second=" "
endif
if ( "$table" == "trackDb" ) then
set third=`hgsql -h $sqlbeta -N -e 'SHOW TABLE STATUS LIKE "'trackDb_public'"' $db \
| awk '{print $14, $15}'`
- if ( $status ) then
- echo "."
- continue
+ if ( "$third" == "" ) then
+ set third=" "
endif
endif
set fourth=`getRRtableStatus.csh $db $table Update_time`
- if ( $status ) then
- set fourth=""
+ if ( $status ) then #check status here because contents could be error msg
+ set fourth=" "
endif
- echo "."$first
- echo "."$second
+ echo ".$first $HOST"
+ echo ".$second $sqlbeta"
if ( "$table" == "trackDb" ) then
- echo "."$third "(trackDb_public)"
+ echo ".$third $sqlbeta (trackDb_public)"
endif
echo
- echo "."$fourth
+ echo ".$fourth RR"
end
echo