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
    	value as :date when type == 'number' otherwise
    	value as :time when type == 'time' otherwise
    	value as :datetime when type == 'datetime' otherwise
    	value as :boolean when type == 'boolean' otherwise
    	(value when value != '<empty_string>' otherwise '')
  	)
	
%function csvToJava(csvFile)
	using(csv = getCsvFile(csvFile))(
		(csv filter $$ > 0) map ((obj, position) ->
			obj mapObject (
				'$$': toType($, csv[0][$$])
			)
		)
	)
---
{
	csvToJava: csvToJava
}