Subversion Repositories DevTools

    /** Potentially take a snapshot of the current release

     *  Assumes that the last build-plan was an empty plan. ie: Nothing to build

     *  Will check that there are no build errors

     *  It will ignore packages that cannot be built as they have no BuildStandard

     *  

     * @param mRtagId   - Release to process

     * @throws Exception 

     * @throws SQLException 

     */

    public void takeSnapshot(int mRtagId) throws SQLException, Exception {

        int buildErrors = 0;

        try

        {

            connect();

            //  Determine if there are any packages that have been excluded from the build

            //

            mLogger.debug("takeSnapshot {}", mRtagId);

            PreparedStatement stmt0 = mConnection.prepareStatement(

                    "select count(*) as count from do_not_ripple dnr, package_build_info pbi where rtag_id = ? and dnr.pv_id = pbi.pv_id");

            stmt0.setFetchSize(1000);

            stmt0.setInt(1, mRtagId);

            RmResultSet rset = new RmResultSet(stmt0.executeQuery(),"queryBuildExclusions");

            if ( rset.next() )             {

                buildErrors = rset.mustGetKeyInt("count");

            } else {

                buildErrors = 1;

            }

            rset.close();

            stmt0.close();

            if (buildErrors == 0 )

            {

                //  No Build errors

                //  Take a snapshot, but not if its the same as the last one

                //

                CallableStatement stmt1 = mConnection.prepareCall( "call PK_RELEASE.TAKE_SNAPSHOT(?,?,?,?)" );

                stmt1.setInt( 1, mRtagId );

                stmt1.setInt( 2, 0 );

                stmt1.setInt( 3, 3768 );               // USER ID - buildadm ( Yes I know its ugly )

                stmt1.registerOutParameter( 4, Types.INTEGER);

                stmt1.executeUpdate();

                int newRtagId = stmt1.getInt( 4 );

                stmt1.close();

                if (newRtagId > 0 ) {

                    mLogger.warn("Snapshot taken: {} New: {}", mRtagId, newRtagId);

                }

            }

        }

        catch ( SQLException e )

        {

            handleSQLException(e, "");

        }

        finally

        {

            // this block is executed regardless of what happens in the try block

            // even if an exception is thrown

            // ensure disconnect

            disconnect();

        }        

    }