src/utils/qa/bigPush.csh 1.5
1.5 2009/04/11 00:37:01 rhead
Sourced new qaConfig file at the top. Changed -h hgwbeta lines to look for sql host stored in a variable, specified in the new qaConfig file.
Index: src/utils/qa/bigPush.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/bigPush.csh,v
retrieving revision 1.4
retrieving revision 1.5
diff -b -B -U 1000000 -r1.4 -r1.5
--- src/utils/qa/bigPush.csh 25 Mar 2009 18:29:29 -0000 1.4
+++ src/utils/qa/bigPush.csh 11 Apr 2009 00:37:01 -0000 1.5
@@ -1,80 +1,81 @@
#!/bin/tcsh
+source `which qaConfig.csh`
################################
# 04-02-04
# updated:
# 04-08-04
#
# Runs through set of all tables ever used in this assembly.
# Pushes multiple tables from dev to beta
# can't use "&" after output command because of "password prompt"
# (if you do, each command gets put into background and
# requires "fg" to get to password prompt)
# can't redirect output into file:
# use "script filename.out" to capture ?
# also records total size of the push
#
################################
set db=""
set tablelist=""
if ($2 == "") then
echo
echo " pushes tables in list to beta and records size."
echo " do not redirect output ! "
echo " do not run in the background:"
echo " (will hang on long tables due to pasword prompt)."
echo " reports total size of push."
echo
echo " usage: database, tablelist"
echo
exit
else
set db=$1
set tablelist=$2
endif
set trackName=`echo $2 | sed -e "s/Tables//"`
# echo trackName = $trackName
echo
echo "will have to re-type Password after long tables (timeout)"
echo
rm -f $db.$trackName.push
foreach table (`cat $tablelist`)
echo pushing "$table"
sudo mypush $db "$table" hgwbeta >> $db.$trackName.push
echo "$table" >> $db.$trackName.push
# tail -f $db.$trackName.push
end
echo
# --------------------------------------------
# "check that all tables were pushed:"
echo
~/bin/updateTimes.csh $db $tablelist
echo
# --------------------------------------------
# "find the sizes of the pushes:"
echo
echo "find the sizes of the pushes:"
echo
grep 'total size' $db.$trackName.push | gawk '{total+=$4} END {print total}' \
> $db.$trackName.pushSize
set size=`cat $db.$trackName.pushSize`
echo "$size\n bytes"
echo
echo $size | gawk '{print $1/1000;print " kilobytes"}'
echo
echo $size | gawk '{print $1/1000000;print " megabytes"}'
echo
echo
echo end.