runsumdbquery.py

Go to the documentation of this file.

#!/usr/bin/env python

from __future__ import print_function

import sys
import os
import psycopg2
import string
#import re

if (len(sys.argv) != 2):
    print ("Usage: getDUNE35tRunInfo.py [run number]")
    exit(1)

run=sys.argv[1]

try:
    conn = psycopg2.connect("dbname=lbne35t_prod host=ifdbrep.fnal.gov port=5440 user=lbne_reader password=dune35t")
except:
    print ("I am unable to connect to the database")
    exit(0)
    
cur = conn.cursor()

SQL = "select * from dune35t.run_summary where run="+run

cur.execute(SQL)
row = cur.fetchone()

run = row[0]
cfg = row[1]
runType = row[2]
comp = row[3]
tstart = row[4]
tstop = row[5]
# sometimes we get None as the stop time -- put in the start time
#tstop = str(tstop).replace("None",str(tstart))

print ("Run: ",run)
print ("ConfigId: ",cfg)
print ("Run Type: ",runType)
print ("Components: ",comp)
print ("Start time: ",tstart)
print ("Stop time: ",tstop)