[Ds-java-dev] svn commit r17513 - trunk/solutions/data-services/java/modules/core/src/test/resources/test-dbs

[sumedha at wso2.com]

Author: sumedha
Date: Wed May 28 05:31:28 2008
New Revision: 17513
URL: http://wso2.org/svn/browse/wso2?view=rev&revision=17513

Log:
Added a test to check insert with not return element

Modified:
   trunk/solutions/data-services/java/modules/core/src/test/resources/test-dbs/MySQLService.dbs

Modified: trunk/solutions/data-services/java/modules/core/src/test/resources/test-dbs/MySQLService.dbs
URL: http://wso2.org/svn/browse/wso2/trunk/solutions/data-services/java/modules/core/src/test/resources/test-dbs/MySQLService.dbs?rev=17513&r1=17512&r2=17513&view=diff
==============================================================================
--- trunk/solutions/data-services/java/modules/core/src/test/resources/test-dbs/MySQLService.dbs	(original)
+++ trunk/solutions/data-services/java/modules/core/src/test/resources/test-dbs/MySQLService.dbs	Wed May 28 05:31:28 2008
@@ -1,13 +1,14 @@
 <data name="MySQLService">
    <config>
       <property name="org.wso2.ws.dataservice.driver">com.mysql.jdbc.Driver</property>
-      <property name="org.wso2.ws.dataservice.protocol">jdbc:mysql://localhost:3306/classicmodels?autoReconnect=true</property>
+      <property name="org.wso2.ws.dataservice.protocol">jdbc:mysql://localhost:3306/projects?autoReconnect=true</property>
       <property name="org.wso2.ws.dataservice.user">root</property>
       <property name="org.wso2.ws.dataservice.password">password</property>
       <property name="org.wso2.ws.dataservice.minpoolsize">2</property>
       <property name="org.wso2.ws.dataservice.maxpoolsize">100</property>
    </config>
 
+   <!-- Query and Operation for plain SELECT test -->
    <query id="query1">
       <sql>select customerNumber, customerName, contactLastName, phone, city from customers</sql>
 
@@ -24,5 +25,27 @@
       <call-query href="query1">
       </call-query>
    </operation>
+
+   
+   <!-- Query and Operation for INSERT test -->
+   <query id="insertQuery">
+      <sql>insert into student values(?,?,?,?,?)</sql>
+      <param name="id" sqlType="INTEGER" />
+      <param name="name" sqlType="STRING" />
+      <param name="deptId" sqlType="INTEGER" />
+      <param name="address" sqlType="STRING" />
+      <param name="email" sqlType="STRING" />          
+   </query>
+
+   <operation name="insert">
+      <call-query href="insertQuery">
+        <with-param name="studentId" query-param="id" />
+        <with-param name="name" query-param="name" />
+        <with-param name="department" query-param="deptId" />
+        <with-param name="address" query-param="address" />
+        <with-param name="email" query-param="email" />                              
+      </call-query>
+   </operation>
+   
 </data>