/*-
 * ============LICENSE_START=======================================================
 * ONAP : APPC
 * ================================================================================
 * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
 * ================================================================================
 * Copyright (C) 2017 Amdocs
 * =============================================================================
 * 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.
 * 
 * ECOMP is a trademark and service mark of AT&T Intellectual Property.
 * ============LICENSE_END=========================================================
 */

package org.onap.appc.design.validator;

import java.io.File;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.Properties;
import org.apache.commons.io.FileUtils;
import org.junit.Before;
import org.junit.Ignore;
import org.junit.Test;
import org.onap.appc.design.dbervices.DbService;
import org.onap.appc.design.dbervices.DesignDBService;
import org.onap.appc.design.propertyServices.PropertyUpdateService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import junit.framework.Assert;
import org.powermock.reflect.Whitebox;

public class TestDBService {

    private final org.slf4j.Logger logger = LoggerFactory.getLogger(TestDBService.class);

    @Ignore("Test is taking 60 seconds")
    @Test
    public void testGetDesigns() {
        try {
            String payload = "{\"userID\": \"0000\", \"vnf-type\" : \"DesigTest-VNF\" }";
            DesignDBService dbservice = DesignDBService.initialise();
            dbservice.execute("getDesigns", payload, "1234");
        } catch (Exception e) {
        }
    }

    @Ignore("Test is taking 120 seconds")
    @Test
    public void testGetStatus() {
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService dbservice = DesignDBService.initialise();
            DbService db = new DbService();
            Whitebox.invokeMethod(db, "getDbLibService");
            dbservice.execute("getStatus", payload, "1234");
        } catch (Exception e) {
        }
    }

    @Ignore("Test is taking 120 seconds")
    @Test
    public void testUploadArtifact() {
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService dbservice = DesignDBService.initialise();
            DbService db = new DbService();
            Whitebox.invokeMethod(db, "getDbLibService");
            dbservice.execute("uploadArtifact", payload, "1234");
        } catch (Exception e) {
        }
    }

    @Ignore("Test is taking 120 seconds")
    @Test
    public void testGetArtifact() {
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            DbService db = new DbService();
            Whitebox.invokeMethod(db, "getDbLibService");
            design.execute("getArtifact", payload, "1234");
        } catch (Exception e) {
        }
    }

    @Ignore("Test is taking 120 seconds")
    @Test
    public void testSetIncart() {
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"action-level\":\"VNf\",\"protocol\":\"Test\", \"inCart\":\"Y\",\"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            DbService db = new DbService();
            Whitebox.invokeMethod(db, "getDbLibService");
            design.execute("setInCart", payload, "1234");
        } catch (Exception e) {
        }
    }

    @Ignore("Test is taking 120 seconds")
    @Test
    public void testSetProtocolReference() {
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"action-level\":\"VNf\",\"protocol\":\"Test\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            DbService db = new DbService();
            Whitebox.invokeMethod(db, "getDbLibService");
            design.execute("setProtocolReference", payload, "1234");
        } catch (Exception e) {
        }
    }

    @Ignore("Test is taking 120 seconds")
    @Test
    public void testSetStatus() {
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"status\":\"Test\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-status\":\"\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            DbService db = new DbService();
            Whitebox.invokeMethod(db, "getDbLibService");
            design.execute("setStatus", payload, "1234");
        } catch (Exception e) {
        }
    }

    @Ignore("Test is taking 120 seconds")
    @Test
    public void testGetArtifactReference() {
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"status\":\"Test\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-status\":\"\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            DbService db = new DbService();
            Whitebox.invokeMethod(db, "getDbLibService");
            design.execute("getArtifactReference", payload, "1234");
        } catch (Exception e) {
        }
    }

    @Ignore("Test is taking 120 seconds")
    @Test
    public void testGetGuiReference() {
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"status\":\"Test\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-status\":\"\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            DbService db = new DbService();
            Whitebox.invokeMethod(db, "getDbLibService");
            design.execute("getGuiReference", payload, "1234");
        } catch (Exception e) {
        }
    }

    @Test
    public void testPropertyUpdateService() {
        PropertyUpdateService ps = new PropertyUpdateService();
    }

    @Test
    public void testLinkstatusRelationShip() {        
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"status\":\"Test\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-status\":\"\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            Whitebox.invokeMethod(design, "linkstatusRelationShip", 1, 1, payload);
        } catch (Exception e) {
        }
    }

    @Test
    public void testGetSDCReferenceID() {
        
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"status\":\"Test\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-status\":\"\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            Whitebox.invokeMethod(design, "getSDCReferenceID", payload);
        } catch (Exception e) {
        }
    }

    @Test
    public void testGetDataFromActionStatus() {        
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"status\":\"Test\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-status\":\"\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            Whitebox.invokeMethod(design, "getDataFromActionStatus", payload, "Test");
        } catch (Exception e) {
        }
    }

    @Test
    public void testSetActionStatus() {
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"status\":\"Test\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-status\":\"\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            Whitebox.invokeMethod(design, "setActionStatus", payload, "Accepted");
        } catch (Exception e) {
        }
    }
        
    @Test
    public void testGetSDCArtifactIDbyRequestID() {
        try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"status\":\"Test\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-status\":\"\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            Whitebox.invokeMethod(design, "getSDCArtifactIDbyRequestID", "0");
        } catch (Exception e) {
        }
    }

    @Test
    public void testCreateArtifactTrackingRecord() {
            try {
            String content = FileUtils.readFileToString(new File("src/test/resources/uploadArtifact"));
            String payload = " { \"userID\": \"0000\",\"status\":\"Test\", \"vnf-type\" : \"DesigTest-VNF\", \"action\" : \"Configure\", \"artifact-name\":\"DesignRestArtifact_reference\",\"artifact-version\" :\"0.01\",\"artifact-type\" :\"DESIGNTOOL-TEST\",\"artifact-status\":\"\",\"artifact-contents\":  "+ content + " } ";
            DesignDBService design = DesignDBService.initialise();
            Whitebox.invokeMethod(design, "createArtifactTrackingRecord",payload,"0",1,1);
        } catch (Exception e) {
        }
    }
}