XQuery Update Facility Use Cases

USERS ( USERID, NAME, RATING ) 
ITEMS ( ITEMNO, DESCRIPTION, OFFERED_BY, START_DATE, END_DATE, RESERVE_PRICE ) 
BIDS ( USERID, ITEMNO, BID, BID_DATE )

<items>
  <item_tuple>
    <itemno>1001</itemno>
    <description>Red Bicycle</description>
    <offered_by>U01</offered_by>
    <start_date>1999-01-05</start_date>
    <end_date>1999-01-20</end_date>
    <reserve_price>40</reserve_price>
  </item_tuple>
  <!-- !!! Snip !!! -->

<users>
  <user_tuple>
    <userid>U01</userid>
    <name>Tom Jones</name>
    <rating>B</rating>
  </user_tuple>
  <!-- !!! Snip !!! -->

<bids>
  <bid_tuple> 
    <userid>U02</userid> 
    <itemno>1001</itemno> 
    <bid>35</bid> 
    <bid_date>1999-01-07</bid_date> 
    </bid_tuple> 
  <bid_tuple> 
  <!-- !!! Snip !!! -->
                    

<archived-agenda>
  <last-synch-time>2005-10-05T10:00</last-synch-time>
  <entry>
    <name>Benjamin</name>
    <contact>benjamin@inria.fr</contact>
  </entry>
  <entry>
    <name>Dario</name>
    <contact>dario@uni-pisa.it</contact>
  </entry>
  <entry>
    <name>Anthony</name>
    <contact>tony@uni-toulon.fr</contact>
  </entry>
</archived-agenda>

                                

<log>
</log>

                                

<agenda-version>
  <entry>
    <name>Benjamin</name>
    <contact>benjamin@uni-versailles.fr</contact>
  </entry>
  <entry>
    <name>Dario</name>
    <contact>dario@uni-parissud.fr</contact>
  </entry>
  <entry>
    <name>Anthony</name>
    <contact>tony@ena.fr</contact>
  </entry>
</agenda-version>

                                

<agenda-version>  
  <entry>
    <name>Benjamin</name>
    <contact>benjamin@uni-versailles.fr</contact>
  </entry>
  <entry>
    <name>Dario</name>
    <contact>dario@uni-pisa.it</contact>
  </entry>
  <entry>
    <name>Anthony</name>
    <contact>tony@ehess.fr</contact>
  </entry>
 </agenda-version>

                                

for $a in doc("archive.xml")/entry, 
    $v1 in doc("copy1.xml")/entry, 
    $v2 in doc("copy2.xml")/entry
where $a/name = $v1/name
  and $v1/name = $v2/name
do if ($a/contact = $v1/contact and $v1/contact=$v2/contact)
     then ()
   else if ($v1/contact = $v2/contact)
     then replace value of {$a/contact} with $v1/contact
   else if ($a/contact = $v1/contact)
     then (
       replace value of {$a/contact} with $v2/contact,
       replace value of {$v1/contact} with $v2/contact
     )
   else if ($a/contact = $v2/contact)
     then (
       replace value of {$a/contact} with $v1/contact,
       replace value of {$v2/contact} with $v1/contact
     )
   else (
     insert {
        <fail>
          <arch>{ $a }</arch>
          <v1>{ $v1 }</v1>
          <v2>{ $v2 }</v2>
        </fail>
      }
     as last into doc("log.xml")
   )

  

<archived-agenda>
  <last-synch-time>2005-11-09T12:00</last-synch-time>
  <entry>
    <name>Benjamin</name>
    <!-- copied from the modified entries -->
    <contact>benjamin@uni-versailles.fr</contact>
  </entry>
  <entry>
    <name>Dario</name>
    <!-- copied from first modified version -->
    <contact>dario@uni-parissud.fr</contact>
  </entry>
  <entry>
    <name>Anthony</name>
    <!-- unchanged due to conflict -->
    <contact>tony@uni-toulon.fr</contact>
  </entry>
