[Documentation] Integration with TestContainer

[otaviojava]

Hello, how are you?

Could you enhance the documentation and create a tutorial explaining how to test the Oracle NoSQL database with TestConateiner?

I know that we can use GenericContainer, but could you explain it more as documentation?

[gmfeinberg]

There is a fair bit of information in a separate repository with examples/tutorial information:
https://github.com/oracle/nosql-examples

[dario-vega]

Oi @otaviojava

I will add a new example/tutorial using test-containers at https://github.com/oracle/nosql-examples/tree/master/examples-nosql-java-sdk soon

In the meantime, here is a snippet using Junit4 and test-containers

import oracle.nosql.driver.NoSQLHandle;
import oracle.nosql.driver.NoSQLHandleConfig;
import oracle.nosql.driver.NoSQLHandleFactory;
import oracle.nosql.driver.kv.StoreAccessTokenProvider ;
import oracle.nosql.driver.ops.*;
import oracle.nosql.driver.values.MapValue;

import org.junit.Before;
import org.junit.After;
import org.junit.Test;
import org.junit.Rule;
import static org.junit.Assert.assertEquals;

import org.testcontainers.containers.GenericContainer;
import org.testcontainers.utility.DockerImageName;

public class TestHelloWorld {

    protected NoSQLHandle handle;

    protected void createTestTable() {
        final String createTableStatement = "create table if not exists testTable (id integer, name string, data json, primary key(id))";
        TableRequest tableRequest = new TableRequest()
                .setStatement(createTableStatement);
        handle.doTableRequest(tableRequest,
                                  20000, /* wait up to 20 sec */
                                  1000); /* poll once per second */
        System.out.println("Created table testTable ...");
    }


    @Rule
    public GenericContainer nosql = new GenericContainer(DockerImageName.parse("ghcr.io/oracle/nosql:latest-ce"))
          .withExposedPorts(8080);

    @Before
    public void beforeTest() throws Exception {
        String address = nosql.getHost();
        Integer port = nosql.getFirstMappedPort();

        //NoSQLHandleConfig config = new NoSQLHandleConfig("http://" + System.getenv("NOSQL_ENDPOINT") + ":" + System.getenv("NOSQL_PORT"));
        System.out.println("Connecting to http://" + address + ":" + port);
        NoSQLHandleConfig config = new NoSQLHandleConfig("http://" + address + ":" + port);
        config.setAuthorizationProvider(new StoreAccessTokenProvider());
        handle= NoSQLHandleFactory.createNoSQLHandle(config) ;
        createTestTable();
    }

    /**
     * clean up tables and close handle
     */
    @After
    public void afterTest() throws Exception {
        if (handle != null) {
            handle.close();
        }
    }

    @Test
    public void testQuery() {
        final String countQuery = "select count(1) as cnt from testTable";
        long cnt = 0;
        QueryRequest queryRequest = new QueryRequest().setStatement(countQuery);
        System.out.println(countQuery);
        try (QueryIterableResult results = handle.queryIterable(queryRequest)) {
                for (MapValue qval : results) {
                    cnt = qval.getLong("cnt");
                    System.out.println("countQuery : " + cnt);
                }
        }
        assertEquals(cnt , 0);
    }

}

https://github.com/oracle/docker-images/tree/main/NoSQL

This container image uses a simplified version of the Oracle NoSQL Database called KVLite. KVLite runs as a single process that provides a single storage node and single storage shard. KVLite does not include replication or administration. KVLite is NOT intended for production deployment or performance measurements.