net.solarnetwork.node.dao.jdbc.consumption.test.JdbcConsumptionDatumDaoTest.java Source code

Introduction

Here is the source code for net.solarnetwork.node.dao.jdbc.consumption.test.JdbcConsumptionDatumDaoTest.java

Source

/* ==================================================================
 * JdbcConsumptionDatumDaoTest.java - Oct 5, 2011 8:46:39 PM
 * 
 * Copyright 2007-2011 SolarNetwork.net Dev Team
 * 
 * This program 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 2 of 
 * the License, or (at your option) any later version.
 * 
 * This program 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 this program; if not, write to the Free Software 
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 
 * 02111-1307 USA
 * ==================================================================
 * $Id$
 * ==================================================================
 */

package net.solarnetwork.node.dao.jdbc.consumption.test;

import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertFalse;
import static org.junit.Assert.assertTrue;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import net.solarnetwork.node.consumption.ConsumptionDatum;
import net.solarnetwork.node.dao.jdbc.consumption.JdbcConsumptionDatumDao;
import net.solarnetwork.node.test.AbstractNodeTransactionalTest;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcOperations;
import org.springframework.jdbc.core.ResultSetExtractor;
import org.springframework.test.context.ContextConfiguration;

/**
 * Test case for the {@link JdbcConsumptionDatumDao} class.
 * 
 * @author matt
 * @version 1.0
 */
@ContextConfiguration
public class JdbcConsumptionDatumDaoTest extends AbstractNodeTransactionalTest {

    private static final String TEST_SOURCE_ID = "Test Source";
    private static final Float TEST_AMPS = 2.1F;
    private static final Float TEST_VOLTS = 2.2F;
    private static final Long TEST_WATT_HOUR_READING = 3L;

    private static final String SQL_GET_BY_ID = "SELECT source_id, created, voltage, amps, watt_hour "
            + "FROM solarnode.sn_consum_datum WHERE created = ? AND source_id = ?";

    @Autowired
    private JdbcConsumptionDatumDao dao;
    @Autowired
    private JdbcOperations jdbcOps;

    @Test
    public void storeNew() {
        ConsumptionDatum datum = new ConsumptionDatum(TEST_SOURCE_ID, TEST_AMPS, TEST_VOLTS);
        datum.setCreated(new Date());
        datum.setWattHourReading(TEST_WATT_HOUR_READING);

        dao.storeDatum(datum);

        jdbcOps.query(SQL_GET_BY_ID,
                new Object[] { new java.sql.Timestamp(datum.getCreated().getTime()), TEST_SOURCE_ID },
                new ResultSetExtractor<Object>() {

                    @Override
                    public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
                        assertTrue("Must have one result", rs.next());

                        int col = 1;

                        String s = rs.getString(col++);
                        assertFalse(rs.wasNull());
                        assertEquals(TEST_SOURCE_ID, s);

                        rs.getTimestamp(col++);
                        assertFalse(rs.wasNull());

                        Float f = rs.getFloat(col++);
                        assertFalse(rs.wasNull());
                        assertEquals(TEST_VOLTS.doubleValue(), f.doubleValue(), 0.001);

                        f = rs.getFloat(col++);
                        assertFalse(rs.wasNull());
                        assertEquals(TEST_AMPS.doubleValue(), f.doubleValue(), 0.001);

                        Long l = rs.getLong(col++);
                        assertFalse(rs.wasNull());
                        assertEquals(TEST_WATT_HOUR_READING, l);

                        assertFalse("Must not have more than one result", rs.next());
                        return null;
                    }

                });
    }

}