analysis/SimpleDBTrackingSubsystemChecker/generate_summary_table.sh

0001 #!/bin/bash
0002
0003 # Define files
0004 ALL_RUNS_FILE="all_runs.txt"
0005 TRANSFERRED_FILE="transferred_runs.txt"
0006 CLUSTER_FILE="trkr_cluster_summary.txt"
0007
0008 # All 12 classification files (assumed already exist)
0009 FILES=(
0010   "tpc_fully_finished.txt"
0011   "tpc_segment0_finished.txt"
0012   "tpc_still_running.txt"
0013   "mvtx_fully_finished.txt"
0014   "mvtx_segment0_finished.txt"
0015   "mvtx_still_running.txt"
0016   "intt_fully_finished.txt"
0017   "intt_segment0_finished.txt"
0018   "intt_still_running.txt"
0019   "fully_finished_global.txt"
0020   "segment0_finished_global.txt"
0021   "still_running_global.txt"
0022 )
0023
0024 # Summary
0025 echo "==================== Production Summary ===================="
0026 printf "%-30s %5s\n" "Category" "Count"
0027 echo "------------------------------------------------------------"
0028
0029 # Total available
0030 total_all=$(wc -l < "$ALL_RUNS_FILE")
0031 printf "%-30s %5d\n" "Total available runs" "$total_all"
0032
0033 # Transferred runs
0034 total_transferred=$(wc -l < "$TRANSFERRED_FILE")
0035 printf "%-30s %5d\n" "Fully transferred runs" "$total_transferred"
0036
0037 echo " "
0038 echo "------------------Event combined DSTs-----------------------"
0039 # Now for each category
0040 for file in "${FILES[@]}"; do
0041   label=$(basename "$file" .txt | sed 's/_/ /g' | sed 's/\b\(.\)/\u\1/g')  # format nicely
0042   count=$(wc -l < "$file" 2>/dev/null || echo 0)
0043   printf "%-30s %5d\n" "$label" "$count"
0044 done
0045
0046 echo " "
0047 echo "--------------------Cluster DSTs-------------------------"
0048 if [[ -f "$CLUSTER_FILE" ]]; then
0049   runs_with_finished=$(awk '$2 > 0 { count++ } END { print count+0 }' "$CLUSTER_FILE")
0050   runs_with_90_failed=$(awk '$4 > 90 { count++ } END { print count+0 }' "$CLUSTER_FILE")
0051   runs_with_50_finished=$(awk '$2 > 50 { count++ } END { print count+0 }' "$CLUSTER_FILE")
0052
0053   printf "%-30s %5d\n" "Number of runs with at least one segment finished" "$runs_with_finished"
0054   printf "%-30s %5d\n" "Number of runs with >90% failed" "$runs_with_90_failed"
0055   printf "%-30s %5d\n" "Number of runs with >50% finished" "$runs_with_50_finished"
0056 else
0057   printf "%-30s %5s\n" "TRKR_CLUSTER stats" "File missing"
0058 fi
0059
0060 echo "============================================================"
0061