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

+         {
            p = findPackage(5, packageCollection);
            p.addEmail("timbutdim@erggroup.com");
+         }
-        /* planned do not ripple info
-         * pv_id
-         * 6
-         */
-         p = findPackage(6, packageCollection);
-         p.mDoNotRipple = true;
         /* planned advisory ripple info
          * pv_id
          * 0
          */
          if ( mConnectionString.compareTo("iteration1") == 0 )
+         {
            p = findPackage(10, packageCollection);
            p.addEmail("jimmyfishcake@erggroup.com");
+         }
-        /* released do not ripple info
-         * pv_id
-         * 11
-         */
-         p = findPackage(11, packageCollection);
-         p.mDoNotRipple = true;
         /* released advisory ripple info
          * pv_id
          * 14
          */
          if ( mConnectionString.compareTo("iteration1") != 0 )
+          }
           rset51.close();
           stmt51.close();
-          // get planned package do not ripple info
-          CallableStatement stmt6 = mConnection.prepareCall(
-          "select pl.pv_id " +
-          "from release_manager.planned pl, release_manager.package_versions pv, release_manager.do_not_ripple dnr " +
-          "where pl.rtag_id=" + baseline + " and pv.build_type='A' and pv.dlocked='A' " +
-          "and pv.pv_id = pl.pv_id and dnr.rtag_id=pl.rtag_id and dnr.pv_id=pl.pv_id " +
-          "order by pl.pv_id"
-          );
-          ResultSet rset6 = stmt6.executeQuery();
-          while( rset6.next() )
-          {
-            boolean ignore = false;
-            int pv_id = rset6.getInt("pv_id");
-            if ( rset6.wasNull() )
-            {
-              mLogger.fatal("queryPackageVersions rset6 null pv_id");
-              // show stopper
-              throw new Exception();
-            }
-            Package p = findPackage(pv_id, packageCollection);
-            if ( p == NULL_PACKAGE )
-            {
-              mLogger.warn("queryPackageVersions rset6 highly unlikely " + pv_id);
-              // highly unlikely but package may have been added in between queries
-              ignore = true;
-            }
-            if ( !ignore )
-            {
-              p.mDoNotRipple = true;
-              mLogger.warn("queryPackageVersions rset6 set mDoNotRipple on " + p.mAlias);
-            }
-          }
-          rset6.close();
-          stmt6.close();
           // get planned package advisory ripple info
           CallableStatement stmt7 = mConnection.prepareCall(
           "select pl.pv_id " +
           "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' " +
+          }
           rset12.close();
           stmt12.close();
