ABC Corp 的每位员工都享有不限量的燃油补贴。员工每次给车加油时都必须提交一条记录。这些记录会追加到同一个 XML 文件中,在月末统一处理。
作为数字运营团队的一员,你的任务是读取这个 XML 文件,并把结果写入另一个 XML 文件。输出文件应为每位员工包含一条记录,其中包含以下内容:
你会收到两个 string 参数。
输入 XML 文件的内容会遵循以下 XML 模式。
<?xml version="1.0" encoding="UTF-8" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
targetNamespace="http://www.so2w.org"
xmlns:tns="http://www.so2w.org"
elementFormDefault="qualified">
<xs:element name="FuelEvents">
<xs:complexType>
<xs:sequence>
<xs:element name="FuelEvent" type="tns:FuelUpEvent" nillable="true" minOccurs="0" maxOccurs="1000"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:complexType name="FuelEvent">
<xs:sequence>
<xs:element name="odometerReading" type="xs:integer"/>
<xs:element name="gallons" type="xs:decimal"/>
<xs:element name="gasPrice" type="xs:decimal"/>
</xs:sequence>
<xs:attribute name="employeeId" type="xs:integer" use="required"/>
</xs:complexType>
</xs:schema>
你的任务是把输入的 XML 转换成下面这种 XML 格式,并把内容写入给定的路径。输出文件应为每位员工包含一条记录,并按 employeeId 升序排列。
<?xml version="1.0" encoding="UTF-8" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
targetNamespace="http://www.so2w.org"
xmlns:tns="http://www.so2w.org"
elementFormDefault="qualified">
<xs:element name="employeeFuelRecords">
<xs:complexType>
<xs:sequence>
<xs:element name="employeeFuelRecord" type="tns:employeeFuelRecord" nillable="true" minOccurs="0" maxOccurs="97"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:complexType name="employeeFuelRecord">
<xs:sequence>
<xs:element name="gasFillUpCount" type="xs:integer"/>
<xs:element name="totalFuelCost" type="xs:decimal"/>
<xs:element name="totalGallons" type="xs:decimal"/>
<xs:element name="totalMilesAccrued" type="xs:integer"/>
</xs:sequence>
<xs:attribute name="employeeId" type="xs:integer" use="required"/>
</xs:complexType>
</xs:schema>
n:0 <= n <= 1000example01_input.xml
<s:FuelEvents xmlns:s="http://www.so2w.org">
<s:FuelEvent employeeId="2312">
<s:odometerReading>230</s:odometerReading>
<s:gallons>18.561</s:gallons>
<s:gasPrice>4.56</s:gasPrice>
</s:FuelEvent>
<s:FuelEvent employeeId="2312">
<s:odometerReading>500</s:odometerReading>
<s:gallons>19.345</s:gallons>
<s:gasPrice>4.89</s:gasPrice>
</s:FuelEvent>
</s:FuelEvents>
example01_output.xml
<s:employeeFuelRecords xmlns:s="http://www.so2w.org">
<s:employeeFuelRecord employeeId="2312">
<s:gasFillUpCount>2</s:gasFillUpCount>
<s:totalFuelCost>179.23521</s:totalFuelCost>
<s:totalGallons>37.906</s:totalGallons>
<s:totalMilesAccrued>270</s:totalMilesAccrued>
</s:employeeFuelRecord>
</s:employeeFuelRecords>
example02_input.xml
<s:FuelEvents xmlns:s="http://www.so2w.org">
<s:FuelEvent employeeId="2413">
<s:odometerReading>4089</s:odometerReading>
<s:gallons>21.682</s:gallons>
<s:gasPrice>3.46</s:gasPrice>
</s:FuelEvent>
<s:FuelEvent employeeId="3423">
<s:odometerReading>6582</s:odometerReading>
<s:gallons>15.248</s:gallons>
<s:gasPrice>4.56</s:gasPrice>
</s:FuelEvent>
<s:FuelEvent employeeId="2413">
<s:odometerReading>4127</s:odometerReading>
<s:gallons>4.221</s:gallons>
<s:gasPrice>3.40</s:gasPrice>
</s:FuelEvent>
<s:FuelEvent employeeId="2413">
<s:odometerReading>4349</s:odometerReading>
<s:gallons>11.192</s:gallons>
<s:gasPrice>4.10</s:gasPrice>
</s:FuelEvent>
<s:FuelEvent employeeId="3423">
<s:odometerReading>6767</s:odometerReading>
<s:gallons>8.696</s:gallons>
<s:gasPrice>3.34</s:gasPrice>
</s:FuelEvent>
<s:FuelEvent employeeId="2413">
<s:odometerReading>4547</s:odometerReading>
<s:gallons>9.197</s:gallons>
<s:gasPrice>2.90</s:gasPrice>
</s:FuelEvent>
</s:FuelEvents>
example02_output.xml
<s:employeeFuelRecords xmlns:s="http://www.so2w.org">
<s:employeeFuelRecord employeeId="2413">
<s:gasFillUpCount>4</s:gasFillUpCount>
<s:totalFuelCost>161.92962</s:totalFuelCost>
<s:totalGallons>46.292</s:totalGallons>
<s:totalMilesAccrued>458</s:totalMilesAccrued>
</s:employeeFuelRecord>
<s:employeeFuelRecord employeeId="3423">
<s:gasFillUpCount>2</s:gasFillUpCount>
<s:totalFuelCost>98.57552</s:totalFuelCost>
<s:totalGallons>23.944</s:totalGallons>
<s:totalMilesAccrued>185</s:totalMilesAccrued>
</s:employeeFuelRecord>
</s:employeeFuelRecords>
ballerina/io 模块 读写 XML 文件。