com.claresco.tinman.sql.XapiResultSQLReader.java Source code

Introduction

Here is the source code for com.claresco.tinman.sql.XapiResultSQLReader.java

Source

/**
 * ClarescoExperienceAPI
 * Copyright 
 *
 * This code is free software; you can redistribute it and/or modify it
 * under the terms of the GNU General Public License version 2 only, as
 * published by the Free Software Foundation.
 *
 * Please contact Claresco, www.claresco.com, if you have any questions.
 **/

package com.claresco.tinman.sql;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.joda.time.Duration;
import org.joda.time.Period;

import com.claresco.tinman.lrs.XapiAccount;
import com.claresco.tinman.lrs.XapiResult;
import com.claresco.tinman.lrs.XapiScore;

/**
 * XapiResultSQLReader.java
 *
 *
 *
 * STATUS:
 *    RED
 *
 * @author rheza
 * on Mar 10, 2014
 * 
 */

public class XapiResultSQLReader extends SQLReader {

    private String myTableName = "result";
    private PreparedStatement myIDRetrievalStatement;

    /**
     * Description:
     *
     * Params:
     *
     */
    public XapiResultSQLReader(Connection conn) throws SQLException {
        this.myConn = conn;
        this.myIDRetrievalStatement = SQLUtility.createRetrievalStatement(super.myConn, this.myTableName,
                "resultid");
    }

    protected XapiResult retrieveByID(int theID) throws SQLException {
        this.myIDRetrievalStatement.setInt(1, theID);

        myResult = this.myIDRetrievalStatement.executeQuery();

        if (isResulEmpty()) {
            return null;
        }

        Double theScaled;
        Double theRaw;
        Double theMin;
        Double theMax;

        myResult.next();

        // Prim short for primitive type
        double thePrimScaled = myResult.getDouble("rsltscaled");
        if (myResult.wasNull()) {
            theScaled = null;
        } else {
            theScaled = new Double(thePrimScaled);
        }

        double thePrimRaw = myResult.getDouble("rsltrawscore");
        if (myResult.wasNull()) {
            theRaw = null;
        } else {
            theRaw = new Double(thePrimRaw);
        }

        double thePrimMin = myResult.getDouble("rsltminscore");
        if (myResult.wasNull()) {
            theMin = null;
        } else {
            theMin = new Double(thePrimMin);
        }

        double thePrimMax = myResult.getDouble("rsltmaxscore");
        if (myResult.wasNull()) {
            theMax = null;
        } else {
            theMax = new Double(thePrimMax);
        }

        XapiScore theScore = new XapiScore(theScaled, theRaw, theMin, theMax);
        if (theScore.isEmpty()) {
            theScore = null;
        }

        String theResponse = myResult.getString("rsltresponse");

        long msDuration = myResult.getLong("rsltduration");
        Duration theDuration = new Duration(msDuration);

        Boolean theSuccess;
        Boolean theComplete;
        boolean thePrimSuccess = myResult.getBoolean("rsltsuccess");
        if (myResult.wasNull()) {
            theSuccess = null;
        } else {
            theSuccess = new Boolean(thePrimSuccess);
        }

        boolean thePrimComplete = myResult.getBoolean("rsltcomplete");
        if (myResult.wasNull()) {
            theComplete = null;
        } else {
            theComplete = new Boolean(thePrimComplete);
        }

        return new XapiResult(theScore, theSuccess, theComplete, theResponse, theDuration);
    }

    protected void close() throws SQLException {
        super.close();
        SQLUtility.closeStatement(myIDRetrievalStatement);
    }

    public static void main(String[] args) {
        try {
            Connection conn = SQLUtility.establishDefaultConnection();

            XapiResultSQLReader theReader = new XapiResultSQLReader(conn);
            XapiResult theResult = theReader.retrieveByID(10334);
            System.out.println(theResult);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

}