Subversion Repositories DevTools

Rev

Rev 1336 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
1336 dpurdie 1 
SELECT *
2 
  FROM	(
3 
 
4 
		/* ------- ERROR: Broken dependencies found ------- */
5 
		SELECT DISTINCT 'enum_MSG_BROKEN_DEPENDENCIES_FOUND' AS err_message,
6 
			   'dependencies.asp' AS rfile,
7 
		       '' AS anchor,
8 
               2 AS priority,
9 
			   'WARNING' AS products_msg
10 
		  FROM (
11 
				-- Get all the dependent package-versions
12 
				SELECT TO_NUMBER(:RTAG_ID) AS RTAG_ID, dep.PV_ID, dep.DPV_ID
13 
                       FROM PACKAGE_DEPENDENCIES dep
14 
					  WHERE dep.PV_ID = :PV_ID
15 
				-- Remove those that are in the release
16 
				MINUS
17 
                	SELECT	rc.RTAG_ID, TO_NUMBER(:PV_ID) AS PV_ID, rc.PV_ID AS DPV_ID
18 
                     FROM	RELEASE_CONTENT rc
19 
					WHERE	rc.RTAG_ID = :RTAG_ID
20 
				-- Remove those that have ignore warnings flagged
21 
				MINUS
22 
                	SELECT	igw.rtag_id, igw.pv_id, igw.dpv_id
23 
                     FROM 	IGNORE_WARNINGS igw
24 
					WHERE 	igw.rtag_id = :RTAG_ID
25 
                    AND 	igw.pv_id = :PV_ID
26 
				-- Remove those that are marked as advisory ripple
27 
				MINUS
28 
					SELECT TO_NUMBER(:RTAG_ID) AS RTAG_ID, dep.PV_ID, dep.DPV_ID
29 
                             FROM	PACKAGE_DEPENDENCIES dep,
30 
									PACKAGE_VERSIONS PV
31 
							WHERE	dep.PV_ID = :PV_ID
32 
							 and	dep.DPV_ID = PV.PV_ID
33 
							 and	PV.PKG_ID
34 
							  in	(
35 
								-- Select PKG_IDs of those packages that are marked as advisory
36 
								SELECT	PV.PKG_ID
37 
								from 	ADVISORY_RIPPLE AR,
38 
										PACKAGE_VERSIONS PV
39 
                                where 	AR.RTAG_ID = :RTAG_ID
40 
                                and 	AR.PV_ID = PV.PV_ID
41 
								)
42 
		        ) broken_dep
43 
 
44 
		UNION
45 
 
46 
		/* ------- ERROR: Missing dependencies from release ------- */
47 
		SELECT DISTINCT 'enum_MSG_MISSING_DEPENDENCIES' AS err_message,
48 
			   'dependencies.asp' AS rfile,
49 
		       '' AS anchor,
50 
               1 AS priority,
51 
			   'ERROR' AS products_msg
52 
		  FROM PACKAGE_DEPENDENCIES dep,
53 
		       PACKAGE_VERSIONS dpv
54 
		 WHERE dep.pv_id = :PV_ID
55 
		   AND dep.dpv_id = dpv.pv_id
56 
		   AND (dpv.pkg_id, dpv.v_ext) NOT IN
57 
		       (
58 
		        SELECT pv.pkg_id, pv.v_ext
59 
		          FROM RELEASE_CONTENT rel,
60 
		               PACKAGE_VERSIONS pv
61 
		         WHERE rel.rtag_id = :RTAG_ID
62 
		           AND rel.pv_id = pv.pv_id
63 
		       )
64 
 
65 
		UNION
66 
 
67 
		/* ------- ERROR: Unofficial dependencies found ------- */
68 
		SELECT DISTINCT 'enum_MSG_UNOFFICIAL_DEPENDENCIES_FOUND' AS err_message,
69 
			   'dependencies.asp' AS rfile,
70 
		       '' AS anchor,
71 
               3 AS priority,
72 
			   'ERROR' AS products_msg
73 
		  FROM PACKAGE_DEPENDENCIES dep,
74 
		       PACKAGE_VERSIONS dpv
75 
		 WHERE dep.dpv_id = dpv.pv_id
76 
		   AND dep.pv_id = :PV_ID
77 
		   AND dpv.dlocked = 'N'
78 
 
79 
		UNION
80 
 
81 
		/* ------- ERROR: Package Information Section Incomplete ------- */
82 
		SELECT DISTINCT 'enum_MSG_PACKAGE_INFORMATION_INCOMPLETE' AS err_message,
83 
			   'fixed_issues.asp' AS rfile,
84 
		       '#PACKAGE_INFORMATION' AS anchor,
85 
               10 AS priority,
86 
			   'ERROR' AS products_msg
87 
		  FROM PACKAGE_VERSIONS pv
88 
		 WHERE pv.pv_id = :PV_ID
89 
		   AND (    pv.PV_DESCRIPTION IS NULL
90 
		   		 OR pv.PV_OVERVIEW IS NULL
91 
				 OR pv.IS_BUILD_ENV_REQUIRED IS NULL
92 
		       )
93 
 
94 
		UNION
95 
 
96 
		/* ------- ERROR: Version Control Info ------- */
97 
		SELECT DISTINCT 'enum_MSG_VCS_INFORMATION_INCOMPLETE' AS err_message,
98 
			   'fixed_issues.asp' AS rfile,
99 
		       '#PACKAGE_INFORMATION' AS anchor,
100 
               11 AS priority,
101 
			   'ERROR' AS products_msg
102 
         FROM  PACKAGE_VERSIONS pv,
103 
               VCS_TYPE vt
104 
		 WHERE pv.pv_id = :PV_ID
105 
           AND pv.vcs_type_id  = vt.vcs_type_id
106 
		   AND ( (vt.tag = 'SVN' OR vt.tag = 'CC' or vt.tag = 'CVS')
107 
				   AND (    pv.PKG_LABEL IS NULL
108 
		                 OR pv.SRC_PATH IS NULL
109 
						)
110 
				)
111 
		UNION
112 
 
1372 dpurdie 113 
		/* ------- ERROR: Manually Versioned SVN Packages must have PEG ------- */
114 
		SELECT DISTINCT 'enum_MSG_VCS_SVN_NOT_PEGGED' AS err_message,
115 
			   'fixed_issues.asp' AS rfile,
116 
		       '#PACKAGE_INFORMATION' AS anchor,
117 
               11 AS priority,
118 
			   'ERROR' AS products_msg
119 
         FROM  PACKAGE_VERSIONS pv,
120 
               VCS_TYPE vt
121 
		 WHERE pv.pv_id = :PV_ID
122 
           AND pv.vcs_type_id  = vt.vcs_type_id
123 
		   AND pv.build_type = 'M'
124 
		   AND vt.tag = 'SVN'
125 
		   AND NOT REGEXP_LIKE( pv.PKG_LABEL, '@[0-9]+$')
126 
		UNION
127 
 
128 
 
1336 dpurdie 129 
     	/* ------- ERROR: Reason For This Version ------- */
130 
        SELECT DECODE( pv.COMMENTS,
131 
        			   NULL, DECODE( fixedcq.cnt, 0, 'enum_MSG_REASON_FOR_THIS_VERSION_NOT_SUPLIED', NULL ), NULL ) AS err_message,
132 
               'fixed_issues.asp' AS rfile,
133 
		       '#REASON_FOR_THIS_RELEASE' AS anchor,
134 
               12 AS priority,
135 
			   'ERROR' AS products_msg
136 
		  FROM (
137 
		        SELECT COUNT(*) AS cnt
138 
		          FROM CQ_ISSUES cqi
139 
		         WHERE cqi.pv_id = :PV_ID
140 
		           AND iss_state = :enumISSUES_STATE_FIXED
141 
          		) fixedcq,
142 
                PACKAGE_VERSIONS pv
143 
		 WHERE pv.pv_id = :PV_ID
144 
 
145 
		UNION
146 
 
147 
		/* ------- ERROR: Unit Test Section Incompete ------- */
148 
		SELECT DECODE( COUNT(*), 0, 'enum_MSG_UNIT_TESTS_NOT_SUPPLIED', NULL ) AS err_message,
149 
			   'fixed_issues.asp' AS rfile,
150 
		       '#UNIT_TESTS' AS anchor,
151 
               13 AS priority,
152 
			   'ERROR' AS products_msg
153 
		  FROM UNIT_TESTS ut
154 
		 WHERE ut.PV_ID = :PV_ID
155 
 
156 
		) errmsg
157 
ORDER BY priority