Subversion Repositories DevTools

Rev

Rev 7079 | Rev 7081 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 7079 Rev 7080
Line 2864... Line 2864...
2864 
            // These are packages that are marked as pending build
 2864 
            // These are packages that are marked as pending build
2865 
            //
 2865 
            //
2866 
            mLogger.debug("queryPackageVersions: stmt1");
 2866 
            mLogger.debug("queryPackageVersions: stmt1");
2867 
            phase.setPhase("getPlannedPkgs1");
 2867 
            phase.setPhase("getPlannedPkgs1");
2868 
            PreparedStatement stmt1 = mConnection.prepareStatement(
 2868 
            PreparedStatement stmt1 = mConnection.prepareStatement(
2869 
                    "select pl.pv_id, pv.modified_stamp," +
 2869 
                    "select pl.pv_id, pv.modified_stamp" +
2870 
                            " from release_manager.planned pl," +
 2870 
                            " from release_manager.planned pl," +
2871 
                            "      release_manager.package_versions pv," +
 2871 
                            "      release_manager.package_versions pv," +
2872 
                            "      release_manager.packages p" +
 2872 
                            "      release_manager.packages p" +
2873 
                            " where pl.rtag_id=" + baseline +
 2873 
                            " where pl.rtag_id=" + baseline +
2874 
                            "   and pv.build_type='A' and pv.dlocked='A'" +
 2874 
                            "   and pv.build_type='A' and pv.dlocked='A'" +
Line 3101... Line 3101...
3101 
            PreparedStatement stmt1 = mConnection.prepareStatement(
 3101 
            PreparedStatement stmt1 = mConnection.prepareStatement(
3102 
                    "select pv.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, " +
 3102 
                    "select pv.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, " +
3103 
                            " pv.v_ext, pv.change_type, pv.ripple_field," +
 3103 
                            " pv.v_ext, pv.change_type, pv.ripple_field," +
3104 
                            " pv.major_limit, pv.minor_limit, pv.patch_limit, pv.build_number_limit," +
 3104 
                            " pv.major_limit, pv.minor_limit, pv.patch_limit, pv.build_number_limit," +
3105 
                            " pv.modified_stamp," +
 3105 
                            " pv.modified_stamp," +
3106 
                            " release_manager.PK_RMAPI.return_vcs_tag(pl.pv_id) AS vcsTag," +
 3106 
                            " release_manager.PK_RMAPI.return_vcs_tag(pv.pv_id) AS vcsTag," +
3107 
                            " pv.build_time" +
 3107 
                            " pv.build_time" +
3108 
                            " from " +
 3108 
                            " from " +
3109 
                            "      release_manager.package_versions pv," +
 3109 
                            "      release_manager.package_versions pv," +
3110 
                            "      release_manager.packages p" +
 3110 
                            "      release_manager.packages p" +
3111 
                            " where pv.pv_id=" + pvId +
 3111 
                            " where pv.pv_id=" + pvId +
Line 3182... Line 3182...
3182 
            PreparedStatement stmt2 = mConnection.prepareStatement(
 3182 
            PreparedStatement stmt2 = mConnection.prepareStatement(
3183 
                    "select dpv.v_ext, dpv.pv_id" +
 3183 
                    "select dpv.v_ext, dpv.pv_id" +
3184 
                            " from " +
 3184 
                            " from " +
3185 
                            "     release_manager.package_versions pv,"+
 3185 
                            "     release_manager.package_versions pv,"+
3186 
                            "     release_manager.package_dependencies pd," +
 3186 
                            "     release_manager.package_dependencies pd," +
3187 
                            "     release_manager.package_versions dpv,"+
 3187 
                            "     release_manager.package_versions dpv"+
3188 
                            " where pv.pv_id=" + pvId +
3188 
                            " where pv.pv_id=" + pvId +
3189 
                            "  and pd.pv_id=pv.pv_id"+
 3189 
                            "  and pd.pv_id=pv.pv_id"+
3190 
                            "  and dpv.pv_id=pd.dpv_id"
 3190 
                            "  and dpv.pv_id=pd.dpv_id"
3191 
                    );
 3191 
                    );
3192 
            stmt2.setFetchSize(500);
 3192 
            stmt2.setFetchSize(500);
Line 3206... Line 3206...
3206 
 
 3206 
 
3207 
            // get Package build info
 3207 
            // get Package build info
3208 
            mLogger.debug("getPackageInfo: stmt3");
 3208 
            mLogger.debug("getPackageInfo: stmt3");
3209 
            PreparedStatement stmt3 = mConnection.prepareStatement(
 3209 
            PreparedStatement stmt3 = mConnection.prepareStatement(
3210 
                    "select bm.bm_name, bsa.bsa_name" +
 3210 
                    "select bm.bm_name, bsa.bsa_name" +
3211 
                            "from " +
 3211 
                            " from " +
3212 
                            "     release_manager.package_versions pv," +
 3212 
                            "   release_manager.package_versions pv," +
3213 
                            "     release_manager.package_build_info pbi," +
 3213 
                            "   release_manager.package_build_info pbi," +
3214 
                            "     release_manager.build_machines bm," +
 3214 
                            "   release_manager.build_machines bm," +
3215 
                            "     release_manager.build_standards_addendum bsa " +
 3215 
                            "   release_manager.build_standards_addendum bsa " +
3216 
                            "where pv_id=" + pvId +
3216 
                            " where pv.pv_id=" + pvId +
3217 
                            "     and pbi.pv_id=pv.pv_id" +
 3217 
                            "   and pbi.pv_id=pv.pv_id" +
3218 
                            "     and bm.bm_id=pbi.bm_id" +
 3218 
                            "   and bm.bm_id=pbi.bm_id" +
3219 
                            "     and bsa.bsa_id=pbi.bsa_id "
 3219 
                            "   and bsa.bsa_id=pbi.bsa_id "
3220 
                    );
 3220 
                    );
3221 
            stmt3.setFetchSize(500);
 3221 
            stmt3.setFetchSize(500);
3222 
            RmResultSet rset3 = new RmResultSet(stmt3.executeQuery(), "getPackageInfo rset3");
 3222 
            RmResultSet rset3 = new RmResultSet(stmt3.executeQuery(), "getPackageInfo rset3");
3223 
 
 3223 
 
3224 
            if( rset3.next() )
 3224 
            if( rset3.next() )
Line 3265... Line 3265...
3265 
 
 3265 
 
3266 
            // get Package build failure info...
 3266 
            // get Package build failure info...
3267 
            //      view based
 3267 
            //      view based
3268 
            mLogger.debug("getPackageInfo: stmt5");
 3268 
            mLogger.debug("getPackageInfo: stmt5");
3269 
            PreparedStatement stmt5 = mConnection.prepareStatement(
 3269 
            PreparedStatement stmt5 = mConnection.prepareStatement(
3270 
                    "select pv.pv_id, u.user_email" +
 3270 
                    "SELECT rc.pv_id," +
3271 
                            " from " +
 3271 
                            "  u.user_email" +
- 
 
 3272 
                            " FROM release_manager.release_content rc," +
3272 
                            "      release_manager.release_tags rt, " +
 3273 
                            "  release_manager.release_tags rt," +
3273 
                            "      release_manager.package_versions pv, " +
 3274 
                            "  release_manager.package_versions pv," +
3274 
                            "      release_manager.autobuild_failure af, " +
 3275 
                            "  release_manager.autobuild_failure af," +
3275 
                            "      release_manager.members_group mg, " +
 3276 
                            "  release_manager.members_group mg," +
3276 
                            "      release_manager.users u " +
 3277 
                            "  release_manager.users u" +
- 
 
 3278 
                            " WHERE rc.rtag_id     = " + rippleEngine.getRtagId() +
- 
 
 3279 
                            " AND rt.rtag_id       = rc.rtag_id" +
3277 
                            " where pv.pv_id=" + pvId +
3280 
                            " AND pv.pv_id=" + pvId +
3278 
                            "      and rt.rtag_id=" + rippleEngine.getRtagId() +
3281 
                            " AND pv.pv_id         = rc.pv_id" +
3279 
                            "      and af.view_id=pv.view_id " +
 3282 
                            " AND af.view_id       = rc.base_view_id" +
3280 
                            "      and mg.group_email_id=af.group_email_id " +
 3283 
                            " AND mg.group_email_id= af.group_email_id" +
3281 
                            "      and u.user_id=mg.user_id " +
 3284 
                            " AND u.user_id        = mg.user_id" +
3282 
                            "      and af.proj_id=rt.proj_id "
 3285 
                            " AND af.proj_id       = rt.proj_id"
3283 
                    );
 3286 
                    );
3284 
            stmt5.setFetchSize(500);
 3287 
            stmt5.setFetchSize(500);
3285 
            RmResultSet rset5 = new RmResultSet(stmt5.executeQuery(), "getPackageInfo rset5");
 3288 
            RmResultSet rset5 = new RmResultSet(stmt5.executeQuery(), "getPackageInfo rset5");
3286 
 
 3289 
 
3287 
            if( rset5.next() )
 3290 
            if( rset5.next() )
Line 3305... Line 3308...
3305 
                    "      release_manager.users u3 " +
 3308 
                    "      release_manager.users u3 " +
3306 
                    " where pv.pv_id=" + pvId +
3309 
                    " where pv.pv_id=" + pvId +
3307 
                    "   and rt.rtag_id=" + rippleEngine.getRtagId() +
3310 
                    "   and rt.rtag_id=" + rippleEngine.getRtagId() +
3308 
                    "   and pv.build_type='A'" +
 3311 
                    "   and pv.build_type='A'" +
3309 
                    "   and pv.dlocked='A' " +
 3312 
                    "   and pv.dlocked='A' " +
3310 
                    "   and pv.pv_id = pl.pv_id" +
 - 
 
3311 
                    "   and u1.user_id=pv.creator_id" +
 3313 
                    "   and u1.user_id=pv.creator_id" +
3312 
                    "   and u2.user_id=pv.owner_id" +
 3314 
                    "   and u2.user_id=pv.owner_id" +
3313 
                    "   and u3.user_id=pv.modifier_id"
 3315 
                    "   and u3.user_id=pv.modifier_id"
3314 
                    );
 3316 
                    );
3315 
            stmt6.setFetchSize(500);
 3317 
            stmt6.setFetchSize(500);
Line 3326... Line 3328...
3326 
            stmt6.close();
 3328 
            stmt6.close();
3327
3329
3328 
            // get Package advisory ripple info
 3330 
            // get Package advisory ripple info
3329 
            mLogger.debug("getPackageInfo: stmt7");
 3331 
            mLogger.debug("getPackageInfo: stmt7");
3330 
            PreparedStatement stmt7 = mConnection.prepareStatement(
 3332 
            PreparedStatement stmt7 = mConnection.prepareStatement(
3331 
                    "select pl.pv_id, pv.modified_stamp " +
 3333 
                    "select pv.pv_id, pv.modified_stamp " +
3332 
                    " from " +
 3334 
                    " from " +
3333 
                    "      release_manager.package_versions pv," +
 3335 
                    "      release_manager.package_versions pv," +
3334 
                    "      release_manager.advisory_ripple ar " +
 3336 
                    "      release_manager.advisory_ripple ar " +
3335 
                    " where pv.pv_id = " + pvId +
 3337 
                    " where pv.pv_id = " + pvId +
3336 
                    "    and ar.rtag_id=" + rippleEngine.getRtagId() +
 3338 
                    "    and ar.rtag_id=" + rippleEngine.getRtagId() +