Utils

Utils

Sql Util

Contains couple functions for:

• createSqlConn - fast SQL connection creation
• applyInVars and getInParams - handling IN () SQL predicates
• getQueryFromFile - get SQL string from file on disc, provide basic validation
• executeFile and execute - handling Sql.rows() request with nullable Sql parameters (original Groovy Sql API throws couple weird Exceptions) Please refer to GroovyDoc for more information

Xml Util

Contains couple functions for:

• walkXmlByPath - receiving List<NodeChild> of similar elements from existsing XML object. Please refer to [Transform XML][#transformXml] section.
• isPathInXmlTree - check if provided XML path exists for current element
• walkXmlByPathForValue - get value located in XML under provided XML path
• printNode - pretty print of ChildNode
• mapXml - create SQL naming from XML. For more information, please refer to [Map XML][#mapXml] section

JSON Util

Contains couple functions for:

• printMap - pretty print of Map object as JSON string
• walkJsonByPath - receiving value of element from provided Path