</archived-agenda>

                                        

<log>
  <!-- update failure details -->
  <fail>
     <arch>
       <!-- archived agenda version -->
       <entry>
         <name>Anthony</name>
         <contact>tony@uni-toulon.fr</contact>
       </entry>
     </arch>
     <v1>
       <!-- first modified version -->
       <entry>
         <name>Anthony</name>
         <contact>tony@ena.fr</contact>
       </entry>
     </v1>
     <v2>
       <!-- second modified version -->
       <entry>
         <name>Anthony</name>
         <contact>tony@ehess.fr</contact>
       </entry>
     </v2>
  </fail>
</log>

                                

<agenda-version>
  <entry>
    <name>Benjamin</name>
    <!-- kept after synchronization -->
    <contact>benjamin@uni-versailles.fr</contact>
  </entry>
  <entry>
    <!-- kept after synchronization -->
    <name>Dario</name>
    <contact>dario@uni-parissud.fr</contact>
  </entry>
  <entry>
    <!-- kept after synchronization failure -->
    <name>Anthony</name>
    <contact>tony@ena.fr</contact>
  </entry>
</agenda-version>

                                

<agenda-version>  
  <entry>
    <!-- kept after synchronization -->
    <name>Benjamin</name>
    <contact>benjamin@uni-versailles.fr</contact>
  </entry>
  <entry>
    <!-- value taken from the other modified version -->
    <name>Dario</name>
    <contact>dario@uni-parissud.fr</contact>
  </entry>
  <entry>
    <!-- kept after synchronization failure -->
    <name>Anthony</name>
    <contact>tony@ehess.fr</contact>
  </entry>
</agenda-version>

                                

<?xml version='1.0' ?>
<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope"> 
 <env:Header>
  <m:reservation xmlns:m="http://travelcompany.example.org/reservation" 
          env:role="http://www.w3.org/2003/05/soap-envelope/role/next"
           env:mustUnderstand="true">
   <m:reference>uuid:093a2da1-q345-739r-ba5d-pqff98fe8j7d</m:reference>
   <m:dateAndTime>2001-11-29T13:20:00.000-05:00</m:dateAndTime>
  </m:reservation>
  <n:passenger xmlns:n="http://mycompany.example.com/employees"
          env:role="http://www.w3.org/2003/05/soap-envelope/role/next"
           env:mustUnderstand="true">
   <n:name>Åke Jógvan Øyvind</n:name>
  </n:passenger>
 </env:Header>
 <env:Body>
  <p:itinerary
    xmlns:p="http://travelcompany.example.org/reservation/travel">
   <p:departure>
     <p:departing>New York</p:departing>
     <p:arriving>Los Angeles</p:arriving>
     <p:departureDate>2001-12-14</p:departureDate>
     <p:departureTime>late afternoon</p:departureTime>
     <p:seatPreference>aisle</p:seatPreference>
   </p:departure>
   <p:return>
     <p:departing>Los Angeles</p:departing>
     <p:arriving>New York</p:arriving>
     <p:departureDate>2001-12-20</p:departureDate>
     <p:departureTime>mid-morning</p:departureTime>
     <p:seatPreference/>
   </p:return>
  </p:itinerary>
  <q:lodging
   xmlns:q="http://travelcompany.example.org/reservation/hotels">
   <q:preference>none</q:preference>
  </q:lodging>
 </env:Body>
</env:Envelope>
                                        
                                        

                                        
declare namespace env="http://www.w3.org/2003/05/soap-envelope";
declare namespace m="http://travelcompany.example.org/reservation";
declare namespace n="http://mycompany.example.com/employees";
declare namespace p="http://travelcompany.example.org/reservation/travel";

(:  A clarification is needed only if there are no
 :  airports or more than one for a given city. If
 :  there is precisely one, there is no need to
 :  ask for information on that city.
 :)

