/*
   
     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.commons.dbcp2.managed;
  
  import static org.junit.jupiter.api.Assertions.assertEquals;
  import static org.junit.jupiter.api.Assertions.assertNotNull;
  import static org.junit.jupiter.api.Assertions.assertNull;
  import static org.junit.jupiter.api.Assertions.assertThrows;
  import static org.junit.jupiter.api.Assertions.fail;
  
  import java.sql.Connection;
  import java.sql.SQLException;
  
  import javax.sql.XADataSource;
  import javax.transaction.TransactionManager;
  import javax.transaction.TransactionSynchronizationRegistry;
  import javax.transaction.xa.XAException;
  
  import org.apache.commons.dbcp2.BasicDataSource;
  import org.apache.commons.dbcp2.TestBasicDataSource;
  import org.apache.geronimo.transaction.manager.TransactionManagerImpl;
  import org.h2.Driver;
  import org.h2.jdbcx.JdbcDataSource;
  import org.junit.jupiter.api.Test;
  
  import com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionManagerImple;
  import com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionSynchronizationRegistryImple;
  
  /**
   * TestSuite for BasicManagedDataSource
   */
  public class TestBasicManagedDataSource extends TestBasicDataSource {
  
      @Override
      protected BasicDataSource createDataSource() throws Exception {
          final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource();
          final TransactionManagerImpl transactionManager = new TransactionManagerImpl();
          basicManagedDataSource.setTransactionManager(transactionManager);
          basicManagedDataSource.setTransactionSynchronizationRegistry(transactionManager);
          return basicManagedDataSource;
      }
  
      @Test
      public void testCreateXaDataSourceNewInstance() throws SQLException, XAException {
          try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
              basicManagedDataSource.setXADataSource(JdbcDataSource.class.getCanonicalName());
              basicManagedDataSource.setDriverClassName(Driver.class.getName());
              basicManagedDataSource.setTransactionManager(new TransactionManagerImpl());
              assertNotNull(basicManagedDataSource.createConnectionFactory());
          }
      }
  
      @Test
      public void testCreateXaDataSourceNoInstanceSetAndNoDataSource() throws SQLException, XAException {
          try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
              basicManagedDataSource.setDriverClassName("org.apache.commons.dbcp2.TesterDriver");
              basicManagedDataSource.setUrl("jdbc:apache:commons:testdriver");
              basicManagedDataSource.setTransactionManager(new TransactionManagerImpl());
              assertNotNull(basicManagedDataSource.createConnectionFactory());
          }
      }
  
      /**
       * JIRA: DBCP-294
       * Verify that PoolableConnections created by BasicManagedDataSource unregister themselves
       * when reallyClosed.
       */
      @Test
      public void testReallyClose() throws Exception {
          try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
              basicManagedDataSource.setTransactionManager(new TransactionManagerImpl());
              basicManagedDataSource.setDriverClassName("org.apache.commons.dbcp2.TesterDriver");
              basicManagedDataSource.setUrl("jdbc:apache:commons:testdriver");
              basicManagedDataSource.setUsername("userName");
              basicManagedDataSource.setPassword("password");
              basicManagedDataSource.setMaxIdle(1);
              // Create two connections
              final ManagedConnection<?> conn = (ManagedConnection<?>) basicManagedDataSource.getConnection();
              assertNotNull(basicManagedDataSource.getTransactionRegistry().getXAResource(conn));
              final ManagedConnection<?> conn2 = (ManagedConnection<?>) basicManagedDataSource.getConnection();
              conn2.close(); // Return one connection to the pool
              conn.close(); // No room at the inn - this will trigger reallyClose(), which should unregister
              assertThrows(SQLException.class, () -> basicManagedDataSource.getTransactionRegistry().getXAResource(conn),
                      "Expecting SQLException - XAResources orphaned");
             conn2.close();
         }
     }
 
     @Test
     public void testRuntimeExceptionsAreRethrown() throws SQLException, XAException {
         try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
             basicManagedDataSource.setTransactionManager(new TransactionManagerImpl());
             basicManagedDataSource.setDriverClassName("org.apache.commons.dbcp2.TesterDriver");
             basicManagedDataSource.setUrl("jdbc:apache:commons:testdriver");
             basicManagedDataSource.setUsername("userName");
             basicManagedDataSource.setPassword("password");
             basicManagedDataSource.setMaxIdle(1);
             // results in a NPE
             assertThrows(NullPointerException.class, () -> basicManagedDataSource.createPoolableConnectionFactory(null));
         }
     }
 
     @Test
     public void testSetDriverName() throws SQLException {
         try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
             basicManagedDataSource.setDriverClassName("adams");
             assertEquals("adams", basicManagedDataSource.getDriverClassName());
             basicManagedDataSource.setDriverClassName(null);
             assertNull(basicManagedDataSource.getDriverClassName());
         }
     }
 
     @Test
     public void testSetNullXaDataSourceInstance() throws SQLException, XAException {
         try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
             basicManagedDataSource.setTransactionManager(new TransactionManagerImpl());
             basicManagedDataSource.setDriverClassName("org.apache.commons.dbcp2.TesterDriver");
             basicManagedDataSource.setUrl("jdbc:apache:commons:testdriver");
             basicManagedDataSource.setUsername("userName");
             basicManagedDataSource.setPassword("password");
             basicManagedDataSource.setMaxIdle(1);
             basicManagedDataSource.setXaDataSourceInstance(null);
             assertNull(basicManagedDataSource.getXaDataSourceInstance());
         }
     }
 
     /** DBCP-564 */
     @Test
     public void testSetRollbackOnlyBeforeGetConnectionDoesNotLeak() throws Exception {
         final TransactionManager transactionManager = ((BasicManagedDataSource) ds).getTransactionManager();
         final int n = 3;
         ds.setMaxIdle(n);
         ds.setMaxTotal(n);
 
         for (int i = 0; i <= n; i++) { // loop n+1 times
             transactionManager.begin();
             transactionManager.setRollbackOnly();
             try (final Connection conn = getConnection()) {
                 assertNotNull(conn);
             }
             transactionManager.rollback();
         }
 
         assertEquals(0, ds.getNumActive());
         assertEquals(1, ds.getNumIdle());
     }
 
     @Test
     public void testSetXaDataSourceInstance() throws SQLException, XAException {
         try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
             basicManagedDataSource.setTransactionManager(new TransactionManagerImpl());
             basicManagedDataSource.setDriverClassName("org.apache.commons.dbcp2.TesterDriver");
             basicManagedDataSource.setUrl("jdbc:apache:commons:testdriver");
             basicManagedDataSource.setUsername("userName");
             basicManagedDataSource.setPassword("password");
             basicManagedDataSource.setMaxIdle(1);
             basicManagedDataSource.setXaDataSourceInstance(new JdbcDataSource());
             assertNotNull(basicManagedDataSource.createConnectionFactory());
         }
     }
 
     @Test
     public void testTransactionManagerNotSet() throws SQLException {
         try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
             assertThrows(SQLException.class, basicManagedDataSource::createConnectionFactory);
         }
     }
 
     @Test
     public void testTransactionSynchronizationRegistry() throws Exception {
         try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
             basicManagedDataSource.setTransactionManager(new TransactionManagerImple());
             final TransactionSynchronizationRegistry tsr = new TransactionSynchronizationRegistryImple();
             basicManagedDataSource.setTransactionSynchronizationRegistry(tsr);
             final JdbcDataSource xaDataSource = new JdbcDataSource();
             xaDataSource.setUrl("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1");
             basicManagedDataSource.setXaDataSourceInstance(xaDataSource);
             basicManagedDataSource.setMaxIdle(1);
 
             final TransactionManager tm = basicManagedDataSource.getTransactionManager();
             tm.begin();
             tsr.registerInterposedSynchronization(new SynchronizationAdapter() {
                 @Override
                 public void beforeCompletion() {
                     Connection connection = null;
                     try {
                         connection = basicManagedDataSource.getConnection();
                         assertNotNull(connection);
                     } catch (final SQLException e) {
                         fail(e.getMessage());
                     } finally {
                         if (connection != null) {
                             try {
                                 connection.close();
                             } catch (final SQLException e) {
                                 fail(e.getMessage());
                             }
                         }
                     }
                 }
             });
             tm.commit();
         }
     }
 
     @Test
     public void testXADataSource() throws SQLException {
         try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
             basicManagedDataSource.setXADataSource("anything");
             assertEquals("anything", basicManagedDataSource.getXADataSource());
         }
     }
 
     @Test
     public void testXaDataSourceInstance() throws SQLException {
         try (final BasicManagedDataSource basicManagedDataSource = new BasicManagedDataSource()) {
             final XADataSource ds = new JdbcDataSource();
             basicManagedDataSource.setXaDataSourceInstance(ds);
             assertEquals(ds, basicManagedDataSource.getXaDataSourceInstance());
         }
     }
 }