Subversion Repositories DevTools

Rev

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

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