appc-dispatcher/appc-dispatcher-common/lock-manager-lib/lock-manager-impl/src/test/java/org/openecomp/appc/lockmanager/impl/sql/MySqlLockManagerBaseTests.java

   1 /*-
   2  * ============LICENSE_START=======================================================
   3  * openECOMP : APP-C
   4  * ================================================================================
   5  * Copyright (C) 2017 AT&T Intellectual Property. All rights
   6  *                                              reserved.
   7  * ================================================================================
   8  * Licensed under the Apache License, Version 2.0 (the "License");
   9  * you may not use this file except in compliance with the License.
  10  * You may obtain a copy of the License at
  11  *
  12  *      http://www.apache.org/licenses/LICENSE-2.0
  13  *
  14  * Unless required by applicable law or agreed to in writing, software
  15  * distributed under the License is distributed on an "AS IS" BASIS,
  16  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  17  * See the License for the specific language governing permissions and
  18  * limitations under the License.
  19  * ============LICENSE_END=========================================================
  20  */
  21
  22 package org.openecomp.appc.lockmanager.impl.sql;
  23
  24 import org.junit.Rule;
  25 import org.junit.rules.TestName;
  26 import org.openecomp.appc.dao.util.DefaultJdbcConnectionFactory;
  27 import org.openecomp.appc.lockmanager.api.LockManager;
  28 import org.openecomp.appc.lockmanager.api.LockManagerBaseTests;
  29 import org.openecomp.appc.lockmanager.impl.sql.JdbcLockManager;
  30 import org.openecomp.appc.lockmanager.impl.sql.MySqlConnectionFactory;
  31
  32 import java.sql.Connection;
  33 import java.sql.PreparedStatement;
  34 import java.sql.SQLException;
  35
  36 public abstract class MySqlLockManagerBaseTests extends LockManagerBaseTests {
  37
  38         private static final boolean USE_REAL_DB = Boolean.getBoolean("lockmanager.tests.useRealDb");
  39         private static final String TABLE_LOCK_MANAGEMENT = "TEST_LOCK_MANAGEMENT";
  40         private static final String JDBC_URL = System.getProperty("lockmanager.tests.jdbcUrl", "jdbc:mysql://192.168.1.2/test");
  41         private static final String JDBC_USERNAME = System.getProperty("lockmanager.tests.jdbcUsername", "test");
  42         private static final String JDBC_PASSWORD = System.getProperty("lockmanager.tests.jdbcPassword", "123456");
  43
  44         protected static final int CONCURRENT_TEST_WAIT_TIME = 10; // secs
  45
  46         @Rule
  47         public TestName testName = new TestName();
  48
  49         @Override
  50         protected LockManager createLockManager() {
  51                 JdbcLockManager jdbcLockManager = createJdbcLockManager(USE_REAL_DB);
  52                 DefaultJdbcConnectionFactory connectionFactory = new MySqlConnectionFactory();
  53                 connectionFactory.setJdbcURL(JDBC_URL);
  54                 connectionFactory.setJdbcUserName(JDBC_USERNAME);
  55                 connectionFactory.setJdbcPassword(JDBC_PASSWORD);
  56                 jdbcLockManager.setConnectionFactory(connectionFactory);
  57                 jdbcLockManager.setTableName(TABLE_LOCK_MANAGEMENT);
  58                 System.out.println("=> Running LockManager test [" + jdbcLockManager.getClass().getName() + "." + testName.getMethodName() + "]" + (USE_REAL_DB ? ". JDBC URL is [" + JDBC_URL + "]" : ""));
  59                 clearTestLocks(jdbcLockManager);
  60                 return jdbcLockManager;
  61         }
  62
  63         protected abstract JdbcLockManager createJdbcLockManager(boolean useRealDb);
  64
  65         protected boolean setSynchronizer(Synchronizer synchronizer) {
  66                 if(!(lockManager instanceof SynchronizerReceiver)) {
  67                         System.err.println("Skipping concurrency test [" + testName.getMethodName() + "] for LockManager of type " + lockManager.getClass());
  68                         return false;
  69                 }
  70                 ((SynchronizerReceiver)lockManager).setSynchronizer(synchronizer);
  71                 return true;
  72         }
  73
  74         private static final String SQL_DELETE_LOCK_RECORD = String.format("DELETE FROM %s WHERE RESOURCE_ID=?", TABLE_LOCK_MANAGEMENT);
  75         private void clearTestLocks(JdbcLockManager jdbcLockManager) {
  76                 Connection connection = jdbcLockManager.openDbConnection();
  77                 if(connection == null) {
  78                         return;
  79                 }
  80                 try {
  81                         for(Resource resource: Resource.values()) {
  82                                 try(PreparedStatement statement = connection.prepareStatement(SQL_DELETE_LOCK_RECORD)) {
  83                                         statement.setString(1, resource.name());
  84                                         statement.executeUpdate();
  85                                 }
  86                         }
  87                 } catch(SQLException e) {
  88                         throw new RuntimeException("Cannot clear test resources in table", e);
  89                 } finally {
  90                         jdbcLockManager.closeDbConnection(connection);
  91                 }
  92         }
  93 }