/*
 * Copyright (C) 2004-2008 Jive Software, 2017-2025 Ignite Realtime Foundation. All rights reserved.
 *
 * 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 org.jivesoftware.database;

import org.apache.commons.dbcp2.*;
import org.apache.commons.pool2.impl.GenericObjectPool;
import org.apache.commons.pool2.impl.GenericObjectPoolConfig;
import org.jivesoftware.util.JiveGlobals;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Path;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.time.Duration;

/**
 * A connection provider for the embedded hsqlDB database. The database file is stored at
 * {@code home/database}. The log file for this connection provider is stored at
 * {@code [home]/logs/EmbeddedConnectionProvider.log}, so you should ensure
 * that the {@code [home]/logs} directory exists.
 *
 * @author Matt Tucker
 */
public class EmbeddedConnectionProvider implements ConnectionProvider {

    private static final Logger Log = LoggerFactory.getLogger(EmbeddedConnectionProvider.class);

    private String serverURL;
    private PoolingDataSource<PoolableConnection> dataSource;

    public EmbeddedConnectionProvider() {
    }

    @Override
    public boolean isPooled() {
        return true;
    }

    @Override
    public Connection getConnection() throws SQLException {
        if (dataSource == null) {
            throw new SQLException("Check HSQLDB properties; data source was not be initialised");
        }
        return dataSource.getConnection();
    }

    @Override
    public void start() {
        final Path databaseDir = JiveGlobals.getHomePath().resolve("embedded-db");
        // If the database doesn't exist, create it.
        if (!Files.exists(databaseDir)) {
            if (Files.isSymbolicLink(databaseDir)) {
                Log.error("'embedded-db' {} is a link to a directory that doesn't exists", databaseDir);
                throw new RuntimeException("'embedded-db' %s is a link to a directory that doesn't exists".formatted(databaseDir));
            }
            try {
                Files.createDirectory(databaseDir);
            } catch (IOException e) {
                Log.error("Unable to create 'embedded-db' directory", e);
                throw new RuntimeException("Unable to create 'embedded-db' directory", e);
            }
        }

        serverURL = "jdbc:hsqldb:" + databaseDir.resolve("openfire");
        final ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(serverURL, "sa", "");
        final PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory, null);
        poolableConnectionFactory.setMaxConnLifetimeMillis(Duration.ofHours(12).toMillis());

        final GenericObjectPoolConfig<PoolableConnection> poolConfig = new GenericObjectPoolConfig<>();
        poolConfig.setMinIdle(3);
        poolConfig.setMaxTotal(25);
        final GenericObjectPool<PoolableConnection> connectionPool = new GenericObjectPool<>(poolableConnectionFactory, poolConfig);
        poolableConnectionFactory.setPool(connectionPool);
        dataSource = new PoolingDataSource<>(connectionPool);
    }

    @Override
    public void restart() {
        // Kill off pool.
        destroy();
        // Start a new pool.
        start();
    }

    @Override
    public void destroy() {
        // Shutdown the database.
        Connection con = null;
        PreparedStatement pstmt = null;
        try {
            con = getConnection();
            pstmt = con.prepareStatement("SHUTDOWN");
            pstmt.execute();
        }
        catch (SQLException sqle) {
            Log.error(sqle.getMessage(), sqle);
        }
        finally {
            DbConnectionManager.closeConnection(pstmt, con);
        }
        try {
            if (dataSource != null) {
                dataSource.close();
            }
        } catch (final Exception e) {
            Log.error("Unable to close the data source", e);
        }
    }

    @Override
    public void finalize() throws Throwable {
        destroy();
        super.finalize();
    }
}