Home » Blogs » witt's blog

dB Initialization (TPC) for Run 15

Updated on Mon, 2015-01-12 11:49. Originally created by witt on 2015-01-12 11:47.

The following commands were used to initialize the TPC dB tables for Run 15.  The table_upload.C script can be found in /star/u/witt/TPC/DbTableInitialization/Run15. 
The first and second timestamp arguments are the source and destination beginTime respectively.

For simulations (beginTime between 12-10 and 12-20 each year)

root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcAdcCorrectionB","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcAvgCurrent","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcCurrentCorrection","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcDriftDistOxygen","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcLengthCorrectionB","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcRowQ","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcSecRowB","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcSpaceCharge","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcZCorrectionB","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcZDC","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcAcCharge","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcAnodeHVavg","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcAvCurrent","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcDriftVelocity","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcGain","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcGas","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcGasTemperature","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcGridLeak","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcHitErrors","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcISTimeOffsets","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcOSTimeOffsets","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcOmegaTau","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcPadrowT0","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcPressureB","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcSlewing","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcStatus","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'

root4star -b -q 'table_reupload.C("Geometry_tpc","TpcInnerSectorPosition","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","TpcOuterSectorPosition","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","TpcSuperSectorPosition","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","tpcFieldCage","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","tpcFieldCageShort","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","tpcGlobalPosition","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","tpcHVPlanes","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","tpcSectorPosition","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'

root4star -b -q 'table_reupload.C("Calibrations_tracker","tpcInnerHitError","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tracker","tpcMaxHits","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tracker","tpcOuterHitError","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'

root4star -b -q 'table_reupload.C("Calibrations_rich","spaceChargeCorR2","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'

root4star -b -q 'table_reupload.C("RunLog_onl","tpcRDOMasks","ofl","2013-12-10 00:01:00","2014-12-10 00:01:00")'

For real data (beginTime after 12-20 each year)

root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcAdcCorrectionB","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcAvgCurrent","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcCurrentCorrection","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcDriftDistCorr","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcDriftDistOxygen","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcLengthCorrectionB","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcRowQ","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcSecRowB","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcTimeGain","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcZCorrectionB","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","TpcZDC","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcAvCurrent","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcDriftVelocity","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcEffectiveGeom","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcElectronics","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcFieldCage","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcGridLeak","ofl","2011-12-30 00:00:00","2014-12-20 00:01:01")' # last pp200 from run 12
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcHighVoltages","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcHitErrors","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcOmegaTau","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcPadrowT0","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcSlewing","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcSlowControlSim","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcStatus","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcT0","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tpc","tpcTimeNorms","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'

root4star -b -q 'table_reupload.C("Geometry_tpc","TpcInnerSectorPosition","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","TpcOuterSectorPosition","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","TpcSuperSectorPosition","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","tpcFieldCage","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","tpcFieldCageShort","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","tpcGlobalPosition","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Geometry_tpc","tpcHVPlanes","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'

root4star -b -q 'table_reupload.C("Calibrations_tracker","tpcInnerHitError","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'
root4star -b -q 'table_reupload.C("Calibrations_tracker","tpcOuterHitError","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'

root4star -b -q 'table_reupload.C("Calibrations_rich","spaceChargeCorR2","ofl","2011-12-30 00:00:00","2014-12-20 00:01:01")'  # last pp200 from run 12

root4star -b -q 'table_reupload.C("RunLog_onl","tpcRDOMasks","ofl","2013-12-20 00:01:00","2014-12-20 00:01:00")'

»