File: rdb-queries-results-q18-static-cbcl.xq

package info (click to toggle)
qtxmlpatterns-opensource-src 5.15.8-2
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 308,892 kB
  • sloc: xml: 360,343; cpp: 91,994; ansic: 388; sh: 53; sed: 31; makefile: 23
file content (24 lines) | stat: -rw-r--r-- 774 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
(: insert-start :)
declare variable $input-context1 external;
declare variable $input-context2 external;
declare variable $input-context3 external;
(: insert-end :)
<result>
  {
    for $u in $input-context2//user_tuple
    order by exactly-one($u/name)
    return
        <user>
            { $u/name }
            {
                for $b in distinct-values($input-context3//bid_tuple
                                             [userid = $u/userid]/itemno)
                for $i in $input-context1//item_tuple[itemno = $b]
                let $descr := $i/description/text()
                order by exactly-one($descr)
                return
                    <bid_on_item>{ $descr }</bid_on_item>
            }
        </user>
  }
</result>