| Line 503... |
Line 503... |
| 503 |
* 6 113 UnfinishedProduct .tim 6.TIM.WIP \vob\UnfinishedProduct M
|
503 |
* 6 113 UnfinishedProduct .tim 6.TIM.WIP \vob\UnfinishedProduct M
|
| 504 |
* 25 45 Banana .tim B.TIM.WIP \vob\Banana M
|
504 |
* 25 45 Banana .tim B.TIM.WIP \vob\Banana M
|
| 505 |
*/
|
505 |
*/
|
| 506 |
if ( mConnectionString.compareTo("iteration1") == 0 )
|
506 |
if ( mConnectionString.compareTo("iteration1") == 0 )
|
| 507 |
{
|
507 |
{
|
| 508 |
Package p = new Package(0, "UncommonDependency", ".tim", "UncommonDependency.tim", "CC::/vob/UncommonDependency::0.TIM.WIP", 'P', 'b');
|
508 |
Package p = new Package(0, "UncommonDependency", ".tim", "UncommonDependency.tim", "CC::/vob/UncommonDependency::0.TIM.WIP", 'P', 'b', "1.0.0000");
|
| 509 |
p.mPid = 76;
|
509 |
p.mPid = 76;
|
| 510 |
p.mDirectlyPlanned = true;
|
510 |
p.mDirectlyPlanned = true;
|
| 511 |
packageCollection.add(p);
|
511 |
packageCollection.add(p);
|
| 512 |
}
|
512 |
}
|
| 513 |
|
513 |
|
| 514 |
Package p = new Package(1, "DependencyMissingFromRelease", ".tim", "DependencyMissingFromRelease.tim", "CC::/vob/DependencyMissingFromRelease::1.TIM.WIP", 'M', 'b');
|
514 |
Package p = new Package(1, "DependencyMissingFromRelease", ".tim", "DependencyMissingFromRelease.tim", "CC::/vob/DependencyMissingFromRelease::1.TIM.WIP", 'M', 'b', "1.0.0000");
|
| 515 |
p.mPid = 1011;
|
515 |
p.mPid = 1011;
|
| 516 |
p.mDirectlyPlanned = true;
|
516 |
p.mDirectlyPlanned = true;
|
| 517 |
packageCollection.add(p);
|
517 |
packageCollection.add(p);
|
| 518 |
|
518 |
|
| 519 |
if ( mConnectionString.compareTo("iteration1") == 0 || mConnectionString.compareTo("iteration2") == 0 )
|
519 |
if ( mConnectionString.compareTo("iteration1") == 0 || mConnectionString.compareTo("iteration2") == 0 )
|
| 520 |
{
|
520 |
{
|
| 521 |
p = new Package(2, "CommonDependency", ".tim", "CommonDependency.tim", "CC::/vob/CommonDependency::2.TIM.WIP", 'M', 'b');
|
521 |
p = new Package(2, "CommonDependency", ".tim", "CommonDependency.tim", "CC::/vob/CommonDependency::2.TIM.WIP", 'M', 'b', "1.0.0000");
|
| 522 |
p.mPid = 34;
|
522 |
p.mPid = 34;
|
| 523 |
p.mDirectlyPlanned = true;
|
523 |
p.mDirectlyPlanned = true;
|
| 524 |
packageCollection.add(p);
|
524 |
packageCollection.add(p);
|
| 525 |
}
|
525 |
}
|
| 526 |
|
526 |
|
| 527 |
if ( mConnectionString.compareTo("iteration1") == 0
|
527 |
if ( mConnectionString.compareTo("iteration1") == 0
|
| 528 |
|| mConnectionString.compareTo("iteration2") == 0
|
528 |
|| mConnectionString.compareTo("iteration2") == 0
|
| 529 |
|| mConnectionString.compareTo("iteration3") == 0 )
|
529 |
|| mConnectionString.compareTo("iteration3") == 0 )
|
| 530 |
{
|
530 |
{
|
| 531 |
p = new Package(3, "SolarisCentricProduct", ".tim", "SolarisCentricProduct.tim", "CC::/vob/SolarisCentricProduct::3.TIM.WIP", 'N', 'b');
|
531 |
p = new Package(3, "SolarisCentricProduct", ".tim", "SolarisCentricProduct.tim", "CC::/vob/SolarisCentricProduct::3.TIM.WIP", 'N', 'b', "1.0.0000");
|
| 532 |
p.mPid = 908;
|
532 |
p.mPid = 908;
|
| 533 |
p.mDirectlyPlanned = true;
|
533 |
p.mDirectlyPlanned = true;
|
| 534 |
packageCollection.add(p);
|
534 |
packageCollection.add(p);
|
| 535 |
}
|
535 |
}
|
| 536 |
|
536 |
|
| 537 |
if ( mConnectionString.compareTo("iteration1") == 0
|
537 |
if ( mConnectionString.compareTo("iteration1") == 0
|
| 538 |
|| mConnectionString.compareTo("iteration2") == 0
|
538 |
|| mConnectionString.compareTo("iteration2") == 0
|
| 539 |
|| mConnectionString.compareTo("iteration3") == 0
|
539 |
|| mConnectionString.compareTo("iteration3") == 0
|
| 540 |
|| mConnectionString.compareTo("iteration4") == 0 )
|
540 |
|| mConnectionString.compareTo("iteration4") == 0 )
|
| 541 |
{
|
541 |
{
|
| 542 |
p = new Package(4, "GenericProduct", ".tim", "GenericProduct.tim", "CC::/vob/GenericProduct::4.TIM.WIP", 'P', 'b');
|
542 |
p = new Package(4, "GenericProduct", ".tim", "GenericProduct.tim", "CC::/vob/GenericProduct::4.TIM.WIP", 'P', 'b', "1.0.0000");
|
| 543 |
p.mPid = 6;
|
543 |
p.mPid = 6;
|
| 544 |
p.mDirectlyPlanned = true;
|
544 |
p.mDirectlyPlanned = true;
|
| 545 |
packageCollection.add(p);
|
545 |
packageCollection.add(p);
|
| 546 |
}
|
546 |
}
|
| 547 |
|
547 |
|
| Line 549... |
Line 549... |
| 549 |
|| mConnectionString.compareTo("iteration2") == 0
|
549 |
|| mConnectionString.compareTo("iteration2") == 0
|
| 550 |
|| mConnectionString.compareTo("iteration3") == 0
|
550 |
|| mConnectionString.compareTo("iteration3") == 0
|
| 551 |
|| mConnectionString.compareTo("iteration4") == 0
|
551 |
|| mConnectionString.compareTo("iteration4") == 0
|
| 552 |
|| mConnectionString.compareTo("iteration5") == 0 )
|
552 |
|| mConnectionString.compareTo("iteration5") == 0 )
|
| 553 |
{
|
553 |
{
|
| 554 |
p = new Package(5, "Product", ".tim", "Product.tim", "CC::/vob/Product::5.TIM.WIP", 'M', 'b');
|
554 |
p = new Package(5, "Product", ".tim", "Product.tim", "CC::/vob/Product::5.TIM.WIP", 'M', 'b', "1.0.0000");
|
| 555 |
p.mPid = 11;
|
555 |
p.mPid = 11;
|
| 556 |
p.mDirectlyPlanned = true;
|
556 |
p.mDirectlyPlanned = true;
|
| 557 |
packageCollection.add(p);
|
557 |
packageCollection.add(p);
|
| 558 |
}
|
558 |
}
|
| 559 |
|
559 |
|
| 560 |
p = new Package(6, "UnfinishedProduct", ".tim", "UnfinishedProduct.tim", "CC::/vob/UnfinishedProduct::6.TIM.WIP", 'M', 'b');
|
560 |
p = new Package(6, "UnfinishedProduct", ".tim", "UnfinishedProduct.tim", "CC::/vob/UnfinishedProduct::6.TIM.WIP", 'M', 'b', "1.0.0000");
|
| 561 |
p.mPid = 113;
|
561 |
p.mPid = 113;
|
| 562 |
p.mDirectlyPlanned = true;
|
562 |
p.mDirectlyPlanned = true;
|
| 563 |
packageCollection.add(p);
|
563 |
packageCollection.add(p);
|
| 564 |
|
564 |
|
| 565 |
if ( mConnectionString.compareTo("iteration1") == 0 )
|
565 |
if ( mConnectionString.compareTo("iteration1") == 0 )
|
| 566 |
{
|
566 |
{
|
| 567 |
p = new Package(25, "Banana", ".tim", "Banana.tim", "CC::B.TIM.WIP/vob/Banana", 'M', 'b');
|
567 |
p = new Package(25, "Banana", ".tim", "Banana.tim", "CC::B.TIM.WIP/vob/Banana", 'M', 'b', "1.0.0000");
|
| 568 |
p.mPid = 45;
|
568 |
p.mPid = 45;
|
| 569 |
p.mDirectlyPlanned = true;
|
569 |
p.mDirectlyPlanned = true;
|
| 570 |
packageCollection.add(p);
|
570 |
packageCollection.add(p);
|
| 571 |
}
|
571 |
}
|
| 572 |
|
572 |
|
| Line 1518... |
Line 1518... |
| 1518 |
Vector<String> globalAndProjectWideBuildFailureEmailCollection = new Vector<String>();
|
1518 |
Vector<String> globalAndProjectWideBuildFailureEmailCollection = new Vector<String>();
|
| 1519 |
globalAndProjectWideBuildFailureEmailCollection.add(queryGlobalAddresses());
|
1519 |
globalAndProjectWideBuildFailureEmailCollection.add(queryGlobalAddresses());
|
| 1520 |
|
1520 |
|
| 1521 |
CallableStatement stmt0 = mConnection.prepareCall(
|
1521 |
CallableStatement stmt0 = mConnection.prepareCall(
|
| 1522 |
"select u.user_email " +
|
1522 |
"select u.user_email " +
|
| 1523 |
"from release_manager.autobuild_failure af, release_manager.members_group mg, release_manager.users u, release_manager.views v, release_manager.release_tags rt " +
|
1523 |
"from release_manager.autobuild_failure af, " +
|
| - |
|
1524 |
"release_manager.members_group mg, " +
|
| - |
|
1525 |
"release_manager.users u, " +
|
| - |
|
1526 |
"release_manager.views v, " +
|
| - |
|
1527 |
"release_manager.release_tags rt " +
|
| 1524 |
"where rt.rtag_id=" + baseline + " " +
|
1528 |
"where rt.rtag_id=" + baseline + " " +
|
| 1525 |
"and v.view_name='PROJECT WIDE' " +
|
1529 |
"and v.view_name='PROJECT WIDE' " +
|
| 1526 |
"and af.proj_id=rt.proj_id " +
|
1530 |
"and af.proj_id=rt.proj_id " +
|
| 1527 |
"and af.view_id=v.view_id " +
|
1531 |
"and af.view_id=v.view_id " +
|
| 1528 |
"and mg.group_email_id=af.group_email_id " +
|
1532 |
"and mg.group_email_id=af.group_email_id " +
|
| Line 1543... |
Line 1547... |
| 1543 |
rset0.close();
|
1547 |
rset0.close();
|
| 1544 |
stmt0.close();
|
1548 |
stmt0.close();
|
| 1545 |
|
1549 |
|
| 1546 |
// get planned package info
|
1550 |
// get planned package info
|
| 1547 |
// devi 48629 support multiple wips on the same package and build in the order they were released
|
1551 |
// devi 48629 support multiple wips on the same package and build in the order they were released
|
| - |
|
1552 |
// These are packages that are marked as pending build
|
| - |
|
1553 |
//
|
| 1548 |
mLogger.warn("queryPackageVersions: stmt1");
|
1554 |
mLogger.warn("queryPackageVersions: stmt1");
|
| 1549 |
CallableStatement stmt1 = mConnection.prepareCall(
|
1555 |
CallableStatement stmt1 = mConnection.prepareCall(
|
| 1550 |
"select pl.pv_id, p.pkg_id, p.pkg_name," +
|
1556 |
"select pl.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, " +
|
| 1551 |
"pv.v_ext, pv.change_type, pv.ripple_field," +
|
1557 |
"pv.v_ext, pv.change_type, pv.ripple_field," +
|
| 1552 |
"pv.major_limit, pv.minor_limit, pv.patch_limit, pv.build_number_limit," +
|
1558 |
"pv.major_limit, pv.minor_limit, pv.patch_limit, pv.build_number_limit," +
|
| 1553 |
"pv.modified_stamp," +
|
1559 |
"pv.modified_stamp," +
|
| 1554 |
"release_manager.PK_RMAPI.return_vcs_tag(pl.pv_id) AS vcsTag" +
|
1560 |
"release_manager.PK_RMAPI.return_vcs_tag(pl.pv_id) AS vcsTag" +
|
| 1555 |
" from release_manager.planned pl," +
|
1561 |
" from release_manager.planned pl," +
|
| Line 1589... |
Line 1595... |
| 1589 |
mLogger.fatal("queryPackageVersions rset1 null pkg_name " + pv_id);
|
1595 |
mLogger.fatal("queryPackageVersions rset1 null pkg_name " + pv_id);
|
| 1590 |
// show stopper
|
1596 |
// show stopper
|
| 1591 |
throw new Exception("queryPackageVersions rset1 null pkg_name " + pv_id);
|
1597 |
throw new Exception("queryPackageVersions rset1 null pkg_name " + pv_id);
|
| 1592 |
}
|
1598 |
}
|
| 1593 |
|
1599 |
|
| - |
|
1600 |
String pkg_version = rset1.getString("pkg_version");
|
| - |
|
1601 |
if (pkg_version == null)
|
| - |
|
1602 |
{
|
| - |
|
1603 |
pkg_version = "1.0.0000";
|
| - |
|
1604 |
mLogger.fatal("queryPackageVersions rset1 null pkg_version " + pv_id);
|
| - |
|
1605 |
// show stopper
|
| - |
|
1606 |
throw new Exception("queryPackageVersions rset1 null pkg_version " + pv_id);
|
| - |
|
1607 |
}
|
| - |
|
1608 |
|
| 1594 |
String v_ext = rset1.getString("v_ext");
|
1609 |
String v_ext = rset1.getString("v_ext");
|
| 1595 |
|
1610 |
|
| 1596 |
if ( v_ext == null )
|
1611 |
if ( v_ext == null )
|
| 1597 |
{
|
1612 |
{
|
| 1598 |
v_ext = "";
|
1613 |
v_ext = "";
|
| Line 1617... |
Line 1632... |
| 1617 |
}
|
1632 |
}
|
| 1618 |
else if ( change_type.compareTo("P") == 0 )
|
1633 |
else if ( change_type.compareTo("P") == 0 )
|
| 1619 |
{
|
1634 |
{
|
| 1620 |
ct = 'P';
|
1635 |
ct = 'P';
|
| 1621 |
}
|
1636 |
}
|
| - |
|
1637 |
else if ( change_type.compareTo("F") == 0 )
|
| - |
|
1638 |
{
|
| - |
|
1639 |
ct = 'F';
|
| - |
|
1640 |
}
|
| 1622 |
|
1641 |
|
| 1623 |
if ( ct != 'x' )
|
1642 |
if ( ct != 'x' )
|
| 1624 |
{
|
1643 |
{
|
| 1625 |
String ripple_field = rset1.getString("ripple_field");
|
1644 |
String ripple_field = rset1.getString("ripple_field");
|
| 1626 |
|
1645 |
|
| Line 1665... |
Line 1684... |
| 1665 |
if ( vcs_tag == null )
|
1684 |
if ( vcs_tag == null )
|
| 1666 |
{
|
1685 |
{
|
| 1667 |
vcs_tag = "";
|
1686 |
vcs_tag = "";
|
| 1668 |
}
|
1687 |
}
|
| 1669 |
|
1688 |
|
| 1670 |
Package p = new Package(pv_id, pkg_name, v_ext, pkg_name + v_ext, vcs_tag, ct, ripple_field.charAt(0));
|
1689 |
Package p = new Package(pv_id, pkg_name, v_ext, pkg_name + v_ext, vcs_tag, ct, ripple_field.charAt(0), pkg_version);
|
| 1671 |
p.mPid = pkg_id;
|
1690 |
p.mPid = pkg_id;
|
| 1672 |
p.mDirectlyPlanned = true;
|
1691 |
p.mDirectlyPlanned = true;
|
| 1673 |
p.mMajorLimit = major_limit;
|
1692 |
p.mMajorLimit = major_limit;
|
| 1674 |
p.mMinorLimit = minor_limit;
|
1693 |
p.mMinorLimit = minor_limit;
|
| 1675 |
p.mPatchLimit = patch_limit;
|
1694 |
p.mPatchLimit = patch_limit;
|
| Line 2032... |
Line 2051... |
| 2032 |
|
2051 |
|
| 2033 |
rset7.close();
|
2052 |
rset7.close();
|
| 2034 |
stmt7.close();
|
2053 |
stmt7.close();
|
| 2035 |
|
2054 |
|
| 2036 |
// get released package info
|
2055 |
// get released package info
|
| - |
|
2056 |
// Get package information on ALL released packages within the release of interest
|
| - |
|
2057 |
//
|
| 2037 |
mLogger.warn("queryPackageVersions: stmt8");
|
2058 |
mLogger.warn("queryPackageVersions: stmt8");
|
| 2038 |
CallableStatement stmt8 = mConnection.prepareCall(
|
2059 |
CallableStatement stmt8 = mConnection.prepareCall(
|
| 2039 |
"select rc.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext," +
|
2060 |
"select rc.pv_id, p.pkg_id, p.pkg_name, pv.pkg_version, pv.v_ext," +
|
| 2040 |
"pv.ripple_field,pv.major_limit, pv.minor_limit, pv.patch_limit," +
|
2061 |
"pv.ripple_field,pv.major_limit, pv.minor_limit, pv.patch_limit," +
|
| 2041 |
"pv.build_number_limit," +
|
2062 |
"pv.build_number_limit," +
|