Subversion Repositories DevTools

Rev

Rev 4201 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 4201 Rev 4212
Line 503... Line 503...
503
         * 6     113    UnfinishedProduct            .tim  6.TIM.WIP \vob\UnfinishedProduct            M
503
         * 6     113    UnfinishedProduct            .tim  6.TIM.WIP \vob\UnfinishedProduct            M
504
         * 25    45     Banana                       .tim  B.TIM.WIP \vob\Banana                       M
504
         * 25    45     Banana                       .tim  B.TIM.WIP \vob\Banana                       M
505
         */
505
         */
506
         if ( mConnectionString.compareTo("iteration1") == 0 )
506
         if ( mConnectionString.compareTo("iteration1") == 0 )
507
         {
507
         {
508
           Package p = new Package(0, "UncommonDependency", ".tim", "UncommonDependency.tim", "CC::/vob/UncommonDependency::0.TIM.WIP", 'P', 'b');
508
           Package p = new Package(0, "UncommonDependency", ".tim", "UncommonDependency.tim", "CC::/vob/UncommonDependency::0.TIM.WIP", 'P', 'b', "1.0.0000");
509
           p.mPid = 76;
509
           p.mPid = 76;
510
           p.mDirectlyPlanned = true;
510
           p.mDirectlyPlanned = true;
511
           packageCollection.add(p);
511
           packageCollection.add(p);
512
         }
512
         }
513
         
513
         
514
         Package p = new Package(1, "DependencyMissingFromRelease", ".tim", "DependencyMissingFromRelease.tim", "CC::/vob/DependencyMissingFromRelease::1.TIM.WIP", 'M', 'b');
514
         Package p = new Package(1, "DependencyMissingFromRelease", ".tim", "DependencyMissingFromRelease.tim", "CC::/vob/DependencyMissingFromRelease::1.TIM.WIP", 'M', 'b', "1.0.0000");
515
         p.mPid = 1011;
515
         p.mPid = 1011;
516
         p.mDirectlyPlanned = true;
516
         p.mDirectlyPlanned = true;
517
         packageCollection.add(p);
517
         packageCollection.add(p);
518
         
518
         
519
         if ( mConnectionString.compareTo("iteration1") == 0 || mConnectionString.compareTo("iteration2") == 0 )
519
         if ( mConnectionString.compareTo("iteration1") == 0 || mConnectionString.compareTo("iteration2") == 0 )
520
         {
520
         {
521
           p = new Package(2, "CommonDependency", ".tim", "CommonDependency.tim", "CC::/vob/CommonDependency::2.TIM.WIP", 'M', 'b');
521
           p = new Package(2, "CommonDependency", ".tim", "CommonDependency.tim", "CC::/vob/CommonDependency::2.TIM.WIP", 'M', 'b', "1.0.0000");
522
           p.mPid = 34;
522
           p.mPid = 34;
523
           p.mDirectlyPlanned = true;
523
           p.mDirectlyPlanned = true;
524
           packageCollection.add(p);
524
           packageCollection.add(p);
525
         }
525
         }
526
         
526
         
527
         if ( mConnectionString.compareTo("iteration1") == 0 
527
         if ( mConnectionString.compareTo("iteration1") == 0 
528
           || mConnectionString.compareTo("iteration2") == 0
528
           || mConnectionString.compareTo("iteration2") == 0
529
           || mConnectionString.compareTo("iteration3") == 0 )
529
           || mConnectionString.compareTo("iteration3") == 0 )
530
         {
530
         {
531
           p = new Package(3, "SolarisCentricProduct", ".tim", "SolarisCentricProduct.tim", "CC::/vob/SolarisCentricProduct::3.TIM.WIP", 'N', 'b');
531
           p = new Package(3, "SolarisCentricProduct", ".tim", "SolarisCentricProduct.tim", "CC::/vob/SolarisCentricProduct::3.TIM.WIP", 'N', 'b', "1.0.0000");
532
           p.mPid = 908;
532
           p.mPid = 908;
533
           p.mDirectlyPlanned = true;
533
           p.mDirectlyPlanned = true;
534
           packageCollection.add(p);
534
           packageCollection.add(p);
535
         }
535
         }
536
         
536
         
537
         if ( mConnectionString.compareTo("iteration1") == 0 
537
         if ( mConnectionString.compareTo("iteration1") == 0 
538
           || mConnectionString.compareTo("iteration2") == 0
538
           || mConnectionString.compareTo("iteration2") == 0
539
           || mConnectionString.compareTo("iteration3") == 0
539
           || mConnectionString.compareTo("iteration3") == 0
540
           || mConnectionString.compareTo("iteration4") == 0 )
540
           || mConnectionString.compareTo("iteration4") == 0 )
541
         {
541
         {
542
           p = new Package(4, "GenericProduct", ".tim", "GenericProduct.tim", "CC::/vob/GenericProduct::4.TIM.WIP", 'P', 'b');
542
           p = new Package(4, "GenericProduct", ".tim", "GenericProduct.tim", "CC::/vob/GenericProduct::4.TIM.WIP", 'P', 'b', "1.0.0000");
543
           p.mPid = 6;
543
           p.mPid = 6;
544
           p.mDirectlyPlanned = true;
544
           p.mDirectlyPlanned = true;
545
           packageCollection.add(p);
545
           packageCollection.add(p);
546
         }
546
         }
