<http:listener-config name="HTTP_Listener_Configuration" host="localhost" port="8081" doc:name="HTTP Listener Configuration"/>
<db:mysql-config name="MySQL_Configuration" host="localhost" port="3306" user="root" password="Blue1234" database="news" doc:name="MySQL Configuration"/>
<http:request-config name="HTTP_Request_Configuration" host="localhost"  doc:name="HTTP Request Configuration" port="8081"/>
<file:connector name="file" writeToDirectory="C:UsersHershDesktopfile" autoDelete="true" streaming="true" validateConnections="true" doc:name="File" />
<flow name="parsetemplateFlow">
    <http:listener config-ref="HTTP_Listener_Configuration" path="/web" doc:name="HTTP"/>
    <set-payload value="#[message.inboundProperties.'http.query.params'.q]" doc:name="Set Payload" mimeType="text/html"/>
    <db:select config-ref="MySQL_Configuration" doc:name="Database">
        <db:parameterized-query><![CDATA[select txt from news.nws where sub=#[message.payload]]]></db:parameterized-query>
    </db:select>
    <response>
        <http:static-resource-handler resourceBase="C:UsersHershDesktopattach" defaultFile="index.html" doc:name="HTTP Static Resource Handler"/>
    </response>
    <logger message="#[message.payload]" level="INFO" doc:name="Logger"/>
    <set-payload value="#[message.payload]" doc:name="Set Payload"/>
    <response>
        <file:outbound-endpoint path="C:UsersHershDesktopfile" outputPattern="output.txt" connector-ref="file" responseTimeout="10000" doc:name="File"/>
    </response>
</flow>