Or maybe you meant:
<foods
>
<food id="1" name="celery">
<location name="England">
<currency>pounds</currency>
</location>
</food>
<food id="2" name="beets">
<location name="France">
<currency>francs</currency>
</location>
</food>
<food id="3" name="goat cheese">
<location name="United States">
<currency>dollars</currency>
</location>
</food>
</foods>
which, with the appropriate schema, would hypothetically get me:
{"foods":[{"id":1, "name":"celery", "location":{"name":"England",
"currency":"pounds"}},{"id":2, "name":"beets", "location":{name:"France",
"currency":"francs"}}, {"id":3, "name":"goat cheese",
"location":{"name":"United States","currency":dollars"}}]}
.. since you've already got the functionality of folding attributes and
child elements together as subobjects of their parent.
On Sun, Apr 21, 2013 at 9:23 AM, Stu Salsbury <[email protected]>wrote:
> I'm not sure I follow. If I had food repeating, and food had a cost
> attribute and a location element (and I had appropriate schema, and the two
> hypothetical map parameters) I'd get:
>
> {"foods":[{"id":1, "name":"celery", "cost":50.2, "location":
> "Norway"},{"id":2, "name":"beets", "cost":23.3,
> "location":"Finland"},{"id":3, "name":"goat cheese", "cost":0.5,
> "location":"Denmark"}]}
>
> But wouldn't the example just be demonstrating what happens if I change
> the "price" element to a "cost" attribute and add a "location" element? I
> think I must be misunderstanding your question.
>
>
>
>
> On Sun, Apr 21, 2013 at 8:54 AM, David Lee <[email protected]>wrote:
>
>> Q: in your example what if foods had an attribute or more then one
>> element name? ( say food repeating and cost attribute and location element)
>>
>>
>>
>> Sent from my iPad (excuse the terseness)
>> David A Lee
>> [email protected]
>> 812-630-7622
>>
>>
>> On Apr 21, 2013, at 10:50 AM, "Stu Salsbury" <[email protected]>
>> wrote:
>>
>> Thank you, David. Adding "element-namespace" certainly helps. I wish
>> I'd thought of that.
>>
>> I guess that, unless the function is directly told that food is to be
>> an array, it only renders the last element?
>>
>> Also, it would be great if:
>>
>> (a) there was a parameter to indicate that any elements which have
>> multiplicity should be arrays; and
>> (b) there was a parameter to indicate that the array elements should not
>> be in the json (i.e. their content remains but is not wrapped with their
>> name as a key/value).
>>
>> something like:
>> (: I'm making up these parameter names -- this code isn't real!!!
>> :)
>> , $_ := map:put($c,"arrays-for-multiplicity",true);
>> , $_ := map:put($c,"unwrap-array-elements",true);
>>
>> so that I'd get:
>>
>> {"foods":[{"id":1, "name":"celery", "price":50.2},{"id":2,
>> "name":"beets", "price":23.3},{"id":3, "name":"goat cheese", "price":0.5}]}
>>
>>
>>
>> On Sun, Apr 21, 2013 at 4:49 AM, David Lee <[email protected]>wrote:
>>
>>> You need to indicate that food is an array element.****
>>>
>>> Since you have now put food in a namespace your array-element-names isnt
>>> finding it.****
>>>
>>> You either need to use an xs:QName() to give the full name of "food" or
>>> to declare the default namespace for the configuration using ****
>>>
>>> ** **
>>>
>>> e.g. this should work****
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> , $_ := map:put($c,"array-element-names", xs:QName("agt:food") )**
>>> **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> alternatively****
>>>
>>> , $_ := map:put($c,"element-namespace","
>>> http://example.com/agt";)****
>>>
>>> ** **
>>>
>>> which has the nice side effect of making the transformation reversable.*
>>> ***
>>>
>>> ** **
>>>
>>> ** **
>>>
>>>
>>> -----------------------------------------------------------------------------
>>> ****
>>>
>>> David Lee
>>> Lead Engineer
>>> MarkLogic Corporation
>>> [email protected]
>>> Phone: +1 812-482-5224****
>>>
>>> Cell: +1 812-630-7622
>>> www.marklogic.com
>>>
>>> ****
>>>
>>> ** **
>>>
>>> *From:* [email protected] [mailto:
>>> [email protected]] *On Behalf Of *Stu Salsbury
>>> *Sent:* Sunday, April 21, 2013 1:18 AM
>>> *To:* [email protected]
>>> *Subject:* [MarkLogic Dev General] transform-to-json -- custom config
>>> drops elements?****
>>>
>>> ** **
>>>
>>> I have the following xml****
>>>
>>> ** **
>>>
>>> <foods****
>>>
>>> xmlns="http://example.com/agt"****
>>>
>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"****
>>>
>>> >** **
>>>
>>> <food id="1" name="celery">****
>>>
>>> <price>50.2</price>****
>>>
>>> </food>****
>>>
>>> <food id="2" name="beets">****
>>>
>>> <price>23.3</price>****
>>>
>>> </food>****
>>>
>>> <food id="3" name="goat cheese">****
>>>
>>> <price>0.5</price>****
>>>
>>> </food>****
>>>
>>> </foods>****
>>>
>>> ** **
>>>
>>> With the following xsd:****
>>>
>>> ** **
>>>
>>> <xs:schema****
>>>
>>> targetNamespace="http://example.com/agt"****
>>>
>>> attributeFormDefault="unqualified"****
>>>
>>> elementFormDefault="unqualified"****
>>>
>>> xmlns:xs="http://www.w3.org/2001/XMLSchema"****
>>>
>>> >** **
>>>
>>> <xs:element name="price" type="xs:decimal"/>****
>>>
>>> <xs:element name="food">****
>>>
>>> <xs:complexType>****
>>>
>>> <xs:sequence>****
>>>
>>> <xs:element ref="price"/>****
>>>
>>> </xs:sequence>****
>>>
>>> <xs:attribute name="id" type="xs:integer"/>****
>>>
>>> <xs:attribute name="name" type="xs:string"/>****
>>>
>>> </xs:complexType>****
>>>
>>> </xs:element>****
>>>
>>> <xs:element name="foods">****
>>>
>>> <xs:complexType>****
>>>
>>> <xs:sequence>****
>>>
>>> <xs:element ref="food" maxOccurs="unbounded" minOccurs="0"/>****
>>>
>>> </xs:sequence>****
>>>
>>> </xs:complexType>****
>>>
>>> </xs:element>****
>>>
>>> </xs:schema>****
>>>
>>> ** **
>>>
>>> When I execute the following query in the console:****
>>>
>>> ** **
>>>
>>> xquery version "1.0-ml";****
>>>
>>> import module namespace json = "http://marklogic.com/xdmp/json"; at
>>> "/MarkLogic/json/json.xqy";****
>>>
>>> declare namespace agt = "http://example.com/agt";****
>>>
>>> let $c := json:config("custom")****
>>>
>>> , $_ := map:put($c,"array-element-names", "food")****
>>>
>>> return****
>>>
>>> json:transform-to-json( doc("foods.xml") , $c )****
>>>
>>> ** **
>>>
>>> ... I get:****
>>>
>>> ** **
>>>
>>> {"foods":{"food":{"id":3, "name":"goat cheese", "price":0.5}}}****
>>>
>>> ** **
>>>
>>> Something isn't clicking for me. What happened to the food elements?
>>> No array, and only the last one made it into the output. Note that taking
>>> out the array-element-names does *not* solve the missing food elements.*
>>> ***
>>>
>>> ** **
>>>
>>> Is this a bug or am I doing it wrong? I just started with MarkLogic
>>> Server, so I could very well be doing it wrong. Any advice appreciated.*
>>> ***
>>>
>>> ** **
>>>
>>> Regards,****
>>>
>>> Stu****
>>>
>>> _______________________________________________
>>> General mailing list
>>> [email protected]
>>> http://developer.marklogic.com/mailman/listinfo/general
>>>
>>>
>> _______________________________________________
>> General mailing list
>> [email protected]
>> http://developer.marklogic.com/mailman/listinfo/general
>>
>>
>> _______________________________________________
>> General mailing list
>> [email protected]
>> http://developer.marklogic.com/mailman/listinfo/general
>>
>>
>
_______________________________________________
General mailing list
[email protected]
http://developer.marklogic.com/mailman/listinfo/general
