2 * ================================================================================
\r
4 * ================================================================================
\r
5 * Copyright (C) 2017 AT&T Intellectual Property
\r
6 * ================================================================================
\r
7 * Licensed under the Apache License, Version 2.0 (the "License");
\r
8 * you may not use this file except in compliance with the License.
\r
9 * You may obtain a copy of the License at
\r
11 * http://www.apache.org/licenses/LICENSE-2.0
\r
13 * Unless required by applicable law or agreed to in writing, software
\r
14 * distributed under the License is distributed on an "AS IS" BASIS,
\r
15 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
16 * See the License for the specific language governing permissions and
\r
17 * limitations under the License.
\r
18 * ================================================================================
\r
20 package org.openecomp.portalapp.portal.test.core;
\r
22 import java.sql.Connection;
\r
23 import java.sql.SQLException;
\r
25 import javax.sql.DataSource;
\r
27 import org.junit.After;
\r
28 import org.junit.Before;
\r
29 import org.junit.Test;
\r
30 import org.openecomp.portalapp.portal.test.framework.ApplicationCommonContextTestSuite;
\r
31 import org.springframework.beans.factory.annotation.Autowired;
\r
32 import org.springframework.core.io.ClassPathResource;
\r
33 import org.springframework.jdbc.datasource.DataSourceUtils;
\r
34 import org.springframework.jdbc.datasource.init.ResourceDatabasePopulator;
\r
36 public class RemoveSampleTestData extends ApplicationCommonContextTestSuite {
\r
38 DataSource dataSource;
\r
40 public static int count = 0;
\r
43 public void removeTestData() throws SQLException {
\r
44 String sql = "RemoveTestData.sql";
\r
45 createConnection(sql);
\r
48 public void createConnection(String sql) {
\r
49 Connection connection = null;
\r
50 ResourceDatabasePopulator populator = new ResourceDatabasePopulator();
\r
51 populator.addScript(new ClassPathResource(sql));
\r
53 connection = DataSourceUtils.getConnection(dataSource);
\r
54 populator.populate(connection);
\r
56 if (connection != null) {
\r
57 DataSourceUtils.releaseConnection(connection, dataSource);
\r
63 public void removeTest() {
\r