|
BmnRoot
|
#include <UniRun.h>
Public Member Functions | |
| virtual | ~UniRun () |
| int | GetPeriodNumber () |
| get period number of the current run | |
| int | GetRunNumber () |
| get run number of the current run | |
| int | GetRunType () |
| get run type of the current run | |
| TDatime | GetStartDatetime () |
| get start datetime of the current run | |
| TDatime * | GetEndDatetime () |
| get end datetime of the current run | |
| TString | GetBeamParticle () |
| get beam particle of the current run | |
| TString | GetTargetParticle () |
| get target particle of the current run | |
| double * | GetEnergy () |
| get energy of the current run | |
| double * | GetFieldVoltage () |
| get field voltage of the current run | |
| int * | GetEventCount () |
| get event count of the current run | |
| int * | GetGeometryId () |
| get geometry id of the current run | |
| int | GetRunQuality () |
| get run quality of the current run | |
| int | SetPeriodNumber (int period_number) |
| set period number of the current run | |
| int | SetRunNumber (int run_number) |
| set run number of the current run | |
| int | SetRunType (int run_type) |
| set run type of the current run | |
| int | SetStartDatetime (TDatime start_datetime) |
| set start datetime of the current run | |
| int | SetEndDatetime (TDatime *end_datetime) |
| set end datetime of the current run | |
| int | SetBeamParticle (TString beam_particle) |
| set beam particle of the current run | |
| int | SetTargetParticle (TString target_particle) |
| set target particle of the current run | |
| int | SetEnergy (double *energy) |
| set energy of the current run | |
| int | SetFieldVoltage (double *field_voltage) |
| set field voltage of the current run | |
| int | SetEventCount (int *event_count) |
| set event count of the current run | |
| int | SetGeometryId (int *geometry_id) |
| set geometry id of the current run | |
| int | SetRunQuality (int run_quality) |
| set run quality of the current run | |
| void | Print () |
| print information about current run | |
| TObjArray * | GetRawFiles () |
| get array of raw files (UniRawFile*) corresponding to the run (return nullptr if an error occured) | |
| ClassDef (UniRun, 1) | |
| virtual | ~UniRun () |
| int | GetPeriodNumber () |
| get period number of the current run | |
| int | GetRunNumber () |
| get run number of the current run | |
| int | GetRunType () |
| get run type of the current run | |
| TDatime | GetStartDatetime () |
| get start datetime of the current run | |
| TDatime * | GetEndDatetime () |
| get end datetime of the current run | |
| TString | GetBeamParticle () |
| get beam particle of the current run | |
| TString | GetTargetParticle () |
| get target particle of the current run | |
| double * | GetEnergy () |
| get energy of the current run | |
| double * | GetFieldVoltage () |
| get field voltage of the current run | |
| int * | GetEventCount () |
| get event count of the current run | |
| int * | GetGeometryId () |
| get geometry id of the current run | |
| int | GetRunQuality () |
| get run quality of the current run | |
| int | SetPeriodNumber (int period_number) |
| set period number of the current run | |
| int | SetRunNumber (int run_number) |
| set run number of the current run | |
| int | SetRunType (int run_type) |
| set run type of the current run | |
| int | SetStartDatetime (TDatime start_datetime) |
| set start datetime of the current run | |
| int | SetEndDatetime (TDatime *end_datetime) |
| set end datetime of the current run | |
| int | SetBeamParticle (TString beam_particle) |
| set beam particle of the current run | |
| int | SetTargetParticle (TString target_particle) |
| set target particle of the current run | |
| int | SetEnergy (double *energy) |
| set energy of the current run | |
| int | SetFieldVoltage (double *field_voltage) |
| set field voltage of the current run | |
| int | SetEventCount (int *event_count) |
| set event count of the current run | |
| int | SetGeometryId (int *geometry_id) |
| set geometry id of the current run | |
| int | SetRunQuality (int run_quality) |
| set run quality of the current run | |
| void | Print () |
| print information about current run | |
| TObjArray * | GetRawFiles () |
| get array of raw files (UniRawFile*) corresponding to the run (return nullptr if an error occured) | |
| ClassDef (UniRun, 1) | |
Static Public Member Functions | |
| static UniRun * | CreateRun (int period_number, int run_number, int run_type, TDatime start_datetime, TDatime *end_datetime, TString beam_particle, TString target_particle, double *energy, double *field_voltage, int *event_count, int *geometry_id, int run_quality) |
| add new run to the database | |
| static UniRun * | GetRun (int period_number, int run_number) |
| get run from the database | |
| static int | CheckRunExists (int period_number, int run_number) |
| check run exists in the database: 1- true, 0 - false, <0 - database operation error | |
| static int | DeleteRun (int period_number, int run_number) |
| delete run from the database | |
| static int | PrintAll () |
| print all runs | |
| static int | GetRunNumbers (UniqueRunNumber *&run_numbers, int start_period, int start_run=0, int end_period=-1, int end_run=-1) |
| static int | GetRunNumbers (UniqueRunNumber *&run_numbers) |
| static int | SetRootGeometry (int start_period, int start_run, int end_period, int end_run, unsigned char *root_geometry, Long_t size_root_geometry) |
| set geometry binary data (geometry file's data) for runs from start_run_number to end_run_number | |
| static int | GetRootGeometry (int period_number, int run_number, unsigned char *&root_geometry, Long_t &size_root_geometry) |
| get geometry binary data (geometry file's data) for selected run number | |
| static int | WriteGeometryFile (int start_period, int start_run, int end_period, int end_run, const char *geo_file_path) |
| write geometry file for runs from start_run_number to end_run_number to the database | |
| static int | ReadGeometryFile (int period_number, int run_number, char *geo_file_path, bool usePrevGeometryIfMissing=false) |
| static int | ReadPreviousGeometryFile (int &period_number, int &run_number, char *geo_file_path) |
| static double | FindPreviousFieldVoltage (int &period_number, int &run_number) |
| static TObjArray * | Search (UniSearchCondition &search_condition) |
| get runs corresponding to the specified single condition and set owner for search_condition to kTRUE | |
| static TObjArray * | Search (TObjArray &search_conditions) |
| get runs corresponding to the specified (vector) conditions and set owner for search_condition to kTRUE | |
| static UniRun * | GetRun (int &period_number, int &run_number, bool usePrevRunIfMissing) |
| static int | FindPreviousRun (int &period_number, int &run_number) |
| static UniRun * | CreateRun (int period_number, int run_number, int run_type, TDatime start_datetime, TDatime *end_datetime, TString beam_particle, TString target_particle, double *energy, double *field_voltage, int *event_count, int *geometry_id, int run_quality) |
| add new run to the database | |
| static UniRun * | GetRun (int period_number, int run_number) |
| get run from the database | |
| static int | CheckRunExists (int period_number, int run_number) |
| check run exists in the database: 1- true, 0 - false, <0 - database operation error | |
| static int | DeleteRun (int period_number, int run_number) |
| delete run from the database | |
| static int | PrintAll () |
| print all runs | |
| static int | GetRunNumbers (UniqueRunNumber *&run_numbers, int start_period, int start_run=0, int end_period=-1, int end_run=-1) |
| static int | GetRunNumbers (UniqueRunNumber *&run_numbers) |
| static int | SetRootGeometry (int start_period, int start_run, int end_period, int end_run, unsigned char *root_geometry, Long_t size_root_geometry) |
| set geometry binary data (geometry file's data) for runs from start_run_number to end_run_number | |
| static int | GetRootGeometry (int period_number, int run_number, unsigned char *&root_geometry, Long_t &size_root_geometry) |
| get geometry binary data (geometry file's data) for selected run number | |
| static int | WriteGeometryFile (int start_period, int start_run, int end_period, int end_run, const char *geo_file_path) |
| write geometry file for runs from start_run_number to end_run_number to the database | |
| static int | ReadGeometryFile (int period_number, int run_number, char *geo_file_path, bool usePrevGeometryIfMissing=false) |
| static int | ReadPreviousGeometryFile (int &period_number, int &run_number, char *geo_file_path) |
| static double | FindPreviousFieldVoltage (int &period_number, int &run_number) |
| static TObjArray * | Search (UniSearchCondition &search_condition) |
| get runs corresponding to the specified single condition and set owner for search_condition to kTRUE | |
| static TObjArray * | Search (TObjArray &search_conditions) |
| get runs corresponding to the specified (vector) conditions and set owner for search_condition to kTRUE | |
| static UniRun * | GetRun (int &period_number, int &run_number, bool usePrevRunIfMissing) |
| static int | FindPreviousRun (int &period_number, int &run_number) |
|
virtual |
Definition at line 50 of file UniRun.cxx.
|
virtual |
|
static |
check run exists in the database: 1- true, 0 - false, <0 - database operation error
Definition at line 262 of file UniRun.cxx.
References UniConnection::GetSQLServer(), and UniConnection::Open().
|
static |
check run exists in the database: 1- true, 0 - false, <0 - database operation error
| UniRun::ClassDef | ( | UniRun | , |
| 1 | |||
| ) |
| UniRun::ClassDef | ( | UniRun | , |
| 1 | |||
| ) |
|
static |
add new run to the database
Definition at line 67 of file UniRun.cxx.
References UniConnection::GetSQLServer(), and UniConnection::Open().
|
static |
add new run to the database
|
static |
delete run from the database
Definition at line 302 of file UniRun.cxx.
References UniConnection::GetSQLServer(), and UniConnection::Open().
|
static |
delete run from the database
|
static |
get field voltage value if period_number > 0 and run_number > 0: from the closest previous run, below (period:run) in another case: for the latest run in the database ATTENTION: changes the input period and run numbers to the correspoding ones of the previous run with the field voltage
Definition at line 1226 of file UniRun.cxx.
References UniConnection::GetSQLServer(), and UniConnection::Open().
|
static |
get field voltage value if period_number > 0 and run_number > 0: from the closest previous run, below (period:run) in another case: for the latest run in the database ATTENTION: changes the input period and run numbers to the correspoding ones of the previous run with the field voltage
|
static |
get number of the closest run below the given one or return the latest run in the database if period_number < 1 or run_number < 1
Definition at line 1511 of file UniRun.cxx.
References UniConnection::GetSQLServer(), and UniConnection::Open().
Referenced by GetRun().
|
static |
get number of the closest run below the given one or return the latest run in the database if period_number < 1 or run_number < 1
|
inline |
get beam particle of the current run
Definition at line 113 of file UniRun.h.
Referenced by BmnRunInfo::BmnRunInfo(), BmnZDCRaw2Digit::BmnZDCRaw2Digit(), BmnMassSpectrumAnal::createFilelist(), BmnTrackingQaOffline::DoAnalisys(), BmnLambdaEmbedding::Embedding(), eventdisplay(), BmnFillDstTask::Init(), BmnEfficiencyTools::Process(), run8_reco_bmn(), run_reco_bmn(), and run_reco_src().
|
inline |
|
inline |
get end datetime of the current run
Definition at line 105 of file UniRun.h.
Referenced by BmnFillDstTask::Init(), and BmnMscRaw2Digit::ParseTxtSpillLog().
|
inline |
|
inline |
get energy of the current run
Definition at line 117 of file UniRun.h.
Referenced by BmnRunInfo::BmnRunInfo(), BmnSRCTriggersCheck::Exec(), and BmnFillDstTask::Init().
|
inline |
|
inline |
get event count of the current run
Definition at line 133 of file UniRun.h.
Referenced by BmnRunInfo::BmnRunInfo().
|
inline |
|
inline |
get field voltage of the current run
Definition at line 125 of file UniRun.h.
Referenced by BmnEfficiency::BmnEfficiency(), BmnEfficiency::BmnEfficiency(), BmnRunInfo::BmnRunInfo(), BmnTrackingQaOffline::DoAnalisys(), BmnLambdaEmbeddingQa::DoDrawEventsWithEmbeddedSignals(), BmnLambdaEmbedding::Embedding(), eventdisplay(), BmnGlobalAlignment::Init(), BmnQaOffline::Init(), BmnTwoParticleDecay::Init(), run8_reco_bmn(), run_reco_bmn(), and run_reco_src().
|
inline |
|
inline |
get geometry id of the current run
Definition at line 141 of file UniRun.h.
Referenced by BmnRunInfo::BmnRunInfo(), and GetRootGeometry().
|
inline |
|
inline |
get period number of the current run
Definition at line 97 of file UniRun.h.
Referenced by BmnRunInfo::BmnRunInfo().
|
inline |
| TObjArray * UniRun::GetRawFiles | ( | ) |
get array of raw files (UniRawFile*) corresponding to the run (return nullptr if an error occured)
Definition at line 866 of file UniRun.cxx.
References UniRawFile::GetRawFiles().
| TObjArray * UniRun::GetRawFiles | ( | ) |
get array of raw files (UniRawFile*) corresponding to the run (return nullptr if an error occured)
|
static |
get geometry binary data (geometry file's data) for selected run number
Definition at line 1020 of file UniRun.cxx.
References GetGeometryId(), UniRunGeometry::GetRootGeometry(), UniRunGeometry::GetRootGeometrySize(), GetRun(), and UniRunGeometry::GetRunGeometry().
Referenced by ReadGeometryFile().
|
static |
get geometry binary data (geometry file's data) for selected run number
|
static |
get run from the database with the given period and run numbers if usePrevRunIfMissing is true then find and get the previous (existing) run in case the given run is absent ATTENTION: changes the input period and run numbers to ones of the found run (if usePrevRunIfMissing is true)
Definition at line 1490 of file UniRun.cxx.
References FindPreviousRun(), and GetRun().
|
static |
get run from the database with the given period and run numbers if usePrevRunIfMissing is true then find and get the previous (existing) run in case the given run is absent ATTENTION: changes the input period and run numbers to ones of the found run (if usePrevRunIfMissing is true)
|
static |
get run from the database
Definition at line 177 of file UniRun.cxx.
References UniConnection::GetSQLServer(), and UniConnection::Open().
Referenced by BmnEfficiency::BmnEfficiency(), BmnEfficiency::BmnEfficiency(), BmnZDCRaw2Digit::BmnZDCRaw2Digit(), BmnMassSpectrumAnal::createFilelist(), BmnTrackingQaOffline::DoAnalisys(), BmnLambdaEmbeddingQa::DoDrawEventsWithEmbeddedSignals(), BmnLambdaEmbedding::Embedding(), eventdisplay(), BmnSRCTriggersCheck::Exec(), BmnMonitor::GetAlikeRunsByUniDB(), GetRootGeometry(), GetRun(), BmnGlobalAlignment::Init(), BmnFillDstTask::Init(), BmnQaOffline::Init(), BmnTwoParticleDecay::Init(), BmnMscRaw2Digit::ParseTxtSpillLog(), BmnEfficiencyTools::Process(), run8_reco_bmn(), run_reco_bmn(), run_reco_src(), BmnMetadataDecoder::SetDigiDirectory(), SetRootGeometry(), and bmn::online::ReconstructionProcessor::SetupExperimentalRun().
|
static |
get run from the database
|
inline |
get run number of the current run
Definition at line 99 of file UniRun.h.
Referenced by BmnRunInfo::BmnRunInfo().
|
inline |
|
static |
get all numbers of stored runs in the Database
| [out] | run_numbers | pairs (period number+run numbers) of all runs |
Definition at line 925 of file UniRun.cxx.
References UniConnection::GetSQLServer(), i, and UniConnection::Open().
|
static |
get all numbers of stored runs in the Database
| [out] | run_numbers | pairs (period number+run numbers) of all runs |
|
static |
get numbers of runs stored in the Database for a selected range
| [in] | start_period | start period number for selected run numbers' range |
| [in] | start_run | start run number for selected run numbers' range (default, 0 means "from the first run of the start period") |
| [in] | end_period | end period number for selected run numbers' range (default, -1 means "end_period = start_period") |
| [in] | end_run | end run number for selected run numbers' range (default, -1 means "up to the last run of the end period") |
| [out] | run | pairs (period number+run numbers) of existing runs for a selected range (from start to end) |
Definition at line 872 of file UniRun.cxx.
References UniConnection::GetSQLServer(), i, and UniConnection::Open().
Referenced by SetRootGeometry().
|
static |
get numbers of runs stored in the Database for a selected range
| [in] | start_period | start period number for selected run numbers' range |
| [in] | start_run | start run number for selected run numbers' range (default, 0 means "from the first run of the start period") |
| [in] | end_period | end period number for selected run numbers' range (default, -1 means "end_period = start_period") |
| [in] | end_run | end run number for selected run numbers' range (default, -1 means "up to the last run of the end period") |
| [out] | run | pairs (period number+run numbers) of existing runs for a selected range (from start to end) |
|
inline |
|
inline |
|
inline |
|
inline |
|
inline |
get start datetime of the current run
Definition at line 103 of file UniRun.h.
Referenced by BmnFillDstTask::Init(), and BmnMscRaw2Digit::ParseTxtSpillLog().
|
inline |
|
inline |
get target particle of the current run
Definition at line 115 of file UniRun.h.
Referenced by BmnRunInfo::BmnRunInfo(), BmnMassSpectrumAnal::createFilelist(), BmnTrackingQaOffline::DoAnalisys(), eventdisplay(), BmnSRCTriggersCheck::Exec(), BmnFillDstTask::Init(), BmnEfficiencyTools::Process(), run8_reco_bmn(), run_reco_bmn(), and run_reco_src().
|
inline |
| void UniRun::Print | ( | ) |
print information about current run
Definition at line 848 of file UniRun.cxx.
| void UniRun::Print | ( | ) |
print information about current run
|
static |
print all runs
Definition at line 333 of file UniRun.cxx.
References UniConnection::GetSQLServer(), and UniConnection::Open().
|
static |
print all runs
|
static |
read geometry file for selected run number from the database and write it to the file if the given run is absent and usePrevGeometryIfMissing is true then use the nearest run below period:run
Definition at line 1105 of file UniRun.cxx.
References GetRootGeometry(), and ReadPreviousGeometryFile().
Referenced by BmnTrackingQaOffline::BmnTrackingQaOffline(), BmnLambdaEmbeddingQa::DoDrawEventsWithEmbeddedSignals(), eventdisplay(), BmnGlobalAlignment::Init(), BmnQaOffline::Init(), BmnTwoParticleDecay::Init(), run8_reco_bmn(), run_reco_bmn(), and run_reco_src().
|
static |
read geometry file for selected run number from the database and write it to the file if the given run is absent and usePrevGeometryIfMissing is true then use the nearest run below period:run
|
static |
read previous geometry file from the database and write it to the file if period_number > 0 and run_number > 0: for the nearest run with a geometry below (period:run) in another case: for the latest run in the database ATTENTION: changes the input period and run numbers to the correspoding ones of the previous run
Definition at line 1151 of file UniRun.cxx.
References UniConnection::GetSQLServer(), and UniConnection::Open().
Referenced by ReadGeometryFile(), and bmn::online::ReconstructionProcessor::SetupExperimentalRun().
|
static |
read previous geometry file from the database and write it to the file if period_number > 0 and run_number > 0: for the nearest run with a geometry below (period:run) in another case: for the latest run in the database ATTENTION: changes the input period and run numbers to the correspoding ones of the previous run
|
static |
get runs corresponding to the specified (vector) conditions and set owner for search_condition to kTRUE
Definition at line 1273 of file UniRun.cxx.
References UniSearchCondition::columnBeamParticle, UniSearchCondition::columnEndDateTime, UniSearchCondition::columnEnergy, UniSearchCondition::columnEventCount, UniSearchCondition::columnFieldVoltage, UniSearchCondition::columnPeriodNumber, UniSearchCondition::columnRunNumber, UniSearchCondition::columnStartDatetime, UniSearchCondition::columnTargetParticle, UniSearchCondition::conditionEqual, UniSearchCondition::conditionGreater, UniSearchCondition::conditionGreaterOrEqual, UniSearchCondition::conditionLess, UniSearchCondition::conditionLessOrEqual, UniSearchCondition::conditionLike, UniSearchCondition::conditionNotEqual, UniSearchCondition::conditionNotNull, UniSearchCondition::conditionNull, UniSearchCondition::GetColumn(), UniSearchCondition::GetCondition(), UniSearchCondition::GetDatimeValue(), UniSearchCondition::GetDoubleValue(), UniSearchCondition::GetIntValue(), UniConnection::GetSQLServer(), UniSearchCondition::GetStringValue(), UniSearchCondition::GetUIntValue(), UniSearchCondition::GetValueType(), and UniConnection::Open().
|
static |
get runs corresponding to the specified (vector) conditions and set owner for search_condition to kTRUE
|
static |
get runs corresponding to the specified single condition and set owner for search_condition to kTRUE
Definition at line 1479 of file UniRun.cxx.
References Search().
Referenced by BmnMonitor::GetAlikeRunsByElog(), BmnMonitor::GetAlikeRunsByUniDB(), and Search().
|
static |
get runs corresponding to the specified single condition and set owner for search_condition to kTRUE
| int UniRun::SetBeamParticle | ( | TString | beam_particle | ) |
set beam particle of the current run
Definition at line 584 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetBeamParticle | ( | TString | beam_particle | ) |
set beam particle of the current run
| int UniRun::SetEndDatetime | ( | TDatime * | end_datetime | ) |
set end datetime of the current run
Definition at line 543 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetEndDatetime | ( | TDatime * | end_datetime | ) |
set end datetime of the current run
| int UniRun::SetEnergy | ( | double * | energy | ) |
set energy of the current run
Definition at line 650 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetEnergy | ( | double * | energy | ) |
set energy of the current run
| int UniRun::SetEventCount | ( | int * | event_count | ) |
set event count of the current run
Definition at line 732 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetEventCount | ( | int * | event_count | ) |
set event count of the current run
| int UniRun::SetFieldVoltage | ( | double * | field_voltage | ) |
set field voltage of the current run
Definition at line 691 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetFieldVoltage | ( | double * | field_voltage | ) |
set field voltage of the current run
| int UniRun::SetGeometryId | ( | int * | geometry_id | ) |
set geometry id of the current run
Definition at line 773 of file UniRun.cxx.
References UniConnection::GetSQLServer().
Referenced by SetRootGeometry().
| int UniRun::SetGeometryId | ( | int * | geometry_id | ) |
set geometry id of the current run
| int UniRun::SetPeriodNumber | ( | int | period_number | ) |
set period number of the current run
Definition at line 411 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetPeriodNumber | ( | int | period_number | ) |
set period number of the current run
|
static |
set geometry binary data (geometry file's data) for runs from start_run_number to end_run_number
Definition at line 971 of file UniRun.cxx.
References UniRunGeometry::CreateRunGeometry(), UniRunGeometry::GetGeometryId(), GetRun(), GetRunNumbers(), i, UniqueRunNumber::period_number, UniqueRunNumber::run_number, and SetGeometryId().
Referenced by WriteGeometryFile().
|
static |
set geometry binary data (geometry file's data) for runs from start_run_number to end_run_number
| int UniRun::SetRunNumber | ( | int | run_number | ) |
set run number of the current run
Definition at line 444 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetRunNumber | ( | int | run_number | ) |
set run number of the current run
| int UniRun::SetRunQuality | ( | int | run_quality | ) |
set run quality of the current run
Definition at line 814 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetRunQuality | ( | int | run_quality | ) |
set run quality of the current run
| int UniRun::SetRunType | ( | int | run_type | ) |
set run type of the current run
Definition at line 477 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetRunType | ( | int | run_type | ) |
set run type of the current run
| int UniRun::SetStartDatetime | ( | TDatime | start_datetime | ) |
set start datetime of the current run
Definition at line 510 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetStartDatetime | ( | TDatime | start_datetime | ) |
set start datetime of the current run
| int UniRun::SetTargetParticle | ( | TString | target_particle | ) |
set target particle of the current run
Definition at line 617 of file UniRun.cxx.
References UniConnection::GetSQLServer().
| int UniRun::SetTargetParticle | ( | TString | target_particle | ) |
set target particle of the current run
|
static |
write geometry file for runs from start_run_number to end_run_number to the database
Definition at line 1054 of file UniRun.cxx.
References SetRootGeometry().
|
static |
write geometry file for runs from start_run_number to end_run_number to the database