[wsas-java-dev] svn commit r9571 - in branches/wsas/java/2.1/wsas/java/modules/samples/DataService: dbs sql

[svn at wso2.org]

Author: azeez
Date: Thu Nov  8 04:31:33 2007
New Revision: 9571

Added:
   branches/wsas/java/2.1/wsas/java/modules/samples/DataService/dbs/DeptUpdateService.dbs
Modified:
   branches/wsas/java/2.1/wsas/java/modules/samples/DataService/sql/CreateTables.sql
Log:
Adding add/update DB service sample

Added: branches/wsas/java/2.1/wsas/java/modules/samples/DataService/dbs/DeptUpdateService.dbs
==============================================================================
--- (empty file)
+++ branches/wsas/java/2.1/wsas/java/modules/samples/DataService/dbs/DeptUpdateService.dbs	Thu Nov  8 04:31:33 2007
@@ -0,0 +1,35 @@
+<data name="DeptUpdateService">
+    <config>
+        <property name="org.wso2.ws.dataservice.driver">org.apache.derby.jdbc.EmbeddedDriver</property>
+        <property name="org.wso2.ws.dataservice.protocol">jdbc:derby:../samples/DataService/database/DATA_SERV_SAMP</property>
+        <property name="org.wso2.ws.dataservice.user">wsas</property>
+        <property name="org.wso2.ws.dataservice.password">wsas</property>
+    </config>    
+
+    <operation name="addNewDepartment">
+        <call-query href="addDept">
+            <with-param name="deptId" query-param="deptId" />
+            <with-param name="deptName" query-param="deptName" />
+        </call-query>
+    </operation>
+    <query id="addDept">
+        <sql>insert into department (id,name) values (?,?)</sql>
+        <result element="Results" rowName="Result" />
+        <param name="deptId" sqlType="INTEGER" />
+        <param name="deptName" sqlType="STRING" />
+    </query>
+
+    <operation name="updateDepartment">
+        <call-query href="updateDept">
+            <with-param name="deptId" query-param="deptId" />
+            <with-param name="deptName" query-param="deptName" />
+        </call-query>
+    </operation>
+    <query id="updateDept">
+        <sql>update department set name = ?  where id = ?</sql>
+        <result element="Results" rowName="Result" />
+        <param name="deptName" sqlType="STRING" />
+        <param name="deptId" sqlType="INTEGER" />
+    </query>
+
+</data>
\ No newline at end of file

Modified: branches/wsas/java/2.1/wsas/java/modules/samples/DataService/sql/CreateTables.sql
==============================================================================
--- branches/wsas/java/2.1/wsas/java/modules/samples/DataService/sql/CreateTables.sql	(original)
+++ branches/wsas/java/2.1/wsas/java/modules/samples/DataService/sql/CreateTables.sql	Thu Nov  8 04:31:33 2007
@@ -92,5 +92,10 @@
 );
 CREATE UNIQUE INDEX payments_pk ON Payments( customerNumber, checkNumber );
 
+CREATE TABLE department(
+	id INTEGER,
+	name VARCHAR(200)
+);
+