Subversion Repositories DevTools

Rev

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

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