2008 November | Dimuthu's Blog

November 27th, 2008Steps to Convert a SQL Query to a Data Service

With WSF/PHP Data Service library, you can convert a SQL query to a Data Service very easily in few steps.

Decide your SQL query first, For the query you may require some input parameters, and you have to decide what should be returned by the query, Say your query is
```
$sql_query = "SELECT name, age, email FROM users where country = ?";
```
Then the “country” is our input parameter and the name, age, email are our return values.
Define the input Format. For the above query it will be something like,
```
$inputFormat = array("country" => "INT");
```

Define the output format. We are giving the name “Users” for the out most wrapper element and the name “user” for the wrapper element of each user. Here is how we define it,

$outputFormat = array("resultElement" => "users",
                "rowElement" => "user",
                "elements" => array(
                            "name" => "name",
                            "age" => "age",
                            "email" => "email"));

For this output format, our expected result payload would be like,

<users>
  <user>
     <name>xxx</name>
     <age>23</age>
     <email>xxx@xxx.xx</email>
  </user>
  <user>
     <name>yyy</name>
     <age>23</age>
     <email>yyy@yyy.yy</email>
  </user>
  ....
</users>

Define your operation using the sql query, input and output formats.

$operations = array("getUsersByCountry" => array(
                              "inputFormat" => $inputFormat,
                              "sql" => $sql_query,
                              "outputFormat" => $outputFormat));

Define your database configuration in an array like this,

$config = array(
    "db" => "mysql", // your db engine
    "username" => "myname", // name & password for the db server
    "password" => "mypasswd",
    "dbname" => "db", // the db
    "dbhost" => "localhost");

Create a DataService instance using the database configuration and the operations we just created. And call DataServices reply method.

$ds_service = new DataService(array(
               "config" => $config,
               "operations" => $operations));

$ds_service->reply();

That is it. You just exposed your query as a web service. The PHP script URL will be the endpoint URL for the web service.

More »

DataServices, SOA, SQL, Tutorial/Guide, php, web services, wsf/php, wso2 No Comments »

November 27th, 2008WSO2 Carbon Explained In Pictures

WSO2 Carbon is getting ready to come out very soon. You want to know what exactly WSO2 Carbon is?. Just check this samisa’s blog about “Carbon In Pictures”.

More »

DataServices, SOA, web services, wso2 No Comments »

November 26th, 20085 Facts About WS-Addressing Action in WSF/PHP

WS-Addressing Action is used by web services to dispatch the operation for an incoming request SOAP message. It is one way of dispatching operations in WSF/PHP and it base Apach Axis2/C, other ways are SOAP action based dispatching which covers in my early blog “The Use of SOAP Action with WSF/PHP“, Body based dispatching and URI based dispatching.

In WSF/PHP client, we can enable the addressing by setting the “action” field in the request WSMessage instance and setting “useWSA”=> TRUE in the WSClient instance. Here is an example.

$requestPayloadString = <<<XML
<ns1:echoString xmlns:ns1="http://wso2.org/wsfphp/samples">
   <text>Hello World!</text>
</ns1:echoString>
XML;

$client = new WSClient(array("to" => "http://localhost/samples/echo_service.php",
                             "useWSA" => TRUE));

$requestMessage = new WSMessage($requestPayloadString,
	    array("action" => "http://localhost/samples/echo_service/echoString"));

$responseMessage = $client->request($requestMessage);

printf("Response = %s <br>", htmlspecialchars($responseMessage->str));

If you doesn’t set “useWSA” => TRUE explicitly, the client will send the action as a SOAP action rather than a WSA Action. The above is the same example I used in demonstrating SOAP action with just the addition of “useWSA” option.

You can select WS-Addressing version among “submission” which .NET support by default and “1.0″, just by mention it in the “useWSA” field.
I.e.

“useWSA” => “submission”	Then the namespaces are having the values defined in the submission specification of WS-Addressing.
“useWSA” => 1.0	Then the namespace are having the values defined in the WS-Addressing 1.0 spec.

In the option “actions” in the WSService, we can provide the action to operation map, so the service will direct the SOAP messages to the correct operation by looking at the WS-Addressing action of the SOAP message.
Here is a sample code that use action to dispatch the operation.

function echoStringFunc($inMessage) {
    // logic of echoString operation
}

function echoIntFunc($inMessage) {
    // logic of echoInt operation
}

// we will take echoString and echoInt as tow operations
$operations = array("echoString" => "echoStringFunction",
                    "echoInt" => "echoIntFunction");

// soap action to operation map
$actions = array("http://localhost/samples/echo_service/echoString" => "echoString",
                 "http://localhost/samples/echo_service/echoInt" => "echoInt");

// creating the service with the operations and actions set
$service = new WSService(array("operations" => $operations,
                               "actions" => $actions));

$service->reply();

Note that this code is same as the code I post in a previous blog “The Use of SOAP Action with WSF/PHP” which uses SOAP action to dispatch the operation. In fact WSService will adjust to dispatch SOAP messages, so if there is a SOAP action in the message, it will be dispatched using that, and if it contains WS-Addressing action, it will used to do dis

Dimuthu’s Blog

November 27th, 2008Steps to Convert a SQL Query to a Data Service

November 27th, 2008WSO2 Carbon Explained In Pictures

November 26th, 20085 Facts About WS-Addressing Action in WSF/PHP