content: /*
   * Licensed to the Apache Software Foundation (ASF) under one or more
   * contributor license agreements.  See the NOTICE file distributed with
   * this work for additional information regarding copyright ownership.
   * The ASF 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.apache.calcite.adapter.elasticsearch;
  
  import org.apache.calcite.jdbc.CalciteConnection;
  import org.apache.calcite.schema.SchemaPlus;
  import org.apache.calcite.schema.impl.ViewTable;
  import org.apache.calcite.test.CalciteAssert;
  
  import com.fasterxml.jackson.databind.node.ObjectNode;
  import com.google.common.collect.ImmutableMap;
  
  import org.junit.jupiter.api.BeforeAll;
  import org.junit.jupiter.api.Test;
  import org.junit.jupiter.api.parallel.ResourceAccessMode;
  import org.junit.jupiter.api.parallel.ResourceLock;
  
  import java.sql.Connection;
  import java.sql.DriverManager;
  import java.sql.SQLException;
  import java.util.Arrays;
  import java.util.Collections;
  import java.util.Locale;
  import java.util.Map;
  
  /**
   * Checks renaming of fields (also upper, lower cases) during projections.
   */
  @ResourceLock(value = "elasticsearch-scrolls", mode = ResourceAccessMode.READ)
  class ProjectionTest {
  
    public static final EmbeddedElasticsearchPolicy NODE = EmbeddedElasticsearchPolicy.create();
  
    private static final String NAME = "projectiontest";
  
    @BeforeAll
    public static void setupInstance() throws Exception {
      final Map<String, String> mappings =
          ImmutableMap.of("A", "keyword",
              "b", "keyword", "cCC", "keyword", "DDd", "keyword");
  
      NODE.createIndex(NAME, mappings);
  
      String doc = "{'A': 'aa', 'b': 'bb', 'cCC': 'cc', 'DDd': 'dd'}".replace('\'', '"');
      NODE.insertDocument(NAME, (ObjectNode) NODE.mapper().readTree(doc));
    }
  
    private static Connection createConnection() throws SQLException {
      final Connection connection =
          DriverManager.getConnection("jdbc:calcite:");
      final SchemaPlus root =
          connection.unwrap(CalciteConnection.class).getRootSchema();
  
      root.add("elastic",
          new ElasticsearchSchema(NODE.restClient(), NODE.mapper(), NAME));
  
      // add calcite view programmatically
      final String viewSql =
          String.format(Locale.ROOT, "select cast(_MAP['A'] AS varchar(2)) AS a,"
              + " cast(_MAP['b'] AS varchar(2)) AS b, "
              + " cast(_MAP['cCC'] AS varchar(2)) AS c, "
              + " cast(_MAP['DDd'] AS varchar(2)) AS d "
              + " from \"elastic\".\"%s\"", NAME);
  
      root.add("VIEW",
          ViewTable.viewMacro(root, viewSql,
              Collections.singletonList("elastic"),
              Arrays.asList("elastic", "view"), false));
  
      return connection;
    }
  
    @Test void projection() {
      CalciteAssert.that()
          .with(ProjectionTest::createConnection)
          .query("select * from view")
          .returns("A=aa; B=bb; C=cc; D=dd\n");
  
      CalciteAssert.that()
          .with(ProjectionTest::createConnection)
          .query("select a, b, c, d from view")
          .returns("A=aa; B=bb; C=cc; D=dd\n");
  
      CalciteAssert.that()
          .with(ProjectionTest::createConnection)
          .query("select d, c, b, a from view")
          .returns("D=dd; C=cc; B=bb; A=aa\n");
  
      CalciteAssert.that()
          .with(ProjectionTest::createConnection)
          .query("select a from view")
          .returns("A=aa\n");
  
      CalciteAssert.that()
          .with(ProjectionTest::createConnection)
          .query("select a, b from view")
          .returns("A=aa; B=bb\n");
  
      CalciteAssert.that()
          .with(ProjectionTest::createConnection)
          .query("select b, a from view")
          .returns("B=bb; A=aa\n");
  
    }
  
  }
  