/* ===================================================================
* JdbcConsumptionDatumDao.java
*
* Created Dec 4, 2009 10:22:46 AM
*
* Copyright 2007-2009 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
* ===================================================================
*/
package net.solarnetwork.node.dao.jdbc.consumption;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.Date;
import java.util.List;
import net.solarnetwork.node.consumption.ConsumptionDatum;
import net.solarnetwork.node.dao.jdbc.AbstractJdbcDatumDao;
import org.springframework.core.io.ClassPathResource;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
/**
* JDBC-based implementation of {@link net.solarnetwork.node.dao.DatumDao} for
* {@link ConsumptionDatum} domain objects.
*
* <p>
* Ueses a {@link javax.sql.DataSource} and requires a schema named
* {@link net.solarnetwork.node.dao.jdbc.JdbcDaoConstants#SCHEMA_NAME} with two
* tables:
* {@link net.solarnetwork.node.dao.jdbc.JdbcDaoConstants#TABLE_SETTINGS} to
* hold settings and {@link #TABLE_CONSUMPTION_DATUM} to hold the actual
* consumption data.
* </p>
*
* <p>
* This class will check to see if the
* {@link net.solarnetwork.node.dao.jdbc.JdbcDaoConstants#TABLE_SETTINGS} table
* exists when the {@link #init()} method is called. If it does not, it assumes
* the database needs to be created and will load a classpath SQL file resource
* specified by the {@link #getInitSqlResource()}, which should create the
* tables needed by this class. See the {@code derby-init.sql} resource in this
* package for an example.
* </p>
*
* @author matt
* @version 1.2
*/
public class JdbcConsumptionDatumDao extends AbstractJdbcDatumDao<ConsumptionDatum> {
/** The default tables version. */
public static final int DEFAULT_TABLES_VERSION = 9;
/** The table name for {@link ConsumptionDatum} data. */
public static final String TABLE_CONSUMPTION_DATUM = "sn_consum_datum";
/** The default classpath Resource for the {@code initSqlResource}. */
public static final String DEFAULT_INIT_SQL = "derby-consumptiondatum-init.sql";
/** The default value for the {@code sqlGetTablesVersion} property. */
public static final String DEFAULT_SQL_GET_TABLES_VERSION = "SELECT svalue FROM solarnode.sn_settings WHERE skey = "
+ "'solarnode.sn_consum_datum.version'";
/**
* Default constructor.
*/
public JdbcConsumptionDatumDao() {
super();
setSqlResourcePrefix("derby-consumptiondatum");
setTableName(TABLE_CONSUMPTION_DATUM);
setTablesVersion(DEFAULT_TABLES_VERSION);
setSqlGetTablesVersion(DEFAULT_SQL_GET_TABLES_VERSION);
setInitSqlResource(new ClassPathResource(DEFAULT_INIT_SQL, getClass()));
}
@Override
public Class<? extends ConsumptionDatum> getDatumType() {
return ConsumptionDatum.class;
}
@Override
@Transactional(readOnly = false, propagation = Propagation.REQUIRED)
public void storeDatum(ConsumptionDatum datum) {
storeDomainObject(datum);
}
@Override
@Transactional(readOnly = false, propagation = Propagation.REQUIRED)
public void setDatumUploaded(ConsumptionDatum datum, Date date, String destination, String trackingId) {
updateDatumUpload(datum, date == null ? System.currentTimeMillis() : date.getTime());
}
@Override
@Transactional(readOnly = false, propagation = Propagation.REQUIRED)
public int deleteUploadedDataOlderThan(int hours) {
return deleteUploadedDataOlderThanHours(hours);
}
@Override
@Transactional(readOnly = true, propagation = Propagation.REQUIRED)
public List<ConsumptionDatum> getDatumNotUploaded(String destination) {
return findDatumNotUploaded(new RowMapper<ConsumptionDatum>() {
@Override
public ConsumptionDatum mapRow(ResultSet rs, int rowNum) throws SQLException {
if ( log.isTraceEnabled() ) {
log.trace("Handling result row " + rowNum);
}
ConsumptionDatum datum = new ConsumptionDatum();
int col = 1;
datum.setCreated(rs.getTimestamp(col++));
datum.setSourceId(rs.getString(col++));
Number val = (Number) rs.getObject(col++);
datum.setLocationId(val == null ? null : val.longValue());
val = (Number) rs.getObject(col++);
datum.setWatts(val == null ? null : val.intValue());
val = (Number) rs.getObject(col++);
datum.setWattHourReading(val == null ? null : val.longValue());
return datum;
}
});
}
@Override
protected void setStoreStatementValues(ConsumptionDatum datum, PreparedStatement ps)
throws SQLException {
int col = 1;
ps.setTimestamp(col++,
new java.sql.Timestamp(datum.getCreated() == null ? System.currentTimeMillis() : datum
.getCreated().getTime()));
ps.setString(col++, datum.getSourceId() == null ? "" : datum.getSourceId());
if ( datum.getLocationId() == null ) {
ps.setNull(col++, Types.BIGINT);
} else {
ps.setLong(col++, datum.getLocationId());
}
if ( datum.getWatts() == null ) {
ps.setNull(col++, Types.INTEGER);
} else {
ps.setInt(col++, datum.getWatts());
}
if ( datum.getWattHourReading() == null ) {
ps.setNull(col++, Types.BIGINT);
} else {
ps.setLong(col++, datum.getWattHourReading());
}
}
}