Subversion Repositories DevTools

Rev

Rev 5506 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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

            186