UE_in_pp/macro/getlist.sh

0001 #!/bin/bash
0002
0003 DST_CALO_LIST="run21_jet10_dst_calo_cluster.list"
0004 DST_TRUTH_LIST="run21_jet10_g4hits.list"
0005 DST_GLOBAL_LIST="run21_jet10_dst_mbd_epd.list"
0006 DST_TRUTH_JET_LIST="run21_jet10_dst_truth_jet.list"
0007 DST_TRACKS_LIST="run21_jet10_dst_tracks.list"
0008
0009 # Run SQL queries and redirect results to files
0010 psql -h sphnxdbmaster.sdcc.bnl.gov -d FileCatalog -t -A -q -F" " --command "SELECT filename FROM datasets WHERE runnumber = 21 AND dsttype = 'DST_CALO_CLUSTER' AND filename LIKE '%pythia8_Jet10-0000000021%' ORDER BY segment;" > "$DST_CALO_LIST"
0011 psql -h sphnxdbmaster.sdcc.bnl.gov -d FileCatalog -t -A -q -F" " --command "SELECT filename FROM datasets WHERE runnumber = 21 AND dsttype = 'G4Hits' AND filename LIKE '%pythia8_Jet10-0000000021%' ORDER BY segment;" > "$DST_TRUTH_LIST"
0012 psql -h sphnxdbmaster.sdcc.bnl.gov -d FileCatalog -t -A -q -F" " --command "SELECT filename FROM datasets WHERE runnumber = 21 AND dsttype = 'DST_MBD_EPD' AND filename LIKE '%pythia8_Jet10-0000000021%' ORDER BY segment;" > "$DST_GLOBAL_LIST"
0013 psql -h sphnxdbmaster.sdcc.bnl.gov -d FileCatalog -t -A -q -F" " --command "SELECT filename FROM datasets WHERE runnumber = 21 AND dsttype = 'DST_TRUTH_JET' AND filename LIKE '%pythia8_Jet10-0000000021%' ORDER BY segment;" > "$DST_TRUTH_JET_LIST"
0014 #psql -h sphnxdbmaster.sdcc.bnl.gov -d FileCatalog -t -A -q -F" " --command "SELECT filename FROM datasets WHERE runnumber = 22 AND dsttype = 'DST_TRACKS' AND filename LIKE '%pythia8_Jet50-0000000022%' ORDER BY segment;" > "$DST_TRACKS_LIST"