Subversion Repositories DevTools

import java.io.ByteArrayOutputStream;
import java.io.PrintStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;

import releaseManager.TeamCity;
import releaseManager.ReleaseManager;
import releaseManager.VixPackage;

public class Aggregator
{
        private static final String DB_HOST     = "auperaprm01";
        private static final String DB_PORT     = "1521";
        private static final String DB_USER     = "RM_READONLY";
        private static final String DB_PASSWORD = "RM_READONLY";                        
        private static final String DB_SERVICE  = "RELEASEM";

        /**
         * @param args - the first and only arguments should be the rtag_id as
         *               found in the Release Manager URL.
         *               E.g. java Aggregator 30083
         */
        public static void main(String[] args)
        {       
                TeamCity teamCity = new TeamCity(System.out);
                
                if (args.length < 1) {
                        teamCity.error("Please supply an rtag_id.", "No argument supplied");
                        System.exit(-1);
                }               

                String releaseVersion = args[0];
                
                try
                {
                        int rtagId = Integer.parseInt(releaseVersion);
                        
                        // Load ORACLE DB driver class
                        // Available at: http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
                        // Filename: ojdbc6.jar
                        // See https://sites.google.com/a/vixtechnology.com/vixwiki/home/staff-wiki-s/richard-puchmayer/passwords-to-update
                        //     for username and password to use.
                        Class.forName("oracle.jdbc.driver.OracleDriver");
                        
                        Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@"+DB_HOST+":"+DB_PORT+":"+DB_SERVICE, DB_USER, DB_PASSWORD);
                        ReleaseManager releaseManager = new ReleaseManager(connection);
                        
                        List<VixPackage> packages = releaseManager.getTestedPackages(rtagId);
                        
                        if (packages.size() == 0)       // Cannot be null
                        {
                                teamCity.error("This project/release does not have any tests", "Release = " + releaseVersion);
                                System.exit(-1);
                        }
                        
                        teamCity.startSuite(releaseVersion);
                        for (VixPackage pkg : packages)
                        {
                                teamCity.startSuite(pkg.packageName);
                                teamCity.startSuite(pkg.packageVersion);
                                teamCity.startTest("<none>");
                                teamCity.finishTest("<none>");
                                teamCity.finishSuite(pkg.packageVersion);
                                teamCity.finishSuite(pkg.packageName);
                        }
                        teamCity.finishSuite(releaseVersion);
                }
                catch (SQLException e)
                {
                        ByteArrayOutputStream buffer = new ByteArrayOutputStream();
                        PrintStream output = new PrintStream(buffer);
                        e.printStackTrace(output);
                        teamCity.error("Could not retrieve any packages for this release: " + releaseVersion, buffer.toString());
                        System.exit(-1);
                }
                catch (ClassNotFoundException e)
                {
                        ByteArrayOutputStream buffer = new ByteArrayOutputStream();
                        PrintStream output = new PrintStream(buffer);
                        e.printStackTrace(output);
                        teamCity.error("Could not load the Oracle jdbc jar", buffer.toString());
                        System.exit(-1);
                }
                catch (NumberFormatException e)
                {
                        teamCity.error("Please supply a valid rtag_id.", "Argument: " + releaseVersion);
                        System.exit(-1);
                }
        }
}