806ffeed2a266ddda82a124a90ce365095d66bd2
braney
  Thu Sep 15 11:02:44 2022 -0700
oops, broke validateOmim.sh with an earlier change

diff --git src/hg/utils/otto/omim/validateOmim.sh src/hg/utils/otto/omim/validateOmim.sh
index eb2781e..e380c05 100755
--- src/hg/utils/otto/omim/validateOmim.sh
+++ src/hg/utils/otto/omim/validateOmim.sh
@@ -1,25 +1,28 @@
 #!/bin/sh -e
 
 db=$1
 tooMuch=0.1000   # how much change (either gain or loss) is too much
 
 for i in `cat ../../omim.tables`
 do 
     if test $i == "omimGeneMap" 
     then
 	fields="month,day,year,location,geneSymbol,geneStatus,title1,title2,omimId,method,comment1,comment2,disorders1,disorders2,disorders3,mouseCorrelate,reference"
+    elif test $i == "omimGeneMap2" 
+    then
+	fields="location,compCtyoLoc,omimId,geneSymbol,geneName,approvedSymbol,entrez,comments,phenotypes,mmGeneId"
     else
 	fields='*'
     fi
     echo "select $fields from $i" |  hgsql $db | tail -n +2 | sort > $i.out
     f=$i"New"
     echo "select $fields from $f" |hgsql $db | tail -n +2 | sort > $f.out
     oldCount=`cat $i.out | wc -l`
     newCount=`cat $f.out | wc -l`
     common=`join -t '\001'  $i.out $f.out | wc -l`
     onlyOld=`join -t '\001' -v 1 $i.out $f.out | wc -l`
     onlyNew=`join -t '\001' -v 2 $i.out $f.out | wc -l`
     echo $i $newCount "-" $onlyNew "=" $common "=" $oldCount "-" $onlyOld  
     rm $i.out $f.out
 done > newOmim.stats