biz.wolschon.finance.jgnucash.mysql.impl.SplitRowMapper.java Source code

Introduction

Here is the source code for biz.wolschon.finance.jgnucash.mysql.impl.SplitRowMapper.java

Source

/**
 * SplitRowMapper.javaTransactionMenuAction.java
 * created: 10.08.2009
 * (c) 2008 by <a href="http://Wolschon.biz">Wolschon Softwaredesign und Beratung</a>
 * This file is part of jgnucashLib-GPL by Marcus Wolschon <a href="mailto:Marcus@Wolscon.biz">Marcus@Wolscon.biz</a>.
 * You can purchase support for a sensible hourly rate or
 * a commercial license of this file (unless modified by others) by contacting him directly.
 *
 *  jgnucashLib-GPL 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.
 *
 *  jgnucashLib-GPL 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 General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with jgnucashLib-V1.  If not, see <http://www.gnu.org/licenses/>.
 *
 ***********************************
 * Editing this file:
 *  -For consistent code-quality this file should be checked with the
 *   checkstyle-ruleset enclosed in this project.
 *  -After the design of this file has settled it should get it's own
 *   JUnit-Test that shall be executed regularly. It is best to write
 *   the test-case BEFORE writing this class and to run it on every build
 *   as a regression-test.
 */

package biz.wolschon.finance.jgnucash.mysql.impl;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.jdbc.core.simple.ParameterizedRowMapper;

import biz.wolschon.numbers.FixedPointNumber;

/**
 * (c) 2009 by <a href="http://Wolschon.biz>Wolschon Softwaredesign und Beratung</a>.<br/>
 * Project: jgnucashLib-GPL<br/>
 * SplitRowMapper<br/>
 * created: 10.08.2009 <br/>
 *<br/><br/>
 * <b>Map the result of a database-query to {@link GnucashDBSplit}-instances.</b>
 * @author  <a href="mailto:Marcus@Wolschon.biz">fox</a>
 */
public class SplitRowMapper implements ParameterizedRowMapper<GnucashDBSplit> {

    public static final String ROWTRANSACTIONGUID = "tx_guid";
    public static final String DBTABLE = "splits";
    /**
     * The {@link GnucashDatabase} we belong to.
     */
    private final GnucashDatabase myGnucashFile;

    /**
     * @param aGnucashFile The {@link GnucashDatabase} we belong to.
     */
    protected SplitRowMapper(final GnucashDatabase aGnucashFile) {
        super();
        myGnucashFile = aGnucashFile;
    }

    /**
     * @param aResultSet the result-set whos current result to map
     * @param aRowNumber the current row-number in the result-set
     * @return the result mapped to a bean
     * @throws SQLException on problems with the database
     * @see org.springframework.jdbc.core.simple.ParameterizedRowMapper#mapRow(java.sql.ResultSet, int)
     */
    @Override
    public GnucashDBSplit mapRow(final ResultSet aResultSet, final int aRowNumber) throws SQLException {
        int vnum = aResultSet.getInt("value_num");
        int vdenum = aResultSet.getInt("value_denom");
        int qnum = aResultSet.getInt("quantity_num");
        int qdenum = aResultSet.getInt("quantity_denom");
        FixedPointNumber quantity = new FixedPointNumber(qnum + "/" + qdenum);
        FixedPointNumber value = new FixedPointNumber(vnum + "/" + vdenum);
        GnucashDBSplit retval = new GnucashDBSplit(myGnucashFile, aResultSet.getString("guid"),
                aResultSet.getString(ROWTRANSACTIONGUID), aResultSet.getString("lot_guid"),
                aResultSet.getString("account_guid"), aResultSet.getString("memo"), aResultSet.getString("action"),
                value, quantity);
        return retval;
    }
}