/*
*Copyright (c) 2005-2010, 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.ei.dataservice.integration.test.services;

import org.apache.axiom.om.OMAbstractFactory;
import org.apache.axiom.om.OMElement;
import org.apache.axiom.om.OMFactory;
import org.apache.axiom.om.OMNamespace;
import org.apache.axis2.AxisFault;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.testng.Assert;
import org.testng.annotations.AfterClass;
import org.testng.annotations.BeforeClass;
import org.testng.annotations.Test;
import org.wso2.carbon.automation.test.utils.axis2client.AxisServiceClient;
import org.wso2.ei.dataservice.integration.test.DSSIntegrationTest;

import javax.xml.xpath.XPathExpressionException;
import java.io.File;
import java.util.ArrayList;
import java.util.List;

public class NestedQueryTestCase extends DSSIntegrationTest {
    private static final Log log = LogFactory.getLog(NestedQueryTestCase.class);

    private final OMFactory fac = OMAbstractFactory.getOMFactory();
    private final OMNamespace omNs = fac.createOMNamespace("http://ws.wso2.org/dataservice/samples", "ns1");
    private final String serviceName = "NestedQueryTest";


    @BeforeClass(alwaysRun = true)
    public void serviceDeployment() throws Exception {

        super.init();
        List<File> sqlFileLis = new ArrayList<File>();
        sqlFileLis.add(selectSqlFile("CreateTables.sql"));
        sqlFileLis.add(selectSqlFile("Offices.sql"));
        sqlFileLis.add(selectSqlFile("Customers.sql"));
        sqlFileLis.add(selectSqlFile("Employees.sql"));
        sqlFileLis.add(selectSqlFile("Orders.sql"));
        deployService(serviceName,
                      createArtifact(getResourceLocation() + File.separator + "dbs" + File.separator
                                     + "rdbms" + File.separator + "MySql" + File.separator
                                     + "NestedQueryTest.dbs", sqlFileLis));

    }

    @AfterClass(alwaysRun = true)
    public void destroy() throws Exception {
        deleteService(serviceName);
        cleanup();
    }


    @Test(groups = {"wso2.dss"})
    public void getCustomerOrdersNestedQuery() throws AxisFault, XPathExpressionException {
        for (int i = 1; i < 6; i++) {
            getCustomerOrders();
        }
        log.info("Customer Orders Nested Query verified");
    }


    @Test(groups = {"wso2.dss"})
    public void listOfficeNestedQueryOperation() throws AxisFault, XPathExpressionException {
        for (int i = 1; i < 6; i++) {
            getOffices();
        }
        log.info("List Office Nested Query verified");
    }

    private void getCustomerName() throws AxisFault, XPathExpressionException {

        OMElement payload = fac.createOMElement("customerName", omNs);

        OMElement customerNumber = fac.createOMElement("customerNumber", omNs);
        customerNumber.setText("103");
        payload.addChild(customerNumber);

        OMElement result = new AxisServiceClient().sendReceive(payload, getServiceUrlHttp(serviceName), "customerName");
        Assert.assertNotNull(result, "Response message null ");
        log.debug(result);
        Assert.assertTrue(result.toString().contains("<Name>Atelier graphique</Name>"), "Expected not same");

    }

    private void getCustomerOrders() throws AxisFault, XPathExpressionException {
        OMElement payload = fac.createOMElement("customerOrders", omNs);

        OMElement result = new AxisServiceClient().sendReceive(payload, getServiceUrlHttp(serviceName), "customerOrders");
        Assert.assertNotNull(result, "Response message null ");
        log.debug(result);
        Assert.assertTrue(result.toString().contains("<Order><Order-number>"), "Expected not same");
        Assert.assertTrue(result.toString().contains("<Customer><Name>"), "Expected not same");
        Assert.assertTrue(result.toString().contains("</Customer>"), "Expected not same");
    }

    private void getEmployeesInOffice() throws AxisFault, XPathExpressionException {
        OMElement payload = fac.createOMElement("employeesInOffice", omNs);

        OMElement officeCode = fac.createOMElement("officeCode", omNs);
        officeCode.setText("1");
        payload.addChild(officeCode);

        OMElement result = new AxisServiceClient().sendReceive(payload, getServiceUrlHttp(serviceName), "employeesInOffice");
        Assert.assertNotNull(result, "Response message null ");
        log.debug(result);
        Assert.assertNotNull(result.getFirstElement(), "First Chilled null ");
        log.debug(result.getFirstElement());
        Assert.assertTrue(result.getFirstElement().toString().contains("<employeeNumber>1002</employeeNumber>"), "Expected not same");
    }

    private void getOffices() throws AxisFault, XPathExpressionException {
        OMElement payload = fac.createOMElement("listOffices", omNs);

        OMElement result = new AxisServiceClient().sendReceive(payload, getServiceUrlHttp(serviceName), "listOffices");
        Assert.assertNotNull(result, "Response message null ");
        log.debug(result);
        Assert.assertTrue(result.toString().contains("<Office><officeCode>1</officeCode>"), "Expected not same");
        Assert.assertTrue(result.toString().contains("<Employees><Employee><employeeNumber>"), "Expected not same");
    }

}
