Database Connector in Mule | Delete Data from MYSQL
Here we are performing delete operation in MySQL database.
Http Method : DELETE
Below is the Delete flow where we used 'Byte Array to String' & 'JSON to Object' for converting incoming request from byte form to database object.
Here in HTTP Configuration rest of the settings are same as previous except path is set to : /deleteinfo
In DB Connector, choose operation as Delete and write parameterized query as shown below
save it by ctrl+s
We have used set payload component to display a user friendly message as : Data is deleted successfully.
Finally, run the project and once it is deployed please select PUT method in postman and hit URL :
http://localhost:8085/api/deleteinfo
Output :
Data is deleted successfully
Below is XML code for above flow :
<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns:json="http://www.mulesoft.org/schema/mule/json" xmlns:db="http://www.mulesoft.org/schema/mule/db" xmlns:http="http://www.mulesoft.org/schema/mule/http" xmlns="http://www.mulesoft.org/schema/mule/core" xmlns:doc="http://www.mulesoft.org/schema/mule/documentation"
xmlns:spring="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-current.xsd
http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/current/mule.xsd
http://www.mulesoft.org/schema/mule/db http://www.mulesoft.org/schema/mule/db/current/mule-db.xsd
http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/current/mule-http.xsd
http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/current/mule-json.xsd">
<db:mysql-config name="MySQL_Configuration" host="localhost" port="3306" user="root" password="********" database="demodata" doc:name="MySQL Configuration"/>
<http:listener-config name="HTTP_Listener_Configuration" host="0.0.0.0" port="8085" basePath="/api" doc:name="HTTP Listener Configuration"/>
<flow name="testdbconnectorFlow3">
<http:listener config-ref="HTTP_Listener_Configuration" path="/deleteinfo" doc:name="HTTP"/>
<byte-array-to-string-transformer doc:name="Byte Array to String"/>
<json:json-to-object-transformer returnClass="java.util.Map" doc:name="JSON to Object"/>
<db:delete config-ref="MySQL_Configuration" doc:name="Database">
<db:parameterized-query><![CDATA[delete from info where ID = #[payload.id]]]></db:parameterized-query>
</db:delete>
<set-payload value="Data is deleted successfully" doc:name="Set Payload"/>
</flow>
</mule>
No comments:
Post a Comment