Difference between revisions of "SRC/CT Good Run Selection"

Latest revision as of 15:21, 19 November 2022

RCDB

The run condition parameters are stored in the Run Conditions DataBase (RCDB). It is part of the Hall D software package.
Connection to the database
- Main MySQL database: mysql://rcdb@hallddb/rcdb
- Local SQLite database: sqlite:///path.to.file.db
Different interfaces we can use.
- Python interface

import rcdb
 
db = rcdb.RCDBProvider("mysql://rcdb@hallddb/rcdb")
good_runs = db.select_runs(RCDB_QUERY, MINRUN, MAXRUN)
 
#Get the list of selected runs
for run in good_runs:
    print(run.number)
 
#Check whether one specific run is in the selected list
run = db.get_run(NUMBER)
if run not in good_runs:
    continue

- Command line interface

# Connected to the main RCDB by default
rcnd  # list all the conditions
rcnd NUMBER  # list all the condition values of one specific run
rcnd NUMBER CONDITION # return the value of some condition of one specific run

- Web interface
  - Link to the website
  - The runs can be selected with RCDB_QUERY, MINRUN and MAXRUN. But the @is_src_production alias can not be used for now. The full query needs to be filled in (See the monitoring runs section below).
  - The "Conditions" tab lists all the conditions available in RCDB.
- Job submission
  - Run python launch script with the command 'python launch.py MINRUN MAXRUN'
  - Specify the RCDB_QUERY in the configuration file (.config)
More detailed documentation can be found here: wiki, GitHub
Contact Sean Dobbs if the information needs to be edited in RCDB.

All runs

90001 to 90662 in Run Period 2021-11
Run sheet filled by shift takers

Monitoring runs

Runs included in the monitoring and reconstruction launches. These runs are calibrated. Relatively loose selection is used so that some test runs and junk runs are also included.
RCDB query: "@is_src_production" (alias of "daq_run=='PHYSICS_SRC' and beam_current > 2. and event_count > 5000000 and solenoid_current > 100 and collimator_diameter != 'Blocking'")
List of monitoring runs

Approved runs

Runs included in the analysis launches. Approved to be used in analysis after checking the calibration and data quality
RCDB query: "@is_src_production and @status_approved"
List of approved runs
List of excluded runs

Selection queries

Target used
- Liquid deuterium: "target_type=='FULL & Ready Deuterium'"
- Liquid He-4: "target_type=='FULL & Ready Helium'"
- Multi-foil C-12: "target_type=='FULL & Ready Carbon'"
- Empty target: "(target_type=='EMPTY & Ready' or target_type=='OFF')"

Run conditions
- Raw mode: "run_config=='FCAL_BCAL_PS_SRC_m10.conf'"
- Compton trigger: "run_config=='CCAL_FCAL_PS_m9.conf'"
- Low intensity: "run_config == 'FCAL_BCAL_PS_SRC_m9.conf' and beam_on_current < 55.0"
- Normal production: "run_config == 'FCAL_BCAL_PS_SRC_m9.conf' and beam_on_current > 55.0"

Photon polarization
- Amorphous: "polarization_angle == -1.0"
- Diamond: "polarization_angle >= 0.0"
  - 0/90 PARA: "polarization_angle == 0.0"
  - 0/90 PERP: "polarization_angle == 90.0"
  - 45/135 PARA: "polarization_angle == 135.0"
  - 45/135 PERP: "polarization_angle == 45.0"

@@ Line 1: / Line 1: @@
 ==RCDB==
