/*
* Copyright 2010-2012 Ning, Inc.
*
* Ning licenses this file to you under the Apache License, version 2.0
* (the "License"); you may not use this file except in compliance with the
* License. You may obtain a copy of the License at:
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
* WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
* License for the specific language governing permissions and limitations
* under the License.
*/
package com.ning.billing.usage.timeline.persistent;
import java.util.List;
import java.util.Map;
import javax.annotation.Nullable;
import org.joda.time.DateTime;
import org.skife.jdbi.v2.Handle;
import org.skife.jdbi.v2.IDBI;
import org.skife.jdbi.v2.Query;
import org.skife.jdbi.v2.ResultIterator;
import org.skife.jdbi.v2.exceptions.CallbackFailedException;
import org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException;
import org.skife.jdbi.v2.sqlobject.stringtemplate.StringTemplate3StatementLocator;
import org.skife.jdbi.v2.tweak.HandleCallback;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import com.ning.billing.usage.timeline.categories.CategoryIdAndMetric;
import com.ning.billing.usage.timeline.chunks.TimelineChunk;
import com.ning.billing.usage.timeline.chunks.TimelineChunkMapper;
import com.ning.billing.usage.timeline.consumer.TimelineChunkConsumer;
import com.ning.billing.usage.timeline.shutdown.StartTimes;
import com.ning.billing.usage.timeline.sources.SourceIdAndMetricId;
import com.ning.billing.usage.timeline.util.DateTimeUtils;
import com.google.common.base.Joiner;
import com.google.common.collect.BiMap;
import com.google.common.collect.HashBiMap;
import com.google.inject.Inject;
public class DefaultTimelineDao implements TimelineDao {
private static final Logger log = LoggerFactory.getLogger(DefaultTimelineDao.class);
private static final Joiner JOINER = Joiner.on(",");
private final IDBI dbi;
private final TimelineChunkMapper timelineChunkMapper;
private final TimelineSqlDao delegate;
@Inject
public DefaultTimelineDao(final IDBI dbi) {
this.dbi = dbi;
this.timelineChunkMapper = new TimelineChunkMapper();
this.delegate = dbi.onDemand(TimelineSqlDao.class);
}
@Override
public String getSource(final Integer sourceId) throws UnableToObtainConnectionException, CallbackFailedException {
return delegate.getSource(sourceId);
}
@Override
public Integer getSourceId(final String source) throws UnableToObtainConnectionException, CallbackFailedException {
return delegate.getSourceId(source);
}
@Override
public BiMap<Integer, String> getSources() throws UnableToObtainConnectionException, CallbackFailedException {
final HashBiMap<Integer, String> accumulator = HashBiMap.create();
for (final Map<String, Object> metric : delegate.getSources()) {
accumulator.put(Integer.valueOf(metric.get("source_id").toString()), metric.get("source_name").toString());
}
return accumulator;
}
@Override
public synchronized int getOrAddSource(final String source) throws UnableToObtainConnectionException, CallbackFailedException {
delegate.begin();
delegate.addSource(source);
final Integer sourceId = delegate.getSourceId(source);
delegate.commit();
return sourceId;
}
@Override
public Integer getEventCategoryId(final String eventCategory) throws UnableToObtainConnectionException, CallbackFailedException {
return delegate.getEventCategoryId(eventCategory);
}
@Override
public String getEventCategory(final Integer eventCategoryId) throws UnableToObtainConnectionException, CallbackFailedException {
return delegate.getEventCategory(eventCategoryId);
}
@Override
public BiMap<Integer, String> getEventCategories() throws UnableToObtainConnectionException, CallbackFailedException {
final HashBiMap<Integer, String> accumulator = HashBiMap.create();
for (final Map<String, Object> eventCategory : delegate.getEventCategories()) {
accumulator.put(Integer.valueOf(eventCategory.get("event_category_id").toString()), eventCategory.get("event_category").toString());
}
return accumulator;
}
@Override
public synchronized int getOrAddEventCategory(final String eventCategory) throws UnableToObtainConnectionException, CallbackFailedException {
delegate.begin();
delegate.addEventCategory(eventCategory);
final Integer eventCategoryId = delegate.getEventCategoryId(eventCategory);
delegate.commit();
return eventCategoryId;
}
@Override
public Integer getMetricId(final int eventCategoryId, final String metric) throws UnableToObtainConnectionException, CallbackFailedException {
return delegate.getMetricId(eventCategoryId, metric);
}
@Override
public CategoryIdAndMetric getCategoryIdAndMetric(final Integer metricId) throws UnableToObtainConnectionException, CallbackFailedException {
return delegate.getEventCategoryIdAndMetric(metricId);
}
@Override
public BiMap<Integer, CategoryIdAndMetric> getMetrics() throws UnableToObtainConnectionException, CallbackFailedException {
final HashBiMap<Integer, CategoryIdAndMetric> accumulator = HashBiMap.create();
for (final Map<String, Object> metricInfo : delegate.getMetrics()) {
accumulator.put(Integer.valueOf(metricInfo.get("sample_kind_id").toString()),
new CategoryIdAndMetric((Integer) metricInfo.get("event_category_id"), metricInfo.get("sample_kind").toString()));
}
return accumulator;
}
@Override
public synchronized int getOrAddMetric(final Integer sourceId, final Integer eventCategoryId, final String metric) throws UnableToObtainConnectionException, CallbackFailedException {
delegate.begin();
delegate.addMetric(eventCategoryId, metric);
final Integer metricId = delegate.getMetricId(eventCategoryId, metric);
delegate.commit();
return metricId;
}
@Override
public Iterable<Integer> getMetricIdsBySourceId(final Integer sourceId) throws UnableToObtainConnectionException, CallbackFailedException {
return delegate.getMetricIdsBySourceId(sourceId);
}
@Override
public Iterable<SourceIdAndMetricId> getMetricIdsForAllSources() throws UnableToObtainConnectionException, CallbackFailedException {
return delegate.getMetricIdsForAllSources();
}
@Override
public Long insertTimelineChunk(final TimelineChunk timelineChunk) throws UnableToObtainConnectionException, CallbackFailedException {
delegate.begin();
delegate.insertTimelineChunk(timelineChunk);
final long timelineChunkId = delegate.getLastInsertedId();
delegate.commit();
return timelineChunkId;
}
@Override
public void getSamplesBySourceIdsAndMetricIds(final List<Integer> sourceIdList,
@Nullable final List<Integer> metricIdList,
final DateTime startTime,
final DateTime endTime,
final TimelineChunkConsumer chunkConsumer) {
dbi.withHandle(new HandleCallback<Void>() {
@Override
public Void withHandle(final Handle handle) throws Exception {
handle.setStatementLocator(new StringTemplate3StatementLocator(TimelineSqlDao.class));
ResultIterator<TimelineChunk> iterator = null;
try {
final Query<Map<String, Object>> query = handle
.createQuery("getSamplesBySourceIdsAndMetricIds")
.bind("startTime", DateTimeUtils.unixSeconds(startTime))
.bind("endTime", DateTimeUtils.unixSeconds(endTime))
.define("sourceIds", JOINER.join(sourceIdList));
if (metricIdList != null && !metricIdList.isEmpty()) {
query.define("metricIds", JOINER.join(metricIdList));
}
iterator = query
.map(timelineChunkMapper)
.iterator();
while (iterator.hasNext()) {
chunkConsumer.processTimelineChunk(iterator.next());
}
return null;
} finally {
if (iterator != null) {
try {
iterator.close();
} catch (Exception e) {
log.error("Exception closing TimelineChunkAndTimes iterator for sourceIds {} and metricIds {}", sourceIdList, metricIdList);
}
}
}
}
});
}
@Override
public Integer insertLastStartTimes(final StartTimes startTimes) {
return delegate.insertLastStartTimes(startTimes);
}
@Override
public StartTimes getLastStartTimes() {
return delegate.getLastStartTimes();
}
@Override
public void deleteLastStartTimes() {
delegate.deleteLastStartTimes();
}
@Override
public void test() throws UnableToObtainConnectionException, CallbackFailedException {
delegate.test();
}
@Override
public void bulkInsertSources(final List<String> sources) throws UnableToObtainConnectionException, CallbackFailedException {
delegate.bulkInsertSources(sources.iterator());
}
@Override
public void bulkInsertEventCategories(final List<String> categoryNames) throws UnableToObtainConnectionException, CallbackFailedException {
delegate.bulkInsertEventCategories(categoryNames.iterator());
}
@Override
public void bulkInsertMetrics(final List<CategoryIdAndMetric> categoryAndKinds) {
delegate.bulkInsertMetrics(categoryAndKinds.iterator());
}
@Override
public void bulkInsertTimelineChunks(final List<TimelineChunk> timelineChunkList) {
delegate.bulkInsertTimelineChunks(timelineChunkList.iterator());
}
}