[Ds-java-dev] svn commit r14533 - trunk/solutions/data-services/php

[svn at wso2.org]

Author: manoj
Date: Wed Mar  5 05:01:59 2008
New Revision: 14533

Log:



Added:
   trunk/solutions/data-services/php/CustomerOrdersService.php   (contents, props changed)

Added: trunk/solutions/data-services/php/CustomerOrdersService.php
==============================================================================
--- (empty file)
+++ trunk/solutions/data-services/php/CustomerOrdersService.php	Wed Mar  5 05:01:59 2008
@@ -0,0 +1,41 @@
+<?php
+/*
+ * Copyright 2005,2006 WSO2, Inc. http://wso2.com
+ *
+ * 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.
+ */
+
+require_once("DataService.php");
+
+$config = array("username"=>"root",  "password"=>"","dbname"=>"ds","dbhost"=>"localhost");
+
+$inputFormat = <<<XML
+<with-param name="customerNumber" query-param="customerNumber" sqlType="INT" />
+</request>
+XML;
+
+$outputFormat = <<<XML
+<result element="Orders" rowName="Order">
+<element name="Order-number" column="ORDERNUMBER" />
+<element name="Last-name" column="ORDERDATE" />
+<element name="First-name" column="STATUS" />
+</result>
+XML;
+
+$sql = "select o.ORDERNUMBER,o.ORDERDATE, o.STATUS,o.CUSTOMERNUMBER from WSO2WSAS.ORDERS o";
+
+$operations = array("customerOrders"=>array(/*"inputFormat"=>$inputFormat,*/ "outputFormat"=>$outputFormat, "sql"=>$sql));
+
+$my_data_service = new DataService(array("config"=>$config,"operations"=>$operations));
+$my_data_service->reply();
+?>