reports/DBReporter2/ReportMaker.java

import java.sql.*;
import java.util.*;
import java.awt.image.*;
import java.io.*;

import uk.ac.ukc.iscream.util.*;


// ReportMaker class - used to produce each type of report for a machine.
public class ReportMaker {

    // Constructor.  This takes the database Statement.    
    public ReportMaker(Statement stmt, String webDir, String dateDir, long startTime, long endTime) {
        _stmt = stmt;
        _webDir = webDir;
        _dateDir = dateDir;
        _startTime = startTime;
        _endTime = endTime;
    }
    
    // Produce all reports in the report list for the machine.
    public void produce(ReportList reports, String machine) throws SQLException {
        
        System.out.println("Producing reports for " + machine + ".");

        // Make a list of PlotData objects to build the charts.
        LinkedList plots = new LinkedList();
        Iterator reportIt = reports.iterator();
        while (reportIt.hasNext()) {
            reportIt.next();
            plots.add(new PlotData(_startTime, _endTime));
        }
        
        
        // Select the data we nede from the database.
        String sql = "SELECT receipt_date, xml FROM ipacket WHERE machine_name='" + machine + "' AND receipt_date>=" + _startTime + " AND receipt_date<=" + _endTime + " ORDER BY receipt_date;";
        ResultSet rs = null;
        try {
            rs = _stmt.executeQuery(sql);
        }
        catch (SQLException e) {
            System.out.println("Unable to select data for " + machine + ".");
            return;
        }
        
        System.out.println("[DEBUG]Populating PlotData objects.");

        // Go through each selected XML string and add the necessary
        // data to the PlotData object associated with that report.
        try {
            XMLPacketMaker pm = null;
            XMLPacket packet = null;
            String xml = null;
            while(rs.next()) {
                xml = rs.getString("xml");
                pm = new XMLPacketMaker(xml);
                packet = pm.createXMLPacket();
                reportIt = reports.iterator();
                Iterator plotIt = plots.iterator();
                while (reportIt.hasNext()) {
                    PlotData plotData = (PlotData)plotIt.next();
                    Report report = (Report)reportIt.next();
                    String reportField = report.getReportField();
                    long x = rs.getLong("receipt_date");
                    double y;
                    try {
                        y = Double.parseDouble(packet.getParam(reportField));
                    }
                    catch (NumberFormatException e) {
                        System.out.println("Skipped a non-numerical field for " + reportField + ".");
                        continue;
                    }
                    plotData.addPoint(x, y);
                }
            }
            rs.close();
        }
        catch (SQLException e) {
            System.out.println("SQLException: " + e);
        }
        
        System.out.println("[DEBUG]Writing graphs to disk.");
        
        // Write a chart of each report to disk.
        Iterator plotIt = plots.iterator();
        reportIt = reports.iterator();
        while (reportIt.hasNext()) {
            Report report = (Report)reportIt.next();
            String reportField = report.getReportField();
            PlotData plotData = (PlotData)plotIt.next();
            plotData.flushPoints();
            plotData.scaleToFitX(SHTMLLayout.CHART_WIDTH, SHTMLLayout.CHART_HEIGHT);
            IscreamChart chart = new IscreamChart(_startTime, _endTime);
            double maxY = report.getMaxY();
            if (!report.isScaled()) {
                maxY = plotData.getMaxY();
            }
            BufferedImage img = chart.drawChart(plotData, SHTMLLayout.CHART_WIDTH, SHTMLLayout.CHART_HEIGHT, 24, 10, maxY);
            IscreamChartWriter imgWriter = new IscreamChartWriter();
            IscreamFilePlacer placer = new IscreamFilePlacer(_webDir);
            File destination = placer.makeDirs(_dateDir, machine, reportField);
            imgWriter.writeChart(img, new File(destination, "chart.gif"));
            System.out.println("[DEBUG]Point count: " + plotData.countPoints());            
        }
        
    }
    
