Subversion Repositories DevTools

Rev

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

Rev 5596 Rev 5898
Line 1... Line 1...
1 
SELECT *
 1 
SELECT *
2 
  FROM   (
 2 
  FROM   (
3 
 
 3 
 
4 
 
 4 
 
- 
 
 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 
 
5 
      /* ------- ERROR: Missing dependencies from release ------- */
 17 
      /* ------- ERROR: Missing dependencies from release ------- */
6 
      SELECT DISTINCT 'enum_MSG_MISSING_DEPENDENCIES' AS err_message,
 18 
      SELECT DISTINCT 'enum_MSG_MISSING_DEPENDENCIES' AS err_message,
7 
            'dependencies.asp' AS rfile,
 19 
            'dependencies.asp' AS rfile,
8 
             '' AS anchor,
 20 
             '' AS anchor,
9 
               1 AS priority,
 21 
              2 AS priority,
10 
            'ERROR' AS products_msg
 22 
            'ERROR' AS products_msg
11 
        FROM PACKAGE_DEPENDENCIES dep,
 23 
        FROM PACKAGE_DEPENDENCIES dep,
12 
             PACKAGE_VERSIONS dpv
 24 
             PACKAGE_VERSIONS dpv
13 
       WHERE dep.pv_id = :PV_ID
 25 
       WHERE dep.pv_id = :PV_ID
14 
         AND dep.dpv_id = dpv.pv_id
 26 
         AND dep.dpv_id = dpv.pv_id
Line 73... Line 85...
73 
 
 85 
 
74 
		/* ------- ERROR: Subversion to CC regression ------- */
 86 
		/* ------- ERROR: Subversion to CC regression ------- */
75 
		SELECT DISTINCT 'enum_MSG_VCS_SUBVERSION_CC_MIX' AS err_message,
 87 
		SELECT DISTINCT 'enum_MSG_VCS_SUBVERSION_CC_MIX' AS err_message,
76 
			   'fixed_issues.asp' AS rfile,
 88 
			   'fixed_issues.asp' AS rfile,
77 
		       '#PACKAGE_INFORMATION' AS anchor,
 89 
		       '#PACKAGE_INFORMATION' AS anchor,
78 
               11 AS priority,
 90 
               12 AS priority,
79 
			   'ERROR' AS products_msg
 91 
			   'ERROR' AS products_msg
80 
         FROM  PACKAGE_VERSIONS pv,
 92 
         FROM  PACKAGE_VERSIONS pv,
81 
               VCS_TYPE vt
 93 
               VCS_TYPE vt
82 
		 WHERE pv.pv_id = :PV_ID
 94 
		 WHERE pv.pv_id = :PV_ID
83 
           AND pv.vcs_type_id  = vt.vcs_type_id
 95 
           AND pv.vcs_type_id  = vt.vcs_type_id
Line 89... Line 101...
89 
 
 101 
 
90 
      /* ------- ERROR: Build Std Missing For auto-build package versions ------- */
 102 
      /* ------- ERROR: Build Std Missing For auto-build package versions ------- */
91 
      SELECT DISTINCT 'enum_MSG_AUTOBUILD_PACKAGE_REQUIRES_BUILD_STD_AND_ENV' AS err_message,
 103 
      SELECT DISTINCT 'enum_MSG_AUTOBUILD_PACKAGE_REQUIRES_BUILD_STD_AND_ENV' AS err_message,
92 
             'fixed_issues.asp' AS rfile,
 104 
             'fixed_issues.asp' AS rfile,
93 
             '#PACKAGE_INFORMATION' AS anchor,
 105 
             '#PACKAGE_INFORMATION' AS anchor,
94 
             12 AS priority,
 106 
             13 AS priority,
95 
             'ERROR' AS products_msg
 107 
             'ERROR' AS products_msg
96 
        FROM PACKAGE_VERSIONS pv
 108 
        FROM PACKAGE_VERSIONS pv
97 
       WHERE pv.pv_id = :PV_ID
 109 
       WHERE pv.pv_id = :PV_ID
98 
         AND pv.build_type = 'A'
 110 
         AND pv.build_type = 'A'
99 
         AND (pv.bs_id IS NULL OR pv.bs_id = 3)
 111 
         AND (pv.bs_id IS NULL OR pv.bs_id = 3)
Line 102... Line 114...
102 
 
 114 
 
103 
      /* ------- ERROR: Build Env Missing For auto-build package versions ------- */
 115 
      /* ------- 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,
 116 
      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,
 117 
             'fixed_issues.asp' AS rfile,
106 
             '#PACKAGE_INFORMATION' AS anchor,
 118 
             '#PACKAGE_INFORMATION' AS anchor,
107 
             13 AS priority,
 119 
             14 AS priority,
108 
             'ERROR' AS products_msg
 120 
             'ERROR' AS products_msg
109 
        FROM PACKAGE_VERSIONS pv,
 121 
        FROM PACKAGE_VERSIONS pv,
110 
        ( SELECT COUNT(*) AS cnt FROM PACKAGE_BUILD_INFO pbi WHERE pbi.pv_id = :PV_ID ) pbi_data
 122 
        ( SELECT COUNT(*) AS cnt FROM PACKAGE_BUILD_INFO pbi WHERE pbi.pv_id = :PV_ID ) pbi_data
111 
       WHERE pv.pv_id = :PV_ID
 123 
       WHERE pv.pv_id = :PV_ID
112 
         AND pv.build_type = 'A'
 124 
         AND pv.build_type = 'A'
Line 117... Line 129...
117 
        /* ------- ERROR: Reason For This Version ------- */
 129 
        /* ------- ERROR: Reason For This Version ------- */
118 
        SELECT DECODE( pv.COMMENTS,
 130 
        SELECT DECODE( pv.COMMENTS,
119 
               NULL, DECODE( fixedcq.cnt, 0, 'enum_MSG_REASON_FOR_THIS_VERSION_NOT_SUPLIED', NULL ), NULL ) AS err_message,
 131 
               NULL, DECODE( fixedcq.cnt, 0, 'enum_MSG_REASON_FOR_THIS_VERSION_NOT_SUPLIED', NULL ), NULL ) AS err_message,
120 
               'fixed_issues.asp' AS rfile,
 132 
               'fixed_issues.asp' AS rfile,
121 
               '#REASON_FOR_THIS_RELEASE' AS anchor,
 133 
               '#REASON_FOR_THIS_RELEASE' AS anchor,
122 
               14 AS priority,
 134 
               15 AS priority,
123 
               'ERROR' AS products_msg
 135 
               'ERROR' AS products_msg
124 
        FROM (
 136 
        FROM (
125 
              SELECT COUNT(*) AS cnt
 137 
              SELECT COUNT(*) AS cnt
126 
                FROM CQ_ISSUES cqi
 138 
                FROM CQ_ISSUES cqi
127 
               WHERE cqi.pv_id = :PV_ID
 139 
               WHERE cqi.pv_id = :PV_ID
Line 134... Line 146...
134 
 
 146 
 
135 
      /* ------- ERROR: Unit Test Section Incompete ------- */
 147 
      /* ------- ERROR: Unit Test Section Incompete ------- */
136 
      SELECT DECODE( COUNT(*), 0, 'enum_MSG_UNIT_TESTS_NOT_SUPPLIED', NULL ) AS err_message,
 148 
      SELECT DECODE( COUNT(*), 0, 'enum_MSG_UNIT_TESTS_NOT_SUPPLIED', NULL ) AS err_message,
137 
             'fixed_issues.asp' AS rfile,
 149 
             'fixed_issues.asp' AS rfile,
138 
             '#UNIT_TESTS' AS anchor,
 150 
             '#UNIT_TESTS' AS anchor,
139 
             15 AS priority,
 151 
             16 AS priority,
140 
             'ERROR' AS products_msg
 152 
             'ERROR' AS products_msg
141 
        FROM UNIT_TESTS ut
 153 
        FROM UNIT_TESTS ut
142 
       WHERE ut.PV_ID = :PV_ID
 154 
       WHERE ut.PV_ID = :PV_ID
143 
 
 155 
 
144 
      ) errmsg
 156 
      ) errmsg