Getting started Community Training Tutorials Documentation APIs, AI & Tools
<mule>
<http:listener-config name="HTTP_Listener_config">
<http:listener-connection host="0.0.0.0" port="8081" />
</http:listener-config>
<db:config name="Database_Config">
<db:my-sql-connection host="localhost" port="3306" user="admin" password="admin" database="usersdb" />
</db:config>
<flow name="GET-Users-FLOW">
<http:listener config-ref="HTTP_Listener_config" path="/users"/>
<db:select config-ref="Database_Config">
<db:sql ><![CDATA[SELECT * FROM USERS]]></db:sql>
</db:select>
</flow>
<flow name="GET-User-By-Id-FLOW">
<http:listener config-ref="HTTP_Listener_config" path="/userById" />
<db:select config-ref="Database_Config" >
<db:sql ><![CDATA[SELECT * FROM USERS WHERE :userIdParameter == userID]]></db:sql>
<db:input-parameters ><![CDATA[#[{userIdParameter: attributes.queryParams.id}]]]></db:input-parameters>
</db:select>
</flow>
</mule>



