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.causeway.testdomain.persistence.jdo;
  
  import java.sql.SQLException;
  
  import org.junit.jupiter.api.BeforeAll;
  import org.junit.jupiter.api.Disabled;
  import org.junit.jupiter.api.MethodOrderer;
  import org.junit.jupiter.api.Order;
  import org.junit.jupiter.api.Test;
  import org.junit.jupiter.api.TestMethodOrder;
  
  import static org.junit.jupiter.api.Assertions.assertEquals;
  import static org.junit.jupiter.api.Assertions.assertNotNull;
  
  import org.springframework.boot.test.context.SpringBootTest;
  import org.springframework.test.context.TestPropertySource;
  import org.springframework.transaction.annotation.Transactional;
  
  import org.apache.causeway.applib.query.Query;
  import org.apache.causeway.core.config.presets.CausewayPresets;
  import org.apache.causeway.testdomain.jdo.RegressionTestWithJdoFixtures;
  import org.apache.causeway.testdomain.jdo.conf.Configuration_usingJdo;
  import org.apache.causeway.testdomain.jdo.entities.JdoBook;
  import org.apache.causeway.testdomain.jdo.entities.JdoInventory;
  import org.apache.causeway.testdomain.jdo.entities.JdoProduct;
  
  @SpringBootTest(
          classes = {
                  Configuration_usingJdo.class,
          },
          properties = {
                  "spring.datasource.url=jdbc:h2:mem:JdoQueryTest"
          })
  @TestPropertySource(CausewayPresets.UseLog4j2Test)
  @TestMethodOrder(MethodOrderer.OrderAnnotation.class)
  @Transactional
  class JdoQueryTest extends RegressionTestWithJdoFixtures {
  
   //   @Inject private JdoSupportService jdoSupport;
  
      @BeforeAll
      static void beforeAll() throws SQLException {
          // launch H2Console for troubleshooting ...
          // Util_H2Console.main(null);
      }
  
      @Test @Order(1)
      void sampleInventory_shouldBeSetUpWith3Books() {
  
          // when
  
          var inventories = repositoryService.allInstances(JdoInventory.class);
  
          // then - expected post condition: ONE inventory with 3 books
  
          assertEquals(1, inventories.size());
  
          var inventory = inventories.get(0);
          assertNotNull(inventory);
          assertNotNull(inventory.getProducts());
          assertEquals(3, inventory.getProducts().size());
  
          testFixtures.assertInventoryHasBooks(inventory.getProducts(), 1, 2, 3);
      }
  
      @Test @Order(2) @Disabled("broken won't fix")
      void sampleInventory_shouldSupportQueryCount() {
  
          //testFixtures.setUp3Books();
  
          testFixtures.assertInventoryHasBooks(repositoryService
                  .allMatches(Query.allInstances(JdoBook.class)),
                  1, 2, 3);
  
          testFixtures.assertInventoryHasBooks(repositoryService
                  .allMatches(Query.allInstances(JdoBook.class)
                          .withLimit(2)),
                  1, 2);
      }
  
      @Test @Order(3) @Disabled("start not supported, should throw unsupported exception maybe?")
      void sampleInventory_shouldSupportQueryStart() {
  
          //testFixtures.setUp3Books();
  
          testFixtures.assertInventoryHasBooks(repositoryService
                  .allMatches(Query.allInstances(JdoBook.class)
                          .withStart(1)),
                  2, 3);
  
          testFixtures.assertInventoryHasBooks(repositoryService
                  .allMatches(Query.allInstances(JdoBook.class)
                          .withRange(1, 1)),
                  2);
      }
  
      @Test @Order(4) @Disabled("broken won't fix")
      void sampleInventory_shouldSupportNamedQueriesThroughApplib() {
  
          //testFixtures.setUp3Books();
  
          var query = Query.named(JdoBook.class, "findAffordableBooks")
                  .withParameter("priceUpperBound", 60.);
  
          var affordableBooks = repositoryService.allMatches(query);
          testFixtures.assertInventoryHasBooks(affordableBooks, 1, 2);
      }
  
  //    @Test @Order(4)
  //    void sampleInventory_shouldSupportNamedQueriesDirectly() {
  //
  //        setUp3Books();
  //
  //        var namedParams = _Maps.<String, Object>newHashMap();
  //
  //        var pm = jdoSupport.getPersistenceManagerFactory().getPersistenceManager();
  //        var query = pm.newNamedQuery(JdoProduct.class, "findAffordableProducts")
  //                .setNamedParameters(namedParams);
  //        namedParams.put("priceUpperBound", 60.);
  //
  //        var affordableBooks = query.executeList();
  //        assertInventoryHasBooks(affordableBooks, 1, 2);
  //    }
  
  //    @Test @Order(5)
  //    void sampleInventory_shouldSupportJdoQuery() {
  //
  //        setUp3Books();
  //
  //        var pm = jdoSupport.getPersistenceManagerFactory().getPersistenceManager();
  //        var query = pm.newQuery(JdoBook.class)
  //                .filter("price <= 60.");
  //
  //        var affordableBooks = query.executeList();
  //        assertInventoryHasBooks(affordableBooks, 1, 2);
  //    }
  
      @Test @Order(99) @Disabled("broken won't fix")
      void previousTest_shouldHaveRolledBack() {
          assertEquals(0, repositoryService.allInstances(JdoInventory.class).size());
          assertEquals(0, repositoryService.allInstances(JdoProduct.class).size());
      }
  
  }
  