Mercurial > hg > release > thermostat-0.13
view storage/core/src/main/java/com/redhat/thermostat/storage/internal/dao/HostInfoDAOImpl.java @ 1218:e2034aa58edf
Implement aggregate prepared query (count).
Reviewed-by: omajid
Review-thread: http://icedtea.classpath.org/pipermail/thermostat/2013-August/007834.html
PR1509
author | Severin Gehwolf <sgehwolf@redhat.com> |
---|---|
date | Fri, 09 Aug 2013 10:43:36 +0200 |
parents | b43db0f054d2 |
children | b015c7f31a11 |
line wrap: on
line source
/* * Copyright 2012, 2013 Red Hat, Inc. * * This file is part of Thermostat. * * Thermostat 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, or (at your * option) any later version. * * Thermostat 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 Thermostat; see the file COPYING. If not see * <http://www.gnu.org/licenses/>. * * Linking this code with other modules is making a combined work * based on this code. Thus, the terms and conditions of the GNU * General Public License cover the whole combination. * * As a special exception, the copyright holders of this code give * you permission to link this code with independent modules to * produce an executable, regardless of the license terms of these * independent modules, and to copy and distribute the resulting * executable under terms of your choice, provided that you also * meet, for each linked independent module, the terms and conditions * of the license of that module. An independent module is a module * which is not derived from or based on this code. If you modify * this code, you may extend this exception to your version of the * library, but you are not obligated to do so. If you do not wish * to do so, delete this exception statement from your version. */ package com.redhat.thermostat.storage.internal.dao; import java.util.ArrayList; import java.util.Collection; import java.util.Collections; import java.util.List; import java.util.logging.Level; import java.util.logging.Logger; import com.redhat.thermostat.common.utils.LoggingUtils; import com.redhat.thermostat.storage.core.Category; import com.redhat.thermostat.storage.core.CategoryAdapter; import com.redhat.thermostat.storage.core.Cursor; import com.redhat.thermostat.storage.core.DescriptorParsingException; import com.redhat.thermostat.storage.core.HostRef; import com.redhat.thermostat.storage.core.Key; import com.redhat.thermostat.storage.core.PreparedStatement; import com.redhat.thermostat.storage.core.Put; import com.redhat.thermostat.storage.core.StatementDescriptor; import com.redhat.thermostat.storage.core.StatementExecutionException; import com.redhat.thermostat.storage.core.Storage; import com.redhat.thermostat.storage.dao.AgentInfoDAO; import com.redhat.thermostat.storage.dao.HostInfoDAO; import com.redhat.thermostat.storage.model.AgentInformation; import com.redhat.thermostat.storage.model.AggregateCount; import com.redhat.thermostat.storage.model.HostInfo; public class HostInfoDAOImpl extends BaseCountable implements HostInfoDAO { private static final Logger logger = LoggingUtils.getLogger(HostInfoDAOImpl.class); static final String QUERY_HOST_INFO = "QUERY " + hostInfoCategory.getName() + " WHERE '" + Key.AGENT_ID.getName() + "' = ?s LIMIT 1"; static final String QUERY_ALL_HOSTS = "QUERY " + hostInfoCategory.getName(); // We can use hostInfoCategory.getName() here since this query // only changes the data class. When executed we use the adapted // aggregate category. static final String AGGREGATE_COUNT_ALL_HOSTS = "QUERY-COUNT " + hostInfoCategory.getName(); private final Storage storage; private final AgentInfoDAO agentInfoDao; private final Category<AggregateCount> aggregateCategory; public HostInfoDAOImpl(Storage storage, AgentInfoDAO agentInfo) { this.storage = storage; this.agentInfoDao = agentInfo; // Adapt category to the aggregate form CategoryAdapter<HostInfo, AggregateCount> adapter = new CategoryAdapter<>(hostInfoCategory); this.aggregateCategory = adapter.getAdapted(AggregateCount.class); storage.registerCategory(hostInfoCategory); storage.registerCategory(aggregateCategory); } @Override public HostInfo getHostInfo(HostRef ref) { return getHostInfo(ref.getAgentId()); } private HostInfo getHostInfo(String agentId) { StatementDescriptor<HostInfo> desc = new StatementDescriptor<>(hostInfoCategory, QUERY_HOST_INFO); PreparedStatement<HostInfo> prepared; Cursor<HostInfo> cursor; try { prepared = storage.prepareStatement(desc); prepared.setString(0, agentId); cursor = prepared.executeQuery(); } catch (DescriptorParsingException e) { // should not happen, but if it *does* happen, at least log it logger.log(Level.SEVERE, "Preparing query '" + desc + "' failed!", e); return null; } catch (StatementExecutionException e) { // should not happen, but if it *does* happen, at least log it logger.log(Level.SEVERE, "Executing query '" + desc + "' failed!", e); return null; } HostInfo result = null; if (cursor.hasNext()) { result = cursor.next(); } return result; } @Override public void putHostInfo(HostInfo info) { Put add = storage.createAdd(hostInfoCategory); add.setPojo(info); add.apply(); } @Override public Collection<HostRef> getHosts() { Cursor<HostInfo> cursor = getAllHostInfoCursor(); if (cursor == null) { return Collections.emptyList(); } List<HostRef> result = new ArrayList<>(); while (cursor.hasNext()) { HostInfo hostInfo = cursor.next(); result.add(toHostRef(hostInfo)); } return result; } @Override public Collection<HostRef> getAliveHosts() { List<HostRef> hosts = new ArrayList<>(); List<AgentInformation> agentInfos = agentInfoDao.getAliveAgents(); for (AgentInformation agentInfo : agentInfos) { HostInfo hostInfo = getHostInfo(agentInfo.getAgentId()); // getHostInfo may return null if user is not allowed to // see the given host by ACL. if (hostInfo != null) { hosts.add(toHostRef(hostInfo)); } } return hosts; } private HostRef toHostRef(HostInfo hostInfo) { String agentId = hostInfo.getAgentId(); String hostName = hostInfo.getHostname(); return new HostRef(agentId, hostName); } private Cursor<HostInfo> getAllHostInfoCursor() { StatementDescriptor<HostInfo> desc = new StatementDescriptor<>(hostInfoCategory, QUERY_ALL_HOSTS); PreparedStatement<HostInfo> prepared; try { prepared = storage.prepareStatement(desc); return prepared.executeQuery(); } catch (DescriptorParsingException e) { // should not happen, but if it *does* happen, at least log it logger.log(Level.SEVERE, "Preparing query '" + desc + "' failed!", e); return null; } catch (StatementExecutionException e) { // should not happen, but if it *does* happen, at least log it logger.log(Level.SEVERE, "Executing query '" + desc + "' failed!", e); return null; } } @Override public long getCount() { StatementDescriptor<AggregateCount> desc = new StatementDescriptor<>( aggregateCategory, AGGREGATE_COUNT_ALL_HOSTS); long count = getCount(desc, storage); return count; } }