soliantconsulting/SimpleFM

View on GitHub
test/Client/ResultSet/TestAssets/ParentChildAssociations/Base-recid1-id2.xml

Summary

Maintainability
Test Coverage
<?xml version ="1.0" encoding="UTF-8" standalone="no"?>
<fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0">
    <error code="0"></error>
    <product build="04/07/2016" name="FileMaker Web Publishing Engine" version="15.0.1.137"></product>
    <datasource database="XmlSchemaDemo" date-format="MM/dd/yyyy" layout="Base" table="Base" time-format="HH:mm:ss" timestamp-format="MM/dd/yyyy HH:mm:ss" total-count="2"></datasource>
    <metadata>
        <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="id" not-empty="no" numeric-only="yes" result="number" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="id_Parent" not-empty="no" numeric-only="no" result="number" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Number Field" not-empty="no" numeric-only="no" result="number" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Text Field" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Date Field" not-empty="no" numeric-only="no" result="date" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Time Field" not-empty="no" numeric-only="no" result="time" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Timestamp Field" not-empty="no" numeric-only="no" result="timestamp" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="Container Field" not-empty="no" numeric-only="no" result="container" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="Container Field 2" not-empty="no" numeric-only="no" result="container" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="Calculation Text Field" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="calculation"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="Summary Number Field" not-empty="no" numeric-only="no" result="number" time-of-day="no" type="summary"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="10" name="Repeating Number Field" not-empty="no" numeric-only="no" result="number" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Parent::id" not-empty="no" numeric-only="yes" result="number" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Parent::Number Field" not-empty="no" numeric-only="no" result="number" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Parent::Text Field" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
        <relatedset-definition table="Child">
            <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Child::id" not-empty="no" numeric-only="yes" result="number" time-of-day="no" type="normal"></field-definition>
            <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Child::Number Field" not-empty="no" numeric-only="no" result="number" time-of-day="no" type="normal"></field-definition>
            <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Child::Text Field" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
        </relatedset-definition>
        <relatedset-definition table="Parent">
            <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Parent::id" not-empty="no" numeric-only="yes" result="number" time-of-day="no" type="normal"></field-definition>
            <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Parent::Number Field" not-empty="no" numeric-only="no" result="number" time-of-day="no" type="normal"></field-definition>
            <field-definition auto-enter="yes" four-digit-year="no" global="no" max-repeat="1" name="Parent::Text Field" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
        </relatedset-definition>
    </metadata>
    <resultset count="1" fetch-size="1">
        <record mod-id="18" record-id="1">
            <field name="id">
                <data>2</data>
            </field>
            <field name="id_Parent">
                <data>2</data>
            </field>
            <field name="Number Field">
                <data>10000000000000000000000000000000000</data>
            </field>
            <field name="Text Field">
                <data>Some other text with line breaks
Line two
Line three</data>
            </field>
            <field name="Date Field">
                <data>09/14/2016</data>
            </field>
            <field name="Time Field">
                <data>14:22:27</data>
            </field>
            <field name="Timestamp Field">
                <data>09/14/2016 14:22:27</data>
            </field>
            <field name="Container Field">
                <data>/fmi/xml/cnt/Untitled.jpg?-db=XML%20Schema%20Demo&amp;-lay=Base&amp;-recid=1&amp;-field=Container%20Field(1)</data>
            </field>
            <field name="Container Field 2">
                <data></data>
            </field>
            <field name="Calculation Text Field">
                <data>Value from Text Field: Some other text with line breaks
Line two
Line three</data>
            </field>
            <field name="Summary Number Field">
                <data>1.0e+34</data>
            </field>
            <field name="Repeating Number Field">
                <data>601.20157571027432741</data>
                <data>978.28654885867694091</data>
                <data>562.11884952868085286</data>
                <data>610.68434562589779535</data>
                <data>723.31044362559360206</data>
                <data>57.364410225222206563</data>
                <data>494.45716803565276098</data>
                <data>289.12837504537181044</data>
                <data>977.22398985867353627</data>
                <data>212.27656395696614666</data>
            </field>
            <field name="Parent::id">
                <data>2</data>
            </field>
            <field name="Parent::Number Field">
                <data>94.82918507895723447869</data>
            </field>
            <field name="Parent::Text Field">
                <data>Parent text</data>
            </field>
            <relatedset count="3" table="Child">
                <record mod-id="14" record-id="1">
                    <field name="Child::id">
                        <data>1</data>
                    </field>
                    <field name="Child::Number Field">
                        <data>94.1324372811592222645</data>
                    </field>
                    <field name="Child::Text Field">
                        <data>Child text</data>
                    </field>
                </record>
                <record mod-id="12" record-id="2">
                    <field name="Child::id">
                        <data>2</data>
                    </field>
                    <field name="Child::Number Field">
                        <data>91.9985313244911746543</data>
                    </field>
                    <field name="Child::Text Field">
                        <data>Other Child text</data>
                    </field>
                </record>
                <record mod-id="15" record-id="3">
                    <field name="Child::id">
                        <data>3</data>
                    </field>
                    <field name="Child::Number Field">
                        <data>39.353500010567681099802</data>
                    </field>
                    <field name="Child::Text Field">
                        <data>Yet moar Child text</data>
                    </field>
                </record>
            </relatedset>
            <relatedset count="1" table="Parent">
                <record mod-id="5" record-id="1">
                    <field name="Parent::id">
                        <data>2</data>
                    </field>
                    <field name="Parent::Number Field">
                        <data>94.82918507895723447869</data>
                    </field>
                    <field name="Parent::Text Field">
                        <data>Parent text</data>
                    </field>
                </record>
            </relatedset>
        </record>
    </resultset>
</fmresultset>