Difference between revisions of "Transversity MySQL database"
From Hall A Wiki
(→Run Flag in AnalysisInfo) |
|||
Line 7: | Line 7: | ||
** Primary information is from the "start of run" and "end of run" | ** Primary information is from the "start of run" and "end of run" | ||
** Further information is filled in by those doing the analysis (online and offline) | ** Further information is filled in by those doing the analysis (online and offline) | ||
+ | ==Script for adding entries to the AnalysisInfo table== | ||
+ | -r, --runnum [LOW NUMBER]-[HIGH NUMBER] | ||
+ | Specify the range of runnumbers to modify. One number will work | ||
+ | for single run modifications. | ||
+ | |||
+ | -u, --username [USERNAME] | ||
+ | Specify the name of the person making the modification, | ||
+ | input your name, please. | ||
+ | |||
+ | -t, --type [RUNTYPE] | ||
+ | Specify the type of run, e.g: production, cosmics... | ||
+ | |||
+ | -b, --beampol [BEAM POLARIZATION] | ||
+ | Specify the beam polarization. | ||
+ | |||
+ | -f --flag [FLAG] | ||
+ | Specify the run quality. | ||
+ | -1 data file does not exist | ||
+ | 0 junk run | ||
+ | 5 target is not in 3He position, e.g: BCM/BPM... | ||
+ | 10 target is in 3He position, but for other purpose, e.g: test... | ||
+ | 15 production run with some problems, e.g: roc problem... | ||
+ | 20 production run with no obvious problems | ||
+ | |||
+ | -c, --comment "[COMMENT]" | ||
+ | Add a comment. For best results, put the entire comment in | ||
+ | quotation marks. | ||
+ | |||
+ | -v, --verbose | ||
+ | Be verbose. | ||
+ | |||
==Table Descriptions== | ==Table Descriptions== | ||
===RunInfo=== | ===RunInfo=== |
Revision as of 05:35, 16 February 2009
Contents
Available Tables
- RunInfo
- From the "start of run"
- EndRunInfo
- From the "end of run"
- AnalysisInfo
- Primary information is from the "start of run" and "end of run"
- Further information is filled in by those doing the analysis (online and offline)
Script for adding entries to the AnalysisInfo table
-r, --runnum [LOW NUMBER]-[HIGH NUMBER] Specify the range of runnumbers to modify. One number will work for single run modifications.
-u, --username [USERNAME] Specify the name of the person making the modification, input your name, please.
-t, --type [RUNTYPE] Specify the type of run, e.g: production, cosmics...
-b, --beampol [BEAM POLARIZATION] Specify the beam polarization.
-f --flag [FLAG] Specify the run quality. -1 data file does not exist 0 junk run 5 target is not in 3He position, e.g: BCM/BPM... 10 target is in 3He position, but for other purpose, e.g: test... 15 production run with some problems, e.g: roc problem... 20 production run with no obvious problems
-c, --comment "[COMMENT]" Add a comment. For best results, put the entire comment in quotation marks.
-v, --verbose Be verbose.
Table Descriptions
RunInfo
+-------------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------------+-------------+------+-----+---------+-------+ | RunNumber | int(11) | | PRI | 0 | | | RunStartTime | datetime | YES | | NULL | | | TargetName | varchar(50) | YES | | NULL | | | TargetPolarizeDirection | varchar(50) | YES | | NULL | | | Prescale1 | int(11) | YES | | NULL | | | Prescale2 | int(11) | YES | | NULL | | | Prescale3 | int(11) | YES | | NULL | | | Prescale4 | int(11) | YES | | NULL | | | Prescale5 | int(11) | YES | | NULL | | | Prescale6 | int(11) | YES | | NULL | | | Prescale7 | int(11) | YES | | NULL | | | Prescale8 | int(11) | YES | | NULL | | | RichHV16 | float | YES | | NULL | | | RichCurrent16 | float | YES | | NULL | | | RichHV17 | float | YES | | NULL | | | RichMethaneFlow | float | YES | | NULL | | | UpstreamBCMCurrent | float | YES | | NULL | | | DownstreamBCMCurrent | float | YES | | NULL | | | Energy | float | YES | | NULL | | | RasterWidthX | float | YES | | NULL | | | RasterWidthY | float | YES | | NULL | | | WienAngle | float | YES | | NULL | | | BeamHalfWavePlate | varchar(50) | YES | | NULL | | | SmallCoilCurrent | float | YES | | NULL | | | VerticalCoilCurrent | float | YES | | NULL | | | LargeCoilCurrent | float | YES | | NULL | | | He3FlipID | int(11) | YES | | NULL | | | TargetPolarization | float | YES | | NULL | | | TargetPosition | float | YES | | NULL | | | BBChamber1Threshold | float | YES | | NULL | | | BBChamber2Threshold | float | YES | | NULL | | | BBChamber3Threshold | float | YES | | NULL | | | BBShowerThreshold | float | YES | | NULL | | | BBPreShowerThreshold | float | YES | | NULL | | | BBShower2Threshold | float | YES | | NULL | | | BBCherenkovThreshold | float | YES | | NULL | | | CodaConfig | varchar(50) | YES | | NULL | | | HappexRunNumber | int(11) | YES | | NULL | | | ShiftWorkerComment | longtext | YES | | NULL | | +-------------------------+-------------+------+-----+---------+-------+
EndRunInfo
+--------------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------+------+-----+---------+-------+ | RunNumber | int(11) | YES | MUL | NULL | | | Events_0 | int(11) | YES | | NULL | | | Events_pp | int(11) | YES | | NULL | | | Events_mm | int(11) | YES | | NULL | | | Events_pm | int(11) | YES | | NULL | | | Events_mp | int(11) | YES | | NULL | | | Time_0 | float | YES | | NULL | | | Time_pp | float | YES | | NULL | | | Time_mm | float | YES | | NULL | | | Time_pm | float | YES | | NULL | | | Time_mp | float | YES | | NULL | | | DeadTime_0 | float | YES | | NULL | | | DeadTime_pp | float | YES | | NULL | | | DeadTime_mm | float | YES | | NULL | | | DeadTime_pm | float | YES | | NULL | | | DeadTime_mp | float | YES | | NULL | | | T1real_0 | int(11) | YES | | NULL | | | T2real_0 | int(11) | YES | | NULL | | | T3real_0 | int(11) | YES | | NULL | | | T4real_0 | int(11) | YES | | NULL | | | T5real_0 | int(11) | YES | | NULL | | | T6real_0 | int(11) | YES | | NULL | | | T7real_0 | int(11) | YES | | NULL | | | T8real_0 | int(11) | YES | | NULL | | | T1real_pp | int(11) | YES | | NULL | | | T2real_pp | int(11) | YES | | NULL | | | T3real_pp | int(11) | YES | | NULL | | | T4real_pp | int(11) | YES | | NULL | | | T5real_pp | int(11) | YES | | NULL | | | T6real_pp | int(11) | YES | | NULL | | | T7real_pp | int(11) | YES | | NULL | | | T8real_pp | int(11) | YES | | NULL | | | T1real_mm | int(11) | YES | | NULL | | | T2real_mm | int(11) | YES | | NULL | | | T3real_mm | int(11) | YES | | NULL | | | T4real_mm | int(11) | YES | | NULL | | | T5real_mm | int(11) | YES | | NULL | | | T6real_mm | int(11) | YES | | NULL | | | T7real_mm | int(11) | YES | | NULL | | | T8real_mm | int(11) | YES | | NULL | | | T1real_pm | int(11) | YES | | NULL | | | T2real_pm | int(11) | YES | | NULL | | | T3real_pm | int(11) | YES | | NULL | | | T4real_pm | int(11) | YES | | NULL | | | T5real_pm | int(11) | YES | | NULL | | | T6real_pm | int(11) | YES | | NULL | | | T7real_pm | int(11) | YES | | NULL | | | T8real_pm | int(11) | YES | | NULL | | | T1real_mp | int(11) | YES | | NULL | | | T2real_mp | int(11) | YES | | NULL | | | T3real_mp | int(11) | YES | | NULL | | | T4real_mp | int(11) | YES | | NULL | | | T5real_mp | int(11) | YES | | NULL | | | T6real_mp | int(11) | YES | | NULL | | | T7real_mp | int(11) | YES | | NULL | | | T8real_mp | int(11) | YES | | NULL | | | AverageCurrent_x1 | float | YES | | NULL | | | AverageCurrent_x3 | float | YES | | NULL | | | AverageCurrent_x10 | float | YES | | NULL | | | BeamCharge_u3_0 | float | YES | | NULL | | | BeamCharge_u3_pp | float | YES | | NULL | | | BeamCharge_u3_mm | float | YES | | NULL | | | BeamCharge_u3_pm | float | YES | | NULL | | | BeamCharge_u3_mp | float | YES | | NULL | | | BeamCharge_d3_0 | float | YES | | NULL | | | BeamCharge_d3_pp | float | YES | | NULL | | | BeamCharge_d3_mm | float | YES | | NULL | | | BeamCharge_d3_pm | float | YES | | NULL | | | BeamCharge_d3_mp | float | YES | | NULL | | +--------------------+---------+------+-----+---------+-------+
AnalysisInfo
+-----------+------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+-------------------+----------------+ | anaID | int(11) | | PRI | NULL | auto_increment | | EntryTime | timestamp | YES | | CURRENT_TIMESTAMP | | | RunNumber | int(11) | YES | MUL | NULL | | | UserName | longtext | YES | | NULL | | | RunType | longtext | YES | | NULL | | | Flag | tinyint(4) | YES | | NULL | | | Comment | longtext | YES | | NULL | | +-----------+------------+------+-----+-------------------+----------------+
Run Flag in AnalysisInfo
-1 data file does not exist: skipped run number or data file lost in data disk crash 0 junk run, not useful for anything 5 secondary run, target is not in 3He position, for example:cosmics, BPM/BCM calibration... 10 secondary run, target is in 3He position, for example:cosmics, test... 15 primary run with some problems, run taken for physics analysis but some problem: roc problem, short run time... 20 primary run with no obvious problems logged in HALOG/shift summary/paper summary