Subversion Repositories DevTools

Rev

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

Rev 5506 Rev 6189
Line 1... Line 1...
1 
/* Release Diff */
 1 
                                                               /* Release Diff */
2 
SELECT qry.*
 2 
SELECT qry.*
3 
    FROM (
 3 
    FROM (
4 
 
 4 
 
5 
       /* Removed Packages */
 5 
       /* Removed Packages */
6 
       SELECT 'R' AS CHANGE_TYPE,
 6 
       SELECT 'R' AS CHANGE_TYPE,
Line 220... Line 220...
220 
         AND :UPDATED IS NULL
 220 
         AND :UPDATED IS NULL
221 
 
 221 
 
222 
       UNION
 222 
       UNION
223 
 
 223 
 
224 
       /* NOT CHANGED Packages - NOTE '0' as change type so these entries appear ahead of additions, in sort order */
 224 
       /* NOT CHANGED Packages - NOTE '0' as change type so these entries appear ahead of additions, in sort order */
225 
       SELECT '0' AS CHANGE_TYPE,
 225 
       SELECT 'B' AS CHANGE_TYPE,
226 
              ra.VIEW_ID,
 226 
              ra.VIEW_ID,
227 
              ra.VIEW_NAME,
 227 
              ra.VIEW_NAME,
228 
              ra.PKG_ID,
 228 
              ra.PKG_ID,
229 
              ra.PV_ID AS PV_ID_A,
 229 
              ra.PV_ID AS PV_ID_A,
230 
              ra.COMMENTS AS COMMENTS_A,
 230 
              ra.COMMENTS AS COMMENTS_A,
Line 255... Line 255...
255 
                 AND pv.PKG_ID = pkg.PKG_ID
 255 
                 AND pv.PKG_ID = pkg.PKG_ID
256 
                 AND v.VIEW_ID = rc.BASE_VIEW_ID
 256 
                 AND v.VIEW_ID = rc.BASE_VIEW_ID
257 
            ) ra,
 257 
            ) ra,
