Subversion Repositories DevTools

Rev

Rev 5506 | Rev 5898 | 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 
 
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'
5596 dpurdie 35 
         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 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
5596 dpurdie 49 
			   OR Length(pv.PV_DESCRIPTION) < 1
1336 dpurdie 50 
               OR pv.PV_OVERVIEW IS NULL
5596 dpurdie 51 
 			   OR Length(pv.PV_OVERVIEW) < 1
1336 dpurdie 52 
               OR pv.IS_BUILD_ENV_REQUIRED IS NULL
53 
             )
54 
 
55 
      UNION
56 
 
57 
		/* ------- ERROR: Version Control Info ------- */
58 
		SELECT DISTINCT 'enum_MSG_VCS_INFORMATION_INCOMPLETE' AS err_message,
59 
			   'fixed_issues.asp' AS rfile,
60 
		       '#PACKAGE_INFORMATION' AS anchor,
61 
               11 AS priority,
62 
			   'ERROR' AS products_msg
63 
         FROM  PACKAGE_VERSIONS pv,
64 
               VCS_TYPE vt
65 
		 WHERE pv.pv_id = :PV_ID
66 
           AND pv.vcs_type_id  = vt.vcs_type_id
67 
		   AND ( (vt.tag = 'SVN' OR vt.tag = 'CC' or vt.tag = 'CVS')
68 
				   AND (    pv.PKG_LABEL IS NULL
69 
		                 OR pv.SRC_PATH IS NULL
70 
						)
71 
				)
72 
		UNION
73 
 
2365 dpurdie 74 
		/* ------- ERROR: Subversion to CC regression ------- */
75 
		SELECT DISTINCT 'enum_MSG_VCS_SUBVERSION_CC_MIX' AS err_message,
76 
			   'fixed_issues.asp' AS rfile,
77 
		       '#PACKAGE_INFORMATION' AS anchor,
78 
               11 AS priority,
79 
			   'ERROR' AS products_msg
80 
         FROM  PACKAGE_VERSIONS pv,
81 
               VCS_TYPE vt
82 
		 WHERE pv.pv_id = :PV_ID
83 
           AND pv.vcs_type_id  = vt.vcs_type_id
84 
		   AND ( vt.tag = 'CC' or vt.tag = 'CVS' )
85 
		   AND ( PK_RMAPI.IsSVN(pv.pkg_id) > 0 )
86 
 
87 
		UNION
88 
 
89 
 
1336 dpurdie 90 
      /* ------- ERROR: Build Std Missing For auto-build package versions ------- */
91 
      SELECT DISTINCT 'enum_MSG_AUTOBUILD_PACKAGE_REQUIRES_BUILD_STD_AND_ENV' AS err_message,
92 
             'fixed_issues.asp' AS rfile,
93 
             '#PACKAGE_INFORMATION' AS anchor,
94 
             12 AS priority,
95 
             'ERROR' AS products_msg
96 
        FROM PACKAGE_VERSIONS pv
97 
       WHERE pv.pv_id = :PV_ID
98 
         AND pv.build_type = 'A'
99 
         AND (pv.bs_id IS NULL OR pv.bs_id = 3)
100 
 
101 
      UNION
102 
 
103 
      /* ------- ERROR: Build Env Missing For auto-build package versions ------- */
104 
      SELECT DECODE( pbi_data.cnt, 0, 'enum_MSG_AUTOBUILD_PACKAGE_REQUIRES_BUILD_STD_AND_ENV', NULL) AS err_message,
105 
             'fixed_issues.asp' AS rfile,
106 
             '#PACKAGE_INFORMATION' AS anchor,
107 
             13 AS priority,
108 
             'ERROR' AS products_msg
109 
        FROM PACKAGE_VERSIONS pv,
110 
        ( SELECT COUNT(*) AS cnt FROM PACKAGE_BUILD_INFO pbi WHERE pbi.pv_id = :PV_ID ) pbi_data
111 
       WHERE pv.pv_id = :PV_ID
112 
         AND pv.build_type = 'A'
113 
         AND NOT (pv.bs_id IS NULL OR pv.bs_id = 3)
114 
 
115 
      UNION
116 
 
117 
        /* ------- ERROR: Reason For This Version ------- */
118 
        SELECT DECODE( pv.COMMENTS,
119 
               NULL, DECODE( fixedcq.cnt, 0, 'enum_MSG_REASON_FOR_THIS_VERSION_NOT_SUPLIED', NULL ), NULL ) AS err_message,
120 
               'fixed_issues.asp' AS rfile,
121 
               '#REASON_FOR_THIS_RELEASE' AS anchor,
122 
               14 AS priority,
123 
               'ERROR' AS products_msg
124 
        FROM (
125 
              SELECT COUNT(*) AS cnt
126 
                FROM CQ_ISSUES cqi
127 
               WHERE cqi.pv_id = :PV_ID
128 
                 AND iss_state = :enumISSUES_STATE_FIXED
129 
             ) fixedcq,
130 
             PACKAGE_VERSIONS pv
131 
       WHERE pv.pv_id = :PV_ID
132 
 
133 
      UNION
134 
 
135 
      /* ------- ERROR: Unit Test Section Incompete ------- */
136 
      SELECT DECODE( COUNT(*), 0, 'enum_MSG_UNIT_TESTS_NOT_SUPPLIED', NULL ) AS err_message,
137 
             'fixed_issues.asp' AS rfile,
138 
             '#UNIT_TESTS' AS anchor,
139 
             15 AS priority,
140 
             'ERROR' AS products_msg
141 
        FROM UNIT_TESTS ut
142 
       WHERE ut.PV_ID = :PV_ID
143 
 
144 
      ) errmsg
145 
ORDER BY priority