Subversion Repositories DevTools

Rev

Rev 5710 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
392 dpurdie 1 
#! perl
2 
########################################################################
5710 dpurdie 3 
# Copyright (c) VIX TECHNOLOGY (AUST) LTD
392 dpurdie 4 
#
5 
# Module name   : jats.sh
6 
# Module type   : Makefile system
7 
# Compiler(s)   : n/a
8 
# Environment(s): jats
9 
#
10 
# Description   : Display the currently released version of ALL packages
11 
#                 that are a part of a given release
12 
#
13 
#                 Currently hard coded to Sydney Legacy
14 
#                 Appears to be an OLD version of play5
15 
#
16 
# Usage:
17 
#
18 
# Version   Who      Date        Description
19 
#
20 
#......................................................................#
21 
 
22 
require 5.006_001;
23 
use strict;
24 
use warnings;
25 
use JatsError;
26 
use JatsRmApi;
27 
 
28 
#use Data::Dumper;
29 
use Cwd;
30 
use DeployUtils::RmPkgInfo;
31 
my $GBE_PERL     = $ENV{'GBE_PERL'};        # Essential ENV variables
32 
my $GBE_CORE     = $ENV{'GBE_CORE'};
33 
my $opt_verbose = 1;
34 
my $RM_DB;
35 
 
36 
 
37 
my @GDATA;
38 
sub getPkgDetailsByRTAG_ID
39 
{
40 
    my ($RTAG_ID) =@_;
41 
    my $foundDetails = 0;
42 
    my (@row);
43 
 
44 
    # if we are not or cannot connect then return 0 as we have not found anything
45 
    connectRM(\$RM_DB);
46 
 
47 
    # First get details from pv_id
48 
 
49 
    my $m_sqlstr = "SELECT pv.PV_ID, pkg.PKG_NAME, pv.PKG_VERSION FROM RELEASE_CONTENT rc, PACKAGE_VERSIONS pv, PACKAGES pkg WHERE rc.RTAG_ID = $RTAG_ID AND rc.PV_ID = pv.PV_ID AND pv.PKG_ID = pkg.PKG_ID";
50 
    my $sth = $RM_DB->prepare($m_sqlstr);
51 
    if ( defined($sth) )
52 
    {
53 
        if ( $sth->execute( ) )
54 
        {
55 
            print "--- Execute\n";
56 
            if ( $sth->rows )
57 
            {
58 
                print "--- Execute ROWS\n";
59 
                while ( @row = $sth->fetchrow_array )
60 
                {
61 
                    my %DATA;
62 
                    $DATA{pv_id}            = $row[0];
63 
                    $DATA{name}             = $row[1];
64 
                    $DATA{version}          = $row[2];
65 
                    push @GDATA, (\%DATA);
66 
                }
67 
            }
68 
            print "--- Finish\n";
69 
            $sth->finish();
70 
        }
71 
    }
72 
    else
73 
    {
74 
        Error("Prepare failure" );
75 
    }
76 
}
77 
 
78 
#-------------------------------------------------------------------------------
79 
# Function        : Main
80 
#
81 
# Description     :
82 
#
83 
# Inputs          :
84 
#
85 
# Returns         :
86 
#
87 
 
88 
ErrorConfig( 'name'    =>'PLAY4' );
89 
 
90 
getPkgDetailsByRTAG_ID(1861);               # Sydney Legacy
91 
DebugDumpData("GDATA", \@GDATA);
92 
exit;
93 
 
94