Changeset 641 for MDRepository
- Timestamp:
- 08/20/10 11:54:54 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
MDRepository/trunk/xquery/cmd-stats.xql
r624 r641 1 <result> 2 <item label="CMD" >{count(//CMD)}</item> 3 <item label="CMD with Resource" >{count(//CMD[.//ResourceType='Resource'])}</item> 4 <item label="CMD with Metadata" >{count(//CMD[.//ResourceType='Metadata'])}</item> 5 <item label="ResourceProxy - Resource" >{count(//ResourceProxy[ResourceType='Resource'])}</item> 6 <item label="ResourceProxy - Metadata" >{count(//ResourceProxy[ResourceType='Metadata'])}</item> 7 8 <item label="CMD with MD, Res " >{count(//CMD[.//ResourceType='Resource'][.//ResourceType='Metadata'])}</item> 9 <item label="CMD without " >{count(//CMD[not(.//ResourceType='Resource')][not(.//ResourceType='Metadata')])}</item> 10 <item label="CMD with relative Resource (starts-with('.'))" >{count(//CMD[.//ResourceType='Resource'][starts-with(.//ResourceRef,'.')])}</item> 11 <item label="CMD with http-uri Resource" >{count(//CMD[.//ResourceType='Resource'][starts-with(.//ResourceRef,'http')])}</item> 12 <item label="CMD with relative MD" >{count(//CMD[.//ResourceType='Metadata'][starts-with(.//ResourceRef,'.')])}</item> 13 <item label="CMD with http-uri MD" >{count(//CMD[.//ResourceType='Metadata'][starts-with(.//ResourceRef,'http')])}</item> 14 <item label="CMD - Resource not relative, not http" >{count(//CMD[.//ResourceType='Resource'][not(starts-with(.//ResourceRef,'.'))][not(starts-with(.//ResourceRef,'http'))])}</item> 15 <item label="CMD - Resource only filename (text, no '/')" >{count(//CMD[.//ResourceProxy[ResourceType='Resource'][ResourceRef[text()][not(contains(.,'/'))]]])}</item> 16 <item label="CMD - only filename (text, no '/')" >{count(//CMD[.//ResourceRef[text()][not(contains(.,'/'))]])}</item> 17 <item label="ResourceRef only filename (text, no '/')" >{count(//ResourceRef[text()][not(contains(.,'/'))])}</item> 18 <item label="CMD - empty ResourceRef" >{count(//CMD[.//ResourceRef[not(text())]])}</item> 19 <item label="ResourceRef empty " >{count(//ResourceRef[not(text())])}</item> 20 21 <!-- too expensive?! <item label="CMD - empty and non-empty ResourceRef" >{count(//CMD[.//ResourceRef[not(text())]][.//ResourceRef[text()]])}</item> --> 22 23 </result> 1 let $doc-name := xmldb:store("/db/cmdi-mirror", "stats.xml", <result></result>), 2 $doc := doc($doc-name), 3 $items := (<item label="CMD" >count(//CMD)</item>, 4 <item label="CMD with Resource" >count(//CMD[.//ResourceType='Resource'])</item>, 5 <item label="CMD with Metadata" >count(//CMD[.//ResourceType='Metadata'])</item>, 6 <item label="ResourceProxy - Resource" >count(//ResourceProxy[ResourceType='Resource'])</item>, 7 <item label="ResourceProxy - Metadata" >count(//ResourceProxy[ResourceType='Metadata'])</item>, 8 <item label="CMD with MD, Res " >count((//CMD[.//ResourceType='Resource'], //CMD[.//ResourceType='Metadata']))</item>, 9 <item label="CMD without " >count(//CMD[not(.//ResourceType='Resource')][not(.//ResourceType='Metadata')])</item>, 10 <item label="CMD with relative Resource (starts-with('.'))" >count(//CMD[.//ResourceType='Resource'][starts-with(.//ResourceRef,'.')])</item>, 11 <item label="CMD with http-uri Resource" >count(//CMD[.//ResourceType='Resource'][starts-with(.//ResourceRef,'http')])</item>, 12 <item label="CMD with relative MD" >count(//CMD[.//ResourceType='Metadata'][starts-with(.//ResourceRef,'.')])</item>, 13 <item label="CMD with http-uri MD" >count(//CMD[.//ResourceType='Metadata'][starts-with(.//ResourceRef,'http')])</item>, 14 <item label="CMD - Resource not relative, not http" >count(//CMD[.//ResourceType='Resource'][not(starts-with(.//ResourceRef,'.'))][not(starts-with(.//ResourceRef,'http'))])</item>, 15 <item label="CMD - Resource only filename (text, no '/')" >count(//CMD[.//ResourceProxy[ResourceType='Resource'][ResourceRef[not(. = "")][not(contains(.,'/'))]]])</item>, 16 <item label="CMD - only filename (text, no '/')" >count(//CMD[.//ResourceRef[not(. = "")][not(contains(.,'/'))]])</item>, 17 <item label="ResourceRef only filename (text, no '/')" >count(//ResourceRef[not(. = "")][not(contains(.,'/'))])</item>, 18 <item label="CMD - empty ResourceRef">count(//CMD[.//ResourceRef[. = ""]])</item>, 19 <item label="ResourceRef empty">count(//ResourceRef[. = ""])</item>, 20 <item label="CMD - empty and non-empty ResourceRef">count((//CMD[.//ResourceRef[. = ""]], //CMD[.//ResourceRef[not(. = "")]]))</item>) 21 return 22 for $item in $items 23 let $answer := util:eval($item/text()) 24 return update insert <item label="{$item/@label}">{$answer}</item> into $doc/result
Note: See TracChangeset
for help on using the changeset viewer.