Contents

#!/usr/bin/ruby -I../.. -rmagic_xml
#Copyright (c) 2006-2007 Tomasz Wegrzanowski <[e-mail]>
#
#Permission is hereby granted, free of charge, to any person obtaining a
#copy of this software and associated documentation files (the "Software"),
#to deal in the Software without restriction, including without limitation
#the rights to use, copy, modify, merge, publish, distribute, sublicense,
#and/or sell copies of the Software, and to permit persons to whom the
#Software is furnished to do so, subject to the following conditions:
#
#The above copyright notice and this permission notice shall be included in
#all copies or substantial portions of the Software.
#
#THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
#IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
#FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
#THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR
#OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
#ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
#DEALINGS IN THE SOFTWARE.


users = XML.load('users.xml').children(:user_tuple).sort_by{|i| i[:@name]}
items = XML.load('items.xml')
bids  = XML.load('bids.xml')

XML.result! {
    users.each{|u|
        user! {
            add! u.child(:name)
            bids.find_all{|b|
                b.is_a? XML and b[:@userid] == u[:@userid]
            }.map{|b| b[:@itemno]}.uniq.map{|b|
                items.find{|i| i.is_a? XML and i[:@itemno] == b}[:@description]
            }.sort.each{|dsc|
                bid_on_item! dsc
            }
        }
    }
}

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
magic_xml-0.1.1	xquery_use_cases/rdb/q18.rb
magic_xml-0.1.0	xquery_use_cases/rdb/q18.rb