src/utils/qa/igtc.csh 1.22

1.22 2009/05/19 18:51:34 ann
My preliminary attempt to clean up the 'sqlbeta' substitutions made during the last checkin. It is going to need to be tested during the next run of this script. Most of the variables were not being interpreted.
Index: src/utils/qa/igtc.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/igtc.csh,v
retrieving revision 1.21
retrieving revision 1.22
diff -b -B -U 4 -r1.21 -r1.22
--- src/utils/qa/igtc.csh	11 Apr 2009 00:37:04 -0000	1.21
+++ src/utils/qa/igtc.csh	19 May 2009 18:51:34 -0000	1.22
@@ -387,9 +387,9 @@
 end
 echo
 foreach table ( extFile seq )
   foreach mouse ( $mice )
-    echo 'hgsql -h $sqlbeta -e ' "'"CREATE TABLE $table$oldYear${oldMonth}01 \
+    echo 'hgsql -h '"$sqlbeta"' -e ' "'"CREATE TABLE $table$oldYear${oldMonth}01 \
       SELECT \* FROM $table"'" $mouse  
   end
 end
 echo
@@ -404,9 +404,9 @@
 end
 echo
 foreach table ( extFile seq )
   foreach mouse ( $mice )
-    echo 'hgsql -h $sqlbeta -e ' "'"SHOW TABLES LIKE \"$table%\" "'" \
+    echo 'hgsql -h '"$sqlbeta"' -e ' "'"SHOW TABLES LIKE \"$table%\" "'" \
       $mouse
   end
 end
 
@@ -432,9 +432,9 @@
 end
 echo
 foreach table ( extFile seq )
   foreach mouse ( $mice )
-    echo 'hgsql -h $sqlbeta -e ' \
+    echo 'hgsql -h '"$sqlbeta"' -e ' \
       "'"DROP TABLE $table$oldOldYear${oldOldMonth}01"'" \
       $mouse
   end
 end
@@ -460,13 +460,13 @@
 end
 
 echo
 foreach mouse ( $mice )
-  echo 'hgsql -h $sqlbeta -e ' "'"DELETE FROM $mouse.extFile WHERE name LIKE \
+  echo 'hgsql -h '"$sqlbeta"' -e ' "'"DELETE FROM $mouse.extFile WHERE name LIKE \
     '"'genetrap.$lastMonth.fasta'"' \' $mouse 
 end
 foreach i ( $counter )
-  echo 'hgsql -h $sqlbeta -e ' "'"DELETE FROM $mice[$i].seq WHERE extFile = \
+  echo 'hgsql -h '"$sqlbeta"' -e ' "'"DELETE FROM $mice[$i].seq WHERE extFile = \
       $extFileIdOld[$i]\' $mice[$i]
 end
 echo
 
@@ -497,9 +497,9 @@
 wc -l *devOnly | grep -v total
 echo
 echo "beta"
 foreach i ( $counter )
-  hgsql -h $sqlbeta -Ne 'SELECT COUNT(*) FROM seq \
+  hgsql -h '$sqlbeta' -Ne 'SELECT COUNT(*) FROM seq \
     WHERE extFile = "'$extFileIdOld[$i]'"' $mice[$i]
 end
 wc -l *betaOnly | grep -v total
 
@@ -509,11 +509,11 @@
 echo "Here are the commands needed to load the new rows into extFile \
   and seq tables on BETA:\n"
 
 foreach mouse ( $mice )
-  echo 'hgsql -h $sqlbeta -e ' "'"LOAD DATA LOCAL INFILE \
+  echo 'hgsql -h '"$sqlbeta"' -e ' "'"LOAD DATA LOCAL INFILE \
     '"'$mouse.seq.$update'"'     INTO TABLE seq"'"         $mouse
-  echo 'hgsql -h $sqlbeta -e ' "'"LOAD DATA LOCAL INFILE \
+  echo 'hgsql -h '"$sqlbeta"' -e ' "'"LOAD DATA LOCAL INFILE \
     '"'$mouse.extFile.$update'"' INTO TABLE extFile"'" $mouse
   echo
 end
 
@@ -554,9 +554,9 @@
   echo 'hgsql -Ne' "'" 'SELECT COUNT(*) FROM seq WHERE extFile = "'$extFileIdOld[$i]'"' \' $mice[$i]
 end
 
 foreach i ( $counter )
-  echo 'hgsql -h $sqlbeta -Ne' "'" \
+  echo 'hgsql -h '"$sqlbeta"' -Ne' "'" \
     'SELECT COUNT(*) FROM seq WHERE extFile = "'$extFileIdOld[$i]'"' \' \
     $mice[$i]
 end
 echo
@@ -565,9 +565,9 @@
 foreach i ( $counter)
   echo 'hgsql -Ne' "'" 'SELECT COUNT(*) FROM seq WHERE extFile = "'$extFileId[$i]'"' \' $mice[$i]
 end
 foreach i ( $counter)
-  echo 'hgsql -h $sqlbeta -Ne' "'" 'SELECT COUNT(*) FROM seq WHERE extFile = "'$extFileId[$i]'"' \' $mice[$i]
+  echo 'hgsql -h '"$sqlbeta"' -Ne' "'" 'SELECT COUNT(*) FROM seq WHERE extFile = "'$extFileId[$i]'"' \' $mice[$i]
 end
 echo
 echo