WebSVN – DevTools – Diff – /buildtool/trunk/src/generated/com/erggroup/buildtool/ripple/ReleaseManager.java



            if ( ct != 'x' )
            {
              Package p = new Package(pv_id, pkg_name, v_ext, pkg_name + v_ext, pkg_label, src_path, ct);
              p.mPid = pkg_id;
              p.mDirectlyPlanned = true;
              Package plannedPackage = findPackage(p.mAlias, packageCollection);
              
              if ( plannedPackage == NULL_PACKAGE )
              {
                mLogger.info("queryPackageVersions rset1 no previous planned package " + pv_id);
                packageCollection.add(p);
              }
            }
          }
          
          rset1.close();
          stmt1.close();
 
          // get planned package dependency info
          CallableStatement stmt2 = mConnection.prepareCall(
          "select pl.pv_id, p.pkg_name, dpv.v_ext, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +
          "where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and pd.pv_id=pl.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +
          "order by pv.modified_stamp"
          );
          ResultSet rset2 = stmt2.executeQuery();
            
          while( rset2.next() )
          {

            
            Package p = findPackage(pv_id, packageCollection);
            
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset2 package superceded by planned " + pv_id);
 
              ignore = true;
            }
            
            String pkg_name = rset2.getString("pkg_name");
            

          rset2.close();
          stmt2.close();
          
          // get planned package build info
          CallableStatement stmt3 = mConnection.prepareCall(
          "select pl.pv_id, bm.bm_name, bsa.bsa_name, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +
          "where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and pbi.pv_id=pv.pv_id and bm.bm_id=pbi.bm_id and bsa.bsa_id=pbi.bsa_id " +
          "order by pv.modified_stamp"
          );
          ResultSet rset3 = stmt3.executeQuery();
             
          while( rset3.next() )
          {

             
            Package p = findPackage(pv_id, packageCollection);
             
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset3 package superceded by planned " + pv_id);
 
              ignore = true;
            }
             
            String bm_name = rset3.getString("bm_name");
             

          rset3.close();
          stmt3.close();
 
          // get planned package unit test info
          CallableStatement stmt4 = mConnection.prepareCall(
          "select pl.pv_id, tt.test_type_name, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +
          "where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and ut.pv_id=pv.pv_id and tt.test_type_id=ut.test_types_fk " +
          "order by pv.modified_stamp"
          );
          ResultSet rset4 = stmt4.executeQuery();
             
          while( rset4.next() )
          {

             
            Package p = findPackage(pv_id, packageCollection);
             
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset4 package superceded by planned " + pv_id);
 
              ignore = true;
            }
             
            String test_type_name = rset4.getString("test_type_name");
             

          stmt4.close();
 
          // get planned package build failure info...
          // global and project wide based
          CallableStatement stmt50 = mConnection.prepareCall(
          "select pl.pv_id, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv " +
          "where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id " +
          "order by pv.modified_stamp"
          );
          ResultSet rset50 = stmt50.executeQuery();
              
          while( rset50.next() )
          {

              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset50 package superceded by planned " + pv_id);
 
            }
            else
            {
              for (Iterator<String> it = globalAndProjectWideBuildFailureEmailCollection.iterator(); it.hasNext(); )
              {

          rset50.close();
          stmt50.close();
 
          // view based
          CallableStatement stmt5 = mConnection.prepareCall(
          "select pl.pv_id, u.user_email, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u " +
          "where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and af.view_id=pl.view_id and mg.group_email_id=af.group_email_id and u.user_id=mg.user_id and af.proj_id=rt.proj_id " +
          "order by pv.modified_stamp"
          );
          ResultSet rset5 = stmt5.executeQuery();
              
          while( rset5.next() )
          {

              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset5 package superceded by planned " + pv_id);
 
            }
            else
            {
              String user_email = rset5.getString("user_email");
              

          rset5.close();
          stmt5.close();
 
          // package version
          CallableStatement stmt51 = mConnection.prepareCall(
          "select pl.pv_id, u1.user_email, u2.user_email, u3.user_email, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.users u1, release_manager.users u2, release_manager.users u3 " +
          "where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and u1.user_id=pv.creator_id and u2.user_id=pv.owner_id and u3.user_id=pv.modifier_id " +
          "order by pv.modified_stamp"
          );
          ResultSet rset51 = stmt51.executeQuery();
              
          while( rset51.next() )
          {

              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset51 package superceded by planned " + pv_id);
 
            }
            else
            {
              
              // walk the 3 columns of user_email in the resultset

          rset51.close();
          stmt51.close();
 
          // get planned package advisory ripple info
          CallableStatement stmt7 = mConnection.prepareCall(
          "select pl.pv_id, pv.modified_stamp " +
          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.advisory_ripple ar " +
          "where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +
          "and pv.pv_id = pl.pv_id and ar.rtag_id=pl.rtag_id and ar.pv_id=pl.pv_id " +
          "order by pv.modified_stamp"
          );
          ResultSet rset7 = stmt7.executeQuery();
               
          while( rset7.next() )
          {

               
            Package p = findPackage(pv_id, packageCollection);
               
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset7 package superceded by planned " + pv_id);
 
              ignore = true;
            }
               
            if ( !ignore )
            {

             
            Package p = findPackage(pv_id, packageCollection);
             
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset9 package superceded by planned " + pv_id);
              ignore = true;
            }
             
            String pkg_name = rset9.getString("pkg_name");
             

              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset10 package superceded by planned " + pv_id);
              ignore = true;
            }
              
            String bm_name = rset10.getString("bm_name");
              

              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset11 package superceded by planned " + pv_id);
              ignore = true;
            }
              
            String test_type_name = rset11.getString("test_type_name");
              

              
            Package p = findPackage(pv_id, packageCollection);
              
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset120 package superceded by planned " + pv_id);
 
            }
            else
            {
              for (Iterator<String> it = globalAndProjectWideBuildFailureEmailCollection.iterator(); it.hasNext(); )
              {

               
            Package p = findPackage(pv_id, packageCollection);
               
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset12 package superceded by planned " + pv_id);
            }
            else
            {
              String user_email = rset12.getString("user_email");
               

                
            Package p = findPackage(pv_id, packageCollection);
                
            if ( p == NULL_PACKAGE )
            {
              mLogger.info("queryPackageVersions rset14 package superceded by planned " + pv_id);
              ignore = true;
            }
                
            if ( !ignore )
            {

Rev 876	Rev 878
Line 1446...	Line 1446...
1446	`if ( ct != 'x' )`	1446	`if ( ct != 'x' )`
1447	`{`	1447	`{`
1448	`Package p = new Package(pv_id, pkg_name, v_ext, pkg_name + v_ext, pkg_label, src_path, ct);`	1448	`Package p = new Package(pv_id, pkg_name, v_ext, pkg_name + v_ext, pkg_label, src_path, ct);`
1449	`p.mPid = pkg_id;`	1449	`p.mPid = pkg_id;`
1450	`p.mDirectlyPlanned = true;`	1450	`p.mDirectlyPlanned = true;`
-		1451	`Package plannedPackage = findPackage(p.mAlias, packageCollection);`
-		1452
-		1453	`if ( plannedPackage == NULL_PACKAGE )`
-		1454	`{`
-		1455	`mLogger.info("queryPackageVersions rset1 no previous planned package " + pv_id);`
1451	`packageCollection.add(p);`	1456	`packageCollection.add(p);`
-		1457	`}`
1452	`}`	1458	`}`
1453	`}`	1459	`}`
1454		1460
1455	`rset1.close();`	1461	`rset1.close();`
1456	`stmt1.close();`	1462	`stmt1.close();`
1457		1463
1458	`// get planned package dependency info`	1464	`// get planned package dependency info`
1459	`CallableStatement stmt2 = mConnection.prepareCall(`	1465	`CallableStatement stmt2 = mConnection.prepareCall(`
1460	`"select pl.pv_id, p.pkg_name, dpv.v_ext " +`	1466	`"select pl.pv_id, p.pkg_name, dpv.v_ext, pv.modified_stamp " +`
1461	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +`	1467	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +`
1462	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`	1468	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`
1463	`"and pv.pv_id = pl.pv_id and pd.pv_id=pl.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +`	1469	`"and pv.pv_id = pl.pv_id and pd.pv_id=pl.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +`
1464	`"order by pl.pv_id"`	1470	`"order by pv.modified_stamp"`
1465	`);`	1471	`);`
1466	`ResultSet rset2 = stmt2.executeQuery();`	1472	`ResultSet rset2 = stmt2.executeQuery();`
1467		1473
1468	`while( rset2.next() )`	1474	`while( rset2.next() )`
1469	`{`	1475	`{`
Line 1480...	Line 1486...
1480		1486
1481	`Package p = findPackage(pv_id, packageCollection);`	1487	`Package p = findPackage(pv_id, packageCollection);`
1482		1488
1483	`if ( p == NULL_PACKAGE )`	1489	`if ( p == NULL_PACKAGE )`
1484	`{`	1490	`{`
1485	`mLogger.info("queryPackageVersions rset2 highly unlikely " + pv_id);`	1491	`mLogger.info("queryPackageVersions rset2 package superceded by planned " + pv_id);`
1486	`// highly unlikely but package may have been added in between queries`	-
1487	`ignore = true;`	1492	`ignore = true;`
1488	`}`	1493	`}`
1489		1494
1490	`String pkg_name = rset2.getString("pkg_name");`	1495	`String pkg_name = rset2.getString("pkg_name");`
1491		1496
Line 1513...	Line 1518...
1513	`rset2.close();`	1518	`rset2.close();`
1514	`stmt2.close();`	1519	`stmt2.close();`
1515		1520
1516	`// get planned package build info`	1521	`// get planned package build info`
1517	`CallableStatement stmt3 = mConnection.prepareCall(`	1522	`CallableStatement stmt3 = mConnection.prepareCall(`
1518	`"select pl.pv_id, bm.bm_name, bsa.bsa_name " +`	1523	`"select pl.pv_id, bm.bm_name, bsa.bsa_name, pv.modified_stamp " +`
1519	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +`	1524	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.package_build_info pbi, release_manager.build_machines bm, release_manager.build_standards_addendum bsa " +`
1520	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`	1525	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`
1521	`"and pv.pv_id = pl.pv_id and pbi.pv_id=pv.pv_id and bm.bm_id=pbi.bm_id and bsa.bsa_id=pbi.bsa_id " +`	1526	`"and pv.pv_id = pl.pv_id and pbi.pv_id=pv.pv_id and bm.bm_id=pbi.bm_id and bsa.bsa_id=pbi.bsa_id " +`
1522	`"order by pl.pv_id"`	1527	`"order by pv.modified_stamp"`
1523	`);`	1528	`);`
1524	`ResultSet rset3 = stmt3.executeQuery();`	1529	`ResultSet rset3 = stmt3.executeQuery();`
1525		1530
1526	`while( rset3.next() )`	1531	`while( rset3.next() )`
1527	`{`	1532	`{`
Line 1537...	Line 1542...
1537		1542
1538	`Package p = findPackage(pv_id, packageCollection);`	1543	`Package p = findPackage(pv_id, packageCollection);`
1539		1544
1540	`if ( p == NULL_PACKAGE )`	1545	`if ( p == NULL_PACKAGE )`
1541	`{`	1546	`{`
1542	`mLogger.info("queryPackageVersions rset3 highly unlikely " + pv_id);`	1547	`mLogger.info("queryPackageVersions rset3 package superceded by planned " + pv_id);`
1543	`// highly unlikely but package may have been added in between queries`	-
1544	`ignore = true;`	1548	`ignore = true;`
1545	`}`	1549	`}`
1546		1550
1547	`String bm_name = rset3.getString("bm_name");`	1551	`String bm_name = rset3.getString("bm_name");`
1548		1552
Line 1627...	Line 1631...
1627	`rset3.close();`	1631	`rset3.close();`
1628	`stmt3.close();`	1632	`stmt3.close();`
1629		1633
1630	`// get planned package unit test info`	1634	`// get planned package unit test info`
1631	`CallableStatement stmt4 = mConnection.prepareCall(`	1635	`CallableStatement stmt4 = mConnection.prepareCall(`
1632	`"select pl.pv_id, tt.test_type_name " +`	1636	`"select pl.pv_id, tt.test_type_name, pv.modified_stamp " +`
1633	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +`	1637	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.unit_tests ut, release_manager.test_types tt " +`
1634	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`	1638	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`
1635	`"and pv.pv_id = pl.pv_id and ut.pv_id=pv.pv_id and tt.test_type_id=ut.test_types_fk " +`	1639	`"and pv.pv_id = pl.pv_id and ut.pv_id=pv.pv_id and tt.test_type_id=ut.test_types_fk " +`
1636	`"order by pl.pv_id"`	1640	`"order by pv.modified_stamp"`
1637	`);`	1641	`);`
1638	`ResultSet rset4 = stmt4.executeQuery();`	1642	`ResultSet rset4 = stmt4.executeQuery();`
1639		1643
1640	`while( rset4.next() )`	1644	`while( rset4.next() )`
1641	`{`	1645	`{`
Line 1652...	Line 1656...
1652		1656
1653	`Package p = findPackage(pv_id, packageCollection);`	1657	`Package p = findPackage(pv_id, packageCollection);`
1654		1658
1655	`if ( p == NULL_PACKAGE )`	1659	`if ( p == NULL_PACKAGE )`
1656	`{`	1660	`{`
1657	`mLogger.info("queryPackageVersions rset4 highly unlikely " + pv_id);`	1661	`mLogger.info("queryPackageVersions rset4 package superceded by planned " + pv_id);`
1658	`// highly unlikely but package may have been added in between queries`	-
1659	`ignore = true;`	1662	`ignore = true;`
1660	`}`	1663	`}`
1661		1664
1662	`String test_type_name = rset4.getString("test_type_name");`	1665	`String test_type_name = rset4.getString("test_type_name");`
1663		1666
Line 1681...	Line 1684...
1681	`stmt4.close();`	1684	`stmt4.close();`
1682		1685
1683	`// get planned package build failure info...`	1686	`// get planned package build failure info...`
1684	`// global and project wide based`	1687	`// global and project wide based`
1685	`CallableStatement stmt50 = mConnection.prepareCall(`	1688	`CallableStatement stmt50 = mConnection.prepareCall(`
1686	`"select pl.pv_id " +`	1689	`"select pl.pv_id, pv.modified_stamp " +`
1687	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv " +`	1690	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv " +`
1688	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`	1691	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`
1689	`"and pv.pv_id = pl.pv_id " +`	1692	`"and pv.pv_id = pl.pv_id " +`
1690	`"order by pl.pv_id"`	1693	`"order by pv.modified_stamp"`
1691	`);`	1694	`);`
1692	`ResultSet rset50 = stmt50.executeQuery();`	1695	`ResultSet rset50 = stmt50.executeQuery();`
1693		1696
1694	`while( rset50.next() )`	1697	`while( rset50.next() )`
1695	`{`	1698	`{`
Line 1704...	Line 1707...
1704		1707
1705	`Package p = findPackage(pv_id, packageCollection);`	1708	`Package p = findPackage(pv_id, packageCollection);`
1706		1709
1707	`if ( p == NULL_PACKAGE )`	1710	`if ( p == NULL_PACKAGE )`
1708	`{`	1711	`{`
1709	`mLogger.info("queryPackageVersions rset50 highly unlikely " + pv_id);`	1712	`mLogger.info("queryPackageVersions rset50 package superceded by planned " + pv_id);`
1710	`// highly unlikely but package may have been added in between queries`	-
1711	`}`	1713	`}`
1712	`else`	1714	`else`
1713	`{`	1715	`{`
1714	`for (Iterator<String> it = globalAndProjectWideBuildFailureEmailCollection.iterator(); it.hasNext(); )`	1716	`for (Iterator<String> it = globalAndProjectWideBuildFailureEmailCollection.iterator(); it.hasNext(); )`
1715	`{`	1717	`{`
Line 1721...	Line 1723...
1721	`rset50.close();`	1723	`rset50.close();`
1722	`stmt50.close();`	1724	`stmt50.close();`
1723		1725
1724	`// view based`	1726	`// view based`
1725	`CallableStatement stmt5 = mConnection.prepareCall(`	1727	`CallableStatement stmt5 = mConnection.prepareCall(`
1726	`"select pl.pv_id, u.user_email " +`	1728	`"select pl.pv_id, u.user_email, pv.modified_stamp " +`
1727	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u " +`	1729	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u " +`
1728	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`	1730	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`
1729	`"and pv.pv_id = pl.pv_id and af.view_id=pl.view_id and mg.group_email_id=af.group_email_id and u.user_id=mg.user_id and af.proj_id=rt.proj_id " +`	1731	`"and pv.pv_id = pl.pv_id and af.view_id=pl.view_id and mg.group_email_id=af.group_email_id and u.user_id=mg.user_id and af.proj_id=rt.proj_id " +`
1730	`"order by pl.pv_id"`	1732	`"order by pv.modified_stamp"`
1731	`);`	1733	`);`
1732	`ResultSet rset5 = stmt5.executeQuery();`	1734	`ResultSet rset5 = stmt5.executeQuery();`
1733		1735
1734	`while( rset5.next() )`	1736	`while( rset5.next() )`
1735	`{`	1737	`{`
Line 1744...	Line 1746...
1744		1746
1745	`Package p = findPackage(pv_id, packageCollection);`	1747	`Package p = findPackage(pv_id, packageCollection);`
1746		1748
1747	`if ( p == NULL_PACKAGE )`	1749	`if ( p == NULL_PACKAGE )`
1748	`{`	1750	`{`
1749	`mLogger.info("queryPackageVersions rset5 highly unlikely " + pv_id);`	1751	`mLogger.info("queryPackageVersions rset5 package superceded by planned " + pv_id);`
1750	`// highly unlikely but package may have been added in between queries`	-
1751	`}`	1752	`}`
1752	`else`	1753	`else`
1753	`{`	1754	`{`
1754	`String user_email = rset5.getString("user_email");`	1755	`String user_email = rset5.getString("user_email");`
1755		1756
Line 1763...	Line 1764...
1763	`rset5.close();`	1764	`rset5.close();`
1764	`stmt5.close();`	1765	`stmt5.close();`
1765		1766
1766	`// package version`	1767	`// package version`
1767	`CallableStatement stmt51 = mConnection.prepareCall(`	1768	`CallableStatement stmt51 = mConnection.prepareCall(`
1768	`"select pl.pv_id, u1.user_email, u2.user_email, u3.user_email " +`	1769	`"select pl.pv_id, u1.user_email, u2.user_email, u3.user_email, pv.modified_stamp " +`
1769	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.users u1, release_manager.users u2, release_manager.users u3 " +`	1770	`"from release_manager.planned pl, release_manager.release_tags rt, release_manager.package_versions pv, release_manager.users u1, release_manager.users u2, release_manager.users u3 " +`
1770	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`	1771	`"where pl.rtag_id=" + baseline + " and rt.rtag_id=pl.rtag_id and pv.build_type='A' and pv.dlocked='A' " +`
1771	`"and pv.pv_id = pl.pv_id and u1.user_id=pv.creator_id and u2.user_id=pv.owner_id and u3.user_id=pv.modifier_id " +`	1772	`"and pv.pv_id = pl.pv_id and u1.user_id=pv.creator_id and u2.user_id=pv.owner_id and u3.user_id=pv.modifier_id " +`
1772	`"order by pl.pv_id"`	1773	`"order by pv.modified_stamp"`
1773	`);`	1774	`);`
1774	`ResultSet rset51 = stmt51.executeQuery();`	1775	`ResultSet rset51 = stmt51.executeQuery();`
1775		1776
1776	`while( rset51.next() )`	1777	`while( rset51.next() )`
1777	`{`	1778	`{`
Line 1786...	Line 1787...
1786		1787
1787	`Package p = findPackage(pv_id, packageCollection);`	1788	`Package p = findPackage(pv_id, packageCollection);`
1788		1789
1789	`if ( p == NULL_PACKAGE )`	1790	`if ( p == NULL_PACKAGE )`
1790	`{`	1791	`{`
1791	`mLogger.info("queryPackageVersions rset51 highly unlikely " + pv_id);`	1792	`mLogger.info("queryPackageVersions rset51 package superceded by planned " + pv_id);`
1792	`// highly unlikely but package may have been added in between queries`	-
1793	`}`	1793	`}`
1794	`else`	1794	`else`
1795	`{`	1795	`{`
1796		1796
1797	`// walk the 3 columns of user_email in the resultset`	1797	`// walk the 3 columns of user_email in the resultset`
Line 1811...	Line 1811...
1811	`rset51.close();`	1811	`rset51.close();`
1812	`stmt51.close();`	1812	`stmt51.close();`
1813		1813
1814	`// get planned package advisory ripple info`	1814	`// get planned package advisory ripple info`
1815	`CallableStatement stmt7 = mConnection.prepareCall(`	1815	`CallableStatement stmt7 = mConnection.prepareCall(`
1816	`"select pl.pv_id " +`	1816	`"select pl.pv_id, pv.modified_stamp " +`
1817	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.advisory_ripple ar " +`	1817	`"from release_manager.planned pl, release_manager.package_versions pv, release_manager.advisory_ripple ar " +`
1818	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`	1818	`"where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +`
1819	`"and pv.pv_id = pl.pv_id and ar.rtag_id=pl.rtag_id and ar.pv_id=pl.pv_id " +`	1819	`"and pv.pv_id = pl.pv_id and ar.rtag_id=pl.rtag_id and ar.pv_id=pl.pv_id " +`
1820	`"order by pl.pv_id"`	1820	`"order by pv.modified_stamp"`
1821	`);`	1821	`);`
1822	`ResultSet rset7 = stmt7.executeQuery();`	1822	`ResultSet rset7 = stmt7.executeQuery();`
1823		1823
1824	`while( rset7.next() )`	1824	`while( rset7.next() )`
1825	`{`	1825	`{`
Line 1836...	Line 1836...
1836		1836
1837	`Package p = findPackage(pv_id, packageCollection);`	1837	`Package p = findPackage(pv_id, packageCollection);`
1838		1838
1839	`if ( p == NULL_PACKAGE )`	1839	`if ( p == NULL_PACKAGE )`
1840	`{`	1840	`{`
1841	`mLogger.info("queryPackageVersions rset7 highly unlikely " + pv_id);`	1841	`mLogger.info("queryPackageVersions rset7 package superceded by planned " + pv_id);`
1842	`// highly unlikely but package may have been added in between queries`	-
1843	`ignore = true;`	1842	`ignore = true;`
1844	`}`	1843	`}`
1845		1844
1846	`if ( !ignore )`	1845	`if ( !ignore )`
1847	`{`	1846	`{`
Line 2026...	Line 2025...
2026		2025
2027	`Package p = findPackage(pv_id, packageCollection);`	2026	`Package p = findPackage(pv_id, packageCollection);`
2028		2027
2029	`if ( p == NULL_PACKAGE )`	2028	`if ( p == NULL_PACKAGE )`
2030	`{`	2029	`{`
2031	`mLogger.info("queryPackageVersions rset9 package may have been superceded by planned " + pv_id);`	2030	`mLogger.info("queryPackageVersions rset9 package superceded by planned " + pv_id);`
2032	`ignore = true;`	2031	`ignore = true;`
2033	`}`	2032	`}`
2034		2033
2035	`String pkg_name = rset9.getString("pkg_name");`	2034	`String pkg_name = rset9.getString("pkg_name");`
2036		2035
Line 2082...	Line 2081...
2082		2081
2083	`Package p = findPackage(pv_id, packageCollection);`	2082	`Package p = findPackage(pv_id, packageCollection);`
2084		2083
2085	`if ( p == NULL_PACKAGE )`	2084	`if ( p == NULL_PACKAGE )`
2086	`{`	2085	`{`
2087	`mLogger.info("queryPackageVersions rset10 package may have been superceded by planned " + pv_id);`	2086	`mLogger.info("queryPackageVersions rset10 package superceded by planned " + pv_id);`
2088	`ignore = true;`	2087	`ignore = true;`
2089	`}`	2088	`}`
2090		2089
2091	`String bm_name = rset10.getString("bm_name");`	2090	`String bm_name = rset10.getString("bm_name");`
2092		2091
Line 2196...	Line 2195...
2196		2195
2197	`Package p = findPackage(pv_id, packageCollection);`	2196	`Package p = findPackage(pv_id, packageCollection);`
2198		2197
2199	`if ( p == NULL_PACKAGE )`	2198	`if ( p == NULL_PACKAGE )`
2200	`{`	2199	`{`
2201	`mLogger.info("queryPackageVersions rset11 package may have been superceded by planned " + pv_id);`	2200	`mLogger.info("queryPackageVersions rset11 package superceded by planned " + pv_id);`
2202	`ignore = true;`	2201	`ignore = true;`
2203	`}`	2202	`}`
2204		2203
2205	`String test_type_name = rset11.getString("test_type_name");`	2204	`String test_type_name = rset11.getString("test_type_name");`
2206		2205
Line 2247...	Line 2246...
2247		2246
2248	`Package p = findPackage(pv_id, packageCollection);`	2247	`Package p = findPackage(pv_id, packageCollection);`
2249		2248
2250	`if ( p == NULL_PACKAGE )`	2249	`if ( p == NULL_PACKAGE )`
2251	`{`	2250	`{`
2252	`mLogger.info("queryPackageVersions rset120 highly unlikely " + pv_id);`	2251	`mLogger.info("queryPackageVersions rset120 package superceded by planned " + pv_id);`
2253	`// highly unlikely but package may have been added in between queries`	-
2254	`}`	2252	`}`
2255	`else`	2253	`else`
2256	`{`	2254	`{`
2257	`for (Iterator<String> it = globalAndProjectWideBuildFailureEmailCollection.iterator(); it.hasNext(); )`	2255	`for (Iterator<String> it = globalAndProjectWideBuildFailureEmailCollection.iterator(); it.hasNext(); )`
2258	`{`	2256	`{`
Line 2287...	Line 2285...
2287		2285
2288	`Package p = findPackage(pv_id, packageCollection);`	2286	`Package p = findPackage(pv_id, packageCollection);`
2289		2287
2290	`if ( p == NULL_PACKAGE )`	2288	`if ( p == NULL_PACKAGE )`
2291	`{`	2289	`{`
2292	`mLogger.info("queryPackageVersions rset12 package may have been superceded by planned " + pv_id);`	2290	`mLogger.info("queryPackageVersions rset12 package superceded by planned " + pv_id);`
2293	`}`	2291	`}`
2294	`else`	2292	`else`
2295	`{`	2293	`{`
2296	`String user_email = rset12.getString("user_email");`	2294	`String user_email = rset12.getString("user_email");`
2297		2295
Line 2330...	Line 2328...
2330		2328
2331	`Package p = findPackage(pv_id, packageCollection);`	2329	`Package p = findPackage(pv_id, packageCollection);`
2332		2330
2333	`if ( p == NULL_PACKAGE )`	2331	`if ( p == NULL_PACKAGE )`
2334	`{`	2332	`{`
2335	`mLogger.info("queryPackageVersions rset14 package may have been superceded by planned " + pv_id);`	2333	`mLogger.info("queryPackageVersions rset14 package superceded by planned " + pv_id);`
2336	`ignore = true;`	2334	`ignore = true;`
2337	`}`	2335	`}`
2338		2336
2339	`if ( !ignore )`	2337	`if ( !ignore )`
2340	`{`	2338	`{`

Subversion Repositories DevTools

(root)/buildtool/trunk/src/generated/com/erggroup/buildtool/ripple/ReleaseManager.java @ 880 – Rev 876 → 878