547
         
547
         
Line 549... Line 549...
549
           || mConnectionString.compareTo("iteration2") == 0
549
           || mConnectionString.compareTo("iteration2") == 0
550
           || mConnectionString.compareTo("iteration3") == 0
550
           || mConnectionString.compareTo("iteration3") == 0
551
           || mConnectionString.compareTo("iteration4") == 0
551
           || mConnectionString.compareTo("iteration4") == 0
552
           || mConnectionString.compareTo("iteration5") == 0 )
552
           || mConnectionString.compareTo("iteration5") == 0 )
553
         {
553
         {
554
           p = new Package(5, "Product", ".tim", "Product.tim", "CC::/vob/Product::5.TIM.WIP", 'M', 'b');
554
           p = new Package(5, "Product", ".tim", "Product.tim", "CC::/vob/Product::5.TIM.WIP", 'M', 'b', "1.0.0000");
555
           p.mPid = 11;
555
           p.mPid = 11;
556
           p.mDirectlyPlanned = true;
556
           p.mDirectlyPlanned = true;
557
           packageCollection.add(p);
557
           packageCollection.add(p);
558
         }
558
         }
559
        
559
        
560
         p = new Package(6, "UnfinishedProduct", ".tim", "UnfinishedProduct.tim", "CC::/vob/UnfinishedProduct::6.TIM.WIP", 'M', 'b');
560
         p = new Package(6, "UnfinishedProduct", ".tim", "UnfinishedProduct.tim", "CC::/vob/UnfinishedProduct::6.TIM.WIP", 'M', 'b', "1.0.0000");
561
         p.mPid = 113;
561
         p.mPid = 113;
562
         p.mDirectlyPlanned = true;
562
         p.mDirectlyPlanned = true;
563
         packageCollection.add(p);
563
         packageCollection.add(p);
564
         
564
         
565
         if ( mConnectionString.compareTo("iteration1") == 0 )
565
         if ( mConnectionString.compareTo("iteration1") == 0 )
566
         {
566
         {
567
           p = new Package(25, "Banana", ".tim", "Banana.tim", "CC::B.TIM.WIP/vob/Banana", 'M', 'b');
567
           p = new Package(25, "Banana", ".tim", "Banana.tim", "CC::B.TIM.WIP/vob/Banana", 'M', 'b', "1.0.0000");
568
           p.mPid = 45;
568
           p.mPid = 45;
569
           p.mDirectlyPlanned = true;
569
           p.mDirectlyPlanned = true;
570
           packageCollection.add(p);
570
           packageCollection.add(p);
571
         }
571
         }
572
         
572
         
Line 1518... Line 1518...
1518
          Vector<String> globalAndProjectWideBuildFailureEmailCollection = new Vector<String>();
1518
          Vector<String> globalAndProjectWideBuildFailureEmailCollection = new Vector<String>();
1519
          globalAndProjectWideBuildFailureEmailCollection.add(queryGlobalAddresses());
1519
          globalAndProjectWideBuildFailureEmailCollection.add(queryGlobalAddresses());
1520
 
1520
 
