From f1d268d1f72d6f890498fbc1d7333218d910a750 Mon Sep 17 00:00:00 2001
From: Kailun Qin <kailun.qin@intel.com>
Date: Fri, 13 Apr 2018 15:58:09 +0800
Subject: Drop DB migration support due to security reasons

Drop current DB migration support in functest using
dropwizard-migrations due to security concerns. Also downgrade jersey
versions to 2.25.1 since dropwizard:1.3.1 does not support jersey:2.26.

Change-Id: I87ace8d3132af7a04141a7d89db80a134a69d538
Issue-ID: VNFSDK-246
Signed-off-by: Kailun Qin <kailun.qin@intel.com>
---
 .../onap/vnfsdk/functest/VnfSdkFuncTestApp.java    |  7 ---
 .../src/main/resources/migrations.xml              | 57 ----------------------
 2 files changed, 64 deletions(-)
 delete mode 100644 vnf-sdk-function-test/src/main/resources/migrations.xml

(limited to 'vnf-sdk-function-test/src')

diff --git a/vnf-sdk-function-test/src/main/java/org/onap/vnfsdk/functest/VnfSdkFuncTestApp.java b/vnf-sdk-function-test/src/main/java/org/onap/vnfsdk/functest/VnfSdkFuncTestApp.java
index cb5f681..e77efc1 100644
--- a/vnf-sdk-function-test/src/main/java/org/onap/vnfsdk/functest/VnfSdkFuncTestApp.java
+++ b/vnf-sdk-function-test/src/main/java/org/onap/vnfsdk/functest/VnfSdkFuncTestApp.java
@@ -21,7 +21,6 @@ import io.dropwizard.Application;
 import io.dropwizard.db.DataSourceFactory;
 import io.dropwizard.hibernate.HibernateBundle;
 import io.dropwizard.hibernate.ScanningHibernateBundle;
-import io.dropwizard.migrations.MigrationsBundle;
 import io.dropwizard.server.SimpleServerFactory;
 import io.dropwizard.setup.Bootstrap;
 import io.dropwizard.setup.Environment;
@@ -58,12 +57,6 @@ public class VnfSdkFuncTestApp extends Application<VnfSdkFuncTestAppConfiguratio
 
     @Override
     public void initialize(Bootstrap<VnfSdkFuncTestAppConfiguration> bootstrap) {
-        bootstrap.addBundle(new MigrationsBundle<VnfSdkFuncTestAppConfiguration>() {
-            @Override
-            public DataSourceFactory getDataSourceFactory(VnfSdkFuncTestAppConfiguration configuration) {
-                return configuration.getDataSourceFactory();
-            }
-        });
         bootstrap.addBundle(hibernateBundle);
     }
 
diff --git a/vnf-sdk-function-test/src/main/resources/migrations.xml b/vnf-sdk-function-test/src/main/resources/migrations.xml
deleted file mode 100644
index 9ec5510..0000000
--- a/vnf-sdk-function-test/src/main/resources/migrations.xml
+++ /dev/null
@@ -1,57 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-
-<databaseChangeLog
-        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
-        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
-        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
-         http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">
-
-    <changeSet id="1" author="Kailun Qin">
-        <createTable tableName="TaskRecord">
-            <column name="packageID" type="varchar(255)">
-                <constraints primaryKey="true" nullable="false"/>
-            </column>
-            <column name="taskID" type="varchar(255)">
-                <constraints unique="true" foreignKeyName="CaseRecord.taskID" nullable="false"/>
-            </column>
-            <column name="envID" type="varchar(255)">
-                <constraints nullable="false"/>
-            </column>
-            <column name="uploadID" type="varchar(255)">
-                <constraints nullable="false"/>
-            </column>
-            <column name="operID" type="varchar(255)">
-                <constraints nullable="false"/>
-            </column>
-            <column name="funcID" type="varchar(255)">
-            </column>
-            <column name="status" type="varchar(255)">
-                <constraints nullable="false"/>
-            </column>
-            <column name="operFinished" type="varchar(255)">
-                <constraints nullable="false"/>
-            </column>
-            <column name="operResult" type="varchar(255)">
-                <constraints nullable="false"/>
-            </column>
-            <column name="OperResultMessage" type="varchar(255)">
-            </column>
-        </createTable>
-
-        <createTable tableName="CaseRecord">
-            <column name="taskID" type="varchar(255)">
-                <constraints primaryKey="true" nullable="false"/>
-            </column>
-            <column name="funcID" type="varchar(255)">
-            </column>
-            <column name="testID" type="varchar(255)">
-            </column>
-            <column name="testResult" type="varchar(255)">
-                <constraints nullable="false"/>
-            </column>
-            <column name="testDescription" type="varchar(255)">
-                <constraints nullable="false"/>
-            </column>
-        </createTable>
-    </changeSet>
-</databaseChangeLog>
-- 
cgit 1.2.3-korg