767e3f123a734a5c0623b2e635c7cdc59e9fb61f braney Mon Mar 13 10:48:38 2023 -0700 starting on work to purge recommend track sets of all that is not relevant to the rts diff --git src/hg/utils/rts/dumpSessions src/hg/utils/rts/dumpSessions new file mode 100755 index 0000000..433b0e1 --- /dev/null +++ src/hg/utils/rts/dumpSessions @@ -0,0 +1,11 @@ +dbs="hg19 hg38" + +for db in $dbs +do + sed '/^ *#/d' ../../htdocs/inc/recTrackSets.$db.tab | tawk '{print $3}' | + while read session + do + hgsql hgcentraltest -Ne "select contents from namedSessionDb where sessionName='$session'" | tr '&' '\n' | sort > $db/$session + done +done +