Difference between revisions of "G2p mysql lib"

Revision as of 09:32, 15 August 2013

The current header file is located in /w/halla-sfs62/g2p/ryan/mysql_root and is called g2p_mysql_lib.h. This is all of course subject to change as the code evolves and reaches a more final state. Load the header in an include statement to access all of it's goodness.

The list of function calls is below (and what they do). Separation between the two HRS is done by run number, so there is just one library for both HRS. Put in the run number and it will find what you need.

NOTE: If the function returns -999 that means that the entry was null. You might want to set a flag to catch these things. Feel free to let me know which runs this happens with and I'll try and update the relevant columns.

Function Calls

Run Quality

Int_t get_my_run_quality(Int_t run_number)

Run Status

Int_t get_my_run_status(Int_t run_number)

Septa Status

Int_t get_my_septa_status(Int_t run_number)

Half Wave Plate Status and Standard Deviation

Int_t get_my_hwp_status(Int_t run_number )
Double_t get_my_hwpSTD(Int_t run_number )

T1 Prescale

Int_t get_my_ps1(Int_t run_number )

T2 Prescale

Int_t get_my_ps2(Int_t run_number )

T3 Prescale

Int_t get_my_ps3(Int_t run_number )

T4 Prescale

Int_t get_my_ps4(Int_t run_number )

T7 Prescale

Int_t get_my_ps7(Int_t run_number )

T8 Prescale

Int_t get_my_ps8(Int_t run_number )

Target Encoder Position and STD

Double_t get_my_target_encoder(Int_t run_number )
Double_t get_my_target_std(Int_t run_number )

Q1 Momentum and STD

Double_t get_my_Q1p(Int_t run_number )
Double_t get_my_Q1pSTD(Int_t run_number )

Q2 Momentum and STD

Double_t get_my_Q2p(Int_t run_number )
Double_t get_my_Q2pSTD(Int_t run_number )

Dipole Momentum and STD

Double_t get_my_D1p(Int_t run_number )
Double_t get_my_D1pSTD(Int_t run_number )

Q3 Momentum and STD

Double_t get_my_Q3p(Int_t run_number )
Double_t get_my_Q3pSTD(Int_t run_number )

Septa Current and STD

Double_t get_my_septa_current(Int_t run_number )
Double_t get_my_septa_currentSTD(Int_t run_number )

Beam Energy and STD

Double_t get_my_beam_energy(Int_t run_number )
Double_t get_my_beam_energySTD(Int_t run_number )

Trigger Efficiency

Double_t get_my_trigger_efficiency(Int_t run_number )

Deadtime of Main Trigger

Double_t get_my_deadtime(Int_t run_number )

Cerenkov Cut

Double_t get_my_cercut(Int_t run_number )

Pion Rejector/Shower First Layer Cut

Double_t get_my_pr1cut(Int_t run_number)

Pion Rejectors/Shower Sum Cut

Double_t get_my_sumcut(Int_t run_number)

Beam Polarization

Double_t get_my_beampol(Int_t run_number )

Beam Polarization Systematic Error

Double_t get_my_beampolsys(Int_t run_number)

Beam Polarization Statistical Error

Double_t get_my_beampolstat(Int_t run_number)

Beam Bleedthrough

Double_t get_my_bleedthrough(Int_t run_number)

One Track Probability

Double_t get_my_onetrackeff(Int_t run_number)

All Good Track Probability

Double_t get_my_alltrackeff(Int_t run_number)

All Good Track Probability Low

Double_t get_my_alltrackeffl(Int_t run_number)

All Good Track Probability High

Double_t get_my_alltrackeffh(Int_t run_number)

Target Polarization

Double_t get_my_targetpol(Int_t run_number)

Target Polarization Uncertainty

Double_t get_my_targetpole(Int_t run_number)

Deadtime Positive Helicity

Double_t get_my_dtplus(Int_t run_number)

Deadtime Negative Helicity

Double_t get_my_dtminus(Int_t run_number)

Livetime Asymmetry in PPM

Double_t get_my_ltasym(Int_t run_number)

Target Field Strength

Double_t get_my_target_fieldInt_t run_number)

Target Orientation

 Int_t get_my_target_orientation(Int_t run_number)

Expert Comment

TString get_my_expert_comment(Int_t run_number)

Run Start Time

TDatime get_my_run_start_time(Int_t run_number )

Run Stop Time

TDatime get_my_run_stop_time(Int_t run_number )

Last time run information was edited in mysql

TDatime get_my_entry_time(Int_t run_number )