Subversion Repositories DevTools

Rev

Rev 5898 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
1336 dpurdie 1 
SELECT *
2 
  FROM   (
3 
 
4 
 
5898 dpurdie 5 
    /* ------- ERROR: Package is unbuildable ------- */
6 
    SELECT DISTINCT 'enum_MSG_UNBUILDABLE_PACKAGE' AS err_message,
7 
           'fixed_issues.asp' AS rfile,
8 
           '#PACKAGE_INFORMATION' AS anchor,
9 
           1 AS priority,
10 
           'ERROR' AS products_msg
11 
     FROM  PACKAGE_VERSIONS pv
12 
     WHERE pv.pv_id = :PV_ID
13 
       AND pv.build_type  = 'U'
14 
 
15 
    UNION
16 
 
1336 dpurdie 17 
      /* ------- ERROR: Missing dependencies from release ------- */
18 
      SELECT DISTINCT 'enum_MSG_MISSING_DEPENDENCIES' AS err_message,
19 
            'dependencies.asp' AS rfile,
20 
             '' AS anchor,
5898 dpurdie 21 
              2 AS priority,
1336 dpurdie 22 
            'ERROR' AS products_msg
23 
        FROM PACKAGE_DEPENDENCIES dep,
24 
             PACKAGE_VERSIONS dpv
25 
       WHERE dep.pv_id = :PV_ID
26 
         AND dep.dpv_id = dpv.pv_id
27 
         AND (dpv.pkg_id, dpv.v_ext) NOT IN
28 
             (
29 
              SELECT pv.pkg_id, pv.v_ext
30 
                FROM RELEASE_CONTENT rel,
31 
                     PACKAGE_VERSIONS pv
32 
               WHERE rel.rtag_id = :RTAG_ID
33 
                 AND rel.pv_id = pv.pv_id
34 
             )
35 
 
36 
      UNION
37 
 
38 
      /* ------- ERROR: Package Information Section - Autobuild with VCS Uncontrolled ------- */
39 
      SELECT DISTINCT 'enum_MSG_AUTOBUILD_PACKAGE_IS_UNCONTROLLED' AS err_message,
40 
             'fixed_issues.asp' AS rfile,
41 
             '#PACKAGE_INFORMATION' AS anchor,
42 
             3 AS priority,
43 
             'ERROR' AS products_msg
44 
        FROM PACKAGE_VERSIONS pv
45 
       WHERE pv.pv_id = :PV_ID
46 
         AND pv.build_type = 'A'
5596 dpurdie 47 
         AND pv.vcs_type_id IN (SELECT vt.vcs_type_id FROM vcs_type vt WHERE vt.tag = 'UC' OR vt.tag = 'CVS')
1336 dpurdie 48 
 
49 
 
50 
      UNION
51 
 
52 
      /* ------- ERROR: Package Information Section Incomplete ------- */
53 
      SELECT DISTINCT 'enum_MSG_PACKAGE_INFORMATION_INCOMPLETE' AS err_message,
54 
             'fixed_issues.asp' AS rfile,
55 
             '#PACKAGE_INFORMATION' AS anchor,
56 
             10 AS priority,
57 
             'ERROR' AS products_msg
58 
        FROM PACKAGE_VERSIONS pv
59 
       WHERE pv.pv_id = :PV_ID
60 
         AND (    pv.PV_DESCRIPTION IS NULL
5596 dpurdie 61 
			   OR Length(pv.PV_DESCRIPTION) < 1
1336 dpurdie 62 
               OR pv.PV_OVERVIEW IS NULL
5596 dpurdie 63 
 			   OR Length(pv.PV_OVERVIEW) < 1
1336 dpurdie 64 
               OR pv.IS_BUILD_ENV_REQUIRED IS NULL
65 
             )
66 
 
67 
      UNION
68 
 
69 
		/* ------- ERROR: Version Control Info ------- */
70 
		SELECT DISTINCT 'enum_MSG_VCS_INFORMATION_INCOMPLETE' AS err_message,
71 
			   'fixed_issues.asp' AS rfile,
72 
		       '#PACKAGE_INFORMATION' AS anchor,
73 
               11 AS priority,
74 
			   'ERROR' AS products_msg
75 
         FROM  PACKAGE_VERSIONS pv,
76 
               VCS_TYPE vt
77 
		 WHERE pv.pv_id = :PV_ID
78 
           AND pv.vcs_type_id  = vt.vcs_type_id
7457 dpurdie 79 
		   AND ( vt.tag != 'UC' AND ( pv.PKG_LABEL IS NULL OR pv.SRC_PATH IS NULL ) )
80 
 
1336 dpurdie 81 
		UNION
82 
 
7457 dpurdie 83 
        /* ------- ERROR: Subversion to CC regression or GIT to Subversion regression ------- */
84 
		SELECT DISTINCT 'enum_MSG_MIXED_VCS' AS err_message,
2365 dpurdie 85 
			   'fixed_issues.asp' AS rfile,
86 
		       '#PACKAGE_INFORMATION' AS anchor,
5898 dpurdie 87 
               12 AS priority,
2365 dpurdie 88 
			   'ERROR' AS products_msg
89 
         FROM  PACKAGE_VERSIONS pv,
7457 dpurdie 90 
               PACKAGES pkg,
2365 dpurdie 91 
               VCS_TYPE vt
7457 dpurdie 92 
         WHERE pv.pv_id = :PV_ID
93 
           AND pv.pkg_id = pkg.pkg_id
2365 dpurdie 94 
           AND pv.vcs_type_id  = vt.vcs_type_id
7457 dpurdie 95 
           AND PK_RMAPI.has_mixed_vcs(vt.tag, pkg.pkg_name) > 0
2365 dpurdie 96 
 
97 
		UNION
98 
 
99 
 
1336 dpurdie 100 
      /* ------- ERROR: Build Std Missing For auto-build package versions ------- */
101 
      SELECT DISTINCT 'enum_MSG_AUTOBUILD_PACKAGE_REQUIRES_BUILD_STD_AND_ENV' AS err_message,
102 
             'fixed_issues.asp' AS rfile,
103 
             '#PACKAGE_INFORMATION' AS anchor,
5898 dpurdie 104 
             13 AS priority,
1336 dpurdie 105 
             'ERROR' AS products_msg
106 
        FROM PACKAGE_VERSIONS pv
107 
       WHERE pv.pv_id = :PV_ID
108 
         AND pv.build_type = 'A'
109 
         AND (pv.bs_id IS NULL OR pv.bs_id = 3)
110 
 
111 
      UNION
112 
 
113 
      /* ------- ERROR: Build Env Missing For auto-build package versions ------- */
114 
      SELECT DECODE( pbi_data.cnt, 0, 'enum_MSG_AUTOBUILD_PACKAGE_REQUIRES_BUILD_STD_AND_ENV', NULL) AS err_message,
115 
             'fixed_issues.asp' AS rfile,
116 
             '#PACKAGE_INFORMATION' AS anchor,
5898 dpurdie 117 
             14 AS priority,
1336 dpurdie 118 
             'ERROR' AS products_msg
119 
        FROM PACKAGE_VERSIONS pv,
120 
        ( SELECT COUNT(*) AS cnt FROM PACKAGE_BUILD_INFO pbi WHERE pbi.pv_id = :PV_ID ) pbi_data
121 
       WHERE pv.pv_id = :PV_ID
122 
         AND pv.build_type = 'A'
123 
         AND NOT (pv.bs_id IS NULL OR pv.bs_id = 3)
124 
 
125 
      UNION
126 
 
127 
        /* ------- ERROR: Reason For This Version ------- */
128 
        SELECT DECODE( pv.COMMENTS,
129 
               NULL, DECODE( fixedcq.cnt, 0, 'enum_MSG_REASON_FOR_THIS_VERSION_NOT_SUPLIED', NULL ), NULL ) AS err_message,
130 
               'fixed_issues.asp' AS rfile,
131 
               '#REASON_FOR_THIS_RELEASE' AS anchor,
5898 dpurdie 132 
               15 AS priority,
1336 dpurdie 133 
               'ERROR' AS products_msg
134 
        FROM (
135 
              SELECT COUNT(*) AS cnt
136 
                FROM CQ_ISSUES cqi
137 
               WHERE cqi.pv_id = :PV_ID
138 
                 AND iss_state = :enumISSUES_STATE_FIXED
139 
             ) fixedcq,
140 
             PACKAGE_VERSIONS pv
141 
       WHERE pv.pv_id = :PV_ID
142 
 
143 
      UNION
144 
 
145 
      /* ------- ERROR: Unit Test Section Incompete ------- */
146 
      SELECT DECODE( COUNT(*), 0, 'enum_MSG_UNIT_TESTS_NOT_SUPPLIED', NULL ) AS err_message,
147 
             'fixed_issues.asp' AS rfile,
148 
             '#UNIT_TESTS' AS anchor,
5898 dpurdie 149 
             16 AS priority,
1336 dpurdie 150 
             'ERROR' AS products_msg
151 
        FROM UNIT_TESTS ut
152 
       WHERE ut.PV_ID = :PV_ID
153 
 
154 
      ) errmsg
155 
ORDER BY priority