blob: c0605581d513a6a3f7dacc63306fa91c02ad522f [file] [log] [blame]
/*
* Copyright (c) 2011, 2020 Oracle and/or its affiliates. All rights reserved.
*
* This program and the accompanying materials are made available under the
* terms of the Eclipse Public License v. 2.0 which is available at
* http://www.eclipse.org/legal/epl-2.0,
* or the Eclipse Distribution License v. 1.0 which is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause
*/
// Contributors:
// David McCann - Aug.15, 2012 - 2.4.1 - Initial implementation
package dbws.testing.simpletable;
import java.io.StringReader;
import java.sql.SQLException;
import java.sql.Statement;
import javax.xml.namespace.QName;
import jakarta.xml.soap.SOAPBody;
import jakarta.xml.soap.SOAPMessage;
import jakarta.xml.ws.Dispatch;
import jakarta.xml.ws.Service;
import jakarta.xml.ws.soap.SOAPBinding;
import org.junit.AfterClass;
import org.junit.BeforeClass;
import org.junit.Test;
import org.w3c.dom.Document;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import dbws.testing.DBWSTestSuite;
import static dbws.testing.simpletable.SimpleTableBuilderTestSuite.CREATE_TABLE;
import static dbws.testing.simpletable.SimpleTableBuilderTestSuite.DROP_TABLE;
import static dbws.testing.simpletable.SimpleTableBuilderTestSuite.POPULATE_TABLE;
import static org.junit.Assert.fail;
import static org.junit.Assert.assertNotNull;
import static org.junit.Assert.assertTrue;
/**
* Tests building a web service from table info.
*
*/
public class SimpleTableServiceTestSuite extends DBWSTestSuite {
static final String SOAP_FINDBYPK_REQUEST =
"<env:Envelope xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">" +
"<env:Body>" +
"<findByPrimaryKey_SimpletableType xmlns=\"urn:simpletableService\">" +
"<id>1</id>" +
"</findByPrimaryKey_SimpletableType>" +
"</env:Body>" +
"</env:Envelope>";
static final String SOAP_FINDALL_REQUEST =
"<env:Envelope xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">" +
"<env:Body>" +
"<findAll_SimpletableType xmlns=\"urn:simpletableService\" xmlns:urn=\"urn:simpletable\"/>" +
"</env:Body>" +
"</env:Envelope>";
static final String SOAP_UPDATE_REQUEST =
"<env:Envelope xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">" +
"<env:Body>" +
"<update_SimpletableType xmlns=\"urn:simpletableService\" xmlns:urn=\"urn:simpletable\">" +
"<theInstance>" +
"<urn:simpletableType>" +
"<urn:id>1</urn:id>" +
"<urn:name>mike norman</urn:name>" +
"<urn:since>2001-12-25</urn:since>" +
"</urn:simpletableType>" +
"</theInstance>" +
"</update_SimpletableType>" +
"</env:Body>" +
"</env:Envelope>";
static final String SOAP_CREATE_REQUEST =
"<env:Envelope xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">" +
"<env:Body>" +
"<create_SimpletableType xmlns=\"urn:simpletableService\" xmlns:urn=\"urn:simpletable\">" +
"<theInstance>" +
"<urn:simpletableType>" +
"<urn:id>4</urn:id>" +
"<urn:name>test</urn:name>" +
"<urn:since>2009-03-27</urn:since>" +
"</urn:simpletableType>" +
"</theInstance>" +
"</create_SimpletableType>" +
"</env:Body>" +
"</env:Envelope>";
static final String SOAP_DELETE_REQUEST =
"<env:Envelope xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">" +
"<env:Body>" +
"<delete_SimpletableType xmlns=\"urn:simpletableService\" xmlns:urn=\"urn:simpletable\">" +
"<id>4</id>" +
"</delete_SimpletableType>" +
"</env:Body>" +
"</env:Envelope>";
static final String SOAP_UPDATE2_REQUEST =
"<env:Envelope xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">" +
"<env:Body>" +
"<update_SimpletableType xmlns=\"urn:simpletableService\" xmlns:urn=\"urn:simpletable\">" +
"<theInstance>" +
"<urn:simpletableType>" +
"<urn:id>1</urn:id>" +
"<urn:name>mike</urn:name>" +
"<urn:since>2001-12-25</urn:since>" +
"</urn:simpletableType>" +
"</theInstance>" +
"</update_SimpletableType>" +
"</env:Body>" +
"</env:Envelope>";
static final String SOAP_FINDBYPK_RESPONSE =
"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?>" +
"<srvc:findByPrimaryKey_SimpletableTypeResponse xmlns=\"urn:simpletable\" xmlns:srvc=\"urn:simpletableService\">" +
"<srvc:result>" +
"<simpletableType>" +
"<id>1</id>" +
"<name>mike</name>" +
"<since>2001-12-25</since>" +
"</simpletableType>" +
"</srvc:result>" +
"</srvc:findByPrimaryKey_SimpletableTypeResponse>";
static final String SOAP_FINDALL_RESPONSE =
"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?>" +
"<srvc:findAll_SimpletableTypeResponse xmlns=\"urn:simpletable\" xmlns:srvc=\"urn:simpletableService\">" +
"<srvc:result>" +
"<simpletableType>" +
"<id>1</id>" +
"<name>mike</name>" +
"<since>2001-12-25</since>" +
"</simpletableType>" +
"<simpletableType>" +
"<id>2</id>" +
"<name>blaise</name>" +
"<since>2001-12-25</since>" +
"</simpletableType>" +
"<simpletableType>" +
"<id>3</id>" +
"<name>rick</name>" +
"<since>2001-12-25</since>" +
"</simpletableType>" +
"</srvc:result>" +
"</srvc:findAll_SimpletableTypeResponse>";
static final String SOAP_UPDATE_RESPONSE_ELEMENTNAME =
"update_SimpletableTypeResponse";
static final String SOAP_FINDBYPK_AFTERUPDATE_RESPONSE =
"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\"?>" +
"<srvc:findByPrimaryKey_SimpletableTypeResponse xmlns=\"urn:simpletable\" xmlns:srvc=\"urn:simpletableService\">" +
"<srvc:result>" +
"<simpletableType>" +
"<id>1</id>" +
"<name>mike norman</name>" +
"<since>2001-12-25</since>" +
"</simpletableType>" +
"</srvc:result>" +
"</srvc:findByPrimaryKey_SimpletableTypeResponse>";
static final String SOAP_CREATE_RESPONSE_ELEMENTNAME =
"create_SimpletableTypeResponse";
static final String SOAP_DELETE_RESPONSE_ELEMENTNAME =
"delete_SimpletableTypeResponse";
@BeforeClass
public static void setUp() {
if (conn == null) {
try {
conn = buildConnection();
} catch (Exception e) {
e.printStackTrace();
}
}
if (ddlCreate) {
runDdl(conn, CREATE_TABLE, ddlDebug);
try {
Statement stmt = conn.createStatement();
for (int i = 0; i < POPULATE_TABLE.length; i++) {
stmt.addBatch(POPULATE_TABLE[i]);
}
stmt.executeBatch();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
@AfterClass
public static void tearDown() {
if (ddlDrop) {
runDdl(conn, DROP_TABLE, ddlDebug);
}
}
@Test
public void testService() {
try {
QName qname = new QName("urn:simpletableService", "simpletableServicePort");
Service service = Service.create(new QName("urn:simpletable", "simpletableService"));
service.addPort(qname, SOAPBinding.SOAP11HTTP_BINDING, "http://" + host + ":" + port + "/simpletable/simpletable");
Dispatch<SOAPMessage> sourceDispatch = service.createDispatch(qname, SOAPMessage.class, Service.Mode.MESSAGE);
SOAPMessage request = createSOAPMessage(SOAP_FINDBYPK_REQUEST);
SOAPMessage response = sourceDispatch.invoke(request);
assertNotNull("findByPrimaryKey_SimpletableType failed: response is null.", response);
SOAPBody responseBody = response.getSOAPPart().getEnvelope().getBody();
Document resultDoc = responseBody.extractContentAsDocument();
Document controlDoc = xmlParser.parse(new StringReader(SOAP_FINDBYPK_RESPONSE));
NodeList elts = resultDoc.getDocumentElement().getElementsByTagNameNS("urn:simpletableService", "result");
assertTrue("The wrong number of elements were returned.", ((elts != null && elts.getLength() > 0) && elts.getLength() == 1));
Node testNode = elts.item(0);
assertTrue("Didn't find [<srvc:result>] element", testNode.getLocalName().equalsIgnoreCase("result"));
elts = controlDoc.getDocumentElement().getElementsByTagNameNS("urn:simpletableService", "result");
Node ctrlNode = elts.item(0);
assertTrue("findByPrimaryKey_SimpletableType document comparison failed. Expected:\n" + documentToString(ctrlNode) + "\nbut was:\n" + documentToString(testNode), comparer.isNodeEqual(ctrlNode, testNode));
request = createSOAPMessage(SOAP_FINDALL_REQUEST);
response = sourceDispatch.invoke(request);
assertNotNull("findAll_SimpletableType failed: response is null.", response);
responseBody = response.getSOAPPart().getEnvelope().getBody();
resultDoc = responseBody.extractContentAsDocument();
controlDoc = xmlParser.parse(new StringReader(SOAP_FINDALL_RESPONSE));
elts = resultDoc.getDocumentElement().getElementsByTagNameNS("urn:simpletableService", "result");
assertTrue("The wrong number of elements were returned.", ((elts != null && elts.getLength() > 0) && elts.getLength() == 1));
testNode = elts.item(0);
assertTrue("Didn't find [<srvc:result>] element", testNode.getLocalName().equalsIgnoreCase("result"));
elts = controlDoc.getDocumentElement().getElementsByTagNameNS("urn:simpletableService", "result");
ctrlNode = elts.item(0);
assertTrue("findAll_SimpletableType document comparison failed. Expected:\n" + documentToString(ctrlNode) + "\nbut was:\n" + documentToString(testNode), comparer.isNodeEqual(ctrlNode, testNode));
request = createSOAPMessage(SOAP_UPDATE_REQUEST);
response = sourceDispatch.invoke(request);
assertNotNull("update_SimpletableType failed: response is null.", response);
assertTrue(SOAP_UPDATE_RESPONSE_ELEMENTNAME + " incorrect", SOAP_UPDATE_RESPONSE_ELEMENTNAME.equals(response.getSOAPBody().getFirstChild().getLocalName()));
request = createSOAPMessage(SOAP_FINDBYPK_REQUEST);
response = sourceDispatch.invoke(request);
assertNotNull("findByPrimaryKey_SimpletableType failed: response is null.", response);
responseBody = response.getSOAPPart().getEnvelope().getBody();
resultDoc = responseBody.extractContentAsDocument();
controlDoc = xmlParser.parse(new StringReader(SOAP_FINDBYPK_AFTERUPDATE_RESPONSE));
elts = resultDoc.getDocumentElement().getElementsByTagNameNS("urn:simpletableService", "result");
assertTrue("The wrong number of elements were returned.", ((elts != null && elts.getLength() > 0) && elts.getLength() == 1));
testNode = elts.item(0);
assertTrue("Didn't find [<srvc:result>] element", testNode.getLocalName().equalsIgnoreCase("result"));
elts = controlDoc.getDocumentElement().getElementsByTagNameNS("urn:simpletableService", "result");
ctrlNode = elts.item(0);
assertTrue("findByPrimaryKey_SimpletableType (after update) document comparison failed. Expected:\n" + documentToString(ctrlNode) + "\nbut was:\n" + documentToString(testNode), comparer.isNodeEqual(ctrlNode, testNode));
request = createSOAPMessage(SOAP_CREATE_REQUEST);
response = sourceDispatch.invoke(request);
assertNotNull("create_SimpletableType failed: response is null.", response);
assertTrue(SOAP_CREATE_RESPONSE_ELEMENTNAME + " incorrect", SOAP_CREATE_RESPONSE_ELEMENTNAME.equals(response.getSOAPBody().getFirstChild().getLocalName()));
request = createSOAPMessage(SOAP_DELETE_REQUEST);
response = sourceDispatch.invoke(request);
assertNotNull("delete_SimpletableType failed: response is null.", response);
assertTrue(SOAP_DELETE_RESPONSE_ELEMENTNAME + " incorrect", SOAP_DELETE_RESPONSE_ELEMENTNAME.equals(response.getSOAPBody().getFirstChild().getLocalName()));
request = createSOAPMessage(SOAP_UPDATE2_REQUEST);
response = sourceDispatch.invoke(request);
assertNotNull("update_SimpletableType (2) failed: response is null.", response);
assertTrue(SOAP_UPDATE_RESPONSE_ELEMENTNAME + " incorrect", SOAP_UPDATE_RESPONSE_ELEMENTNAME.equals(response.getSOAPBody().getFirstChild().getLocalName()));
} catch (Exception x) {
fail("Service test failed: " + x.getMessage());
}
}
}