-*Contact Sean Dobbs if we really need to edit the information in RCDB
+*The run condition parameters are stored in the Run Conditions DataBase (RCDB). It is part of the Hall D software package.
+*Connection to the database
+**Main MySQL database: mysql://rcdb@hallddb/rcdb
+**Local SQLite database: sqlite:///path.to.file.db
+*Different interfaces we can use.
+**Python interface
+<syntaxhighlight lang="python">
+import rcdb
+db = rcdb.RCDBProvider("mysql://rcdb@hallddb/rcdb")
+good_runs = db.select_runs(RCDB_QUERY, MINRUN, MAXRUN)
+#Get the list of selected runs
+for run in good_runs:
+    print(run.number)
+#Check whether one specific run is in the selected list
+run = db.get_run(NUMBER)
+if run not in good_runs:
+    continue
+</syntaxhighlight>
+**Command line interface
+<syntaxhighlight lang="bash">
+# Connected to the main RCDB by default
+rcnd  # list all the conditions
+rcnd NUMBER  # list all the condition values of one specific run
+rcnd NUMBER CONDITION # return the value of some condition of one specific run
+</syntaxhighlight>
+**Web interface
+***[https://halldweb.jlab.org/rcdb/ Link to the website]
+***The runs can be selected with RCDB_QUERY, MINRUN and MAXRUN. But the @is_src_production alias can not be used for now. The full query needs to be filled in (See the monitoring runs section below).
+***The "Conditions" tab lists all the conditions available in RCDB.
+**Job submission
+***Run [https://github.com/JeffersonLab/hd_utilities/blob/master/launch_scripts/launch/launch.py python launch script] with the command 'python launch.py MINRUN MAXRUN'
+***Specify the RCDB_QUERY in the configuration file (.config)
+*More detailed documentation can be found here: [https://halldweb.jlab.org/wiki/index.php/RCDB_conditions_python#Command_line_tools wiki], [https://github.com/JeffersonLab/rcdb/wiki GitHub]
+*Contact Sean Dobbs if the information needs to be edited in RCDB.
 ==All runs==
-*90001 to 90662
+*90001 to 90662 in Run Period 2021-11
+*[https://docs.google.com/spreadsheets/d/19QWkjAPEiSd2scvAllYvgvB_puxKjFiSlh3z6EBfFck/edit?usp=sharing Run sheet filled by shift takers]
 ==Monitoring runs==
-*Runs that are used in the monitoring launches. These runs are calibrated. Relatively loose selection so that some test runs and junk runs are also included.
+*Runs included in the monitoring and reconstruction launches. These runs are calibrated. Relatively loose selection is used so that some test runs and junk runs are also included.
-*RCDB query: "@is_src_production" (alias of "daq_run=='PHYSICS_SRC' and beam_current > 10. and event_count > 5000000 and solenoid_current > 100 and collimator_diameter != 'Blocking'")
+*RCDB query: "@is_src_production" (alias of "daq_run=='PHYSICS_SRC' and beam_current > 2. and event_count > 5000000 and solenoid_current > 100 and collimator_diameter != 'Blocking'")
-*[[SRC/CT monitoring runs | List of runs]]
+*[[SRC/CT monitoring runs | List of monitoring runs]]
-*[https://docs.google.com/spreadsheets/d/1M3v9vpBmoHbHk0gjJHNsgAjq5bQL2UxcaRrUPeM4EaQ/edit#gid=1665922131 Quality check spreadsheet: monitoring ver 05]
-*[https://docs.google.com/spreadsheets/d/1MA6vGl7-T3JHgxGfynUNVY1yVxVIn1RXKbEaVbNsWQ4/edit?usp=sharing Quality check spreadsheet: monitoring ver 06]
 ==Approved runs==
-*Runs that are used in the analysis launches. Approved to be used in analysis after checking the calibration and data quality
+*Runs included in the analysis launches. Approved to be used in analysis after checking the calibration and data quality
 *RCDB query: "@is_src_production and @status_approved"
-*[[SRC/CT approved runs | List of runs]]
+*[[SRC/CT approved runs | List of approved runs]]
-*[[SRC/CT excluded runs | List of excluded runs and the reasons]]
+*[[SRC/CT excluded runs | List of excluded runs]]
+==Selection queries==
+*Target used
+**Liquid deuterium: "target_type=='FULL & Ready Deuterium'"
+**Liquid He-4: "target_type=='FULL & Ready Helium'"
+**Multi-foil C-12: "target_type=='FULL & Ready Carbon'"
+**Empty target: "(target_type=='EMPTY & Ready' or target_type=='OFF')"
+*Run conditions
+**Raw mode: "run_config=='FCAL_BCAL_PS_SRC_m10.conf'"
+**Compton trigger: "run_config=='CCAL_FCAL_PS_m9.conf'"
+**Low intensity: "run_config == 'FCAL_BCAL_PS_SRC_m9.conf' and beam_on_current < 55.0"
+**Normal production: "run_config == 'FCAL_BCAL_PS_SRC_m9.conf' and beam_on_current > 55.0"
-TBA: calibration or production
+*Photon polarization
-target
+**Amorphous: "polarization_angle == -1.0"
-polarization
+**Diamond: "polarization_angle >= 0.0"
+***0/90 PARA: "polarization_angle == 0.0"
+***0/90 PERP: "polarization_angle == 90.0"
+***45/135 PARA: "polarization_angle == 135.0"
+***45/135 PERP: "polarization_angle == 45.0"

Difference between revisions of "SRC/CT Good Run Selection"

Latest revision as of 15:21, 19 November 2022

Contents

RCDB

All runs

Monitoring runs

Approved runs

Selection queries

Navigation menu

Views

Personal tools

Navigation

Search

Tools