1521
          CallableStatement stmt0 = mConnection.prepareCall(
1521
          CallableStatement stmt0 = mConnection.prepareCall(
1522
          "select u.user_email " +
1522
          "select u.user_email " +
1523
          "from release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u, release_manager.views v, release_manager.release_tags rt " +
1523
          "from release_manager.autobuild_failure af, " + 
-
 
1524
                "release_manager.members_group mg, " + 
-
 
1525
                "release_manager.users u, " + 
-
 
1526
                "release_manager.views v, " + 
-
 
1527
                "release_manager.release_tags rt " +
1524
          "where rt.rtag_id=" + baseline + " " +
1528
          "where rt.rtag_id=" + baseline + " " +
1525
          "and v.view_name='PROJECT WIDE' " +
1529
          "and v.view_name='PROJECT WIDE' " +
1526
          "and af.proj_id=rt.proj_id " +
1530
          "and af.proj_id=rt.proj_id " +
1527
          "and af.view_id=v.view_id " +
1531
          "and af.view_id=v.view_id " +
1528
          "and mg.group_email_id=af.group_email_id " +
1532
          "and mg.group_email_id=af.group_email_id " +
Line 1543... Line 1547...
1543
          rset0.close();
1547
          rset0.close();
1544
          stmt0.close();
1548
          stmt0.close();
1545
          
1549
          
1546
          // get planned package info
1550
          // get planned package info
1547
          // devi 48629 support multiple wips on the same package and build in the order they were released
1551
          // devi 48629 support multiple wips on the same package and build in the order they were released
-
 
1552
          // These are packages that are marked as pending build
-
 
1553
          //
1548
          mLogger.warn("queryPackageVersions: stmt1");
1554
          mLogger.warn("queryPackageVersions: stmt1");
1549
          CallableStatement stmt1 = mConnection.prepareCall(
1555
          CallableStatement stmt1 = mConnection.prepareCall(
1550
                "select pl.pv_id, p.pkg_id, p.pkg_name," +
1556
                "select pl.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, " +
1551
                       "pv.v_ext, pv.change_type, pv.ripple_field," +
1557
                       "pv.v_ext, pv.change_type, pv.ripple_field," +
1552
                       "pv.major_limit, pv.minor_limit, pv.patch_limit, pv.build_number_limit," +
1558
                       "pv.major_limit, pv.minor_limit, pv.patch_limit, pv.build_number_limit," +
1553
                       "pv.modified_stamp," +
1559
                       "pv.modified_stamp," +
1554
                       "release_manager.PK_RMAPI.return_vcs_tag(pl.pv_id) AS vcsTag" +
1560
                       "release_manager.PK_RMAPI.return_vcs_tag(pl.pv_id) AS vcsTag" +
1555
                " from release_manager.planned pl," +
1561
                " from release_manager.planned pl," +
Line 1589... Line 1595...
1589
              mLogger.fatal("queryPackageVersions rset1 null pkg_name " + pv_id);
1595
              mLogger.fatal("queryPackageVersions rset1 null pkg_name " + pv_id);
1590
              // show stopper
1596
              // show stopper
1591
              throw new Exception("queryPackageVersions rset1 null pkg_name " + pv_id);
1597
              throw new Exception("queryPackageVersions rset1 null pkg_name " + pv_id);
1592
            }
1598
            }
1593
 
1599
 
-
 
1600
            String pkg_version = rset1.getString("pkg_version");
-
 
1601
            if (pkg_version == null) 
-
 
1602
            {
-
 
1603
                pkg_version = "1.0.0000";
-
 
1604
                mLogger.fatal("queryPackageVersions rset1 null pkg_version " + pv_id);
-
 
1605
                // show stopper
-
 
1606
                throw new Exception("queryPackageVersions rset1 null pkg_version " + pv_id);
-
 
1607
            }
-
 
1608
 
1594
            String v_ext = rset1.getString("v_ext");
1609
            String v_ext = rset1.getString("v_ext");
1595
             
1610
             
1596
            if ( v_ext == null )
1611
            if ( v_ext == null )
1597
            {
1612
            {
1598
              v_ext = "";
1613
              v_ext = "";
Line 1617... Line 1632...
1617
            }
1632
            }
1618
            else if ( change_type.compareTo("P") == 0 )
1633
            else if ( change_type.compareTo("P") == 0 )
1619
            {
1634
            {
1620
              ct = 'P';
1635
              ct = 'P';
1621
            }
1636
            }
-
 
1637
            else if ( change_type.compareTo("F") == 0 )
-
 
1638
            {
-
 
1639
              ct = 'F';
-
 
1640
            }
1622
            
1641
            
1623
            if ( ct != 'x' )
1642
            if ( ct != 'x' )
1624
            {
1643
            {
1625
              String ripple_field = rset1.getString("ripple_field");
1644
              String ripple_field = rset1.getString("ripple_field");
1626
              
1645
              
Line 1665... Line 1684...
1665
              if ( vcs_tag == null )
1684
              if ( vcs_tag == null )
1666
              {
1685
              {
1667
                vcs_tag = "";
1686
                vcs_tag = "";
1668
              }
1687
              }
1669
              
1688
              
1670
              Package p = new Package(pv_id, pkg_name, v_ext, pkg_name + v_ext, vcs_tag, ct, ripple_field.charAt(0));
1689
              Package p = new Package(pv_id, pkg_name, v_ext, pkg_name + v_ext, vcs_tag, ct, ripple_field.charAt(0), pkg_version);
1671
              p.mPid = pkg_id;
1690
              p.mPid = pkg_id;
1672
              p.mDirectlyPlanned = true;
1691
              p.mDirectlyPlanned = true;
1673
              p.mMajorLimit = major_limit;
1692
              p.mMajorLimit = major_limit;
1674
              p.mMinorLimit = minor_limit;
1693
              p.mMinorLimit = minor_limit;
1675
              p.mPatchLimit = patch_limit;
1694
              p.mPatchLimit = patch_limit;
Line 2032... Line 2051...
2032
          
2051
          
2033
          rset7.close();
2052
          rset7.close();
2034
          stmt7.close();
2053
          stmt7.close();
2035
          
2054
          
2036
          // get released package info
2055
          // get released package info
-
 
2056
          //    Get package information on ALL released packages within the release of interest
-
 
2057
          //
2037
          mLogger.warn("queryPackageVersions: stmt8");
2058
          mLogger.warn("queryPackageVersions: stmt8");
2038
          CallableStatement stmt8 = mConnection.prepareCall(
2059
          CallableStatement stmt8 = mConnection.prepareCall(
2039
            "select rc.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext," +
2060
            "select rc.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext," +
2040
                "pv.ripple_field,pv.major_limit, pv.minor_limit, pv.patch_limit," +
2061
                "pv.ripple_field,pv.major_limit, pv.minor_limit, pv.patch_limit," +
2041
                "pv.build_number_limit," +
2062
                "pv.build_number_limit," +