com.esri.geoportal.harvester.beans.BrokerDefinitionManagerBean.java Source code

Introduction

Here is the source code for com.esri.geoportal.harvester.beans.BrokerDefinitionManagerBean.java

Source

/*
 * Copyright 2016 Esri, Inc.
 *
 * Licensed 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.esri.geoportal.harvester.beans;

import com.esri.geoportal.harvester.api.defs.EntityDefinition;
import com.esri.geoportal.harvester.engine.managers.BrokerDefinitionManager;
import com.esri.geoportal.harvester.engine.utils.CrudlException;
import static com.esri.geoportal.harvester.engine.utils.JsonSerializer.serialize;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;
import java.util.HashMap;
import java.util.Map;
import java.util.UUID;
import javax.annotation.PostConstruct;
import javax.annotation.PreDestroy;
import javax.sql.DataSource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import static com.esri.geoportal.harvester.engine.utils.JsonSerializer.deserialize;

/**
 * Broker definition manager bean.
 */
@Service
public class BrokerDefinitionManagerBean implements BrokerDefinitionManager {

    private static final Logger LOG = LoggerFactory.getLogger(BrokerDefinitionManager.class);

    @Autowired
    private DataSource dataSource;

    /**
     * Initializes bean.
     */
    @PostConstruct
    public void init() {
        try (Connection connection = dataSource.getConnection();
                PreparedStatement st = connection.prepareStatement(
                        "CREATE TABLE IF NOT EXISTS BROKERS ( id varchar(38) PRIMARY KEY, brokerDefinition varchar(1024) NOT NULL)");) {
            st.execute();
            LOG.info("BrokerDefinitionManagerBean initialized.");
        } catch (SQLException ex) {
            LOG.info("Error initializing broker definition database", ex);
        }
    }

    /**
     * Destroys bean.
     */
    @PreDestroy
    public void destroy() {
        LOG.info(String.format("BrokerDefinitionManagerBean destroyed."));
    }

    @Override
    public UUID create(EntityDefinition brokerDef) throws CrudlException {
        UUID id = UUID.randomUUID();
        brokerDef.setRef(id.toString());
        try (Connection connection = dataSource.getConnection();
                PreparedStatement st = connection
                        .prepareStatement("INSERT INTO BROKERS (brokerDefinition,id) VALUES (?,?)");) {
            st.setString(1, serialize(brokerDef));
            st.setString(2, id.toString());
            st.executeUpdate();
        } catch (SQLException | IOException ex) {
            throw new CrudlException("Error creating broker definition", ex);
        }
        return id;
    }

    @Override
    public boolean update(UUID id, EntityDefinition brokerDef) throws CrudlException {
        brokerDef.setRef(id.toString());
        try (Connection connection = dataSource.getConnection();
                PreparedStatement st = connection
                        .prepareStatement("UPDATE BROKERS SET brokerDefinition = ? WHERE ID = ?");) {
            st.setString(1, serialize(brokerDef));
            st.setString(2, id.toString());
            return st.executeUpdate() > 0;
        } catch (SQLException | IOException ex) {
            throw new CrudlException("Error updating broker definition", ex);
        }
    }

    @Override
    public EntityDefinition read(UUID id) throws CrudlException {
        try (Connection connection = dataSource.getConnection();
                PreparedStatement st = connection.prepareStatement("SELECT * FROM BROKERS WHERE ID = ?");) {
            st.setString(1, id.toString());
            ResultSet rs = st.executeQuery();
            if (rs.next()) {
                try {
                    EntityDefinition brokerDef = deserialize(rs.getString("brokerDefinition"),
                            EntityDefinition.class);
                    brokerDef.setRef(id.toString());
                    return brokerDef;
                } catch (IOException | SQLException ex) {
                    LOG.warn("Error reading broker definition", ex);
                }
            }
        } catch (SQLException ex) {
            throw new CrudlException("Error reading broker definition", ex);
        }

        return null;
    }

    @Override
    public boolean delete(UUID id) throws CrudlException {
        try (Connection connection = dataSource.getConnection();
                PreparedStatement st = connection.prepareStatement("DELETE FROM BROKERS WHERE ID = ?");) {
            st.setString(1, id.toString());
            return st.executeUpdate() > 0;
        } catch (SQLException ex) {
            throw new CrudlException("Error deleting broker definition", ex);
        }
    }

    @Override
    public Collection<Map.Entry<UUID, EntityDefinition>> list() throws CrudlException {
        HashMap<UUID, EntityDefinition> map = new HashMap<>();
        try (Connection connection = dataSource.getConnection();
                PreparedStatement st = connection.prepareStatement("SELECT * FROM BROKERS");) {
            ResultSet rs = st.executeQuery();
            while (rs.next()) {
                try {
                    UUID id = UUID.fromString(rs.getString("id"));
                    EntityDefinition td = deserialize(rs.getString("brokerDefinition"), EntityDefinition.class);
                    td.setRef(id.toString());
                    map.put(id, td);
                } catch (IOException | SQLException ex) {
                    LOG.warn("Error reading broker definition", ex);
                }
            }
        } catch (SQLException ex) {
            throw new CrudlException("Error selecting broker definition", ex);
        }
        return map.entrySet();
    }

}