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 DISTINCT rc.rtag_id,
 1 
SELECT DISTINCT rc.rtag_id,
2 
       pkg.pkg_name,
 2 
       pkg.pkg_name,
3 
       pv.pkg_version,
 3 
       pv.pkg_version,
4 
       pv.is_autobuildable,
 4 
       pv.is_autobuildable,
5 
       pv.pv_id,
 5 
       pv.pv_id,
- 
 
 6 
       pv.created_stamp,
- 
 
 7 
       pv.modified_stamp,
6 
       pm.code_lines,
 8 
       pm.code_lines,
7 
       pm.branches,
 9 
       pm.branches,
8 
       (CASE
 10 
       (CASE
9 
         WHEN ut.test_types_fk IS NOT NULL THEN 'Y' ELSE 'N'
 11 
         WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N'
10 
        END) AS unit_tested,
 12 
        END) AS unit_tested,
11 
       autotest_qry.autotested
 13 
       autotest_qry.autotested
12 
  FROM package_metrics pm,
 14 
  FROM package_metrics pm,
13 
       package_versions pv,
 15 
       package_versions pv,
14 
       packages pkg,
 16 
       packages pkg,