raminqaf commented on code in PR #29341: URL: https://github.com/apache/flink/pull/29341#discussion_r4205819902
########## flink-table/flink-table-runtime/src/test/java/org/apache/flink/table/runtime/functions/XmlToVariantParserTest.java: ########## @@ -0,0 +1,534 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.table.runtime.functions; + +import org.apache.flink.types.variant.Variant; + +import org.junit.jupiter.api.Test; +import org.junit.jupiter.params.ParameterizedTest; +import org.junit.jupiter.params.provider.Arguments; +import org.junit.jupiter.params.provider.MethodSource; +import org.junit.jupiter.params.provider.ValueSource; +import org.xml.sax.SAXException; + +import javax.xml.transform.stream.StreamSource; +import javax.xml.validation.SchemaFactory; + +import java.io.StringReader; +import java.math.BigDecimal; +import java.time.Instant; +import java.time.LocalDate; +import java.time.LocalDateTime; +import java.time.LocalTime; +import java.util.stream.Stream; + +import static org.assertj.core.api.Assertions.assertThat; +import static org.assertj.core.api.Assertions.assertThatNoException; +import static org.assertj.core.api.Assertions.assertThatThrownBy; +import static org.junit.jupiter.params.provider.Arguments.arguments; + +/** Tests for {@link XmlToVariantParser}. */ +class XmlToVariantParserTest { + + private final XmlToVariantParser parser = new XmlToVariantParser(); + + // -------------------------------------------------------------------------------------------- + // Mapping + // -------------------------------------------------------------------------------------------- + + @ParameterizedTest(name = "{0}") + @MethodSource("mappings") + void testMapping(String xml, String expectedJson) { + assertThat(parser.parse(xml, false).toJson()).isEqualTo(expectedJson); + } + + static Stream<Arguments> mappings() { + return Stream.of( + arguments("<title>Dune</title>", "{\"title\":\"Dune\"}"), + arguments("<title></title>", "{\"title\":\"\"}"), + arguments("<title/>", "{\"title\":\"\"}"), + arguments( + "<book pages=\"320\">\n Dune\n</book>", + "{\"book\":{\"$\":\"Dune\",\"@pages\":\"320\"}}"), + arguments("<book pages=\"320\"/>", "{\"book\":{\"@pages\":\"320\"}}"), + arguments( + "<book>\n" + + " <author>Terry Pratchett</author>\n" + + " <author>Neil Gaiman</author>\n" + + "</book>", + "{\"book\":{\"author\":[\"Terry Pratchett\",\"Neil Gaiman\"]}}"), + arguments( + "<book>\n <title>Dune</title>\n <price>12.5</price>\n</book>", + "{\"book\":{\"#\":{\"price\":1,\"title\":0},\"price\":\"12.5\",\"title\":\"Dune\"}}"), + arguments( + "<book>\n" + + " This is a description\n" + + " <title>Dune</title>\n" + + " and this is another text\n" + + "</book>", + "{\"book\":{\"#\":{\"$\":[0,2],\"title\":1}," + + "\"$\":[\"This is a description\",\"and this is another text\"]," + + "\"title\":\"Dune\"}}"), + arguments( + "<book pages=\"320\">\n" + + " <title>Dune</title>\n" + + " This is a description\n" + + " <price>12.50</price>\n" + + " Text in between\n" + + " <price currency=\"EUR\">13.50</price>\n" + + "</book>", + "{\"book\":{\"#\":{\"$\":[1,3],\"price\":[2,4],\"title\":0}," + + "\"$\":[\"This is a description\",\"Text in between\"]," + + "\"@pages\":\"320\"," + + "\"price\":[\"12.50\",{\"$\":\"13.50\",\"@currency\":\"EUR\"}]," + + "\"title\":\"Dune\"}}"), + arguments("<a><b><c>deep</c></b></a>", "{\"a\":{\"b\":{\"c\":\"deep\"}}}"), + // Namespace prefixes and declarations are kept as written. + arguments( + "<ns:a xmlns:ns=\"urn:ns\" xmlns=\"urn:default\" ns:id=\"1\">" + + "<ns:b>x</ns:b></ns:a>", + "{\"ns:a\":{\"@ns:id\":\"1\",\"@xmlns\":\"urn:default\"," + + "\"@xmlns:ns\":\"urn:ns\",\"ns:b\":\"x\"}}"), + // Attribute values are not trimmed. + arguments("<a b=\" x \"/>", "{\"a\":{\"@b\":\" x \"}}"), + // CDATA is text, and it merges with the text around it. + arguments("<a><![CDATA[<b>&</b>]]></a>", "{\"a\":\"<b>&</b>\"}"), + arguments("<a>x<![CDATA[y]]>z</a>", "{\"a\":\"xyz\"}"), + // Comments and processing instructions are dropped, the text around them merges. + arguments( + "<?xml version=\"1.0\"?><!-- c --><a>foo<!-- c -->bar<?pi x?></a><!-- c -->", + "{\"a\":\"foobar\"}"), + // The input is a string, so an encoding declared in the document is ignored. + arguments( + "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?><a>\u00e4</a>", + "{\"a\":\"\u00e4\"}"), + // Whitespace-only text is dropped, other text is trimmed of XML whitespace only. + arguments("<a>\n <b>x</b>\n</a>", "{\"a\":{\"b\":\"x\"}}"), + arguments("<a> \t\r\n </a>", "{\"a\":\"\"}"), + arguments("<a>\u00a0x\u00a0</a>", "{\"a\":\"\u00a0x\u00a0\"}"), + // Predefined entities and character references are expanded, in text and in + // attribute values. + arguments("<a><>&'</a>", "{\"a\":\"<>&'\"}"), + arguments("<a>AB</a>", "{\"a\":\"AB\"}"), + arguments("<a b=\"<A\"/>", "{\"a\":{\"@b\":\"<A\"}}"), + // Entities declared in the DTD are expanded. + arguments( + "<!DOCTYPE a [<!ENTITY title \"Dune\">]><a>&title;</a>", + "{\"a\":\"Dune\"}")); + } + + // -------------------------------------------------------------------------------------------- + // XML Schema instance attributes + // -------------------------------------------------------------------------------------------- + + @ParameterizedTest(name = "{0}") + @MethodSource("xsiMappings") + void testXsiMapping(String xml, String expectedJson) { + assertThat(parser.parse(xml, false).toJson()).isEqualTo(expectedJson); + } + + static Stream<Arguments> xsiMappings() { + return Stream.of( + // xsi:nil makes an element without other attributes null, and drops the content. + arguments("<a xsi:nil=\"true\"/>", "{\"a\":null}"), + arguments("<a xsi:nil=\"1\"></a>", "{\"a\":null}"), + arguments("<a xsi:nil=\"true\">x</a>", "{\"a\":null}"), + arguments("<a xsi:nil=\"true\"><b>x</b></a>", "{\"a\":null}"), + arguments("<a xsi:nil=\" true \" xsi:type=\"int\"/>", "{\"a\":null}"), + arguments("<a xsi:nil=\"true\" xsi:type=\"Dog\"/>", "{\"a\":null}"), + // The declaration of the xsi prefix is dropped. + arguments( + "<root xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\";>" + + "<a xsi:nil=\"true\"/></root>", + "{\"root\":{\"a\":null}}"), + // xsi:nil that doesn't make the element null is kept, unless it is false. + arguments( + "<a xsi:nil=\"true\" id=\"1\"/>", + "{\"a\":{\"@id\":\"1\",\"@xsi:nil\":\"true\"}}"), + arguments( + "<a xsi:nil=\"true\" id=\"1\">x</a>", + "{\"a\":{\"@id\":\"1\",\"@xsi:nil\":\"true\"}}"), + arguments( + "<a xsi:nil=\" 1 \" id=\"1\"/>", + "{\"a\":{\"@id\":\"1\",\"@xsi:nil\":\"true\"}}"), + arguments( + "<a xsi:nil=\"true\" xsi:type=\"string\" id=\"1\"/>", + "{\"a\":{\"@id\":\"1\",\"@xsi:nil\":\"true\",\"@xsi:type\":\"string\"}}"), + arguments("<a xsi:nil=\"yes\"/>", "{\"a\":{\"@xsi:nil\":\"yes\"}}"), + arguments("<a xsi:nil=\"TRUE\"/>", "{\"a\":{\"@xsi:nil\":\"TRUE\"}}"), + arguments("<a xsi:nil=\"false\">x</a>", "{\"a\":\"x\"}"), + arguments("<a xsi:nil=\"0\"/>", "{\"a\":\"\"}"), + // xsi:type types the text of an element with text but without child elements. + arguments("<a xsi:type=\"int\">5</a>", "{\"a\":5}"), + arguments("<a xsi:type=\"boolean\">true</a>", "{\"a\":true}"), + arguments("<a xsi:type=\"decimal\">-1.23</a>", "{\"a\":-1.23}"), + arguments( + "<price xsi:type=\"decimal\" currency=\"EUR\">13.50</price>", + "{\"price\":{\"$\":13.5,\"@currency\":\"EUR\"}}"), + // xsi:type that doesn't type the text is kept. + arguments("<a xsi:type=\"int\"></a>", "{\"a\":{\"@xsi:type\":\"int\"}}"), + arguments("<a xsi:type=\"string\"/>", "{\"a\":{\"@xsi:type\":\"string\"}}"), + arguments( + "<a id=\"1\" xsi:type=\"string\"/>", + "{\"a\":{\"@id\":\"1\",\"@xsi:type\":\"string\"}}"), + arguments( + "<a xsi:type=\"int\">five</a>", + "{\"a\":{\"$\":\"five\",\"@xsi:type\":\"int\"}}"), + arguments( + "<a xsi:type=\"xs:token\">x</a>", + "{\"a\":{\"$\":\"x\",\"@xsi:type\":\"xs:token\"}}"), + arguments( + "<animal xsi:type=\"Dog\" name=\"Rex\"/>", + "{\"animal\":{\"@name\":\"Rex\",\"@xsi:type\":\"Dog\"}}"), + arguments( + "<shape xsi:type=\"Circle\"><radius>1</radius></shape>", + "{\"shape\":{\"@xsi:type\":\"Circle\",\"radius\":\"1\"}}"), + // Other xsi: attributes are regular attributes. + arguments( + "<a xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"; " + + "xsi:schemaLocation=\"urn:a a.xsd\">x</a>", + "{\"a\":{\"$\":\"x\",\"@xsi:schemaLocation\":\"urn:a a.xsd\"}}")); + } + + @ParameterizedTest(name = "{0}: {1}") + @MethodSource("typedValues") + void testXsiType(String xsiType, String text, Variant.Type expectedType, Object expectedValue) { + final Variant value = parseTyped(xsiType, text); + assertThat(value.getType()).isEqualTo(expectedType); + if (expectedValue instanceof BigDecimal) { + assertThat(value.getDecimal()).isEqualByComparingTo((BigDecimal) expectedValue); + } else { + assertThat(value.get()).isEqualTo(expectedValue); + } + } + + static Stream<Arguments> typedValues() { + return Stream.of( + arguments("string", "5", Variant.Type.STRING, "5"), + arguments("boolean", "true", Variant.Type.BOOLEAN, true), + arguments("boolean", "false", Variant.Type.BOOLEAN, false), + arguments("boolean", "1", Variant.Type.BOOLEAN, true), + arguments("boolean", "0", Variant.Type.BOOLEAN, false), + arguments("byte", "-128", Variant.Type.TINYINT, (byte) -128), + arguments("short", "32767", Variant.Type.SMALLINT, (short) 32767), + arguments("int", "+5", Variant.Type.INT, 5), + arguments("int", " 5 ", Variant.Type.INT, 5), + arguments("long", "9223372036854775807", Variant.Type.BIGINT, Long.MAX_VALUE), + arguments( + "integer", + "123456789012345678901234567890", + Variant.Type.DECIMAL, + new BigDecimal("123456789012345678901234567890")), + arguments("decimal", "12.50", Variant.Type.DECIMAL, new BigDecimal("12.50")), + arguments("decimal", ".5", Variant.Type.DECIMAL, new BigDecimal("0.5")), + arguments("float", "1.5", Variant.Type.FLOAT, 1.5f), + arguments("double", "1.5E3", Variant.Type.DOUBLE, 1500.0), + arguments("double", "-.5e+2", Variant.Type.DOUBLE, -50.0), + arguments("date", "2026-09-23", Variant.Type.DATE, LocalDate.of(2026, 9, 23)), + arguments( + "time", + "12:30:45.123456", + Variant.Type.TIME, + LocalTime.of(12, 30, 45, 123_456_000)), + // Precision that doesn't fit is dropped, like in a cast. + arguments( + "time", + "12:30:45.123456789", + Variant.Type.TIME, + LocalTime.of(12, 30, 45, 123_456_000)), + arguments( + "dateTime", + "2300-01-01T00:00:00.000000001", + Variant.Type.TIMESTAMP, + LocalDateTime.of(2300, 1, 1, 0, 0)), + arguments( + "dateTime", + "2026-09-23T12:30:45", + Variant.Type.TIMESTAMP, + LocalDateTime.of(2026, 9, 23, 12, 30, 45)), + arguments( + "dateTime", + "2026-09-23T12:30:45.123456789", + Variant.Type.TIMESTAMP_NS, + LocalDateTime.of(2026, 9, 23, 12, 30, 45, 123_456_789)), + arguments( + "dateTime", + "2026-09-23T12:30:45Z", + Variant.Type.TIMESTAMP_LTZ, + Instant.parse("2026-09-23T12:30:45Z")), + arguments( + "dateTime", + "2026-09-23T12:30:45.5+02:00", + Variant.Type.TIMESTAMP_LTZ, + Instant.parse("2026-09-23T10:30:45.5Z")), + arguments( + "dateTime", + "2026-09-23T12:30:45.123456789Z", + Variant.Type.TIMESTAMP_LTZ_NS, + Instant.parse("2026-09-23T12:30:45.123456789Z")), + // Types are matched by their local part. + arguments("xs:int", "5", Variant.Type.INT, 5), + arguments("xsd:int", "5", Variant.Type.INT, 5)); + } + + @ParameterizedTest(name = "{0}: {1}") + @MethodSource({"untypedValues", "invalidLexicalForms"}) + void testXsiTypeThatDoesNotApply(String xsiType, String text) { + final Variant value = parseTyped(xsiType, text); + assertThat(value.getField("$").getString()).isEqualTo(text); + assertThat(value.getField("@xsi:type").getString()).isEqualTo(xsiType); + } + + static Stream<Arguments> untypedValues() { + return Stream.of( + arguments("boolean", "yes"), + arguments("boolean", "TRUE"), + arguments("byte", "128"), + arguments("int", "5.0"), + arguments("integer", "1.5"), + // Longer numbers are not typed. + arguments("integer", "1" + "0".repeat(1000)), + arguments("decimal", "1e99999"), + arguments("decimal", "1234567890123456789012345678901234567890"), + arguments("float", "1e50"), + arguments("float", "INF"), + arguments("double", "1e99999"), + arguments("double", "NaN"), + arguments("double", "Infinity"), + arguments("date", "2026-02-30"), + arguments("date", "2026-09-23Z"), + arguments("time", "12:30:45Z"), + arguments("dateTime", "2026-09-23"), + // Valid in XML Schema, but rejected by the Java parsers. + arguments("date", "10000-01-01"), + arguments("dateTime", "10000-01-01T00:00:00"), + arguments("time", "24:00:00"), + arguments("dateTime", "2026-09-23T24:00:00"), + arguments("anyURI", "urn:x"), + arguments("Int", "5")); + } + + /** Values that the Java parsers accept, but XML Schema doesn't. */ + static Stream<Arguments> invalidLexicalForms() { + return Stream.of( + arguments("float", "1f"), + arguments("float", "1.5F"), + arguments("float", "1d"), + arguments("double", "1.5D"), + arguments("float", "0x1.8p1"), + arguments("double", "0x1.8p1"), + // Digits from other scripts: Arabic-Indic three, and fullwidth one and two. + arguments("int", "\u0663"), // ٣ + arguments("long", "\uff11\uff12"), // １２ + arguments("integer", "\u0663"), // ٣ + arguments("decimal", "\u0663"), // ٣ + arguments("decimal", "1e5"), + arguments("time", "12:30"), + arguments("dateTime", "2026-09-23T12:30"), Review Comment: ```java arguments("dateTime", "2026-09-23T12:30:00.1234567890123456789"), ``` What happens with a case like this? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
