dbjson.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: dbjson.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]

comp = "35t:"+comp.replace(",",":")

# timestamp format from Qizhong's example.json: 2015-02-05T20:19:59
tstart = str(row[4]).replace(" ","T")[0:19]
tstop = str(row[5]).replace(" ","T")[0:19]
# sometimes we get None as the stop time -- put in the start time 
tstop = str(tstop).replace("None",str(tstart))


print ("  \"start_time\": \""+tstart+"\",")
print ("  \"end_time\": \""+tstop+"\",")
print ("  \"lbne_data.name\": \""+runType+"\",")
print ("  \"lbne_data.detector_type\": \""+comp+"\",")
print ("  \"lbne_data.run_mode\": \""+cfg+"\"")
print ("}")

#print " "
#print "original debug output:"
#print "Run: ",run
#print "ConfigId: ",cfg
#print "Run Type: ",runType
#print "Components: ",comp
#print "Start time: ",tstart
#print "Stop time: ",tstop