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.camel.quarkus.component.jdbc.mariadb;
  
  import java.util.List;
  
  import io.quarkus.test.junit.QuarkusTest;
  import io.restassured.RestAssured;
  import io.restassured.http.ContentType;
  import org.junit.jupiter.api.Test;
  
  import static org.hamcrest.Matchers.containsStringIgnoringCase;
  import static org.hamcrest.Matchers.equalTo;
  import static org.hamcrest.Matchers.equalToIgnoringCase;
  import static org.hamcrest.Matchers.is;
  import static org.hamcrest.Matchers.not;
  import static org.wildfly.common.Assert.assertFalse;
  import static org.wildfly.common.Assert.assertNotNull;
  
  @QuarkusTest
  public class CamelMariaDbJdbcTest {
      String dbKind = "mariadb";
  
      @Test
      void testGetSpeciesById() {
          RestAssured.when().get("/test/" + dbKind + "/species/1").then()
                  .body(equalToIgnoringCase("[{SPECIES=Camelus dromedarius}]"));
          RestAssured.when().get("/test/" + dbKind + "/species/2").then()
                  .body(equalToIgnoringCase("[{SPECIES=Camelus bactrianus}]"));
          RestAssured.when().get("/test/" + dbKind + "/species/3").then().body(equalToIgnoringCase("[{SPECIES=Camelus ferus}]"));
      }
  
      @Test
      void testGetSpeciesByIdWithResultList() {
          RestAssured.when().get("/test/" + dbKind + "/species/1/list").then().body(is("Camelus dromedarius 1"));
      }
  
      @Test
      void testGetSpeciesByIdWithDefinedType() {
          RestAssured.when().get("/test/" + dbKind + "/species/1/type").then().body(equalToIgnoringCase("Camelus dromedarius 1"));
      }
  
      @Test
      void testExecuteStatement() {
          RestAssured.given()
                  .contentType(ContentType.TEXT).body("select id from camels order by id desc")
                  .post("/test/" + dbKind + "/execute")
                  .then().body(equalToIgnoringCase("[{ID=3}, {ID=2}, {ID=1}]"));
      }
  
      @Test
      void testCamelRetrieveGeneratedKeysHeader() {
          String idKey = "insert_id";
  
          List generatedIDs = RestAssured.given()
                  .get("test/" + dbKind + "/generated-keys/rows")
                  .then().extract().body()
                  .jsonPath().getList(idKey);
  
          assertFalse(generatedIDs.isEmpty());
          assertNotNull(generatedIDs.get(0));
      }
  
      @Test
      void testHeadersFromInsertOrUpdateQuery() {
          RestAssured.given()
                  .get("test/" + dbKind + "/headers/insert")
                  .then()
                  .body(containsStringIgnoringCase("CamelGeneratedKeysRowCount=1"))
                  .and()
                  .body(containsStringIgnoringCase("CamelJdbcUpdateCount=1"))
                  .and()
                  .body(containsStringIgnoringCase("CamelRetrieveGeneratedKeys=true"))
                  .and()
                  .body(not(containsStringIgnoringCase("CamelJdbcRowCount")))
                  .and()
                  .body(not(containsStringIgnoringCase("CamelJdbcColumnNames")))
                  .and()
                  .body(not(containsStringIgnoringCase("CamelJdbcParameters")))
                  .and()
                  .body(not(containsStringIgnoringCase("CamelGeneratedColumns")));
      }
  
      @Test
      void testHeadersFromSelectQuery() {
          RestAssured.given()
                  .get("test/" + dbKind + "/headers/select")
                  .then()
                  .body(not(containsStringIgnoringCase("CamelGeneratedKeysRowCount")))
                  .and()
                  .body(not(containsStringIgnoringCase("CamelJdbcUpdateCount")))
                  .and()
                  .body(not(containsStringIgnoringCase("CamelRetrieveGeneratedKeys")))
                  .and()
                  .body(not(containsStringIgnoringCase("CamelJdbcParameters")))
                  .and()
                  .body(not(containsStringIgnoringCase("CamelGeneratedColumns")))
                  .and()
                  .body(containsStringIgnoringCase("CamelJdbcRowCount"))
                  .and()
                  .body(containsStringIgnoringCase("CamelJdbcColumnNames=[ID, SPECIES]"));
      }
  
      @Test
      void testNamedParameters() {
          RestAssured.given()
                  .get("test/" + dbKind + "/named-parameters/headers-as-parameters")
                  .then()
                  .body(containsStringIgnoringCase("{ID=1, SPECIES=Camelus dromedarius}"))
                  .and()
                  .body(containsStringIgnoringCase("{ID=2, SPECIES=Camelus bactrianus}"));
      }
  
      @Test
      void testCamelJdbcParametersHeader() {
          RestAssured.given()
                  .get("test/" + dbKind + "/named-parameters/headers-as-parameters-map")
                  .then()
                  .body(containsStringIgnoringCase("{ID=2, SPECIES=Camelus bactrianus}"));
      }
  
      @Test
      void testTimeIntervalDatabasePolling() {
          String selectResult = RestAssured.given()
                  .contentType(ContentType.TEXT).body("select * from camelsGenerated order by id desc")
                  .post("/test/" + dbKind + "/execute")
                  .then().extract().body().asString();
  
          RestAssured.given()
                  .body(selectResult)
                  .get("/test/" + dbKind + "/interval-polling")
                  .then()
                  .statusCode(204);
      }
  
      @Test
      void testMoveDataBetweenDatasources() {
          String camelsDbResult = RestAssured.given()
                  .contentType(ContentType.TEXT).body("select * from camels order by id desc")
                  .post("/test/" + dbKind + "/execute")
                  .then().extract().body().asString();
  
          RestAssured.given()
                  .post("test/" + dbKind + "/move-between-datasources");
  
          RestAssured.given()
                  .contentType(ContentType.TEXT).body("select * from camelsProcessed order by id desc")
                  .post("/test/" + dbKind + "/execute")
                  .then()
                  .body(equalTo(camelsDbResult));
      }
  }
  