Difference between revisions of "CLAS12 R1 S6 QA"

From New IAC Wiki
Jump to navigation Jump to search
Line 1: Line 1:
 
=Pre-Potting Tension Error=
 
=Pre-Potting Tension Error=
  
[[File:SL1S6_Field_PrePot.png| 200 px]][[File:SL2S6_Field_PrePot.png| 200 px]][[File:SL1S6_Sense_PrePot.png| 200 px]][[File:SL2S6_Sense_PrePot.png| 200 px]]
+
[[File:SL1S6_Sense_PrePot.png| 200 px]][[File:SL2S6_Sense_PrePot.png| 200 px]]
 
 
  
 +
[[File:SL1S6_Field_PrePot.png| 200 px]][[File:SL2S6_Field_PrePot.png| 200 px]]
  
 
=MYSQL commands=
 
=MYSQL commands=

Revision as of 02:20, 17 October 2012

Pre-Potting Tension Error

SL1S6 Sense PrePot.pngSL2S6 Sense PrePot.png

SL1S6 Field PrePot.pngSL2S6 Field PrePot.png

MYSQL commands

mysql> show databases;

+--------------------+
| Database           |
+--------------------+
| information_schema | 
| mysql              | 
| region1            | 
| test               | 
+--------------------+
4 rows in set (0.02 sec)


mysql> use region1;

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed


mysql> show tables;

+-------------------------------+
| Tables_in_region1             |
+-------------------------------+
| R1S1_Tension_Trend_Test_Field | 
| R1S1_Tension_Trend_Test_Sense | 
| R1S4_Tension_Trend_Test_Field | 
| R1S4_Tension_Trend_Test_Sense | 
| R1S5_Tension_Trend_Test_Field | 
| R1S6_Tension_Trend_Test_Field | 
| R1S6_Tension_Trend_Test_Sense | 
| R1_SL1_S1_Field               | 
| R1_SL1_S1_Sense               | 
| R1_SL1_S4_Field               | 
| R1_SL1_S4_Sense               | 
| R1_SL1_S5_Field               | 
| R1_SL1_S6_Field               | 
| R1_SL1_S6_Sense               | 
| R1_SL2_S1_Field               | 
| R1_SL2_S1_Sense               | 
| R1_SL2_S4_Field               | 
| R1_SL2_S4_Sense               | 
| R1_SL2_S5_Field               | 
| R1_SL2_S6_Field               | 
| R1_SL2_S6_Sense               | 
| R1_particleCounts             | 
| R1_work_log                   | 
+-------------------------------+
23 rows in set (0.00 sec)

mysql> describe R1_SL1_S6_Sense;

+------------------+-------------+------+-----+-------------------+-------+
| Field            | Type        | Null | Key | Default           | Extra |
+------------------+-------------+------+-----+-------------------+-------+
| iCol             | int(11)     | NO   |     | NULL              |       | 
| iRow             | int(11)     | NO   |     | NULL              |       | 
| PeriodMeasured   | float       | YES  |     | NULL              |       | 
| Result           | varchar(32) | YES  |     | NULL              |       | 
| TensionMeasured  | float       | YES  |     | NULL              |       | 
| CalculatedPeriod | float       | YES  |     | NULL              |       | 
| SuperLayer       | int(11)     | NO   |     | NULL              |       | 
| Length           | float       | YES  |     | NULL              |       | 
| FreqMeasured     | float       | YES  |     | NULL              |       | 
| TensionError     | float       | YES  |     | NULL              |       | 
| TestLogic        | int(11)     | NO   |     | NULL              |       | 
| CalcFreq         | float       | YES  |     | NULL              |       | 
| HighCut          | float       | YES  |     | NULL              |       | 
| LowCut           | float       | YES  |     | NULL              |       | 
| Sector           | int(11)     | NO   |     | NULL              |       | 
| Date             | varchar(32) | YES  |     | NULL              |       | 
| Mod_time         | timestamp   | NO   |     | CURRENT_TIMESTAMP |       | 
+------------------+-------------+------+-----+-------------------+-------+
17 rows in set (0.04 sec)


mysql> select TensionError from R1_SL1_S6_Sense INTO OUTFILE '/tmp/R1SL1S6Sense.dat';