STF results

The P/F are automatically written in the file stf_results.txt the failure details are to be found in stf_fail.txt.

Simplest way to look at STF results is to use the DB web-script for STF failures on Hagar's page.

Waiving, explained by Bernhard:

export PYTHONPATH=/home/testdaq/tmp2/FAT/PyDOM Then, e.g. the command for TP5H00201: /home/testdaq/bin/stf_failures_for_dom.sh TP5H0201
this gives a value for stf_result_id
This is the value to use below in the python session...
Now open a python console on a machine were the PyDOM and MySQLdb modules are available in the PYTHONPATH environment variable. This is the case for the domhubs.
Now type the following commands:

[17:08 dryade18] ~/scripts/fat > python
Python 2.2.3 (#1, Feb 14 2005, 14:38:30)
[GCC 3.2.3 20030502 (Red Hat Linux 3.2.3-49)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>> from icecube.domtest.STF import *
>>> db = MySQLdb.connect(user='penguin', db='domprodtest')
>>> s = STFResult(db, the stf_result_id goes in here)
>>> waive_failure(s)
1
Explanation:
You're importing the MySQL and STF module. Afterwards create a connection object with the specified parameters (change the host argument to your needs). Than create the STFResult with the db object and a stf_result_id from the list of the atwd_pulser_spe failures as parameters. Call the function waive_failures with the STFReslut object as parameter. If it prints out 1 than the failure can be waived.

 (the remainder of this page is an example for FAT2- you need to adapt the commands to your FAT)



use domprodtest;



GET THE REF BOARDS:



select STFResult.prod_id,tag_serial from STFResult,Product where STFResult.prod_id=Product.prod_id AND tag_serial="TSLRef01";





select STFResult.prod_id,tag_serial from STFResult,Product where STFResult.prod_id=Product.prod_id AND tag_serial="TSLRef02";



This always gives as a result

800000002,800000003



You do not need to redo this operation, thus!!



GET THE IDS OF THE FAILED TESTS



select STFResult.stf_test_id,name,count(*) As Fails from STFResult,STFTest,STFTestType where passed=0 AND prod_id NOT IN(800000002,800000003) AND STFResult.stf_test_id=STFTest.stf_test_id and STFTest.stf_testtype_id=STFTestType.stf_testtype_id and STFResult.date_tested>'2005-02-16 00:00:00' GROUP BY name ORDER BY Fails;



LIST ALL THE EXISTING TEST PARAMETERS



select stf_param_id,name from STFParameter;





NOW, GO THROUGH THE LIST OF FAILED TESTS!



GET THE LIST OF DOMS FAILING 8000000002 TEST 



select tag_serial,count(*) from STFResult,Product where stf_test_id=800000002 and passed=0 and STFResult.prod_id=Product.prod_id and STFResult.date_tested>'2005-02-16 00:00:00' AND tag_serial NOT LIKE '%Ref%' GROUP BY tag_serial ORDER BY RIGHT(tag_serial,4);



CHECK THE VALUE OF TEST 800000002



SELECT STFResult.stf_result_id,name, value,tag_serial,date_tested FROM STFResultParameter,STFParameter,STFResult,Product WHERE STFResult.prod_id=Product.prod_id AND STFResultParameter.stf_param_id=STFParameter.stf_param_id AND STFResult.stf_result_id=STFResultParameter.stf_result_id AND passed=0 and stf_test_id=800000002 AND name='missing_width' AND STFResult.prod_id NOT IN (800000002,800000003) and STFResult.date_tested>'2005-02-16 00:00:00' ORDER BY STFParameter.stf_param_id;





SELECT STFResult.stf_result_id,name, value,tag_serial,date_tested FROM STFResultParameter,STFParameter,STFResult,Product WHERE STFResult.prod_id=Product.prod_id AND STFResultParameter.stf_param_id=STFParameter.stf_param_id AND STFResult.stf_result_id=STFResultParameter.stf_result_id AND passed=0 and stf_test_id=800000002 and value>10 AND name='missing_width' AND STFResult.prod_id NOT IN (800000002,800000003) and STFResult.date_tested>'2005-02-16 00:00:00' ORDER BY STFParameter.stf_param_id;





CHECK THE VALUE OF TEST 23



SELECT STFResult.stf_result_id,name,value,tag_serial,date_tested FROM STFResultParameter,STFParameter,STFResult,Product WHERE STFResult.prod_id=Product.prod_id AND STFResultParameter.stf_param_id=STFParameter.stf_param_id AND STFResult.stf_result_id=STFResultParameter.stf_result_id AND passed=0 and stf_test_id=23 AND name IN ('noise_positive_max', 'noise_negative_max') AND tag_serial NOT LIKE '%Ref%' and STFResult.date_tested>'2005-02-16 00:00:00' ORDER BY RIGHT(tag_serial,4);





SELECT STFResult.stf_result_id,name,value,tag_serial,date_tested FROM STFResultParameter,STFParameter,STFResult,Product WHERE STFResult.prod_id=Product.prod_id AND STFResultParameter.stf_param_id=STFParameter.stf_param_id AND STFResult.stf_result_id=STFResultParameter.stf_result_id AND passed=0 and stf_test_id=23 AND name IN ('noise_positive_max', 'noise_negative_max') AND tag_serial NOT LIKE '%Ref%' and value>=20 and STFResult.date_tested>'2005-02-16 00:00:00' ORDER BY RIGHT(tag_serial,4);







CHECK THE VALUE OF TEST 800000001:



SELECT STFResult.stf_result_id,name,value,tag_serial,date_tested FROM STFResultParameter,STFParameter,STFResult,Product WHERE STFResult.prod_id=Product.prod_id AND STFResultParameter.stf_param_id=STFParameter.stf_param_id AND STFResult.stf_result_id=STFResultParameter.stf_result_id AND passed=0 and stf_test_id=800000001 AND name IN ('flasher_id', 'max_current_err_pct', 'min_peak_brightness_atwd') AND tag_serial NOT LIKE '%Ref%' and STFResult.date_tested>'2005-02-16 00:00:00' ORDER BY name,RIGHT(tag_serial,4);









CHECK THE VALUE OF TEST 800000003:



 SELECT STFResult.stf_result_id,name,value,tag_serial,date_tested FROM STFResultParameter,STFParameter,STFResult,Product WHERE STFResult.prod_id=Product.prod_id AND STFResultParameter.stf_param_id=STFParameter.stf_param_id AND STFResult.stf_result_id=STFResultParameter.stf_result_id AND passed=0 and stf_test_id=800000003 AND name IN ('hv_worst_set_mvolt', 'hv_worst_read_mvolt') AND tag_serial NOT LIKE '%Ref%' and STFResult.date_tested>'2005-02-16 00:00:00' ORDER BY stf_result_id,name,RIGHT(tag_serial,4);





CHECK THE VALUE OF TEST 800000000:



SELECT STFResult.stf_result_id,name,value,tag_serial,date_tested FROM STFResultParameter,STFParameter,STFResult,Product WHERE STFResult.prod_id=Product.prod_id AND STFResultParameter.stf_param_id=STFParameter.stf_param_id AND STFResult.stf_result_id=STFResultParameter.stf_result_id AND passed=0 and stf_test_id=800000000 AND name IN ('hv_read_min_mvolt','hv_read_max_mvolt','hv_read_rms_mvolt') AND tag_serial NOT LIKE '%Ref%' and STFResult.date_tested>'2005-02-16 00:00:00' ORDER BY stf_result_id,name,RIGHT(tag_serial,4);





CHECK THE VALUE OF TEST 8:



SELECT stf_result_id,tag_serial,stf_test_id FROM STFResult,Product WHERE STFResult.prod_id=Product.prod_id AND passed=0 AND stf_test_id IN (8) AND tag_serial NOT LIKE '%Ref%' and STFResult.date_tested>'2005-02-16 00:00:00' ;



CHECK THE VALUE OF TEST 4:



SELECT stf_result_id,tag_serial,stf_test_id FROM STFResult,Product WHERE STFResult.prod_id=Product.prod_id AND passed=0 AND stf_test_id IN (4) AND tag_serial NOT LIKE '%Ref%' and STFResult.date_tested>'2005-02-16 00:00:00' ;