src/utils/qa/sessionStats.csh 1.6

Index: src/utils/qa/sessionStats.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/sessionStats.csh,v
retrieving revision 1.5
retrieving revision 1.6
diff -b -B -U 4 -r1.5 -r1.6
--- src/utils/qa/sessionStats.csh	11 Apr 2009 00:37:05 -0000	1.5
+++ src/utils/qa/sessionStats.csh	5 May 2009 23:13:56 -0000	1.6
@@ -29,23 +29,23 @@
   exit
 endif
 
 # get months sessions has been alive:
-set months=`hgsql -N -h genome-centdb -e "SELECT DISTINCT firstUse FROM namedSessionDb" hgcentral \
+set months=`hgsql -N -h $sqlrr -e "SELECT DISTINCT firstUse FROM namedSessionDb" hgcentral \
   | awk -F- '{print $1"-"$2}' | sort -u`
 
 # get stats
 echo
 echo " first  count users  shared   reused  "
 echo "------  ----- ----- -------  -------"
 foreach month ( $months )
-  set count=`hgsql -N -h genome-centdb -e 'SELECT COUNT(*) FROM namedSessionDb \
+  set count=`hgsql -N -h $sqlrr -e 'SELECT COUNT(*) FROM namedSessionDb \
     WHERE firstUse like "'$month%'"' hgcentral`
-  set users=`hgsql -N -h genome-centdb -e 'SELECT COUNT(DISTINCT(userName)) \
+  set users=`hgsql -N -h $sqlrr -e 'SELECT COUNT(DISTINCT(userName)) \
     FROM namedSessionDb WHERE firstUse like "'$month%'"' hgcentral`
-  set shared=`hgsql -N -h genome-centdb -e 'SELECT COUNT(*) FROM namedSessionDb \
+  set shared=`hgsql -N -h $sqlrr -e 'SELECT COUNT(*) FROM namedSessionDb \
     WHERE firstUse like "'$month%'" AND shared = 1' hgcentral`
-  set reuse=`hgsql -N -h genome-centdb -e 'SELECT firstUse, lastUse FROM namedSessionDb \
+  set reuse=`hgsql -N -h $sqlrr -e 'SELECT firstUse, lastUse FROM namedSessionDb \
     WHERE firstUse like "'$month%'"' hgcentral \
     |  awk '$1 != $3 {print $1, $3}'  | wc -l`
   echo $month $count $users $shared $reuse  \
     | awk '{printf ("%7s %4s %5s %4s %2d%% %4s %2d%%\n", \
@@ -60,9 +60,9 @@
 echo "------- ----- ----- -------  -------"
 echo "total " $countTot $userTot $shareTot $reuseTot  \
   | awk '{printf ("%7s %4s %5s %4s %2d%% %4s %2d%%\n", \
   $1, $2, $3, $4, $4/$2*100, $5, $5/$2*100)}'
-set uniq=`hgsql -N -h genome-centdb -e 'SELECT COUNT(DISTINCT(userName)) \
+set uniq=`hgsql -N -h $sqlrr -e 'SELECT COUNT(DISTINCT(userName)) \
   FROM namedSessionDb' hgcentral`
 echo "uniq " "-" "$uniq" \
   | awk '{printf ("%7s %4s %5s \n", $1, $2, $3)}'
 echo
@@ -70,20 +70,20 @@
 # see how often people make more than one session:
 echo "how many people had more than one session?"
 echo " people sessions"
 echo " ------ --------"
-hgsql -N -h genome-centdb -e 'SELECT DISTINCT(userName), COUNT(*) as number \
+hgsql -N -h $sqlrr -e 'SELECT DISTINCT(userName), COUNT(*) as number \
   FROM namedSessionDb GROUP BY userName ORDER BY number' hgcentral \
   | awk '{print $2}' | sort -n | uniq -c
 echo
 
 echo "how often are sessions reaccessed?"
-hgsql -t -h genome-centdb -e 'SELECT DISTINCT(useCount), COUNT(*) as sessions \
+hgsql -t -h $sqlrr -e 'SELECT DISTINCT(useCount), COUNT(*) as sessions \
   FROM namedSessionDb GROUP BY useCount ORDER BY useCount' hgcentral 
 echo
 
 echo "most used:"
-hgsql -t -h genome-centdb -e 'SELECT userName, sessionName, firstUse, \
+hgsql -t -h $sqlrr -e 'SELECT userName, sessionName, firstUse, \
   lastUse, useCount FROM namedSessionDb ORDER BY useCount DESC LIMIT 4' hgcentral
 echo
 
 exit 0