-          // get released package do not ripple info
-          CallableStatement stmt13 = mConnection.prepareCall(
-          "select rc.pv_id " +
-          "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.do_not_ripple dnr " +
-          "where rc.rtag_id=" + baseline +
-          " and pv.pv_id = rc.pv_id and dnr.rtag_id=rc.rtag_id and dnr.pv_id=rc.pv_id " +
-          "order by rc.pv_id"
-          );
-          ResultSet rset13 = stmt13.executeQuery();
-          while( rset13.next() )
-          {
-            boolean ignore = false;
-            int pv_id = rset13.getInt("pv_id");
-            if ( rset13.wasNull() )
-            {
-              mLogger.fatal("queryPackageVersions rset13 null pv_id");
-              // show stopper
-              throw new Exception();
-            }
-            Package p = findPackage(pv_id, packageCollection);
-            if ( p == NULL_PACKAGE )
-            {
-              mLogger.warn("queryPackageVersions rset13 package may have been superceded by planned " + pv_id);
-              ignore = true;
-            }
-            if ( !ignore )
-            {
-              p.mDoNotRipple = true;
-              mLogger.warn("queryPackageVersions rset13 set mDoNotRipple on " + p.mAlias);
-            }
-          }
-          rset13.close();
-          stmt13.close();
           // get released advisory ripple info
           CallableStatement stmt14 = mConnection.prepareCall(
           "select rc.pv_id " +
           "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.advisory_ripple ar " +
           "where rc.rtag_id=" + baseline +
+      }
+    }
+  }
   /**handles database connection/disconnection
-   * executes the ExcludeFromBuild stored procedure with the passed parameters
+   * executes the Exclude_Indirect_From_Build stored procedure with the passed parameters
    */
   public void excludeFromBuild(String packageVersionId,
+                               String packageVersion, String rtagId, String rootPvId,
-                               String packageVersion, String rtagId) throws SQLException, Exception
+                               String rootCause, String rootFile) throws SQLException, Exception
+  {
     mLogger.debug("excludeFromBuild " + packageVersionId);
     if ( mUseDatabase )
+    {
       try
+      {
         connect();
-        CallableStatement stmt = mConnection.prepareCall( "begin ? := PK_RMAPI.EXCLUDE_FROM_BUILD(?,?,?,?); end;" );
+        CallableStatement stmt = mConnection.prepareCall( "begin ? := PK_RMAPI.EXCLUDE_INDIRECT_FROM_BUILD(?,?,?,?,?,?,?); end;" );
         stmt.registerOutParameter( 1, Types.INTEGER);
         stmt.setString( 2, packageVersionId );
         stmt.setString( 3, packageVersion );
         stmt.setString( 4, rtagId );
         stmt.setString( 5, "buildadm" );
+        stmt.setString( 6, rootPvId);
+        stmt.setString( 7, rootCause);
+        stmt.setString( 8, rootFile);
         stmt.executeUpdate();
         int result = stmt.getInt( 1 );
         if ( result != 0 )
+        {
           // flag build failure
-          mLogger.fatal( "excludeFromBuild show stopper PK_RMAPI.EXCLUDE_FROM_BUILD failed, returned " + result );
+          mLogger.fatal( "excludeFromBuild show stopper PK_RMAPI.EXCLUDE_INDIRECT_FROM_BUILD failed, returned " + result );
           throw new Exception();
+        }
         stmt.close();
         mConnection.commit();
         disconnect();
+        }
+      }
+    }
+  }
+  /**removes an excluded package from the do_not_ripple table
+   */
+  public void includeToBuild(String packageVersionId, String rtagId) throws SQLException, Exception
+  {
+    mLogger.debug("includeToBuild " + packageVersionId);
+    if ( mUseDatabase )
+    {
+      try
+      {
+        CallableStatement stmt = mConnection.prepareCall("delete from release_manager.do_not_ripple where rtag_id=" + rtagId + " and pv_id=" + packageVersionId);
+        stmt.executeUpdate();
+        stmt.close();
+        mConnection.commit();
+      }
+      catch( SQLException e )
+      {
+        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
+        {
+          mLogger.error("includeToBuild database access error only");
+          throw new SQLException();
+        }
+        else
+        {
+          mLogger.fatal("includeToBuild show stopper");
+          throw new Exception();
+        }
+      }
+    }
+  }
   /**Representation of a row in the RELEASE_CONFIG table
    */
   private class ReleaseConfig
+  {
     /**rtag_id column value
+        }
+      }
+    }
+  }
+  public void queryBuildExclusions(Vector<BuildExclusion> buildExclusionCollection, int baseline) throws SQLException, Exception
+  {
+    mLogger.debug("queryBuildExclusions " + baseline);
+    if ( !mUseDatabase )
+    {
+      mLogger.info("queryBuildExclusions !mUseDatabase");
+    }
+    else
+    {
+      try
+      {
+        CallableStatement stmt = mConnection.prepareCall("select pv_id, root_pv_id, root_cause from release_manager.do_not_ripple where rtag_id=" + baseline);
+        ResultSet rset = stmt.executeQuery();
+        while( rset.next() )
+        {
+          int pvId = rset.getInt("pv_id");
+          if ( rset.wasNull() )
+          {
+            mLogger.fatal("queryBuildExclusions rset null pv_id");
+            // show stopper
+            throw new Exception();
+          }
+          int rootPvId = rset.getInt("root_pv_id");
+          if ( rset.wasNull() )
+          {
+            // quite acceptable
+            rootPvId = -1;
+          }
+          // again, a null root_cause is quite acceptable
+          String rootCause = rset.getString("root_cause");
+          BuildExclusion buildExclusion = new BuildExclusion(pvId, rootPvId, rootCause);
+          buildExclusionCollection.add(buildExclusion);
+        }
+        rset.close();
+        stmt.close();
+      }
+      catch ( SQLException e )
+      {
+        if ( mConnection == null || ( mConnection != null && !mConnection.isValid(10) ) )
+        {
+          mLogger.error("queryBuildExclusions database access error only");
+          throw new SQLException();
+        }
+        else
+        {
+          mLogger.fatal("queryBuildExclusions show stopper");
+          throw new Exception();
+        }
+      }
+    }
+  }
+}

Subversion Repositories DevTools

(root)/buildtool/trunk/src/generated/com/erggroup/buildtool/ripple/ReleaseManager.java @ 866 – Rev 864 → 866