File indexing completed on 2025-08-03 08:15:33
0001
0002
0003 SQLFILE="CheckProductionEventCombine.sql"
0004 RUNLIST="transferred_runs.txt"
0005
0006 if [[ ! -f $SQLFILE ]] || [[ ! -f $RUNLIST ]]; then
0007 echo "Missing SQL file or transferred_runs.txt"
0008 exit 1
0009 fi
0010
0011 psql -h sphnxproddbmaster.sdcc.bnl.gov -d Production -U argouser <<EOF
0012 \echo Creating transferred_runs table
0013 CREATE TEMP TABLE transferred_runs (run int);
0014 \COPY transferred_runs FROM '$RUNLIST'
0015
0016 \echo Running classification SQL
0017 \i $SQLFILE
0018
0019 -- Output 12 result files
0020 \echo Writing TPC results...
0021
0022 \COPY (SELECT run FROM tpc_fully_finished ORDER BY run DESC) TO 'tpc_fully_finished.txt'
0023 \COPY (SELECT run FROM tpc_segment0_finished ORDER BY run DESC) TO 'tpc_segment0_finished.txt'
0024 \COPY (SELECT run FROM tpc_still_running ORDER BY run DESC) TO 'tpc_still_running.txt'
0025
0026 \echo Writing MVTX results...
0027 \COPY (SELECT run FROM mvtx_fully_finished ORDER BY run DESC) TO 'mvtx_fully_finished.txt'
0028 \COPY (SELECT run FROM mvtx_segment0_finished ORDER BY run DESC) TO 'mvtx_segment0_finished.txt'
0029 \COPY (SELECT run FROM mvtx_still_running ORDER BY run DESC) TO 'mvtx_still_running.txt'
0030
0031 \echo Writing INTT results...
0032 \COPY (SELECT run FROM intt_fully_finished ORDER BY run DESC) TO 'intt_fully_finished.txt'
0033 \COPY (SELECT run FROM intt_segment0_finished ORDER BY run DESC) TO 'intt_segment0_finished.txt'
0034 \COPY (SELECT run FROM intt_still_running ORDER BY run DESC) TO 'intt_still_running.txt'
0035
0036 \echo Writing GLOBAL results...
0037 \COPY (SELECT run FROM fully_finished_global ORDER BY run DESC) TO 'fully_finished_global.txt'
0038 \COPY (SELECT run FROM segment0_finished_global ORDER BY run DESC) TO 'segment0_finished_global.txt'
0039 \COPY (SELECT run FROM still_running_global ORDER BY run DESC) TO 'still_running_global.txt'
0040
0041 EOF
