org.kawanfw.sql.jdbc.util.ColPositionBuilder.java Source code

Introduction

Here is the source code for org.kawanfw.sql.jdbc.util.ColPositionBuilder.java

Source

/*
 * This file is part of AceQL. 
 * AceQL: Remote JDBC access over HTTP.                                     
 * Copyright (C) 2015,  KawanSoft SAS
 * (http://www.kawansoft.com). All rights reserved.                                
 *                                                                               
 * AceQL 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.            
 *                                                                               
 * AceQL 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., 51 Franklin Street, Fifth Floor, Boston, MA  
 * 02110-1301  USA
 *
 * Any modifications to this file must keep this entire header
 * intact.
 */
package org.kawanfw.sql.jdbc.util;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.LineNumberReader;
import java.sql.SQLException;
import java.util.Map;
import java.util.logging.Level;

import org.apache.commons.io.FileUtils;
import org.apache.commons.io.IOUtils;
import org.kawanfw.commons.util.ClientLogger;
import org.kawanfw.commons.util.FrameworkDebug;
import org.kawanfw.commons.util.Tag;
import org.kawanfw.sql.jdbc.ConnectionHttp;
import org.kawanfw.sql.json.JsonColPosition;

/**
 * @author Nicolas de Pomereu
 * 
 *         Creator of the Map<String, Integer> of the (column names, column
 *         positions).
 */
public class ColPositionBuilder {

    /** Debug flag */
    private static boolean DEBUG = FrameworkDebug.isSet(ColPositionBuilder.class);

    /** the Mapof the column (names, positions) */
    private Map<String, Integer> columnsPosition = null;

    /**
     * 
     * Constructor
     * 
     * @param file
     *            the file that contains the positions of the columns
     * @param connectionHttp
     *            TODO
     */
    public ColPositionBuilder(File file, ConnectionHttp connectionHttp) throws SQLException {
        if (!file.exists()) {
            String message = Tag.PRODUCT_PRODUCT_FAIL + "Internal File does not exists: " + file;
            throw new SQLException(message, new IOException(message));
        }

        String line = null;
        LineNumberReader lineNumberReader = null;

        try {
            lineNumberReader = new LineNumberReader(new FileReader(file));
            line = lineNumberReader.readLine();
        } catch (FileNotFoundException e) {
            String message = Tag.PRODUCT_PRODUCT_FAIL + "Internal File does not exists: " + file;
            throw new SQLException(message, new IOException(message));
        } catch (IOException e) {
            String message = Tag.PRODUCT_PRODUCT_FAIL + "I/O Error when reading file: " + file;
            throw new SQLException(message, new IOException(message));
        } finally {
            IOUtils.closeQuietly(lineNumberReader);
        }

        if (line == null) {
            String message = Tag.PRODUCT_PRODUCT_FAIL + "Internal File is empty: " + file;
            throw new SQLException(message, new IOException(message));
        }

        line = JsonLineDecryptor.decrypt(line, connectionHttp);

        if (DEBUG) {
            try {
                String fileContent = FileUtils.readFileToString(file);
                debug("fileContent: " + fileContent);
            } catch (IOException e) {
                throw new SQLException(e);
            }
        }

        columnsPosition = JsonColPosition.fromJson(line);
    }

    /**
     * @return the columnsPosition map
     */
    public Map<String, Integer> getColPosition() {
        return this.columnsPosition;
    }

    /**
     * Displays the given message if DEBUG is set.
     * 
     * @param s
     *            the debug message
     */

    private void debug(String s) {
        if (DEBUG) {
            ClientLogger.getLogger().log(Level.WARNING, s);
        }
    }

}