Max Webster webster92

## users
id,name,age,married,email
number,string,number,boolean,string
1,Max Mule,,false,
2,<empty_string>,23,true,test@email.com

## users-test-suite-snippet.xml
<mock:when messageProcessor=".*:.*" doc:name="Mock - Select Users">
  <mock:with-attributes>
    <mock:with-attribute name="doc:name" whereValue="#['Select Users']"/>
  </mock:with-attributes>
  <mock:then-return payload="#[dw(&quot;readUrl('classpath://database_mock.dwl','application/dw').csvToJava('mocks/users.csv')&quot;)]" mimeType="application/java"/>
</mock:when>

## users.csv

          
            id
            name
            age
            married
            email

            
              number
              string
              number
              boolean
              string

            
              1
              Max Mule
              
              false

            
              2
              <empty_string>
              23
              true
              test@email.com

## database-mock.dwl
%dw 1.0

%output application/java

%function getCsvFile(csvFile)
	readUrl("classPath://" ++ csvFile, "application/csv")

%function toType(value, type)
	null when value == '' otherwise (
    	value as :number when type == 'number' otherwise
	id,name,age,married,email
	number,string,number,boolean,string
	1,Max Mule,,false,
	2,<empty_string>,23,true,test@email.com
	<mock:when messageProcessor=".:." doc:name="Mock - Select Users">
	<mock:with-attributes>
	<mock:with-attribute name="doc:name" whereValue="#['Select Users']"/>
	</mock:with-attributes>
	<mock:then-return payload="#[dw("readUrl('classpath://database_mock.dwl','application/dw').csvToJava('mocks/users.csv')")]" mimeType="application/java"/>
	</mock:when>
id	name	age	married	email
number	string	number	boolean	string
1	Max Mule		false
2	<empty_string>	23	true	test@email.com
	%dw 1.0

	%output application/java

	%function getCsvFile(csvFile)
	readUrl("classPath://" ++ csvFile, "application/csv")

	%function toType(value, type)
	null when value == '' otherwise (
	value as :number when type == 'number' otherwise