Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 119 Rev 125
Line 1... Line 1...
1 
SELECT pkg.pkg_name,
 1 
SELECT pkg.pkg_name,
2 
       pv.pkg_version,
 2 
       pv.pkg_version,
3 
       pv.is_autobuildable,
 3 
       pv.is_autobuildable,
4 
       pm.*,
 4 
       pm.*,
5 
       (CASE
 5 
       (CASE
6 
         WHEN ut.test_types_fk IS NOT NULL THEN 'Y' ELSE 'N'
 6 
         WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N'
7 
        END) AS unit_tested,
 7 
        END) AS unit_tested,
8 
       (CASE
 8 
       (CASE
9 
         WHEN ut.test_types_fk = 7 THEN 'Y' ELSE 'N'
 9 
         WHEN ut.test_types_fk = 7 THEN 'Y' ELSE 'N'
10 
        END) AS autotested
 10 
        END) AS autotested
11 
  FROM package_metrics pm,
 11 
  FROM package_metrics pm,
Line 13... Line 13...
13 
       packages pkg,
 13 
       packages pkg,
14 
       unit_tests ut
 14 
       unit_tests ut
15 
 WHERE pv.pkg_id = pkg.pkg_id
 15 
 WHERE pv.pkg_id = pkg.pkg_id
16 
   AND pv.pv_id = :PV_ID
 16 
   AND pv.pv_id = :PV_ID
17 
   AND pm.pv_id = pv.pv_id
 17 
   AND pm.pv_id = pv.pv_id
18 
   AND ut.pv_id (+) = pv.pv_id
 - 
 
19 

            18
            
   AND ut.pv_id (+) = pv.pv_id

          

          

            -
            
 

            19