declare function local:airportChoices($city as xs:string)
{
  let $airports := collection("airports")/AIRPORTS[CITY = $city]
  return
    if (count($airports) = 0)
    then 
       <error> No airports found for {$city}!</error>
    else if (count($airports) > 1) 
    then 
       <airportChoices>
        { 
          for $c in $airports/CODE
          return (string-value( $c ), " ")
        }
       </airportChoices>
    else ()
};

(:  Make sure that each airport is unambiguous. If there is
 :  more than once airport for a city, ask for clarification.
 :
 :  The primer only shows the error condition, so it is not
 :  clear what to do if there are no errors. Here, we simply
 :  return the airports in the itinerary.
 :)

declare function local:airports($in as element(env:Envelope))
{
    let $departureDeparting := $in//p:departure/p:departing
    let $departureDepartingAirports := collection("airports")/AIRPORTS[CITY = $departureDeparting]
    let $departureArriving := $in//p:departure/p:arriving
    let $departureArrivingAirports := collection("airports")/AIRPORTS[CITY = $departureArriving]
    let $returnDeparting := $in//p:return/p:departing
    let $returnDepartingAirports := collection("airports")/AIRPORTS[CITY = $returnDeparting]
    let $returnArriving := $in//p:return/p:arriving
    let $returnArrivingAirports := collection("airports")/AIRPORTS[CITY = $returnArriving]
    return
       if ( count($departureDepartingAirports)=0 or count($departureDepartingAirports)>1
          or count($departureArrivingAirports)=0 or count($departureArrivingAirports)>1
          or count($returnDepartingAirports)=0 or count($returnDepartingAirports)>1
          or count($returnArrivingAirports)=0 or count($returnArrivingAirports)>1 )
         then
          <p:itineraryClarification>
            { local:airportChoices($departureDeparting) }
            { local:airportChoices($departureArriving) }
            { local:airportChoices($returnDeparting) }
            { local:airportChoices($returnArriving) }
          </p:itineraryClarification>
         else 
          <p:itinerary>
            <p:departure>
              <p:departing>{$departureDeparting}</p:departing>
              <p:arriving>{$departureArriving}</p:arriving>
            </p:departure>
            <p:return>
              <p:departing>{$returnDeparting}</p:departing>
              <p:arriving>{$returnArriving}</p:arriving>
            </p:return>
          </p:itinerary>
};

for $in in $msg/env:Envelope
return
   transform 
     copy $out := $in
     do (
       replace value of {$out//m:dateAndTime} with fn:currentDateTime(),
       replace {$out//env:Body} 
       with <env:Body>
             { local:airports($in) }
            </env:Body>
     )
     return $out
                                        

<env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope"> 
 <env:Header>
  <m:reservation xmlns:m="http://travelcompany.example.org/reservation" 
      env:role="http://www.w3.org/2003/05/soap-envelope/role/next"
           env:mustUnderstand="true">
   <m:reference>uuid:093a2da1-q345-739r-ba5d-pqff98fe8j7d</m:reference>
   <m:dateAndTime>2001-11-29T13:35:00.000-05:00</m:dateAndTime> 
  </m:reservation>
  <n:passenger xmlns:n="http://mycompany.example.com/employees"
      env:role="http://www.w3.org/2003/05/soap-envelope/role/next"
           env:mustUnderstand="true">
   <n:name>Åke Jógvan Øyvind</n:name>
  </n:passenger>
 </env:Header>
 <env:Body>
  <p:itineraryClarification 
    xmlns:p="http://travelcompany.example.org/reservation/travel">
   <p:departure>
     <p:departing>
       <p:airportChoices>
          JFK LGA EWR 
       </p:airportChoices>
     </p:departing>
   </p:departure>
   <p:return>
     <p:arriving>
       <p:airportChoices>
         JFK LGA EWR 
       </p:airportChoices>
     </p:arriving>
   </p:return>  
  </p:itineraryClarification>
 </env:Body>
</env:Envelope>