Difference between revisions of "MySQL database"
From Hall A Wiki
Line 1: | Line 1: | ||
== Insert analysis information into MySQL database of QuasiFamily == | == Insert analysis information into MySQL database of QuasiFamily == | ||
− | + | * Find the script setAnalysisInfo.pl in directory: | |
− | /adaqfs/home/adaq/e05102/ | + | /adaqfs/home/adaq/e05102/script |
− | + | * Call command | |
./setAnalysisInfo.pl to run this script | ./setAnalysisInfo.pl to run this script | ||
− | + | * You will see this: | |
Connection successful: handle: DBI::db=HASH(0x8ffdd34) | Connection successful: handle: DBI::db=HASH(0x8ffdd34) | ||
Need some run numbers, dude! | Need some run numbers, dude! |
Revision as of 03:05, 29 April 2009
Insert analysis information into MySQL database of QuasiFamily
- Find the script setAnalysisInfo.pl in directory:
/adaqfs/home/adaq/e05102/script
- Call command
./setAnalysisInfo.pl to run this script
- You will see this:
Connection successful: handle: DBI::db=HASH(0x8ffdd34) Need some run numbers, dude! Usage: setAnalysisInfo.pl [OPTION] Command-line options: -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 -t, --type [RUNTYPE] Specify the type of run (calibration, scan, junk) -k, --kinematic [KINEMATIC] Specify the kinematic name. -p, --production [0,1] Specify if the run is production (1) or not (0) -b, --beampol [BEAM POLARIZATION] Specify the beam polarization -h, --heTargpol [TARGET POLARIZATION] Specify the target polarization -c, --comment "[COMMENT]" Add a comment. For best results, put the entire comment in quotation marks. -v, --verbose Be verbose.
- If a High Voltage Alarm sounds, turn the channel off and then back on
Run the RHRS CODA with the setting "RightHrs"
- Analyzing the RHRS using do_all(run#) will analyze the neutron detector data
- To view just the HAND data once replayed, use the command show_all(run#)
- It's the window where every group of histograms has labels that start with "ND"
- In general,
- the ADCs should look like this:
- and the TDCs should look this:
- If they don't, make a HAlog entry about it
- the ADCs should look like this: