Package dev.frostlake.functions.scalar.semistructured

Class ParseXml

java.lang.Object
dev.frostlake.functions.BuiltInFunction
dev.frostlake.functions.scalar.semistructured.ParseXml
public class ParseXml extends BuiltInFunction
PARSE_XML(text [, disable_auto_convert]) — parses an XML document into Snowflake's XML-in-VARIANT model (see XmlVariants): {"$": content, "@": tag, "@attr": value, "childname": firstContentIndex} with object keys sorted. Element text and attribute values are auto-converted to numbers unless the second argument is TRUE, following Snowflake's live-verified rules: plain integers and decimals convert (leading zeros, a leading +, or a bare leading dot keep the text), exponent forms become DOUBLE, and whitespace is trimmed. An empty or all-whitespace input yields SQL NULL; malformed XML raises Error parsing XML: ….

  • Constructor Details

    • ParseXml

      public ParseXml()

  • Method Details

    • evaluate

      public Object evaluate(List<Object> args)
      Description copied from class: BuiltInFunction
      Computes the function's result over its already-evaluated argument values. A SQL NULL argument arrives as Java null, and returning null makes the SQL result NULL.
      Specified by:
      evaluate in class BuiltInFunction
      Parameters:
      args - the argument values, in call order
      Returns:
      the function's value for these arguments, or null for SQL NULL

    • parseDocument

      public static tools.jackson.databind.JsonNode parseDocument(String xml, boolean disableAutoConvert)
      Parses XML text to the variant model; returns null for an empty/whitespace-only input and throws IllegalArgumentException with the bare parser message on malformed XML.

    • getMinArgCount

      public int getMinArgCount()
      Description copied from class: BuiltInFunction
      The fewest arguments a call to this function may pass; fewer is an argument-count error.
      Specified by:
      getMinArgCount in class BuiltInFunction
      Returns:
      the minimum accepted argument count

    • getMaxArgCount

      public int getMaxArgCount()
      Description copied from class: BuiltInFunction
      The most arguments a call to this function may pass; Integer.MAX_VALUE marks a variadic function (see BuiltInFunction.isVariadic()).
      Specified by:
      getMaxArgCount in class BuiltInFunction
      Returns:
      the maximum accepted argument count