src/utils/qa/comparePublic.csh 1.2

Index: src/utils/qa/comparePublic.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/comparePublic.csh,v
retrieving revision 1.1
retrieving revision 1.2
diff -b -B -U 4 -r1.1 -r1.2
--- src/utils/qa/comparePublic.csh	10 Mar 2010 00:35:33 -0000	1.1
+++ src/utils/qa/comparePublic.csh	11 Mar 2010 03:52:16 -0000	1.2
@@ -37,9 +37,11 @@
 
 
 #  get files of tables and compare: 
 # beta public:
-hgsql -N -h $sqlbeta -e "SELECT tableName $field2 FROM trackDb_public" $db | sort  > $db.public
+hgsql -N -h $sqlbeta -e "SELECT tableName $field2 FROM trackDb_public" $db | sort  > $db.public1
+cp $db.public1 $db.public2
+hgsql -N -h $sqlbeta -e "SELECT tableName $field2 FROM trackDb" $db | sort  > $db.beta
 
 # build url for RR TB query:
 set url1="http://genome.ucsc.edu/cgi-bin/hgTables?db=$db"
 set url2="&hgta_database=$db"
@@ -51,9 +53,13 @@
 set url="$url1$url2$url3$url4$url5$url6"
 
 wget -q -O /dev/stdout "$url" | grep -v "#tableName" > $db.rr
 echo
-commTrio.csh $db.public $db.rr $rm
+commTrio.csh $db.public1 $db.beta $rm
+echo
+commTrio.csh $db.public2 $db.rr $rm
+
+
 
 if ( $rm == 'rm' ) then
   rm -f $db.public
   rm -f $db.rr