258 
            (
 258 
            (
259 
              /* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */
 259 
              /* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */
260 
              (SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, rc.DEPRECATED_STATE , rc.SDKTAG_ID
 260 
              SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, rc.DEPRECATED_STATE , rc.SDKTAG_ID
261 
                 FROM RELEASE_CONTENT rc,
 261 
                 FROM RELEASE_CONTENT rc,
262 
                      PACKAGE_VERSIONS pv,
 262 
                      PACKAGE_VERSIONS pv,
263 
                      PACKAGES pkg
 263 
                      PACKAGES pkg
264 
                WHERE rc.PV_ID = pv.PV_ID
 264 
                WHERE rc.PV_ID = pv.PV_ID
265 
                  AND rc.RTAG_ID = :RTAG_B
 265 
                  AND rc.RTAG_ID = :RTAG_B
Line 270... Line 270...
270 
                      PACKAGE_VERSIONS pv,
 270 
                      PACKAGE_VERSIONS pv,
271 
                      PACKAGES pkg
 271 
                      PACKAGES pkg
272 
                WHERE pl.PV_ID = pv.PV_ID
 272 
                WHERE pl.PV_ID = pv.PV_ID
273 
                  AND pl.RTAG_ID = :RTAG_B
 273 
                  AND pl.RTAG_ID = :RTAG_B
274 
                  AND pl.operation = 'A'
 274 
                  AND pl.operation = 'A'
275 
                  AND pv.PKG_ID = pkg.PKG_ID)
 275 
                  AND pv.PKG_ID = pkg.PKG_ID
276 
              MINUS
 276 
              MINUS
277 
              SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE, NULL AS SDKTAG_ID
 277 
              SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE, NULL AS SDKTAG_ID
278 
                FROM PLANNED pl,
 278 
                FROM PLANNED pl,
279 
                     PACKAGE_VERSIONS pv,
 279 
                     PACKAGE_VERSIONS pv,
280 
                     PACKAGES pkg
 280 
                     PACKAGES pkg
Line 286... Line 286...
286 
       WHERE ra.PKG_ID = rb.PKG_ID
 286 
       WHERE ra.PKG_ID = rb.PKG_ID
287 
         AND NVL( ra.V_EXT, '|LINK_A_NULL|') = NVL( rb.V_EXT, '|LINK_A_NULL|')
 287 
         AND NVL( ra.V_EXT, '|LINK_A_NULL|') = NVL( rb.V_EXT, '|LINK_A_NULL|')
288 
         AND ra.PV_ID = rb.PV_ID
 288 
         AND ra.PV_ID = rb.PV_ID
289 
         AND :NO_CHANGE IS NULL
 289 
         AND :NO_CHANGE IS NULL
290 
 
 290 
 
- 
 
 291 
      /* All Pending additions and Removals
- 
 
 292 
         Change_Type is set so that these will first
- 
 
 293 
       */
- 
 
 294 
      UNION
- 
 
 295 
             SELECT rb.CHANGE_TYPE AS CHANGE_TYPE,
- 
 
 296 
              ra.VIEW_ID,
- 
 
 297 
              ra.VIEW_NAME,
- 
 
 298 
              ra.PKG_ID,
- 
 
 299 
              ra.PV_ID AS PV_ID_A,
- 
 
 300 
              ra.COMMENTS AS COMMENTS_A,
- 
 
 301 
              ra.PKG_NAME AS PKG_NAME_A,
- 
 
 302 
              ra.PKG_VERSION AS PKG_VERSION_A,
- 
 
 303 
              ra.V_NMM AS MAJOR_MINOR_A,
- 
 
 304 
              get_patch_version(ra.V_MM) AS PATCH_NUMBER_A,
- 
 
 305 
              get_build_number(ra.V_MM) AS BUILD_NUMBER_A,
- 
 
 306 
              ra.DEPRECATED_STATE as PKG_STATE_A,
- 
 
 307 
              NVL2(ra.SDKTAG_ID, 1, 0) AS PKG_SDK_A,
- 
 
 308 
              rb.PV_ID AS PV_ID_B,
- 
 
 309 
              rb.COMMENTS AS COMMENTS_B,
- 
 
 310 
              rb.PKG_NAME AS PKG_NAME_B,
- 
 
 311 
              rb.PKG_VERSION AS PKG_VERSION_B,
- 
 
 312 
              rb.V_NMM AS MAJOR_MINOR_B,
- 
 
 313 
              get_patch_version(rb.V_MM) AS PATCH_NUMBER_B,
- 
 
 314 
              get_build_number(rb.V_MM) AS BUILD_NUMBER_B,
- 
 
 315 
              rb.DEPRECATED_STATE AS PKG_STATE_B,
- 
 
 316 
              NVL2(rb.SDKTAG_ID, 1, 0) AS PKG_SDK_B
- 
 
 317 
       FROM (
- 
 
 318 
              SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, v.VIEW_NAME, v.VIEW_ID, rc.DEPRECATED_STATE, rc.SDKTAG_ID
- 
 
 319 
                FROM RELEASE_CONTENT rc,
- 
 
 320 
                     PACKAGE_VERSIONS pv,
- 
 
 321 
                     PACKAGES pkg,
- 
 
 322 
                     VIEWS v
- 
 
 323 
               WHERE rc.PV_ID = pv.PV_ID
- 
 
 324 
                 AND rc.RTAG_ID = :RTAG_A
- 
 
 325 
                 AND pv.PKG_ID = pkg.PKG_ID
- 
 
 326 
                 AND v.VIEW_ID = rc.BASE_VIEW_ID
- 
 
 327 
            ) ra,
- 
 
 328 
            (
- 
 
 329 
              /* ( Planned@B(Additions) and Planned@B(Subtractions) ) */
- 
 
 330 
              (
- 
 
 331 
               SELECT 'APA' as CHANGE_TYPE, pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE, NULL AS SDKTAG_ID
- 
 
 332 
                 FROM PLANNED pl,
- 
 
 333 
                      PACKAGE_VERSIONS pv,
- 
 
 334 
                      PACKAGES pkg
- 
 
 335 
                WHERE pl.PV_ID = pv.PV_ID
- 
 
 336 
                  AND pl.RTAG_ID = :RTAG_B
- 
 
 337 
                  AND pl.operation = 'A'
- 
 
 338 
                  AND pv.PKG_ID = pkg.PKG_ID)
- 
 
 339 
              UNION
- 
 
 340 
              SELECT 'APS' as CHANGE_TYPE, pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE, NULL AS SDKTAG_ID
- 
 
 341 
                FROM PLANNED pl,
- 
 
 342 
                     PACKAGE_VERSIONS pv,
- 
 
 343 
                     PACKAGES pkg
- 
 
 344 
               WHERE pl.PV_ID = pv.PV_ID
- 
 
 345 
                 AND pl.RTAG_ID = :RTAG_B
- 
 
 346 
                 AND pl.operation = 'S'
- 
 
 347 
                 AND pv.PKG_ID = pkg.PKG_ID
- 
 
 348 
            ) rb
- 
 
 349 
       WHERE ra.PKG_ID = rb.PKG_ID
- 
 
 350 
         AND NVL( ra.V_EXT, '|LINK_A_NULL|') = NVL( rb.V_EXT, '|LINK_A_NULL|')
- 
 
 351 
 
- 
 
 352 
 
291 
    ) qry
 353 
    ) qry
292 
   /* NOTE: Sorting by change type has been added to ensure diff.asp can display items correctly and filter out */
 354 
   /* NOTE: Sorting by change type has been added to ensure diff.asp can display items correctly and filter out */
293 
   /*       duplicates. Order is Unchanged, Additions, Removals, and finally Updates. */
 355 
   /*       duplicates. Order is Pending, Unchanged, Additions, Removals, and finally Updates. */
- 
 
 356 
 
294 
ORDER BY UPPER(qry.VIEW_NAME),UPPER(qry.PKG_NAME_A),CHANGE_TYPE
 357 
ORDER BY UPPER(qry.VIEW_NAME),UPPER(qry.PKG_NAME_A),qry.CHANGE_TYPE
- 
 
 358