emp_DataService

emp_DataService.xml

<data disableStreaming="true" enableBoxcarring="true" name="emp_DataService" serviceNamespace="http://ws.wso2.org/dataservice">
   <config id="default">
      <property name="carbon_datasource_name">Signingtest</property>
   </config>
   <query id="select_all_emp_query" useConfig="default">
      <sql>SELECT eno, username, password FROM public.emp</sql>
      <result element="empCollection" rowName="emp">
         <element column="eno" name="eno" xsdType="xs:integer"/>
         <element column="username" name="username" xsdType="xs:string"/>
         <element column="password" name="password" xsdType="xs:string"/>
      </result>
   </query>
  
   <query id="insert_emp_query" useConfig="default">
      <sql>INSERT INTO public.emp(eno,username,password) VALUES(?,?,?)</sql>
      <param name="eno" ordinal="1" sqlType="INTEGER"/>
      <param name="username" ordinal="2" sqlType="STRING"/>
      <param name="password" ordinal="3" sqlType="STRING"/>
   </query>
   <operation name="insert_emp_operation">
      <call-query href="insert_emp_query">
         <with-param name="eno" query-param="eno"/>
         <with-param name="username" query-param="username"/>
         <with-param name="password" query-param="password"/>
      </call-query>
   </operation>
   <operation name="select_all_emp_operation">
      <call-query href="select_all_emp_query"/>
   </operation>
</data>