Skip to content

Latest commit

 

History

History

2-nested-query

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Readme.md
Readme.md
 
 
nested_query_json.xml
nested_query_json.xml
 
 
nested_query_xml.xml
nested_query_xml.xml
 
 

Readme.md

  1. Create table OFFICES
    CREATE TABLE OFFICES (OfficeCode int(11) NOT NULL, AddressLine1 varchar(255) NOT NULL, AddressLine2 varchar(255) DEFAULT NULL, City varchar(255) DEFAULT NULL, State varchar(255) DEFAULT NULL, Country varchar(255) DEFAULT NULL, Phone varchar(255) DEFAULT NULL, PRIMARY KEY (OfficeCode));
  2. Create table EMPLOYEES
    CREATE TABLE EMPLOYEES (EmployeeNumber int(11) NOT NULL, FirstName varchar(255) NOT NULL, LastName varchar(255) DEFAULT NULL, Email varchar(255) DEFAULT NULL, JobTitle varchar(255) DEFAULT NULL, OfficeCode int(11) NOT NULL, PRIMARY KEY (EmployeeNumber,OfficeCode), CONSTRAINT employees_ibfk_1 FOREIGN KEY (OfficeCode) REFERENCES OFFICES (OfficeCode));
  3. Add sample values to table OFFICES
    INSERT INTO OFFICES VALUES (1,"51","Glen Street","Norwich","London","United Kingdom","+441523624");
    INSERT INTO OFFICES VALUES (2,"72","Rose Street","Pasadena","California","United States","+152346343");
  4. Add sample values to table EMPLOYEES
    INSERT INTO EMPLOYEES VALUES (1,"John","Gardiner","[email protected]","Manager",1);
    INSERT INTO EMPLOYEES VALUES (2,"Jane","Stewart","[email protected]","Head of Sales",2);
    INSERT INTO EMPLOYEES VALUES (3,"David","Green","[email protected]","Manager",1);
  • For XML output Add nested_query_xml into the DSS services.
    Evoke the XML service with following body
<body>
      <p:listOfficeSQLOP xmlns:p="http://ws.wso2.org/dataservice">
         <!--Exactly 1 occurrence-->
         <xs:OfficeCode xmlns:xs="http://ws.wso2.org/dataservice">1</xs:OfficeCode>
      </p:listOfficeSQLOP>
</body>

curl -X POST \
  https://localhost:8243/services/nested_query_xml \
  -H 'cache-control: no-cache' \
  -H 'content-type: application/xml' \
  -d '
      <p:listOfficeSQLOP xmlns:p="http://ws.wso2.org/dataservice">
         <!--Exactly 1 occurrence-->
         <xs:OfficeCode xmlns:xs="http://ws.wso2.org/dataservice">1</xs:OfficeCode>
      </p:listOfficeSQLOP>
' -k
  • For JSON output Add nested_query_json into the DSS service
    Evoke JSON service with
    curl -H 'Accept: application/json' -X GET http://localhost:8280/services/nested_query_json.SOAP12Endpoint/offices/1 -k

In case of SSL error while using curl, use -k option with curl command