13c0977119e845ccce3568a58a8c5d0c22093565 braney Thu Apr 6 14:31:15 2023 -0700 spme tests for making a tool that scrubs recommended track sets refs #28525 diff --git src/hg/utils/rts/dumpSessions src/hg/utils/rts/dumpSessions index 9e1994f..2b471d0 100755 --- src/hg/utils/rts/dumpSessions +++ src/hg/utils/rts/dumpSessions @@ -1,11 +1,12 @@ dbs="hg19 hg38" +namedSessionDb=namedSessionDb 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' && userName='View'" | tr '&' '\n' | sort -u -u > $db/$session + hgsql hgcentraltest -Ne "select contents from $namedSessionDb where sessionName='$session' and userName='View'" | tr '&' '\n' | sort -u | sed '/^$/d' > $db/$session done done