content: /*
   * Copyright 1999-2018 Alibaba Group Holding Ltd.
   *
   * 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 com.alibaba.druid.pvt.pool;
  
  import com.alibaba.druid.mock.MockDriver;
  import com.alibaba.druid.pool.DruidDataSource;
  import com.alibaba.druid.stat.DruidDataSourceStatManager;
  import junit.framework.TestCase;
  import org.junit.Assert;
  
  import java.sql.Connection;
  import java.util.concurrent.CountDownLatch;
  import java.util.concurrent.CyclicBarrier;
  import java.util.concurrent.atomic.AtomicInteger;
  
  public class TestIdle3_Concurrent extends TestCase {
      protected void setUp() throws Exception {
          DruidDataSourceStatManager.clear();
      }
  
      protected void tearDown() throws Exception {
          Assert.assertEquals(0, DruidDataSourceStatManager.getInstance().getDataSourceList().size());
      }
  
      public void test_idle2() throws Exception {
          MockDriver driver = new MockDriver();
  
          DruidDataSource dataSource = new DruidDataSource();
          dataSource.setUrl("jdbc:mock:xxx");
          dataSource.setDriver(driver);
          dataSource.setInitialSize(1);
          dataSource.setMaxActive(14);
          dataSource.setMaxIdle(14);
          dataSource.setMinIdle(1);
          dataSource.setMinEvictableIdleTimeMillis(30 * 10); // 300 / 10
          dataSource.setTimeBetweenEvictionRunsMillis(18 * 10); // 180 / 10
          dataSource.setTestWhileIdle(true);
          dataSource.setTestOnBorrow(false);
          dataSource.setValidationQuery("SELECT 1");
          dataSource.setFilters("stat");
  
          // ManagementFactory.getPlatformMBeanServer().registerMBean(dataSource, new
          // ObjectName("com.alibaba:type=DataSource"));
  
          // 第一次创建连接
          {
              Assert.assertEquals(0, dataSource.getCreateCount());
              Assert.assertEquals(0, dataSource.getActiveCount());
  
              Connection conn = dataSource.getConnection();
  
              Assert.assertEquals(dataSource.getInitialSize(), dataSource.getCreateCount());
              Assert.assertEquals(dataSource.getInitialSize(), driver.getConnections().size());
              Assert.assertEquals(1, dataSource.getActiveCount());
  
              conn.close();
              Assert.assertEquals(0, dataSource.getDestroyCount());
              Assert.assertEquals(1, driver.getConnections().size());
              Assert.assertEquals(1, dataSource.getCreateCount());
              Assert.assertEquals(0, dataSource.getActiveCount());
          }
  
          {
              // 并发创建14个
              concurrent(driver, dataSource, 30);
          }
  
          // 连续打开关闭单个连接
          for (int i = 0; i < 1000; ++i) {
              Assert.assertEquals(0, dataSource.getActiveCount());
              Connection conn = dataSource.getConnection();
  
              Assert.assertEquals(1, dataSource.getActiveCount());
              conn.close();
          }
          Thread.sleep(1000);
          Assert.assertEquals(1, dataSource.getPoolingCount());
  
          dataSource.close();
      }
  
      private void concurrent(final MockDriver driver, final DruidDataSource dataSource, final int count)
              throws Exception {
          final int LOOP_COUNT = 1000;
          Thread[] threads = new Thread[count];
          final CyclicBarrier barrier = new CyclicBarrier(count);
          final CountDownLatch endLatch = new CountDownLatch(count);
          for (int i = 0; i < count; ++i) {
              threads[i] = new Thread("thread-" + i) {
                  public void run() {
                      try {
                          for (int i = 0; i < LOOP_COUNT; ++i) {
                              barrier.await();
  
                              Connection conn = dataSource.getConnection();
                              {
                                  AtomicInteger c = new AtomicInteger();
                                  for (int j = 0; j < 1000 * 1; ++j) {
                                      c.incrementAndGet();
                                  }
                                  c.set(0);
                                  Thread.sleep(1);
                              }
                              conn.close();
                          }
                      } catch (Exception e) {
                          e.printStackTrace();
                      } finally {
                          endLatch.countDown();
                      }
                  }
              };
          }
  
          for (int i = 0; i < count; ++i) {
              threads[i].start();
          }
  
          endLatch.await();
          System.out.println("concurrent end");
  
          int max = count > dataSource.getMaxActive() ? dataSource.getMaxActive() : count;
          Assert.assertEquals(max, driver.getConnections().size());
      }
  }
  