Subversion Repositories DevTools

Rev

Rev 5596 | 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 
 
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
79 
		   AND ( (vt.tag = 'SVN' OR vt.tag = 'CC' or vt.tag = 'CVS')
80 
				   AND (    pv.PKG_LABEL IS NULL
81 
		                 OR pv.SRC_PATH IS NULL
82 
						)
83 
				)
84 
		UNION
85 
 
2365 dpurdie 86 
		/* ------- ERROR: Subversion to CC regression ------- */
87 
		SELECT DISTINCT 'enum_MSG_VCS_SUBVERSION_CC_MIX' AS err_message,
88 
			   'fixed_issues.asp' AS rfile,
89 
		       '#PACKAGE_INFORMATION' AS anchor,
5898 dpurdie 90 
               12 AS priority,
2365 dpurdie 91 
			   'ERROR' AS products_msg
92 
         FROM  PACKAGE_VERSIONS pv,
93 
               VCS_TYPE vt
94 
		 WHERE pv.pv_id = :PV_ID
95 
           AND pv.vcs_type_id  = vt.vcs_type_id
96 
		   AND ( vt.tag = 'CC' or vt.tag = 'CVS' )
97 
		   AND ( PK_RMAPI.IsSVN(pv.pkg_id) > 0 )
98 
 
99 
		UNION
100 
 
101 
 
1336 dpurdie 102 
      /* ------- ERROR: Build Std Missing For auto-build package versions ------- */
103 
      SELECT DISTINCT 'enum_MSG_AUTOBUILD_PACKAGE_REQUIRES_BUILD_STD_AND_ENV' AS err_message,
104 
             'fixed_issues.asp' AS rfile,
105 
             '#PACKAGE_INFORMATION' AS anchor,
5898 dpurdie 106 
             13 AS priority,
1336 dpurdie 107 
             'ERROR' AS products_msg
108 
        FROM PACKAGE_VERSIONS pv
109 
       WHERE pv.pv_id = :PV_ID
110 
         AND pv.build_type = 'A'
111 
         AND (pv.bs_id IS NULL OR pv.bs_id = 3)
112 
 
113 
      UNION
114 
 
115 
      /* ------- ERROR: Build Env Missing For auto-build package versions ------- */
116 
      SELECT DECODE( pbi_data.cnt, 0, 'enum_MSG_AUTOBUILD_PACKAGE_REQUIRES_BUILD_STD_AND_ENV', NULL) AS err_message,
117 
             'fixed_issues.asp' AS rfile,
118 
             '#PACKAGE_INFORMATION' AS anchor,
5898 dpurdie 119 
             14 AS priority,
1336 dpurdie 120 
             'ERROR' AS products_msg
121 
        FROM PACKAGE_VERSIONS pv,
122 
        ( SELECT COUNT(*) AS cnt FROM PACKAGE_BUILD_INFO pbi WHERE pbi.pv_id = :PV_ID ) pbi_data
123 
       WHERE pv.pv_id = :PV_ID
124 
         AND pv.build_type = 'A'
125 
         AND NOT (pv.bs_id IS NULL OR pv.bs_id = 3)
126 
 
127 
      UNION
128 
 
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,
5898 dpurdie 134 
               15 AS priority,
1336 dpurdie 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,
5898 dpurdie 151 
             16 AS priority,
1336 dpurdie 152 
             'ERROR' AS products_msg
153 
        FROM UNIT_TESTS ut
154 
       WHERE ut.PV_ID = :PV_ID
155 
 
156 
      ) errmsg
157 
ORDER BY priority