    private Statement _stmt = null;
    private String _webDir;
    private String _dateDir;
    private long _startTime;
    private long _endTime;
}
Revision:	1.4
Committed:	Sat Feb 3 20:47:11 2001 UTC (24 years, 10 months ago) by pjm2
Branch:	MAIN
Changes since 1.3:	+4 -2 lines
Log Message:	The web directory is now specified. This is soon to be tied in with a [PHP?] script to allow report browsing.
#	User	Rev	Content
1	pjm2	1.1	import java.sql.*;
2			import java.util.*;
3			import java.awt.image.*;
4			import java.io.*;
5
6			import uk.ac.ukc.iscream.util.*;
7
8	pjm2	1.2
9			// ReportMaker class - used to produce each type of report for a machine.
10	pjm2	1.1	public class ReportMaker {
11	pjm2	1.2
12			// Constructor. This takes the database Statement.
13	pjm2	1.4	public ReportMaker(Statement stmt, String webDir, String dateDir, long startTime, long endTime) {
14	pjm2	1.1	_stmt = stmt;
15	pjm2	1.4	_webDir = webDir;
16	pjm2	1.1	_dateDir = dateDir;
17			_startTime = startTime;
18			_endTime = endTime;
19			}
20
21	pjm2	1.2	// Produce all reports in the report list for the machine.
22			public void produce(ReportList reports, String machine) throws SQLException {
23	pjm2	1.1
24			System.out.println("Producing reports for " + machine + ".");
25
26	pjm2	1.2	// Make a list of PlotData objects to build the charts.
27			LinkedList plots = new LinkedList();
28	pjm2	1.1	Iterator reportIt = reports.iterator();
29			while (reportIt.hasNext()) {
30	pjm2	1.2	reportIt.next();
31			plots.add(new PlotData(_startTime, _endTime));
32	pjm2	1.1	}
33
34	pjm2	1.2
35			// Select the data we nede from the database.
36			String sql = "SELECT receipt_date, xml FROM ipacket WHERE machine_name='" + machine + "' AND receipt_date>=" + _startTime + " AND receipt_date<=" + _endTime + " ORDER BY receipt_date;";
37	pjm2	1.1	ResultSet rs = null;
38			try {
39			rs = _stmt.executeQuery(sql);
40			}
41			catch (SQLException e) {
42			System.out.println("Unable to select data for " + machine + ".");
43			return;
44			}
45
46			System.out.println("[DEBUG]Populating PlotData objects.");
47
48			// Go through each selected XML string and add the necessary
49			// data to the PlotData object associated with that report.
50			try {
51			XMLPacketMaker pm = null;
52			XMLPacket packet = null;
53			String xml = null;
54			while(rs.next()) {
55			xml = rs.getString("xml");
56			pm = new XMLPacketMaker(xml);
57			packet = pm.createXMLPacket();
58			reportIt = reports.iterator();
59	pjm2	1.2	Iterator plotIt = plots.iterator();
60	pjm2	1.1	while (reportIt.hasNext()) {
61	pjm2	1.2	PlotData plotData = (PlotData)plotIt.next();
62	pjm2	1.1	Report report = (Report)reportIt.next();
63			String reportField = report.getReportField();
64			long x = rs.getLong("receipt_date");
65			double y;
66			try {
67			y = Double.parseDouble(packet.getParam(reportField));
68			}
69			catch (NumberFormatException e) {
70			System.out.println("Skipped a non-numerical field for " + reportField + ".");
71			continue;
72			}
73			plotData.addPoint(x, y);
74			}
75			}
76	pjm2	1.2	rs.close();
77	pjm2	1.1	}
78			catch (SQLException e) {
79			System.out.println("SQLException: " + e);
80			}
81
82			System.out.println("[DEBUG]Writing graphs to disk.");
83
84	pjm2	1.2	// Write a chart of each report to disk.
85			Iterator plotIt = plots.iterator();
86	pjm2	1.1	reportIt = reports.iterator();
87			while (reportIt.hasNext()) {
88			Report report = (Report)reportIt.next();
89			String reportField = report.getReportField();
90	pjm2	1.2	PlotData plotData = (PlotData)plotIt.next();
91	pjm2	1.1	plotData.flushPoints();
92			plotData.scaleToFitX(SHTMLLayout.CHART_WIDTH, SHTMLLayout.CHART_HEIGHT);
93			IscreamChart chart = new IscreamChart(_startTime, _endTime);
94			double maxY = report.getMaxY();
95			if (!report.isScaled()) {
96			maxY = plotData.getMaxY();
97			}
98			BufferedImage img = chart.drawChart(plotData, SHTMLLayout.CHART_WIDTH, SHTMLLayout.CHART_HEIGHT, 24, 10, maxY);
99			IscreamChartWriter imgWriter = new IscreamChartWriter();
100	pjm2	1.4	IscreamFilePlacer placer = new IscreamFilePlacer(_webDir);
101	pjm2	1.3	File destination = placer.makeDirs(_dateDir, machine, reportField);
102			imgWriter.writeChart(img, new File(destination, "chart.gif"));
103	pjm2	1.2	System.out.println("[DEBUG]Point count: " + plotData.countPoints());
104	pjm2	1.1	}
105
106			}
107
108			private Statement _stmt = null;
109	pjm2	1.4	private String _webDir;
110	pjm2	1.1	private String _dateDir;
111			private long _startTime;
112			private long _endTime;
113			}