Repository: incubator-vxquery Updated Branches: refs/heads/master 9ab4c6d9b -> 43e6daad7
Found some files missing from the last commit for aggregate tests. Project: http://git-wip-us.apache.org/repos/asf/incubator-vxquery/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-vxquery/commit/3d64ae33 Tree: http://git-wip-us.apache.org/repos/asf/incubator-vxquery/tree/3d64ae33 Diff: http://git-wip-us.apache.org/repos/asf/incubator-vxquery/diff/3d64ae33 Branch: refs/heads/master Commit: 3d64ae3399af8a20eadce8b9da0929c910471a0a Parents: 7cde080 Author: Preston Carman <[email protected]> Authored: Tue Apr 1 17:06:57 2014 -0700 Committer: Preston Carman <[email protected]> Committed: Tue Apr 1 20:56:26 2014 -0700 ---------------------------------------------------------------------- .../tests/ExpectedTestResults/Aggregate/Partition-1/avg.txt | 1 + .../ExpectedTestResults/Aggregate/Partition-1/count.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-1/max.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-1/min.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-1/sum.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-2/avg.txt | 1 + .../ExpectedTestResults/Aggregate/Partition-2/count.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-2/max.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-2/min.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-2/sum.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-4/avg.txt | 1 + .../ExpectedTestResults/Aggregate/Partition-4/count.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-4/max.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-4/min.txt | 1 + .../tests/ExpectedTestResults/Aggregate/Partition-4/sum.txt | 1 + .../tests/ExpectedTestResults/Ghcnd/Partition-1/q01.txt | 2 +- .../tests/ExpectedTestResults/Ghcnd/Partition-2/q01.txt | 2 +- .../tests/ExpectedTestResults/Ghcnd/Partition-4/q01.txt | 2 +- .../tests/Queries/XQuery/Aggregate/Partition-1/avg.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-1/count.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-1/max.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-1/min.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-1/sum.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-2/avg.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-2/count.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-2/max.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-2/min.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-2/sum.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-4/avg.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-4/count.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-4/max.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-4/min.xq | 8 ++++++++ .../tests/Queries/XQuery/Aggregate/Partition-4/sum.xq | 8 ++++++++ 33 files changed, 138 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/avg.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/avg.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/avg.txt new file mode 100644 index 0000000..7ef6ffe --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/avg.txt @@ -0,0 +1 @@ +12.5 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/count.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/count.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/count.txt new file mode 100644 index 0000000..d8263ee --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/count.txt @@ -0,0 +1 @@ +2 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/max.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/max.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/max.txt new file mode 100644 index 0000000..dc7b54a --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/max.txt @@ -0,0 +1 @@ +33 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/min.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/min.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/min.txt new file mode 100644 index 0000000..ea1acb6 --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/min.txt @@ -0,0 +1 @@ +11.25 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/sum.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/sum.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/sum.txt new file mode 100644 index 0000000..2b82dfe --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-1/sum.txt @@ -0,0 +1 @@ +60 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/avg.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/avg.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/avg.txt new file mode 100644 index 0000000..7ef6ffe --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/avg.txt @@ -0,0 +1 @@ +12.5 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/count.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/count.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/count.txt new file mode 100644 index 0000000..d8263ee --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/count.txt @@ -0,0 +1 @@ +2 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/max.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/max.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/max.txt new file mode 100644 index 0000000..dc7b54a --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/max.txt @@ -0,0 +1 @@ +33 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/min.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/min.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/min.txt new file mode 100644 index 0000000..ea1acb6 --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/min.txt @@ -0,0 +1 @@ +11.25 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/sum.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/sum.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/sum.txt new file mode 100644 index 0000000..2b82dfe --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-2/sum.txt @@ -0,0 +1 @@ +60 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/avg.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/avg.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/avg.txt new file mode 100644 index 0000000..7ef6ffe --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/avg.txt @@ -0,0 +1 @@ +12.5 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/count.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/count.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/count.txt new file mode 100644 index 0000000..d8263ee --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/count.txt @@ -0,0 +1 @@ +2 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/max.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/max.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/max.txt new file mode 100644 index 0000000..dc7b54a --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/max.txt @@ -0,0 +1 @@ +33 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/min.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/min.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/min.txt new file mode 100644 index 0000000..ea1acb6 --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/min.txt @@ -0,0 +1 @@ +11.25 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/sum.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/sum.txt b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/sum.txt new file mode 100644 index 0000000..2b82dfe --- /dev/null +++ b/vxquery-xtest/tests/ExpectedTestResults/Aggregate/Partition-4/sum.txt @@ -0,0 +1 @@ +60 \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-1/q01.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-1/q01.txt b/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-1/q01.txt index 82de09d..ff4bc9b 100644 --- a/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-1/q01.txt +++ b/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-1/q01.txt @@ -1 +1 @@ -<data><date>2001-01-01T00:00:00.000</date><dataType>AWND</dataType><station>GHCND:US000000001</station><value>1000</value><attributes><attribute/><attribute/><attribute>a</attribute><attribute/></attributes></data> \ No newline at end of file +<data><date>2001-01-01T00:00:00.000</date><dataType>AWND</dataType><station>GHCND:US000000001</station><value>1000</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data> \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-2/q01.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-2/q01.txt b/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-2/q01.txt index 82de09d..ff4bc9b 100644 --- a/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-2/q01.txt +++ b/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-2/q01.txt @@ -1 +1 @@ -<data><date>2001-01-01T00:00:00.000</date><dataType>AWND</dataType><station>GHCND:US000000001</station><value>1000</value><attributes><attribute/><attribute/><attribute>a</attribute><attribute/></attributes></data> \ No newline at end of file +<data><date>2001-01-01T00:00:00.000</date><dataType>AWND</dataType><station>GHCND:US000000001</station><value>1000</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data> \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-4/q01.txt ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-4/q01.txt b/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-4/q01.txt index 82de09d..ff4bc9b 100644 --- a/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-4/q01.txt +++ b/vxquery-xtest/tests/ExpectedTestResults/Ghcnd/Partition-4/q01.txt @@ -1 +1 @@ -<data><date>2001-01-01T00:00:00.000</date><dataType>AWND</dataType><station>GHCND:US000000001</station><value>1000</value><attributes><attribute/><attribute/><attribute>a</attribute><attribute/></attributes></data> \ No newline at end of file +<data><date>2001-01-01T00:00:00.000</date><dataType>AWND</dataType><station>GHCND:US000000001</station><value>1000</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data> \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/avg.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/avg.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/avg.xq new file mode 100644 index 0000000..12cfc02 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/avg.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the average minimum temperature. :) +fn:avg( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "TMIN" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/count.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/count.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/count.xq new file mode 100644 index 0000000..3a2609b --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/count.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the number of wind sensor readings. :) +fn:count( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "AWND" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/max.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/max.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/max.xq new file mode 100644 index 0000000..161b409 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/max.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the highest max temperature. :) +fn:max( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "TMAX" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/min.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/min.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/min.xq new file mode 100644 index 0000000..0a135d1 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/min.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the lowest min temperature. :) +fn:min( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "TMIN" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/sum.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/sum.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/sum.xq new file mode 100644 index 0000000..91a2c4c --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-1/sum.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the total precipitation. :) +fn:sum( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "PRCP" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/avg.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/avg.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/avg.xq new file mode 100644 index 0000000..864fdb9 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/avg.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the average minimum temperature. :) +fn:avg( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "TMIN" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/count.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/count.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/count.xq new file mode 100644 index 0000000..3ad16b6 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/count.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the number of wind sensor readings. :) +fn:count( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "AWND" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/max.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/max.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/max.xq new file mode 100644 index 0000000..82b1061 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/max.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the highest max temperature. :) +fn:max( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "TMAX" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/min.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/min.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/min.xq new file mode 100644 index 0000000..d990aff --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/min.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the lowest min temperature. :) +fn:min( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "TMIN" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/sum.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/sum.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/sum.xq new file mode 100644 index 0000000..8c9bea9 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-2/sum.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the total precipitation. :) +fn:sum( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "PRCP" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/avg.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/avg.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/avg.xq new file mode 100644 index 0000000..d50166d --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/avg.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the average minimum temperature. :) +fn:avg( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "TMIN" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/count.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/count.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/count.xq new file mode 100644 index 0000000..cebf3e6 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/count.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the number of wind sensor readings. :) +fn:count( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "AWND" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/max.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/max.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/max.xq new file mode 100644 index 0000000..ba4f771 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/max.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the highest max temperature. :) +fn:max( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "TMAX" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/min.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/min.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/min.xq new file mode 100644 index 0000000..b37f462 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/min.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the lowest min temperature. :) +fn:min( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "TMIN" + return $r/value +) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/3d64ae33/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/sum.xq ---------------------------------------------------------------------- diff --git a/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/sum.xq b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/sum.xq new file mode 100644 index 0000000..c41c7b6 --- /dev/null +++ b/vxquery-xtest/tests/Queries/XQuery/Aggregate/Partition-4/sum.xq @@ -0,0 +1,8 @@ +(: XQuery Aggregate Query :) +(: Find the total precipitation. :) +fn:sum( + let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/|/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/" + for $r in collection($collection)/dataCollection/data + where $r/dataType eq "PRCP" + return $r/value +) \ No newline at end of file
