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

+    }
     /**
      * Add entry to the Build_Instance table
      * Returns the build instance number. This will be used to cross reference unit tests results
+     * @param rtagId
+     * @param pvId
+     * @param BuildReason
+     * @param buildRef
+     *
      * @throws throws SQLException, Exception
+     *
      */
-    public int createBuildInstance(int rtagId, int pvId, BuildReason reason) throws SQLException, Exception
+    public int createBuildInstance(int rtagId, int pvId, BuildReason reason, String buildRef) throws SQLException, Exception
+    {
         int buildId = 0;
         mLogger.debug("createBuildInstance {}:{}", rtagId, pvId);
         if ( mUseDatabase )
+        {
             try
+            {
                 connect();
-                CallableStatement stmt = mConnection.prepareCall("begin ? := PK_RMAPI.new_build_instance(?,?,?); end;");
+                CallableStatement stmt = mConnection.prepareCall("begin ? := PK_RMAPI.new_build_instance(?,?,?,?); end;");
                 stmt.registerOutParameter( 1, Types.INTEGER);
                 stmt.setLong( 2,rtagId );
                 stmt.setLong( 3,pvId );
                 stmt.setString( 4,reason.toString() );
+                stmt.setString( 5,buildRef);
                 stmt.executeUpdate();
                 buildId = stmt.getInt( 1 );
                 mLogger.warn("createBuildInstance: Build Instance ID: {}", buildId);
+        }
         return rv;
+    }
     /**
+     * Remove the BuildRef once the build log has been deleted
+     *
+     * @param rtagId       - Release Id
+     * @param buildRef     - Build Ref
+     *
+     * Returns the internal error code. <0 == error
+     *
+     * Handles exceptions locally as its called in a context with little handling
+     *
+     */
+    public int removeBuildRef(int rtagId, String buildRef)
+    {
+        int rv = 0;
+        mLogger.debug("removeBuildRef {}:{}", rtagId, buildRef);
+        if ( mUseDatabase )
+        {
+            try
+            {
+                connect();
+                String sql = "begin ? := PK_RMAPI.update_build_ref(?,?); end;";
+                CallableStatement stmt = mConnection.prepareCall(sql);
+                stmt.registerOutParameter( 1, Types.INTEGER);
+                stmt.setLong( 2,rtagId );
+                stmt.setString( 3,buildRef );
+                stmt.executeUpdate();
+                rv = stmt.getInt( 1 );
+                mLogger.warn("removeBuildRef: Result: {}", rv);
+                stmt.close();
+                commit();
+            }
+            catch ( SQLException e )
+            {
+                mLogger.error("{} sql exception:{}", "removeBuildRef", e.getMessage());
+            } catch (Exception e) {
+                mLogger.error("{} excpetion:{}", "removeBuildRef", e);
+            }
+            finally
+            {
+                // this block is executed regardless of what happens in the try block
+                //      even if an exception is thrown
+                //      ensure disconnect
+                disconnect();
+            }
+        }
+        return rv;
+    }
+    /**
      * Insert Test Results into Release Manager
      * Manage connection and disconnection
+     *
      * @param buildId
      * @param btr

Subversion Repositories DevTools

(root)/buildtool/trunk/src/main/java/com/erggroup/buildtool/ripple/ReleaseManager.java – Rev 7201 → 7253