aboutsummaryrefslogtreecommitdiff
path: root/utils/cat-grid-jobs
blob: 8cbdac366a8c5369f91567d5bf2bd892bfc2cfc7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
#!/usr/bin/env python
# Copyright (c) 2019, Anthony Latorre <tlatorre at uchicago>
#
# This program is free software: you can redistribute it and/or modify it
# under the terms of the GNU General Public License as published by the Free
# Software Foundation, either version 3 of the License, or (at your option)
# any later version.
#
# This program is distributed in the hope that it will be useful, but WITHOUT
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
# FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
# more details.
#
# You should have received a copy of the GNU General Public License along with
# this program. If not, see <https://www.gnu.org/licenses/>.
"""
Script to combine the fit results from jobs submitted to the grid. It's
expected to be run from a cron job:

    PATH=/usr/bin:$HOME/local/bin
    SDDM_DATA=$HOME/sddm/src
    DQXX_DIR=$HOME/dqxx

    0 * * * * module load hdf5; module load py-h5py; module load zlib; cat-grid-jobs --loglevel debug --logfile cat.log --output-dir $HOME/fit_results

The script will loop through all entries in the database and try to combine the
fit results into a single output file.
"""

from __future__ import print_function, division
import os
import sys
import numpy as np
from datetime import datetime
import h5py
from os.path import join, split
from subprocess import check_call
from sddm import splitext, which
from sddm.logger import Logger
import subprocess

log = Logger()

def cat_grid_jobs(conn, output_dir, zdab_dir=None):
    zdab_cat = which("zdab-cat")

    if zdab_cat is None:
        log.warn("couldn't find zdab-cat in path!",file=sys.stderr)
        return

    c = conn.cursor()

    results = c.execute('SELECT filename, uuid FROM state').fetchall()

    unique_results = set(results)

    for filename, uuid in unique_results:
        head, tail = split(filename)
        root, ext = splitext(tail)

        # First, find all hdf5 result files
        fit_results = c.execute("SELECT submit_file FROM state WHERE state = 'SUCCESS' AND filename = ? AND uuid = ?", (filename, uuid)).fetchall()
        fit_results = [fit_result_filename[0] for fit_result_filename in fit_results]
        fit_results = ['%s.hdf5' % splitext(fit_result_filename)[0] for fit_result_filename in fit_results]

        if len(fit_results) == 0:
            log.verbose("No fit results found for %s (%s)" % (tail, uuid))
            continue

        output = join(output_dir,"%s_%s_fit_results.hdf5" % (root,uuid))

        if 'reduced' in root:
            directories = [head]
            if zdab_dir is not None:
                directories += [zdab_dir]
            for directory in directories:
                for extension in [ext, '.zdab', '.zdab.gz']:
                    # Use the reprocessed version of the file if possible
                    reprocessed_filename = join(directory,root.replace('reduced','reprocessed')) + extension

                    if os.path.exists(reprocessed_filename):
                        log.verbose("Found reprocessed file '%s'. Using that instead of '%s'" % (reprocessed_filename,tail))
                        filename = reprocessed_filename

        if os.path.exists(output):
            total_fits = 0
            for fit_result_filename in fit_results:
                fit_result_head, fit_result_tail = split(fit_result_filename)

                if not os.path.exists(fit_result_filename):
                    log.warn("File '%s' does not exist!" % fit_result_filename)
                    continue

                with h5py.File(fit_result_filename,'r') as f:
                    if 'git_sha1' not in f.attrs:
                        log.warn("No git sha1 found for '%s'. Skipping..." % fit_result_filename)
                        continue
                    total_fits += f['fits'].shape[0]

            with h5py.File(output,'r') as fout:
                if 'reprocessed' in filename and 'reprocessed' not in fout.attrs:
                    pass
                elif 'fits' in fout and fout['fits'].shape[0] >= total_fits:
                    log.verbose("skipping %s because there are already %i fit results" % (tail,total_fits))
                    continue

        if not os.path.exists(filename):
            log.warn("File '%s' does not exist!" % filename)
            continue

        # First we get the full event list along with the data cleaning word, FTP
        # position, FTK, and RSP energy from the original zdab and then add the fit
        # results.
        #
        # Note: We send stderr to /dev/null since there can be a lot of warnings
        # about PMT types and fit results
        with open(os.devnull, 'w') as f:
            log.debug("zdab-cat %s -o %s" % (filename,output))
            try:
                check_call([zdab_cat,filename,"-o",output],stderr=f)
            except subprocess.CalledProcessError as e:
                log.warn(str(e))
                continue

        total_events = 0
        events_with_fit = 0
        total_fits = 0

        with h5py.File(output,"a") as fout:
            # Mark the file as being reprocessed so we know in the future if we
            # already used the reprocessed version instead of the reduced
            # version
            if 'reprocessed' in filename:
                fout.attrs['reprocessed'] = 1

            fits = []

            total_events = fout['ev'].shape[0]
            for fit_result_filename in fit_results:
                fit_result_head, fit_result_tail = split(fit_result_filename)

                if not os.path.exists(fit_result_filename):
                    log.warn("File '%s' does not exist!" % fit_result_filename)
                    continue

                with h5py.File(fit_result_filename) as f:
                    if 'git_sha1' not in f.attrs:
                        log.warn("No git sha1 found for %s. Skipping..." % fit_result_tail)
                        continue

                    # Check to see if the git sha1 match
                    if fout.attrs['git_sha1'] != f.attrs['git_sha1']:
                        log.debug("git_sha1 is %s for current version but %s for %s" % (fout.attrs['git_sha1'],f.attrs['git_sha1'],fit_result_tail))

                    fits.append(f['fits'][:])

                    events_with_fit += len(np.unique(fits[-1][['run','gtid']]))
                    total_fits += fits[-1].shape[0]

            if len(fits):
                del fout['fits']
                fout.create_dataset('fits',data=np.concatenate(fits))

        log.notice("%s (%s): added %i fit results from %i events to a total of %i events" % (tail, uuid, total_fits, events_with_fit, total_events))

if __name__ == '__main__':
    import argparse
    import sqlite3

    parser = argparse.ArgumentParser("concatenate fit results from grid jobs into a single file")
    parser.add_argument("--db", type=str, help="database file", default=None)
    parser.add_argument('--loglevel',
                        help="logging level (debug, verbose, notice, warning)",
                        default='notice')
    parser.add_argument('--logfile', default=None,
                        help="filename for log file")
    parser.add_argument('--output-dir', default=None,
                        help="output directory for fit results")
    parser.add_argument('--zdab-dir', default=None,
                        help="extra directory to search for zdab files")
    args = parser.parse_args()

    log.set_verbosity(args.loglevel)

    if args.logfile:
        log.set_logfile(args.logfile)

    home = os.path.expanduser("~")

    if args.db is None:
        args.db = join(home,'state.db')

    if args.output_dir is None:
        args.output_dir = home
    else:
        if not os.path.exists(args.output_dir):
            log.debug("mkdir %s" % args.output_dir)
            os.mkdir(args.output_dir)

    conn = sqlite3.connect(args.db)

    cat_grid_jobs(conn, args.output_dir, args.zdab_dir)
    conn.close()