src-main.org.awakefw.sql.json.JsonColPosition Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of awake-sql Show documentation
Awake SQL is an open source framework that allows remote and secure JDBC access through HTTP.
There is a newer version: 2.0.2
/*
 * This file is part of Awake SQL. 
 * Awake SQL: Remote JDBC access over HTTP.                                    
 * Copyright (C) 2013,  KawanSoft SAS
 * (http://www.kawansoft.com). All rights reserved.                    
 *                                                                         
 * Awake SQL is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.         
 *              
 * Awake SQL 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 General Public License
 * along with this program; if not, see .
 *
 * If you develop commercial activities using Awake SQL, you must: 
 * a) disclose and distribute all source code of your own product,
 * b) license your own product under the GNU General Public License.
 * 
 * You can be released from the requirements of the license by
 * purchasing a commercial license. Buying such a license will allow you 
 * to ship Awake SQL with your closed source products without disclosing 
 * the source code.
 *
 * For more information, please contact KawanSoft SAS at this
 * address: [email protected]
 * 
 * Any modifications to this file must keep this entire header
 * intact.
 */
package org.awakefw.sql.json;

import java.util.Iterator;
import java.util.LinkedHashMap;
import java.util.Map;
import java.util.Set;

import org.awakefw.file.api.util.AwakeDebug;
import org.json.simple.JSONObject;
import org.json.simple.JSONValue;

/**
 * @author Nicolas de Pomereu Class to transport Result Set column names and
 *         values between host <==> pc.
 */

public class JsonColPosition {

    /** For debug info */
    private static boolean DEBUG = AwakeDebug.isSet(JsonColPosition.class);

    /**
     * Format for JSON String the Map of (column name, column
     * position) of a result set
     * 
     * @param columnPositions
     *            the Map of (column name, column position) of
     *            a result set
     * @return the formated JSON string ready for transport
     */

    public static String toJson(Map columnPositions) {
	if (columnPositions == null) {
	    throw new IllegalArgumentException("columsAndValues is null!");
	}
	
	String jsonString = JSONValue.toJSONString(columnPositions);
	debug(" toJson(Map columnPositions) jsonString: " + jsonString);
	return jsonString;	
    }

    /**
     * Format from JSON string Map of (column name, column
     * position) of a result set
     * 
     * @param jsonString
     *            formated JSON string containing the Map of
     *            (column name, column position)
     * @return Map of (column name, column position)
     */
    public static Map fromJson(String jsonString) {
	if (jsonString == null) {
	    throw new IllegalArgumentException("jsonString is null!");
	}
	
	// Revert it
	Object obj = JSONValue.parse(jsonString);
	JSONObject mapBack = (JSONObject) obj;
		
	debug("jsonString        : " + jsonString);
	debug("mapBack.toString(): " + mapBack.toString());
	
	Map columnPositions = new LinkedHashMap();
	
	Set set = mapBack.keySet();

	for (Iterator iterator = set.iterator(); iterator.hasNext();) {

	    String key = (String) iterator.next();
	    long value = (Long) mapBack.get(key);

	    columnPositions.put(key, (int) value);
	}
	
	// free objects
	obj = null;
	mapBack = null;
	
	return columnPositions;
    }

    /**
     * @param args
     */
    public static void main(String[] args) throws Exception{
	Map columnPositions = new LinkedHashMap();
	columnPositions.put("col_1", 1);
	columnPositions.put("col_2", 2);
	columnPositions.put("col_3", 2);
	System.out.println(columnPositions);
	
	String jsonString = toJson(columnPositions);
	System.out.println(jsonString);
	System.out.println();
	
	Map columnPositionsBack = fromJson(jsonString);
	System.out.println(columnPositionsBack);
	
	
    }
    
    private static void debug(String s) {
	if (DEBUG) {
	    // AwakeFileLogger.log(s);
	    System.out.println(s);
	}
    }

}