TestEntityWithComplexIndices.java

/*
 * Copyright (C) 2012-2016 DuyHai DOAN
 *
 * 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 info.archinnov.achilles.it;

import static info.archinnov.achilles.embedded.CassandraEmbeddedConfigParameters.DEFAULT_CASSANDRA_EMBEDDED_KEYSPACE_NAME;
import static org.assertj.core.api.Assertions.assertThat;

import java.util.List;

import org.apache.commons.lang3.RandomUtils;
import org.junit.Rule;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.mockito.runners.MockitoJUnitRunner;

import com.datastax.driver.core.Session;
import com.google.common.collect.ImmutableMap;
import com.google.common.collect.Sets;

import info.archinnov.achilles.generated.ManagerFactory;
import info.archinnov.achilles.generated.ManagerFactoryBuilder;
import info.archinnov.achilles.generated.manager.EntityWithComplexIndices_Manager;
import info.archinnov.achilles.internals.entities.EntityWithComplexIndices;
import info.archinnov.achilles.junit.AchillesTestResource;
import info.archinnov.achilles.junit.AchillesTestResourceBuilder;
import info.archinnov.achilles.script.ScriptExecutor;

@RunWith(MockitoJUnitRunner.class)
public class TestEntityWithComplexIndices {

    @Rule
    public AchillesTestResource<ManagerFactory> resource = AchillesTestResourceBuilder
            .forJunit()
            .entityClassesToTruncate(EntityWithComplexIndices.class)
            .truncateBeforeAndAfterTest()
            .build((cluster, statementsCache) -> ManagerFactoryBuilder
                    .builder(cluster)
                    .withManagedEntityClasses(EntityWithComplexIndices.class)
                    .doForceSchemaCreation(true)
                    .withStatementsCache(statementsCache)
                    .withDefaultKeyspaceName(DEFAULT_CASSANDRA_EMBEDDED_KEYSPACE_NAME)
                    .build());

    private Session session = resource.getNativeSession();
    private ScriptExecutor scriptExecutor = resource.getScriptExecutor();
    private EntityWithComplexIndices_Manager manager = resource.getManagerFactory().forEntityWithComplexIndices();

    @Test
    public void should_query_using_simple_index() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .simpleIndex().Eq("313")
                .getList();

        //Then
        assertThat(actual).hasSize(1);
        final EntityWithComplexIndices entity = actual.get(0);
        assertThat(entity.getFullIndexOnCollection()).containsExactly("313");
    }

    @Test
    public void should_query_using_collection_index() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .collectionIndex().Contains("4")
                .getList();

        //Then
        assertThat(actual).hasSize(1);
        final EntityWithComplexIndices entity = actual.get(0);
        assertThat(entity.getSimpleIndex()).isEqualTo("411");
    }

    @Test
    public void should_query_using_full_collection_index() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .fullIndexOnCollection().Eq(Sets.newHashSet("311"))
                .getList();

        //Then
        assertThat(actual).hasSize(1);
        final EntityWithComplexIndices entity = actual.get(0);
        assertThat(entity.getSimpleIndex()).isEqualTo("311");
    }

    @Test
    public void should_query_using_map_key_index() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .indexOnMapKey().ContainsKey("312")
                .getList();

        //Then
        assertThat(actual).hasSize(1);
        final EntityWithComplexIndices entity = actual.get(0);
        assertThat(entity.getSimpleIndex()).isEqualTo("312");
    }

    @Test
    public void should_query_using_map_key_value() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .indexOnMapValue().ContainsValue("211")
                .getList();

        //Then
        assertThat(actual).hasSize(1);
        final EntityWithComplexIndices entity = actual.get(0);
        assertThat(entity.getSimpleIndex()).isEqualTo("211");
    }

    @Test
    public void should_query_using_map_key_entry() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .indexOnMapEntry().ContainsEntry(212, "212")
                .getList();

        //Then
        assertThat(actual).hasSize(1);
        final EntityWithComplexIndices entity = actual.get(0);
        assertThat(entity.getSimpleIndex()).isEqualTo("212");
    }

    @Test
    public void should_query_using_index_and_partition_key() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .simpleIndex().Eq("313")
                .id().Eq(id)
                .getList();

        //Then
        assertThat(actual).hasSize(1);
        final EntityWithComplexIndices entity = actual.get(0);
        assertThat(entity.getSimpleIndex()).isEqualTo("313");
    }

    @Test
    public void should_query_using_index_and_clustering_column() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .simpleIndex().Eq("312")
                .clust1().Eq(3)
                .clust3().Eq("2")
                .getList();

        //Then
        assertThat(actual).hasSize(1);
        final EntityWithComplexIndices entity = actual.get(0);
        assertThat(entity.getSimpleIndex()).isEqualTo("312");
    }

    @Test
    public void should_query_using_index_and_clustering_column_slice() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .simpleIndex().Eq("312")
                .clust1().Gte_And_Lte(1, 4)
                .getList();

        //Then
        assertThat(actual).hasSize(1);
        final EntityWithComplexIndices entity = actual.get(0);
        assertThat(entity.getSimpleIndex()).isEqualTo("312");
    }

    @Test
    public void should_query_using_index_and_clustering_column_inequality() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .simpleIndex().Eq("312")
                .clust1().Gte(5)
                .getList();

        //Then
        assertThat(actual).hasSize(0);
    }

    @Test
    public void should_query_using_index_and_multi_clustering_columns_slice() throws Exception {
        //Given
        final Long id = RandomUtils.nextLong(0L, Long.MAX_VALUE);
        scriptExecutor.executeScriptTemplate("EntityWithIndicesForJSON/insertRows.cql", ImmutableMap.of("id", id));

        //When
        final List<EntityWithComplexIndices> actual = manager
                .indexed()
                .select()
                .allColumns_FromBaseTable()
                .where()
                .simpleIndex().Eq("312")
                .clust1_clust2_clust3().clust1_And_clust2_And_clust3_Gte_And_clust1_And_clust2_Lte(1, 1, "1", 3, 2)
                .getList();

        //Then
        assertThat(actual).hasSize(1);
        final EntityWithComplexIndices entity = actual.get(0);
        assertThat(entity.getSimpleIndex()).isEqualTo("312");
    }
}