Java tutorial
/* * Copyright (c) 2018, WSO2 Inc. (http://www.wso2.org) All Rights Reserved. * * WSO2 Inc. 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.wso2.carbon.identity.oauth.endpoint.user.impl; import org.apache.commons.dbcp.BasicDataSource; import org.apache.commons.lang.StringUtils; import java.nio.file.Paths; import java.sql.Connection; import java.sql.SQLException; import java.util.HashMap; import java.util.Map; public class TestUtils { public static final String DB_NAME = "jdbc/WSO2CarbonDB"; public static final String H2_SCRIPT_NAME = "scope.sql"; public static Map<String, BasicDataSource> dataSourceMap = new HashMap<>(); public static void initiateH2Base() throws Exception { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("org.h2.Driver"); dataSource.setUsername("username"); dataSource.setPassword("password"); dataSource.setUrl("jdbc:h2:mem:test" + DB_NAME); try (Connection connection = dataSource.getConnection()) { connection.createStatement().executeUpdate("RUNSCRIPT FROM '" + getFilePath(H2_SCRIPT_NAME) + "'"); } dataSourceMap.put(DB_NAME, dataSource); } public static String getFilePath(String fileName) { if (StringUtils.isNotBlank(fileName)) { return Paths.get(System.getProperty("user.dir"), "src", "test", "resources", "dbscripts", fileName) .toString(); } throw new IllegalArgumentException("DB Script file name cannot be empty."); } public static Connection getConnection() throws SQLException { if (dataSourceMap.get(DB_NAME) != null) { return dataSourceMap.get(DB_NAME).getConnection(); } throw new RuntimeException("No data source initiated for database: " + DB_NAME); } }