/*
 * Copyright Amazon.com, Inc. or its affiliates. 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.
 * A copy of the License is located at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * or in the "license" file accompanying this file. This file 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 software.aws.neptune.opencypher;

import org.junit.jupiter.api.AfterAll;
import org.junit.jupiter.api.Assertions;
import org.junit.jupiter.api.BeforeAll;
import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;
import software.aws.neptune.jdbc.Driver;
import software.aws.neptune.jdbc.helpers.HelperFunctions;
import software.aws.neptune.jdbc.utilities.AuthScheme;
import software.aws.neptune.jdbc.utilities.ConnectionProperties;
import software.aws.neptune.jdbc.utilities.SqlError;
import software.aws.neptune.opencypher.mock.MockOpenCypherDatabase;
import software.aws.neptune.opencypher.mock.MockOpenCypherNodes;
import software.aws.neptune.opencypher.resultset.OpenCypherResultSet;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import java.util.concurrent.atomic.AtomicReference;

public class OpenCypherConnectionTest {
    private static final String HOSTNAME = "localhost";
    private static final String QUERY =
            "MATCH (p1:Person)-[:KNOWS]->(p2:Person)-[:GIVES_PETS_TO]->(k:Kitty) WHERE k.name = 'tootsie' RETURN p1, p2, k";
    private static final Properties PROPERTIES = new Properties();
    private static final String TEST_PROP_KEY_UNSUPPORTED = "unsupported";
    private static final String TEST_PROP_VAL_UNSUPPORTED = "unsupported";
    private static final String TEST_PROP_KEY = "connectionTimeout";
    private static final String TEST_PROP_VAL = "1";
    private static final Properties TEST_PROP = new Properties();
    private static final Properties TEST_PROP_INITIAL = new Properties();
    private static final Properties TEST_PROP_MODIFIED = new Properties();
    private static MockOpenCypherDatabase database;
    private java.sql.Connection connection;

    /**
     * Function to get a random available port and initialize database before testing.
     */
    @BeforeAll
    public static void initializeDatabase() {
        database = MockOpenCypherDatabase.builder(HOSTNAME, OpenCypherConnectionTest.class.getName())
                .withNode(MockOpenCypherNodes.LYNDON)
                .withNode(MockOpenCypherNodes.VALENTINA)
                .withNode(MockOpenCypherNodes.VINNY)
                .withNode(MockOpenCypherNodes.TOOTSIE)
                .withRelationship(MockOpenCypherNodes.LYNDON, MockOpenCypherNodes.VALENTINA, "KNOWS", "KNOWS")
                .withRelationship(MockOpenCypherNodes.LYNDON, MockOpenCypherNodes.VINNY, "GIVES_PETS_TO",
                        "GETS_PETS_FROM")
                .withRelationship(MockOpenCypherNodes.VALENTINA, MockOpenCypherNodes.TOOTSIE, "GIVES_PETS_TO",
                        "GETS_PETS_FROM")
                .build();
        PROPERTIES.putIfAbsent(OpenCypherConnectionProperties.ENDPOINT_KEY,
                String.format("bolt://%s:%d", HOSTNAME, database.getPort()));
    }

    /**
     * Function to get a shutdown database after testing.
     */
    @AfterAll
    public static void shutdownDatabase() {
        database.shutdown();
    }

    @BeforeEach
    void initialize() throws SQLException {
        PROPERTIES.put(ConnectionProperties.AUTH_SCHEME_KEY, AuthScheme.None); // set default to None
        connection = new OpenCypherConnection(new OpenCypherConnectionProperties(PROPERTIES));

        TEST_PROP.put(TEST_PROP_KEY, TEST_PROP_VAL);
        TEST_PROP_INITIAL.put(ConnectionProperties.APPLICATION_NAME_KEY, Driver.APPLICATION_NAME);
        TEST_PROP_INITIAL.putAll(ConnectionProperties.DEFAULT_PROPERTIES_MAP);
        TEST_PROP_INITIAL.putAll(OpenCypherConnectionProperties.DEFAULT_PROPERTIES_MAP);
        TEST_PROP_INITIAL.putAll(PROPERTIES);
        TEST_PROP_MODIFIED.putAll(TEST_PROP_INITIAL);
        TEST_PROP_MODIFIED.remove(TEST_PROP_KEY);
    }

    @Test
    void testOpenCypherConnectionPrepareStatementType() {
        final AtomicReference<PreparedStatement> statement = new AtomicReference<>();
        Assertions.assertDoesNotThrow(() -> statement.set(connection.prepareStatement(QUERY)));
        Assertions.assertTrue(statement.get() instanceof software.aws.neptune.jdbc.PreparedStatement);

        final AtomicReference<ResultSet> openCypherResultSet = new AtomicReference<>();
        Assertions.assertDoesNotThrow(() -> openCypherResultSet.set(statement.get().executeQuery()));
        Assertions.assertTrue(openCypherResultSet.get() instanceof OpenCypherResultSet);
    }

    @Test
    void testOpenCypherConnectionStatementType() {
        final AtomicReference<Statement> statement = new AtomicReference<>();
        Assertions.assertDoesNotThrow(() -> statement.set(connection.createStatement()));
        Assertions.assertTrue(statement.get() instanceof software.aws.neptune.jdbc.Statement);

        final AtomicReference<ResultSet> openCypherResultSet = new AtomicReference<>();
        Assertions.assertDoesNotThrow(() -> openCypherResultSet.set(statement.get().executeQuery(QUERY)));
        Assertions.assertTrue(openCypherResultSet.get() instanceof OpenCypherResultSet);
    }

    @Test
    void testClientInfo() {
        HelperFunctions.expectFunctionDoesntThrow(() -> connection.getClientInfo(), TEST_PROP_INITIAL);

        HelperFunctions.expectFunctionDoesntThrow(() -> connection.setClientInfo(null));
        HelperFunctions.expectFunctionDoesntThrow(() -> connection.getClientInfo(null), null);
        HelperFunctions.expectFunctionDoesntThrow(() -> connection.getClientInfo(), TEST_PROP_INITIAL);

        HelperFunctions.expectFunctionDoesntThrow(() -> connection.getClientInfo(), TEST_PROP_INITIAL);

        HelperFunctions.expectFunctionDoesntThrow(() -> connection.setClientInfo(TEST_PROP_KEY, TEST_PROP_VAL));
        HelperFunctions.expectFunctionDoesntThrow(() -> connection.getClientInfo(TEST_PROP_KEY), TEST_PROP_VAL);

        HelperFunctions.expectFunctionDoesntThrow(() -> connection.setClientInfo(TEST_PROP_KEY, ""));
        HelperFunctions.expectFunctionDoesntThrow(() -> connection.getClientInfo(), TEST_PROP_INITIAL);

        HelperFunctions.expectFunctionDoesntThrow(() -> connection.setClientInfo(TEST_PROP));
        HelperFunctions.expectFunctionDoesntThrow(() -> connection.getClientInfo(TEST_PROP_KEY), TEST_PROP_VAL);

        HelperFunctions.expectFunctionDoesntThrow(() -> connection.setClientInfo(TEST_PROP_KEY, null));
        HelperFunctions.expectFunctionDoesntThrow(() -> connection.getClientInfo(), TEST_PROP_MODIFIED);

        HelperFunctions.expectFunctionThrows(
                SqlError.lookup(SqlError.INVALID_CONNECTION_PROPERTY, TEST_PROP_KEY_UNSUPPORTED, ""),
                () -> connection.setClientInfo(TEST_PROP_KEY_UNSUPPORTED, ""));
        HelperFunctions.expectFunctionThrows(
                SqlError.lookup(SqlError.INVALID_CONNECTION_PROPERTY, TEST_PROP_KEY, TEST_PROP_VAL_UNSUPPORTED),
                () -> connection.setClientInfo(TEST_PROP_KEY, TEST_PROP_VAL_UNSUPPORTED));

        HelperFunctions.expectFunctionDoesntThrow(() -> connection.close());
        HelperFunctions.expectFunctionThrows(
                SqlError.CONN_CLOSED,
                () -> connection.setClientInfo(TEST_PROP_KEY, TEST_PROP_VAL));
        HelperFunctions.expectFunctionThrows(
                SqlError.CONN_CLOSED,
                () -> connection.setClientInfo(TEST_PROP));
    }
}