c3fcdfd3c6db22e6c6ff0f6273a38eaf9b3fd4d6 rhead Thu Jan 17 11:15:12 2013 -0800 Removed references gdbPdb, as this table is no longer in use (RM #9803.) diff --git src/utils/qa/checkMetaData.csh src/utils/qa/checkMetaData.csh index d4e91f3..b055b3e 100755 --- src/utils/qa/checkMetaData.csh +++ src/utils/qa/checkMetaData.csh @@ -1,30 +1,30 @@ #!/bin/tcsh source `which qaConfig.csh` ############################################### # # 08-25-04 # Robert Kuhn # # checks the metadata for a new assembly. # ############################################### set db="" set dbTrunc="" -set metatables="dbDb blatServers defaultDb gdbPdb genomeClade liftOverChain" +set metatables="dbDb blatServers defaultDb genomeClade liftOverChain" if ( $#argv < 1 || $#argv > 3 ) then # no command line args echo echo " checks the metadata for a new assembly." echo echo " usage: database [machine1 machine2]" echo ' (defaults to dev and beta, or use "RR".)' echo exit else set db=$argv[1] set dbTrunc=`echo $db | sed -e "s/[0-9]*//"` endif @@ -153,39 +153,30 @@ hgsql $host1 -Ne 'SELECT * FROM blatServers WHERE db = "'$db'"' $centdb1 | sort \ > $metatable.$db.$out1 hgsql $host2 -Ne 'SELECT * FROM blatServers WHERE db = "'$db'"' $centdb2 | sort \ > $metatable.$db.$out2 # check defaultDb set metatable="defaultDb" hgsql $host1 -Ne 'SELECT * FROM defaultDb WHERE name LIKE "'$dbTrunc'%"' \ $centdb1 > $metatable.$db.$out1 hgsql $host2 -Ne 'SELECT * FROM defaultDb WHERE name LIKE "'$dbTrunc'%"' \ $centdb2 > $metatable.$db.$out2 -# check gdbPdb -set metatable="gdbPdb" - -hgsql $host1 -Ne 'SELECT * FROM gdbPdb WHERE genomeDb = "'$db'"' $centdb1 \ - > $metatable.$db.$out1 -hgsql $host2 -Ne 'SELECT * FROM gdbPdb WHERE genomeDb = "'$db'"' $centdb2 \ - > $metatable.$db.$out2 - - # check liftOverChain set metatable="liftOverChain" hgsql $host1 -Ne 'SELECT * FROM liftOverChain WHERE fromDb = "'$db'" \ or toDb = "'$db'"' $centdb1 | sort \ > $metatable.$db.$out1 hgsql $host2 -Ne 'SELECT * FROM liftOverChain WHERE fromDb = "'$db'" \ or toDb = "'$db'"' $centdb2 | sort \ > $metatable.$db.$out2 # check genomeClade # get genome name for the assembly to query genomeClade table. set genome=`hgsql -N -e 'SELECT genome FROM dbDb WHERE name = "'$db'"' \