Difference between revisions of "Transversity MySQL database"
From Hall A Wiki
(→Script for adding entries to the AnalysisInfo table) |
(→Search the run you want to find) |
||
(One intermediate revision by the same user not shown) | |||
Line 4: | Line 4: | ||
[http://hallaweb.jlab.org/experiment/transversity/db_yawei/index.php E06010 Run Search] | [http://hallaweb.jlab.org/experiment/transversity/db_yawei/index.php E06010 Run Search] | ||
*Run Flag in AnalysisInfo | *Run Flag in AnalysisInfo | ||
− | - | + | -10 data file does not exist: skipped run number or data file lost in data disk crash |
− | + | -5 junk run, not useful for anything | |
5 secondary run, target is not in 3He position, for example:cosmics, BPM/BCM calibration... | 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... | + | 10 secondary run, target is in 3He position, but for other purpose, for example:cosmics, test... |
15 primary run with some problems, run taken for physics analysis but some problem: roc problem, short run time... | 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 | 20 primary run with no obvious problems logged in HALOG/shift summary/paper summary |
Latest revision as of 02:39, 19 February 2009
Contents
Display
Search the run you want to find
- A search tool, using the transversity MYSQL database, is found here:
E06010 Run Search
- Run Flag in AnalysisInfo
-10 data file does not exist: skipped run number or data file lost in data disk crash -5 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, but for other purpose, 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
Available Tables
- RunInfo
- From the "start of run" halla e-log entries
- EndRunInfo
- From the "end of run" halla e-log entries
- AnalysisInfo
- Primary information is from the "start of run" and "end of run" halla e-log entries
- Further information is filled in by those doing the analysis (online and offline)
Script for adding entries to the AnalysisInfo table
Here is the script for adding your own analysis information to the AnalysisInfo table
/adaqfs/home/adaq/transversity/mysql/setAnalysisInfo.pl
- setAnalysisInfo.pl
-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 | | +-----------+------------+------+-----+-------------------+----------------+