/** * A component of a library for * MoSeS. * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. */ package uk.ac.leeds.ccg.andyt.projects.moses.io; import java.io.BufferedReader; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStreamReader; import java.io.RandomAccessFile; import java.io.StreamTokenizer; import java.util.HashMap; import java.util.Random; import java.util.TreeMap; import uk.ac.leeds.ccg.andyt.projects.moses.utilities.ErrorAndExceptionHandler; import uk.ac.leeds.ccg.andyt.projects.moses.utilities.StaticIO; /** * A class for handling an individual * CASUV003DataRecord and collections of * CASUV003DataRecords. * * * @author Andy * Turner * @version 1.0.0, 2006-08-10 * @see AbstractCASDataRecord */ public class CASUV003DataHandler extends AbstractCASDataHandler { /** * Creates a new instance of CASUV003DataHandler for handling * CASUV003DataRecords stored in a formatted File The default * File is hard coded. To specify the File use * CASUV003DataHandler(File). To set a different default * File edit the source code and recompile. */ public CASUV003DataHandler() throws IOException { // this( new File( // "C:/Work/Projects/MoSeS/Workspace/CASUV003DataRecords.dat" ) ); // Want also to setDirectory(); // initMemoryReserve(); // Default this.directory, this.file, this.randomAccessFile File directory = new File("C:/Work/Projects/MoSeS/Workspace/"); this.init(directory); this._File = new File(directory, "CASUV003DataRecords.dat"); if (!this._File.exists()) { this._File.createNewFile(); } this._RecordLength = new CASUV003DataRecord().getSizeInBytes(); // log("this.recordLength " + this.recordLength); this._RandomAccessFile = new RandomAccessFile(this._File, "r"); } /** * Creates a new instance of CASUV003DataHandler with Records loaded from * formattedFile. * * @param formattedFile * Formatted file of CASUV003DataRecords */ public CASUV003DataHandler(File formattedFile) { // initMemoryReserve(); this.init(formattedFile.getParentFile()); this._RecordLength = new CASUV003DataRecord().getSizeInBytes(); load(formattedFile); log("CASUV003DataRecords loaded successfully"); } /** * @param args * the command line arguments No arguments are used. */ public static void main(String[] args) throws IOException { CASUV003DataHandler aCASUV003DataHandler = new CASUV003DataHandler(); aCASUV003DataHandler.run(); } /** * Top level run method */ private void run() throws IOException { // run1( true, 20 ); // run1( false, 20 ); run2(20); } /** * Loads CASUV003DataRecords and prints out n randomly * * @param loadFromSource * If true, data is loaded from hardcoded source files as * downloaded from casweb. Otherwise, data is loaded from * this.formattedFile * @param n * The number of loaded data records to print out. */ private void run2(int n) throws IOException { File file = new File( "C:/Work/Projects/MoSeS/Workspace/Leeds/CASUV003DataRecordsMSOA.dat"); load(file); print(n, new Random()); } /** * Loads CAS001DataRecords and prints out n randomly * @param directory to load source data from * @param n the number of loaded data records to print out. */ protected void formatSourceData( File directory, int n) throws IOException { _RandomAccessFile = new RandomAccessFile(this._File, "rw"); // Load from source File infile; long long0 = 0L; long RecordID = 0L; // Load England infile = new File( directory, "UV003EnglandOA.csv"); RecordID = format(infile, RecordID); log(infile.toString() + " formatted successfully " + RecordID + " records"); // 165665 long0 = RecordID; // Load Wales infile = new File( directory, "UV003WalesOA.csv"); RecordID = format(infile, RecordID); log(infile.toString() + " formatted successfully " + (RecordID - long0) + " records"); // 9769 long0 = RecordID; // Load Scotland infile = new File( directory, "UV003ScotlandOA.csv"); RecordID = format(infile, RecordID); log(infile.toString() + " formatted successfully " + (RecordID - long0) + " records"); // 42604 long0 = RecordID; // Load Northern Ireland infile = new File( directory, "UV003NorthernIrelandOA.csv"); RecordID = format(infile, RecordID); log(infile.toString() + " formatted successfully " + (RecordID - long0) + " records"); // 5022 _RandomAccessFile.close(); load(_File); print(20, new Random()); } /** * Uses a BufferedReader and a StreamTokenizer to * read lines from the sourceFile File. The lines are converted * to CASUV003DataRecords and written to * this.tRandomAccessFile. * * @param sourceFile * The source CASUV003DataRecords file to be formatted and * written to this.tRandomAccessFile. * @param RecordID * The RecordID to assign to the first * CASUV003DataRecord. * @return The RecordID assigned to the last * CASUV003DataRecords. */ protected long format(File sourceFile, long RecordID) throws IOException { log("format( File( " + sourceFile.toString() + " ), RecordID( " + RecordID + " ))"); BufferedReader aBufferedReader = new BufferedReader( new InputStreamReader(new FileInputStream(sourceFile))); StreamTokenizer aStreamTokenizer = new StreamTokenizer(aBufferedReader); StaticIO.setStreamTokenizerSyntax1(aStreamTokenizer); String string0 = new String(); String string1; String string2; long long0; long longZero = 0L; CASUV003DataRecord aCASUV003DataRecord = new CASUV003DataRecord(); boolean print = false; int int1000 = 1000; // Skip the first line int tokenType = aStreamTokenizer.nextToken(); while (tokenType != StreamTokenizer.TT_EOL) { tokenType = aStreamTokenizer.nextToken(); } tokenType = aStreamTokenizer.nextToken(); while (tokenType != StreamTokenizer.TT_EOF) { switch (tokenType) { case StreamTokenizer.TT_EOL: long0 = RecordID % int1000; print = (long0 == longZero); if (print) { string2 = aCASUV003DataRecord.toString(); log(string2); string2 = string0; } // Write out aCASUV003DataRecord.write(_RandomAccessFile); RecordID++; break; case StreamTokenizer.TT_WORD: string1 = aStreamTokenizer.sval; aCASUV003DataRecord = new CASUV003DataRecord(RecordID, string1); break; } string1 = string0; tokenType = aStreamTokenizer.nextToken(); } log("Number of Records loaded = " + RecordID); return RecordID; } /** * @return a CASUV003DataRecord with * AbstractCASDataRecord.RecordID = RecordID * @param RecordID * The RecordID of the CASUV003DataRecord to be returned. */ public AbstractCASDataRecord getDataRecord(long RecordID) { return getCASUV003DataRecord(RecordID); } /** * @return a CASUV003DataRecord with * CASUV003DataRecord.RecordID = RecordID * @param RecordID * The RecordID of the CASUV003DataRecord to be returned. */ public CASUV003DataRecord getCASUV003DataRecord(long RecordID) { CASUV003DataRecord result = null; try { this._RandomAccessFile.seek(_RecordLength * RecordID); result = new CASUV003DataRecord(this._RandomAccessFile); } catch (IOException aIOException) { log(aIOException.getLocalizedMessage()); System.exit(ErrorAndExceptionHandler.IOException); } return result; } /** * Aggregates CASUV003DataRecords from OA To Ward for the OA * records in the range [startRecordID,endRecordID] and writes the results * to aRandomAccessFile * * @param aRandomAccessFile * RandomAccessFile to which results are written * @param startRecordID * The first OA RecordID in the sequence to be aggregated. * @param endRecordID * The last OA RecordID in the sequence to be aggregated. */ public void aggregateOAToWard(RandomAccessFile aRandomAccessFile, long startRecordID, long endRecordID) throws IOException { TreeMap result = new TreeMap(); CASUV003DataRecord aCASUV003DataRecord; CASUV003DataRecord bCASUV003DataRecord; String zoneCode; Object zoneCodeWard; // long newRecordID = startRecordIDForLeeds - 1L; long newRecordID = -1L; for (long RecordID = startRecordID; RecordID < endRecordID; RecordID++) { aCASUV003DataRecord = (CASUV003DataRecord) getDataRecord(RecordID); zoneCode = new String(aCASUV003DataRecord.getZone_Code()); zoneCodeWard = zoneCode.substring(0, 6); if (result.containsKey(zoneCodeWard)) { bCASUV003DataRecord = (CASUV003DataRecord) result.get(zoneCodeWard); result.remove(zoneCodeWard); result.put(zoneCodeWard, aCASUV003DataRecord.aggregate(bCASUV003DataRecord)); } else { result.put(zoneCodeWard, aCASUV003DataRecord); } } write(aRandomAccessFile, result); } /** * Aggregates CASUV003DataRecords from OA To MSOA for the OA * records in the range [startRecordID,endRecordID] and writes the results * to aRandomAccessFile * * @param aRandomAccessFile * RandomAccessFile to which results are written * @param startRecordID * The first OA RecordID in the sequence to be aggregated. * @param endRecordID * The last OA RecordID in the sequence to be aggregated. */ public void aggregateOAToMSOA(RandomAccessFile aRandomAccessFile, long startRecordID, long endRecordID) throws IOException { TreeMap result = new TreeMap(); HashMap lookUpMSOAfromOAHashMap = get_LookUpMSOAfromOAHashMap(); CASUV003DataRecord aCASUV003DataRecord; CASUV003DataRecord bCASUV003DataRecord; String zoneCode; Object zoneCodeMSOA; // long newRecordID = startRecordIDForLeeds - 1L; long newRecordID = -1L; for (long RecordID = startRecordID; RecordID < endRecordID; RecordID++) { aCASUV003DataRecord = (CASUV003DataRecord) getDataRecord(RecordID); zoneCode = new String(aCASUV003DataRecord.getZone_Code()); zoneCodeMSOA = lookUpMSOAfromOAHashMap.get(zoneCode); if (result.containsKey(zoneCodeMSOA)) { bCASUV003DataRecord = (CASUV003DataRecord) result.get(zoneCodeMSOA); result.remove(zoneCodeMSOA); result.put(zoneCodeMSOA, aCASUV003DataRecord.aggregate(bCASUV003DataRecord)); } else { result.put(zoneCodeMSOA, aCASUV003DataRecord); } } write(aRandomAccessFile, result); } }