Mercurial > hg > release > thermostat-0.11
view storage/core/src/main/java/com/redhat/thermostat/storage/internal/dao/AgentInfoDAOImpl.java @ 1152:4ba43dcff78e
Implement prepared statements (Part 1).
Reviewed-by: ebaron
Review-thread: http://icedtea.classpath.org/pipermail/thermostat/2013-June/007214.html
author | Severin Gehwolf <sgehwolf@redhat.com> |
---|---|
date | Fri, 28 Jun 2013 15:27:50 +0200 |
parents | 2e71b9784316 |
children |
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.Collections; import java.util.List; 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.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.Query; import com.redhat.thermostat.storage.core.Remove; 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.core.Update; import com.redhat.thermostat.storage.dao.AgentInfoDAO; import com.redhat.thermostat.storage.model.AgentInformation; import com.redhat.thermostat.storage.query.Expression; import com.redhat.thermostat.storage.query.ExpressionFactory; public class AgentInfoDAOImpl implements AgentInfoDAO { private static final Logger logger = LoggingUtils.getLogger(AgentInfoDAOImpl.class); private final Storage storage; private final ExpressionFactory factory; public AgentInfoDAOImpl(Storage storage) { this.storage = storage; storage.registerCategory(CATEGORY); factory = new ExpressionFactory(); } @Override public long getCount() { return storage.getCount(CATEGORY); } @Override public List<AgentInformation> getAllAgentInformation() { String allAgentsQuery = "QUERY " + CATEGORY.getName(); AgentInformationDescriptor desc = new AgentInformationDescriptor(CATEGORY, allAgentsQuery); PreparedStatement prepared = null; Cursor<AgentInformation> agentCursor = null; try { prepared = storage.prepareStatement(desc); agentCursor = prepared.executeQuery(); } catch (DescriptorParsingException e) { // should not happen, but if it *does* happen, at least log it logger.severe("Preparing query '" + desc + "' failed!"); return Collections.emptyList(); } catch (StatementExecutionException e) { // should not happen, but if it *does* happen, at least log it logger.severe("Executing query '" + desc + "' failed!"); return Collections.emptyList(); } List<AgentInformation> results = new ArrayList<>(); while (agentCursor.hasNext()) { AgentInformation agentInfo = agentCursor.next(); results.add(agentInfo); } return results; } @Override public List<AgentInformation> getAliveAgents() { // QUERY agent-config WHERE ? = true String allAgentsQuery = "QUERY " + CATEGORY.getName() + " WHERE ?s = ?b"; AgentInformationDescriptor desc = new AgentInformationDescriptor(CATEGORY, allAgentsQuery); PreparedStatement prepared = null; Cursor<AgentInformation> agentCursor = null; try { prepared = storage.prepareStatement(desc); prepared.setString(0, ALIVE_KEY.getName()); prepared.setBoolean(1, true); agentCursor = prepared.executeQuery(); } catch (DescriptorParsingException e) { // should not happen, but if it *does* happen, at least log it logger.severe("Preparing query '" + desc + "' failed!"); return Collections.emptyList(); } catch (StatementExecutionException e) { // should not happen, but if it *does* happen, at least log it logger.severe("Executing query '" + desc + "' failed!"); return Collections.emptyList(); } List<AgentInformation> results = new ArrayList<>(); while (agentCursor.hasNext()) { AgentInformation agentInfo = agentCursor.next(); results.add(agentInfo); } return results; } @Override public AgentInformation getAgentInformation(HostRef agentRef) { Query<AgentInformation> query = storage.createQuery(CATEGORY); Expression expr = factory.equalTo(Key.AGENT_ID, agentRef.getAgentId()); query.where(expr); query.limit(1); return query.execute().next(); } @Override public void addAgentInformation(AgentInformation agentInfo) { Put replace = storage.createReplace(CATEGORY); replace.setPojo(agentInfo); replace.apply(); } @Override public void removeAgentInformation(AgentInformation agentInfo) { Expression expr = factory.equalTo(Key.AGENT_ID, agentInfo.getAgentId()); Remove remove = storage.createRemove().from(CATEGORY).where(expr); storage.removePojo(remove); } @Override public void updateAgentInformation(AgentInformation agentInfo) { Update update = storage.createUpdate(CATEGORY); Expression expr = factory.equalTo(Key.AGENT_ID, agentInfo.getAgentId()); update.where(expr); update.set(START_TIME_KEY, agentInfo.getStartTime()); update.set(STOP_TIME_KEY, agentInfo.getStopTime()); update.set(ALIVE_KEY, agentInfo.isAlive()); update.set(CONFIG_LISTEN_ADDRESS, agentInfo.getConfigListenAddress()); update.apply(); } private static class AgentInformationDescriptor implements StatementDescriptor { private final Category<AgentInformation> category; private final String desc; private AgentInformationDescriptor(Category<AgentInformation> cat, String desc) { this.category = cat; this.desc = desc; } @Override public Category<?> getCategory() { return category; } @Override public String getQueryDescriptor() { return desc; } @Override public String toString() { return getClass().getSimpleName() + " " + desc; } } }