/*
 * Copyright 2010-2013 Ning, Inc.
 * Copyright 2014-2018 Groupon, Inc
 * Copyright 2014-2018 The Billing Project, LLC
 *
 * The Billing Project 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 org.killbill.billing;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.List;

import javax.annotation.Nullable;
import javax.cache.CacheManager;
import javax.inject.Named;
import javax.sql.DataSource;

import org.killbill.billing.util.cache.CacheControllerDispatcher;
import org.killbill.commons.embeddeddb.EmbeddedDB;
import org.skife.jdbi.v2.IDBI;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.testng.Assert;
import org.testng.annotations.AfterSuite;
import org.testng.annotations.BeforeMethod;
import org.testng.annotations.BeforeSuite;

import com.google.common.collect.ImmutableMap;
import com.google.inject.Inject;

import static org.killbill.billing.util.glue.IDBISetup.MAIN_RO_IDBI_NAMED;

public class GuicyKillbillTestSuiteWithEmbeddedDB extends GuicyKillbillTestSuite {

    private static final Logger log = LoggerFactory.getLogger(GuicyKillbillTestSuiteWithEmbeddedDB.class);

    @Inject
    protected EmbeddedDB helper;

    @Inject
    protected DataSource dataSource;

    @Inject
    protected IDBI dbi;

    @Inject
    @Named(MAIN_RO_IDBI_NAMED)
    protected IDBI roDbi;

    @Inject
    protected CacheControllerDispatcher controlCacheDispatcher;

    @Nullable
    @Inject(optional = true)
    protected CacheManager cacheManager;

    @BeforeSuite(groups = "slow")
    public void beforeSuite() throws Exception {
        // Hack to configure log4jdbc -- properties used by tests will be properly setup in @BeforeClass
        getConfigSource(ImmutableMap.<String, String>of());
        DBTestingHelper.get().start();
    }

    @BeforeMethod(groups = "slow")
    public void beforeMethod() throws Exception {
        if (hasFailed()) {
            return;
        }

        cleanupAllTables();
        callContext.setDelegate(null, internalCallContext);
        controlCacheDispatcher.clearAll();
    }

    protected void cleanupAllTables() {
        try {
            DBTestingHelper.get().getInstance().cleanupAllTables();
        } catch (final Exception e) {
            Assert.fail("Unable to clean database", e);
        }
    }

    @AfterSuite(groups = "slow")
    public void afterSuite() throws Exception {
        if (hasFailed()) {
            dumpDB();
            log.error("**********************************************************************************************");
            log.error("*** TESTS HAVE FAILED - LEAVING DB RUNNING FOR DEBUGGING - MAKE SURE TO KILL IT ONCE DONE ****");
            log.error(DBTestingHelper.get().getInstance().getCmdLineConnectionString());
            log.error("**********************************************************************************************");
            return;
        }

        if (cacheManager != null) {
            cacheManager.close();
        }

        try {
            DBTestingHelper.get().getInstance().stop();
        } catch (final Exception ignored) {
        }
    }

    private void dumpDB() {
        log.error("*********************************************");
        log.error("*** TESTS HAVE FAILED - DUMPING DATABASE ****");
        log.error("*********************************************\n");

        try {
            final EmbeddedDB embeddedDB = DBTestingHelper.get().getInstance();
            final List<String> tables = embeddedDB.getAllTables();

            final Connection connection = embeddedDB.getDataSource().getConnection();
            try {
                for (final String table : tables) {
                    final StringBuilder tableDump = new StringBuilder("Table ").append(table).append("\n");
                    boolean hasData = false;

                    Statement statement = null;
                    try {
                        statement = connection.createStatement();
                        final ResultSet rs = statement.executeQuery("select * from " + table);

                        final ResultSetMetaData metadata = rs.getMetaData();
                        final int columnCount = metadata.getColumnCount();
                        for (int i = 1; i <= columnCount; i++) {
                            tableDump.append(metadata.getColumnName(i)).append(",");
                        }
                        tableDump.append("\n");

                        while (rs.next()) {
                            hasData = true;
                            for (int i = 1; i <= columnCount; i++) {
                                tableDump.append(rs.getString(i)).append(",");
                            }
                            tableDump.append("\n");
                        }
                    } finally {
                        if (statement != null) {
                            statement.close();
                        }
                    }

                    if (hasData) {
                        log.error(tableDump.toString());
                    }
                }
            } finally {
                connection.close();
            }
            log.error("*********************************************");
        } catch (final Exception e) {
            log.error("Unable to dump DB");
        }
    }
}
