/** * 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 * CASKS006DataRecord and collections of * CASKS006DataRecords. */ public class CASKS006DataHandler extends AbstractCASDataHandler { /** * Creates a new instance of CASKS006DataHandler for handling * CASKS006DataRecords stored in a formatted File The default * File is hard coded. To specify the File use * CASKS006DataHandler(File). To set a different default * File edit the source code and recompile. */ public CASKS006DataHandler() throws IOException { // this( new File( // "C:/Work/Projects/MoSeS/Workspace/CASKS006DataRecords.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, "CASKS006DataRecords.dat"); if (!this._File.exists()) { this._File.createNewFile(); } this._RecordLength = new CASKS006DataRecord().getSizeInBytes(); // System.out.println("this.recordLength " + this.recordLength); this._RandomAccessFile = new RandomAccessFile(this._File, "r"); } /** * Creates a new instance of CASKS006DataHandler with Records loaded from * formattedFile. * * @param formattedFile * Formatted file of CASKS006DataRecords */ public CASKS006DataHandler(File formattedFile) throws IOException { // initMemoryReserve(); this.init(formattedFile.getParentFile()); this._RecordLength = new CASKS006DataRecord().getSizeInBytes(); load(formattedFile); System.out.println("CASKS006DataRecords loaded successfully"); } /** * 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( // "C:/work/data/census/2001/CAS/KeyStatistics/KS006EnglandOA.csv" // ); // RecordID = format( infile, RecordID ); // System.out.println( infile.toString() + // " formatted successfully " + RecordID + " records"); // 165665 // long0 = RecordID; // Load Wales infile = new File( directory, "KS006WalesOA.csv"); RecordID = format(infile, RecordID); System.out.println(infile.toString() + " formatted successfully " + (RecordID - long0) + " records"); // 9769 long0 = RecordID; // // Load Scotland // infile = new File( // "C:/work/data/census/2001/CAS/KeyStatistics/KS006ScotlandOA.csv" // ); // RecordID = format( infile, RecordID ); // System.out.println( infile.toString() + // " formatted successfully " + ( RecordID - long0 ) + " records"); // // 42604 // long0 = RecordID; // // Load Northern Ireland // infile = new File( // "C:/work/data/census/2001/CAS/KeyStatistics/KS006NorthernIrelandOA.csv" // ); // RecordID = format( infile, RecordID ); // System.out.println( infile.toString() + // " formatted successfully " + ( RecordID - long0 ) + " records"); // // 5022 // tRandomAccessFile.close(); load(this._File); print(20, new Random()); } /** * Uses a BufferedReader and a StreamTokenizer to * read lines from the sourceFile File. The lines are converted * to CASKS006DataRecords and written to * this.tRandomAccessFile. * * @param sourceFile * The source CASKS006DataRecords file to be formatted and * written to this.tRandomAccessFile. * @param RecordID * The RecordID to assign to the first * CASKS006DataRecord. * @return The RecordID assigned to the last * CASKS006DataRecords. */ protected long format(File sourceFile, long RecordID) throws IOException { System.out.println("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; CASKS006DataRecord aCASKS006DataRecord = new CASKS006DataRecord(); boolean print = false; int int10000 = 10000; // 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 % int10000; print = (long0 == longZero); if (print) { string2 = aCASKS006DataRecord.toString(); System.out.println(string2); string2 = string0; } // Write out aCASKS006DataRecord.write(_RandomAccessFile); RecordID++; break; case StreamTokenizer.TT_WORD: string1 = aStreamTokenizer.sval; aCASKS006DataRecord = new CASKS006DataRecord(RecordID, string1); break; } string1 = string0; tokenType = aStreamTokenizer.nextToken(); } System.out.println("Number of Records loaded = " + RecordID); return RecordID; } /** * @return a CASKS006DataRecord with * AbstractCASDataRecord.RecordID = RecordID * @param RecordID * The RecordID of the CASKS006DataRecord to be returned. */ public AbstractCASDataRecord getDataRecord( long RecordID) { return getCASKS006DataRecord(RecordID); } /** * @return a CASKS006DataRecord with * CASKS006DataRecord.RecordID = RecordID * @param RecordID * The RecordID of the CASKS006DataRecord to be returned. */ public CASKS006DataRecord getCASKS006DataRecord( long RecordID) { CASKS006DataRecord result = null; try { this._RandomAccessFile.seek(_RecordLength * RecordID); result = new CASKS006DataRecord(this._RandomAccessFile); } catch (IOException aIOException) { log(aIOException.getLocalizedMessage()); System.exit(ErrorAndExceptionHandler.IOException); } return result; } /** * Aggregates CASKS006DataRecords 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(); CASKS006DataRecord aCASKS006DataRecord; CASKS006DataRecord bCASKS006DataRecord; String zoneCode; Object zoneCodeWard; // long newRecordID = startRecordIDForLeeds - 1L; long newRecordID = -1L; for (long RecordID = startRecordID; RecordID < endRecordID; RecordID++) { aCASKS006DataRecord = (CASKS006DataRecord) getDataRecord(RecordID); zoneCode = new String(aCASKS006DataRecord.getZone_Code()); zoneCodeWard = zoneCode.substring(0, 6); if (result.containsKey(zoneCodeWard)) { bCASKS006DataRecord = (CASKS006DataRecord) result.get(zoneCodeWard); result.remove(zoneCodeWard); result.put(zoneCodeWard, aCASKS006DataRecord.aggregate(bCASKS006DataRecord)); } else { result.put(zoneCodeWard, aCASKS006DataRecord); } } write(aRandomAccessFile, result); } /** * Aggregates CASKS006DataRecords 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(); CASKS006DataRecord aCASKS006DataRecord; CASKS006DataRecord bCASKS006DataRecord; String zoneCode; Object zoneCodeMSOA; // long newRecordID = startRecordIDForLeeds - 1L; long newRecordID = -1L; for (long RecordID = startRecordID; RecordID < endRecordID; RecordID++) { aCASKS006DataRecord = (CASKS006DataRecord) getDataRecord(RecordID); zoneCode = new String(aCASKS006DataRecord.getZone_Code()); zoneCodeMSOA = lookUpMSOAfromOAHashMap.get(zoneCode); if (result.containsKey(zoneCodeMSOA)) { bCASKS006DataRecord = (CASKS006DataRecord) result.get(zoneCodeMSOA); result.remove(zoneCodeMSOA); result.put(zoneCodeMSOA, aCASKS006DataRecord.aggregate(bCASKS006DataRecord)); } else { result.put(zoneCodeMSOA, aCASKS006DataRecord); } } write(aRandomAccessFile, result); } }