updateRunHistoryTables Namespace Reference

Variables
	det = sys.argv[1]
	part = sys.argv[2]
	minrun = sys.argv[3]
	conn = psycopg2.connect("dbname=nova_prod host=novadaq-far-db-01.fnal.gov user=novadaq port=5432")
	cur = conn.cursor()
string	SQL = "select run from {}.runs where run>{} and tstop is NULL and partition={} and tstart>now()-interval '7 day' order by run desc"
	rows = cur.fetchall()
bool	isFirst = True
	run = row[0]
string	cmd = "updateRunHistoryTables -d {} {}"

Variable Documentation

string updateRunHistoryTables.cmd = "updateRunHistoryTables -d {} {}"

Definition at line 41 of file updateRunHistoryTables.py.

updateRunHistoryTables.conn = psycopg2.connect("dbname=nova_prod host=novadaq-far-db-01.fnal.gov user=novadaq port=5432")

Definition at line 11 of file updateRunHistoryTables.py.

updateRunHistoryTables.cur = conn.cursor()

Definition at line 22 of file updateRunHistoryTables.py.

updateRunHistoryTables.det = sys.argv[1]

Definition at line 5 of file updateRunHistoryTables.py.

bool updateRunHistoryTables.isFirst = True

Definition at line 33 of file updateRunHistoryTables.py.

updateRunHistoryTables.minrun = sys.argv[3]

Definition at line 7 of file updateRunHistoryTables.py.

Referenced by chaninfo::BadChanList.LoadNewData().

updateRunHistoryTables.part = sys.argv[2]

Definition at line 6 of file updateRunHistoryTables.py.

updateRunHistoryTables.rows = cur.fetchall()

Definition at line 31 of file updateRunHistoryTables.py.

updateRunHistoryTables.run = row[0]

Definition at line 40 of file updateRunHistoryTables.py.

Referenced by jmshower::RecoJMShowerAna.analyze(), comi::NearlineAna.analyze(), om::OnMonProd.analyze(), slid::LIDTraining.analyze(), AnaPlotMaker(), BuildMetricsTree(), BuildMetricsTree_OnMon(), BuildOldTree(), daqqc::QualityCheck.checkRun(), CleanupPrelim(), CleanupTree(), CondenseDetCfg(), CondenseRunList(), convert(), DCMOffsetCalculator(), DDTOnMonPlotMaker(), FileNameToRunSubrun(), FindLatestDB(), GetManualSubruns(), GetPartList(), GetPartList_4DB(), GetProcessed(), GetRunInfo(), GoodRuns(), evd::HeaderDrawer.Header(), art::RangeSet.invalidChecksum(), beamlineutil::BeamlineMagneticField.MagnetCurrent(), make_cosmic_eff_table(), MakeDetCfgCSV(), MakeDQValidityCSV(), MakeDQValidityCSVND(), MakeRunList(), MakeTestStandPlots_AllRuns(), MakeTestStandPlots_NewRuns(), NewNearlinePlots(), om::OnMonProd.NewRunNumber(), om::OnMonProd.NewSubrunNumber(), OnMonAnaHistosFEB_IssueRates(), OnMonAnaHistosPIX(), OnMonPlotMaker(), plot_cosmic_eff(), PlotDB_Web(), plotTime(), om::IPC.PostResources(), evdb::PrintDialog.PrintDialog(), jmshower::NueSel.produce(), jmshower::NueSelLID.produce(), caf::CAFMaker.produce(), util::TimeFilter.ReadEventFile(), util::EventFilterNoSlice.reconfigure(), util::RunEventFilter.reconfigure(), caldp::DriftResponse.Run(), RunCalibration(), cmf::DSTToEventList.RunToPeriod(), cmf::CAFToEventList.RunToPeriod(), SamFileNameToRunSubrun(), rawdata::RawBeamlineConfig.SetBeamlineRun(), cmap::dataprov::CMap.SetCurrentRun(), calib::DriftCache.SetRun(), calib::TimingCache.SetRun(), calib::AbsCache.SetRun(), calib::AttenCache.SetRun(), dbutils::RunHistory.SetRunNumber(), nova::dbi::RunHistory.SetRunNumber(), evdb::NavState.SetTarget(), stats(), om::FEBRateAnalysis.StoreContent(), and om::Ticker.Update().

string updateRunHistoryTables.SQL = "select run from {}.runs where run>{} and tstop is NULL and partition={} and tstart>now()-interval '7 day' order by run desc"

Definition at line 24 of file updateRunHistoryTables.py.