You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vxquery.apache.org by pr...@apache.org on 2014/04/09 00:16:19 UTC
[21/50] [abbrv] Updated the testing resources.
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q00.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q00.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q00.xq
deleted file mode 100644
index 86241cd..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q00.xq
+++ /dev/null
@@ -1,11 +0,0 @@
-(: XQuery Filter Query :)
-(: See historical data for Riverside, CA (AS000000003) station by selecting :)
-(: the weather readings for December 25 over the last 10 years. :)
-let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
-for $r in collection($collection)/dataCollection/data
-let $datetime := xs:dateTime(fn:data($r/date))
-where $r/station eq "GHCND:AS000000003"
- and fn:year-from-dateTime($datetime) ge 2000
- and fn:month-from-dateTime($datetime) eq 3
- and fn:day-from-dateTime($datetime) eq 3
-return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q01.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q01.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q01.xq
deleted file mode 100644
index 1572994..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q01.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Filter Query :)
-(: Find all reading for hurricane force wind warning or extreme wind warning. :)
-(: The warnings occur when the wind speed (AWND) exceeds 110 mph (49.1744 :)
-(: meters per second). (Wind value is in tenth of a meter per second) :)
-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" and xs:decimal(fn:data($r/value)) gt 491.744
-return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q02.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q02.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q02.xq
deleted file mode 100644
index d363fbf..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q02.xq
+++ /dev/null
@@ -1,11 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the annual precipitation (PRCP) for a Seattle using the airport :)
-(: station (US000000002) for 2002. :)
-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/station eq "GHCND:US000000002"
- and $r/dataType eq "PRCP"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
- return $r/value
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q03.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q03.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q03.xq
deleted file mode 100644
index 75a8935..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q03.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the highest recorded temperature (TMAX) in Celsius. :)
-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
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04.xq
deleted file mode 100644
index 61452fb..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04.xq
+++ /dev/null
@@ -1,13 +0,0 @@
-(: XQuery Join Query :)
-(: Find all the weather readings for Washington state for a specific day :)
-(: 2002-2-2. :)
-let $station_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
-for $s in collection($station_collection)/stationCollection/station
-
-let $sensor_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
-for $r in collection($sensor_collection)/dataCollection/data
-
-where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "ST" and fn:upper-case(fn:data($x/displayName)) eq "STATE 1"))
- and xs:dateTime(fn:data($r/date)) eq xs:dateTime("2002-02-02T00:00:00.000")
-return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04_sensors.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04_sensors.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04_sensors.xq
deleted file mode 100644
index 18f5929..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04_sensors.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Join Query :)
-(: Find all the weather readings for Washington state for a specific day :)
-(: 2002-2-2. :)
-let $sensor_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
-for $r in collection($sensor_collection)/dataCollection/data
-
-where xs:dateTime(fn:data($r/date)) eq xs:dateTime("2002-02-02T00:00:00.000")
-return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04_stations.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04_stations.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04_stations.xq
deleted file mode 100644
index d7630f0..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q04_stations.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Join Query :)
-(: Find all the weather readings for Washington state for a specific day :)
-(: 2002-2-2. :)
-let $station_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
-for $s in collection($station_collection)/stationCollection/station
-
-where (some $x in $s/locationLabels satisfies ($x/type eq "ST" and fn:upper-case(fn:data($x/displayName)) eq "STATE 1"))
-return $s
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q05.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q05.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q05.xq
deleted file mode 100644
index df822a1..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q05.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Join Aggregate Query :)
-(: Find the lowest recorded temperature (TMIN) in the United States for :)
-(: 2001. :)
-fn:min(
- let $station_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $s in collection($station_collection)/stationCollection/station
-
- let $sensor_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $r in collection($sensor_collection)/dataCollection/data
-
- where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "CNTRY" and $x/id eq "FIPS:US"))
- and $r/dataType eq "TMIN"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2001
- return $r/value
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q06.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q06.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q06.xq
deleted file mode 100644
index ed9bdb0..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q06.xq
+++ /dev/null
@@ -1,13 +0,0 @@
-(: XQuery Join Query :)
-(: Find the highest recorded temperature (TMAX) for each station for each :)
-(: day over the year 2002. :)
-let $station_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
-for $s in collection($station_collection)/stationCollection/station
-
-let $sensor_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
-for $r in collection($sensor_collection)/dataCollection/data
-
-where $s/id eq $r/station
- and $r/dataType eq "TMAX"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
-return ($s/displayName, $r/date, $r/value)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q07.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q07.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q07.xq
deleted file mode 100644
index d0e8c48..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-1/q07.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Self Join Query :)
-(: Self join with all stations finding the difference in min and max :)
-(: temperature and get the average. :)
-fn:avg(
- let $sensor_collection_min := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $r_min in collection($sensor_collection_min)/dataCollection/data
-
- let $sensor_collection_max := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $r_max in collection($sensor_collection_max)/dataCollection/data
-
- where $r_min/station eq $r_max/station
- and $r_min/date eq $r_max/date
- and $r_min/dataType eq "TMIN"
- and $r_max/dataType eq "TMAX"
- return $r_max/value - $r_min/value
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q00.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q00.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q00.xq
deleted file mode 100644
index 64636bc..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q00.xq
+++ /dev/null
@@ -1,11 +0,0 @@
-(: XQuery Filter Query :)
-(: See historical data for Riverside, CA (AS000000003) station by selecting :)
-(: the weather readings for December 25 over the last 10 years. :)
-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
-let $datetime := xs:dateTime(fn:data($r/date))
-where $r/station eq "GHCND:AS000000003"
- and fn:year-from-dateTime($datetime) ge 2000
- and fn:month-from-dateTime($datetime) eq 3
- and fn:day-from-dateTime($datetime) eq 3
-return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q01.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q01.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q01.xq
deleted file mode 100644
index 4e1edc5..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q01.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Filter Query :)
-(: Find all reading for hurricane force wind warning or extreme wind warning. :)
-(: The warnings occur when the wind speed (AWND) exceeds 110 mph (49.1744 :)
-(: meters per second). (Wind value is in tenth of a meter per second) :)
-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" and xs:decimal(fn:data($r/value)) gt 491.744
-return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q02.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q02.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q02.xq
deleted file mode 100644
index fac6bf0..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q02.xq
+++ /dev/null
@@ -1,11 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the annual precipitation (PRCP) for a Seattle using the airport :)
-(: station (US000000002) for 2002. :)
-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/station eq "GHCND:US000000002"
- and $r/dataType eq "PRCP"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
- return $r/value
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q03.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q03.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q03.xq
deleted file mode 100644
index ce3d0d3..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q03.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the highest recorded temperature (TMAX) in Celsius. :)
-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
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q04.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q04.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q04.xq
deleted file mode 100644
index 5d6d1d1..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q04.xq
+++ /dev/null
@@ -1,13 +0,0 @@
-(: XQuery Join Query :)
-(: Find all the weather readings for Washington state for a specific day :)
-(: 2002-2-2. :)
-let $station_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 $s in collection($station_collection)/stationCollection/station
-
-let $sensor_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($sensor_collection)/dataCollection/data
-
-where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "ST" and fn:upper-case(fn:data($x/displayName)) eq "STATE 1"))
- and xs:dateTime(fn:data($r/date)) eq xs:dateTime("2002-02-02T00:00:00.000")
-return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q05.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q05.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q05.xq
deleted file mode 100644
index 15b98c1..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q05.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Join Aggregate Query :)
-(: Find the lowest recorded temperature (TMIN) in the United States for :)
-(: 2001. :)
-fn:min(
- let $station_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 $s in collection($station_collection)/stationCollection/station
-
- let $sensor_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($sensor_collection)/dataCollection/data
-
- where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "CNTRY" and $x/id eq "FIPS:US"))
- and $r/dataType eq "TMIN"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2001
- return $r/value
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q06.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q06.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q06.xq
deleted file mode 100644
index df17713..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q06.xq
+++ /dev/null
@@ -1,13 +0,0 @@
-(: XQuery Join Query :)
-(: Find the highest recorded temperature (TMAX) for each station for each :)
-(: day over the year 2002. :)
-let $station_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 $s in collection($station_collection)/stationCollection/station
-
-let $sensor_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($sensor_collection)/dataCollection/data
-
-where $s/id eq $r/station
- and $r/dataType eq "TMAX"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
-return ($s/displayName, $r/date, $r/value)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q07.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q07.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q07.xq
deleted file mode 100644
index 2debae0..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-2/q07.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Self Join Query :)
-(: Self join with all stations finding the difference in min and max :)
-(: temperature and get the average. :)
-fn:avg(
- let $sensor_collection_min := "/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_min in collection($sensor_collection_min)/dataCollection/data
-
- let $sensor_collection_max := "/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_max in collection($sensor_collection_max)/dataCollection/data
-
- where $r_min/station eq $r_max/station
- and $r_min/date eq $r_max/date
- and $r_min/dataType eq "TMIN"
- and $r_max/dataType eq "TMAX"
- return $r_max/value - $r_min/value
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q00.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q00.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q00.xq
deleted file mode 100644
index e130e2a..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q00.xq
+++ /dev/null
@@ -1,11 +0,0 @@
-(: XQuery Filter Query :)
-(: See historical data for Riverside, CA (AS000000003) station by selecting :)
-(: the weather readings for December 25 over the last 10 years. :)
-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
-let $datetime := xs:dateTime(fn:data($r/date))
-where $r/station eq "GHCND:AS000000003"
- and fn:year-from-dateTime($datetime) ge 2000
- and fn:month-from-dateTime($datetime) eq 3
- and fn:day-from-dateTime($datetime) eq 3
-return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q01.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q01.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q01.xq
deleted file mode 100644
index bad94e4..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q01.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Filter Query :)
-(: Find all reading for hurricane force wind warning or extreme wind warning. :)
-(: The warnings occur when the wind speed (AWND) exceeds 110 mph (49.1744 :)
-(: meters per second). (Wind value is in tenth of a meter per second) :)
-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" and xs:decimal(fn:data($r/value)) gt 491.744
-return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q02.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q02.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q02.xq
deleted file mode 100644
index f4c2722..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q02.xq
+++ /dev/null
@@ -1,11 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the annual precipitation (PRCP) for a Seattle using the airport :)
-(: station (US000000002) for 2002. :)
-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/station eq "GHCND:US000000002"
- and $r/dataType eq "PRCP"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
- return $r/value
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q03.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q03.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q03.xq
deleted file mode 100644
index 7199c97..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q03.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the highest recorded temperature (TMAX) in Celsius. :)
-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
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q04.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q04.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q04.xq
deleted file mode 100644
index cdf85dd..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q04.xq
+++ /dev/null
@@ -1,13 +0,0 @@
-(: XQuery Join Query :)
-(: Find all the weather readings for Washington state for a specific day :)
-(: 2002-2-2. :)
-let $station_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 $s in collection($station_collection)/stationCollection/station
-
-let $sensor_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($sensor_collection)/dataCollection/data
-
-where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "ST" and fn:upper-case(fn:data($x/displayName)) eq "STATE 1"))
- and xs:dateTime(fn:data($r/date)) eq xs:dateTime("2002-02-02T00:00:00.000")
-return $r
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q05.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q05.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q05.xq
deleted file mode 100644
index 5036305..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q05.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Join Aggregate Query :)
-(: Find the lowest recorded temperature (TMIN) in the United States for :)
-(: 2001. :)
-fn:min(
- let $station_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 $s in collection($station_collection)/stationCollection/station
-
- let $sensor_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($sensor_collection)/dataCollection/data
-
- where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "CNTRY" and $x/id eq "FIPS:US"))
- and $r/dataType eq "TMIN"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2001
- return $r/value
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q06.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q06.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q06.xq
deleted file mode 100644
index 51c474d..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q06.xq
+++ /dev/null
@@ -1,13 +0,0 @@
-(: XQuery Join Query :)
-(: Find the highest recorded temperature (TMAX) for each station for each :)
-(: day over the year 2002. :)
-let $station_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 $s in collection($station_collection)/stationCollection/station
-
-let $sensor_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($sensor_collection)/dataCollection/data
-
-where $s/id eq $r/station
- and $r/dataType eq "TMAX"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
-return ($s/displayName, $r/date, $r/value)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q07.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q07.xq b/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q07.xq
deleted file mode 100644
index a508e52..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/Ghcnd/Partition-4/q07.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Self Join Query :)
-(: Self join with all stations finding the difference in min and max :)
-(: temperature and get the average. :)
-fn:avg(
- let $sensor_collection_min := "/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_min in collection($sensor_collection_min)/dataCollection/data
-
- let $sensor_collection_max := "/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_max in collection($sensor_collection_max)/dataCollection/data
-
- where $r_min/station eq $r_max/station
- and $r_min/date eq $r_max/date
- and $r_min/dataType eq "TMIN"
- and $r_max/dataType eq "TMAX"
- return $r_max/value - $r_min/value
-) div 10
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q02_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q02_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q02_count.xq
deleted file mode 100644
index 73e8aea..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q02_count.xq
+++ /dev/null
@@ -1,11 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the annual precipitation (PRCP) for a Seattle using the airport :)
-(: station (US000000002) for 2002. :)
-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/station eq "GHCND:US000000002"
- and $r/dataType eq "PRCP"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
- return $r/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q03_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q03_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q03_count.xq
deleted file mode 100644
index 0d327d1..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q03_count.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the highest recorded temperature (TMAX) in Celsius. :)
-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 "TMAX"
- return $r/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q05_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q05_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q05_count.xq
deleted file mode 100644
index 9f2ac93..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q05_count.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Join Aggregate Query :)
-(: Find the lowest recorded temperature (TMIN) in the United States for :)
-(: 2001. :)
-fn:count(
- let $station_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $s in collection($station_collection)/stationCollection/station
-
- let $sensor_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $r in collection($sensor_collection)/dataCollection/data
-
- where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "CNTRY" and $x/id eq "FIPS:US"))
- and $r/dataType eq "TMIN"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2001
- return $r/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q07_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q07_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q07_count.xq
deleted file mode 100644
index 917b7c6..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-1/q07_count.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Self Join Query :)
-(: Self join with all stations finding the difference in min and max :)
-(: temperature and get the average. :)
-fn:count(
- let $sensor_collection_min := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $r_min in collection($sensor_collection_min)/dataCollection/data
-
- let $sensor_collection_max := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $r_max in collection($sensor_collection_max)/dataCollection/data
-
- where $r_min/station eq $r_max/station
- and $r_min/date eq $r_max/date
- and $r_min/dataType eq "TMIN"
- and $r_max/dataType eq "TMAX"
- return $r_max/value - $r_min/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q02_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q02_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q02_count.xq
deleted file mode 100644
index 52e7790..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q02_count.xq
+++ /dev/null
@@ -1,11 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the annual precipitation (PRCP) for a Seattle using the airport :)
-(: station (US000000002) for 2002. :)
-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/station eq "GHCND:US000000002"
- and $r/dataType eq "PRCP"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
- return $r/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q03_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q03_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q03_count.xq
deleted file mode 100644
index 619c6d1..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q03_count.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the highest recorded temperature (TMAX) in Celsius. :)
-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 "TMAX"
- return $r/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q05_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q05_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q05_count.xq
deleted file mode 100644
index c32bcd1..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q05_count.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Join Aggregate Query :)
-(: Find the lowest recorded temperature (TMIN) in the United States for :)
-(: 2001. :)
-fn:count(
- let $station_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 $s in collection($station_collection)/stationCollection/station
-
- let $sensor_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($sensor_collection)/dataCollection/data
-
- where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "CNTRY" and $x/id eq "FIPS:US"))
- and $r/dataType eq "TMIN"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2001
- return $r/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q07_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q07_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q07_count.xq
deleted file mode 100644
index fd3431f..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-2/q07_count.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Self Join Query :)
-(: Self join with all stations finding the difference in min and max :)
-(: temperature and get the average. :)
-fn:count(
- let $sensor_collection_min := "/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_min in collection($sensor_collection_min)/dataCollection/data
-
- let $sensor_collection_max := "/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_max in collection($sensor_collection_max)/dataCollection/data
-
- where $r_min/station eq $r_max/station
- and $r_min/date eq $r_max/date
- and $r_min/dataType eq "TMIN"
- and $r_max/dataType eq "TMAX"
- return $r_max/value - $r_min/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q02_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q02_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q02_count.xq
deleted file mode 100644
index 2940380..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q02_count.xq
+++ /dev/null
@@ -1,11 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the annual precipitation (PRCP) for a Seattle using the airport :)
-(: station (US000000002) for 2002. :)
-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/station eq "GHCND:US000000002"
- and $r/dataType eq "PRCP"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
- return $r/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q03_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q03_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q03_count.xq
deleted file mode 100644
index eb6ff10..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q03_count.xq
+++ /dev/null
@@ -1,8 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the highest recorded temperature (TMAX) in Celsius. :)
-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 "TMAX"
- return $r/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q05_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q05_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q05_count.xq
deleted file mode 100644
index 768e35d..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q05_count.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Join Aggregate Query :)
-(: Find the lowest recorded temperature (TMIN) in the United States for :)
-(: 2001. :)
-fn:count(
- let $station_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 $s in collection($station_collection)/stationCollection/station
-
- let $sensor_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($sensor_collection)/dataCollection/data
-
- where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "CNTRY" and $x/id eq "FIPS:US"))
- and $r/dataType eq "TMIN"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2001
- return $r/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q07_count.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q07_count.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q07_count.xq
deleted file mode 100644
index 8ea026b..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndCount/Partition-4/q07_count.xq
+++ /dev/null
@@ -1,16 +0,0 @@
-(: XQuery Self Join Query :)
-(: Self join with all stations finding the difference in min and max :)
-(: temperature and get the average. :)
-fn:count(
- let $sensor_collection_min := "/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_min in collection($sensor_collection_min)/dataCollection/data
-
- let $sensor_collection_max := "/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_max in collection($sensor_collection_max)/dataCollection/data
-
- where $r_min/station eq $r_max/station
- and $r_min/date eq $r_max/date
- and $r_min/dataType eq "TMIN"
- and $r_max/dataType eq "TMAX"
- return $r_max/value - $r_min/value
-)
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q02_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q02_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q02_records.xq
deleted file mode 100644
index 68b87b5..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q02_records.xq
+++ /dev/null
@@ -1,9 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the annual precipitation (PRCP) for a Seattle using the airport :)
-(: station (US000000002) for 2002. :)
- let $collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $r in collection($collection)/dataCollection/data
- where $r/station eq "GHCND:US000000002"
- and $r/dataType eq "PRCP"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
- return $r/value
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q03_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q03_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q03_records.xq
deleted file mode 100644
index 8a22c5e..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q03_records.xq
+++ /dev/null
@@ -1,6 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the highest recorded temperature (TMAX) in Celsius. :)
- 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
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q05_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q05_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q05_records.xq
deleted file mode 100644
index 0cd735d..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q05_records.xq
+++ /dev/null
@@ -1,14 +0,0 @@
-(: XQuery Join Aggregate Query :)
-(: Find the lowest recorded temperature (TMIN) in the United States for :)
-(: 2001. :)
- let $station_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $s in collection($station_collection)/stationCollection/station
-
- let $sensor_collection := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $r in collection($sensor_collection)/dataCollection/data
-
- where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "CNTRY" and $x/id eq "FIPS:US"))
- and $r/dataType eq "TMIN"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2001
- return $r/value
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q07_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q07_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q07_records.xq
deleted file mode 100644
index 793fbba..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-1/q07_records.xq
+++ /dev/null
@@ -1,14 +0,0 @@
-(: XQuery Self Join Query :)
-(: Self join with all stations finding the difference in min and max :)
-(: temperature and get the average. :)
- let $sensor_collection_min := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $r_min in collection($sensor_collection_min)/dataCollection/data
-
- let $sensor_collection_max := "/Users/prestoncarman/Documents/smartsvn/vxquery_git_master/vxquery-xtest/tests/TestSources/ghcnd/"
- for $r_max in collection($sensor_collection_max)/dataCollection/data
-
- where $r_min/station eq $r_max/station
- and $r_min/date eq $r_max/date
- and $r_min/dataType eq "TMIN"
- and $r_max/dataType eq "TMAX"
- return $r_max/value - $r_min/value
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q02_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q02_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q02_records.xq
deleted file mode 100644
index 4b14f55..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q02_records.xq
+++ /dev/null
@@ -1,9 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the annual precipitation (PRCP) for a Seattle using the airport :)
-(: station (US000000002) for 2002. :)
- 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/station eq "GHCND:US000000002"
- and $r/dataType eq "PRCP"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
- return $r/value
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q03_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q03_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q03_records.xq
deleted file mode 100644
index 581644a..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q03_records.xq
+++ /dev/null
@@ -1,6 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the highest recorded temperature (TMAX) in Celsius. :)
- 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
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q05_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q05_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q05_records.xq
deleted file mode 100644
index 83b4683..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q05_records.xq
+++ /dev/null
@@ -1,14 +0,0 @@
-(: XQuery Join Aggregate Query :)
-(: Find the lowest recorded temperature (TMIN) in the United States for :)
-(: 2001. :)
- let $station_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 $s in collection($station_collection)/stationCollection/station
-
- let $sensor_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($sensor_collection)/dataCollection/data
-
- where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "CNTRY" and $x/id eq "FIPS:US"))
- and $r/dataType eq "TMIN"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2001
- return $r/value
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q07_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q07_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q07_records.xq
deleted file mode 100644
index 1948ba0..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-2/q07_records.xq
+++ /dev/null
@@ -1,14 +0,0 @@
-(: XQuery Self Join Query :)
-(: Self join with all stations finding the difference in min and max :)
-(: temperature and get the average. :)
- let $sensor_collection_min := "/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_min in collection($sensor_collection_min)/dataCollection/data
-
- let $sensor_collection_max := "/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_max in collection($sensor_collection_max)/dataCollection/data
-
- where $r_min/station eq $r_max/station
- and $r_min/date eq $r_max/date
- and $r_min/dataType eq "TMIN"
- and $r_max/dataType eq "TMAX"
- return $r_max/value - $r_min/value
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q02_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q02_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q02_records.xq
deleted file mode 100644
index 8fb560b..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q02_records.xq
+++ /dev/null
@@ -1,9 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the annual precipitation (PRCP) for a Seattle using the airport :)
-(: station (US000000002) for 2002. :)
- 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/station eq "GHCND:US000000002"
- and $r/dataType eq "PRCP"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2002
- return $r/value
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q03_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q03_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q03_records.xq
deleted file mode 100644
index 835e3b2..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q03_records.xq
+++ /dev/null
@@ -1,6 +0,0 @@
-(: XQuery Aggregate Query :)
-(: Find the highest recorded temperature (TMAX) in Celsius. :)
- 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
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q05_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q05_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q05_records.xq
deleted file mode 100644
index 664e91b..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q05_records.xq
+++ /dev/null
@@ -1,14 +0,0 @@
-(: XQuery Join Aggregate Query :)
-(: Find the lowest recorded temperature (TMIN) in the United States for :)
-(: 2001. :)
- let $station_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 $s in collection($station_collection)/stationCollection/station
-
- let $sensor_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($sensor_collection)/dataCollection/data
-
- where $s/id eq $r/station
- and (some $x in $s/locationLabels satisfies ($x/type eq "CNTRY" and $x/id eq "FIPS:US"))
- and $r/dataType eq "TMIN"
- and fn:year-from-dateTime(xs:dateTime(fn:data($r/date))) eq 2001
- return $r/value
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q07_records.xq
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q07_records.xq b/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q07_records.xq
deleted file mode 100644
index 6f8c165..0000000
--- a/vxquery-xtest/tests/Queries/XQuery/GhcndRecords/Partition-4/q07_records.xq
+++ /dev/null
@@ -1,14 +0,0 @@
-(: XQuery Self Join Query :)
-(: Self join with all stations finding the difference in min and max :)
-(: temperature and get the average. :)
- let $sensor_collection_min := "/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_min in collection($sensor_collection_min)/dataCollection/data
-
- let $sensor_collection_max := "/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_max in collection($sensor_collection_max)/dataCollection/data
-
- where $r_min/station eq $r_max/station
- and $r_min/date eq $r_max/date
- and $r_min/dataType eq "TMIN"
- and $r_max/dataType eq "TMAX"
- return $r_max/value - $r_min/value
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/sesnors/US000000001_200101_0.xml
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/sesnors/US000000001_200101_0.xml b/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/sesnors/US000000001_200101_0.xml
deleted file mode 100644
index cc2fd33..0000000
--- a/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/sesnors/US000000001_200101_0.xml
+++ /dev/null
@@ -1 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" standalone="yes"?><dataCollection pageCount="1" totalCount="3"><data><date>2001-01-01T00:00:00.000</date><dataType>TMIN</dataType><station>GHCND:US000000001</station><value>11.25</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data><data><date>2001-01-01T00:00:00.000</date><dataType>TMAX</dataType><station>GHCND:US000000001</station><value>31</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data><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></dataCollection>
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/stations/US000000001.xml
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/stations/US000000001.xml b/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/stations/US000000001.xml
deleted file mode 100644
index 213f748..0000000
--- a/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_1/stations/US000000001.xml
+++ /dev/null
@@ -1 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" standalone="yes"?><stationCollection pageSize="100" pageCount="1" totalCount="1"><station><id>GHCND:US000000001</id><displayName>Station 1</displayName><latitude>10.000</latitude><longitude>-10.000</longitude><elevation>1000.0</elevation><locationLabels><type>ST</type><id>FIPS:1</id><displayName>State 1</displayName></locationLabels><locationLabels><type>CNTY</type><id>FIPS:-9999</id><displayName>County 1</displayName></locationLabels><locationLabels><type>CNTRY</type><id>FIPS:US</id><displayName>UNITED STATES</displayName></locationLabels></station></stationCollection>
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/sesnors/US000000002_200202_0.xml
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/sesnors/US000000002_200202_0.xml b/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/sesnors/US000000002_200202_0.xml
deleted file mode 100644
index c095726..0000000
--- a/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/sesnors/US000000002_200202_0.xml
+++ /dev/null
@@ -1 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" standalone="yes"?><dataCollection pageCount="1" totalCount="3"><data><date>2002-02-02T00:00:00.000</date><dataType>TMIN</dataType><station>GHCND:US000000002</station><value>12.5</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data><data><date>2002-02-02T00:00:00.000</date><dataType>TMAX</dataType><station>GHCND:US000000002</station><value>32</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data><data><date>2002-02-02T00:00:00.000</date><dataType>PRCP</dataType><station>GHCND:US000000002</station><value>20</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data></dataCollection>
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/stations/US000000004.xml
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/stations/US000000004.xml b/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/stations/US000000004.xml
deleted file mode 100644
index 3bcec27..0000000
--- a/vxquery-xtest/tests/TestSources/ghcnd/half_1/quarter_2/stations/US000000004.xml
+++ /dev/null
@@ -1 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" standalone="yes"?><stationCollection pageSize="100" pageCount="1" totalCount="1"><station><id>GHCND:US000000004</id><displayName>Station 4</displayName><latitude>40.000</latitude><longitude>-40.000</longitude><elevation>4000.0</elevation><locationLabels><type>ST</type><id>FIPS:1</id><displayName>State 4</displayName></locationLabels><locationLabels><type>CNTY</type><id>FIPS:-9999</id><displayName>County 4</displayName></locationLabels><locationLabels><type>CNTRY</type><id>FIPS:US</id><displayName>UNITED STATES</displayName></locationLabels></station></stationCollection>
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/sesnors/AS000000003_200303_0.xml
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/sesnors/AS000000003_200303_0.xml b/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/sesnors/AS000000003_200303_0.xml
deleted file mode 100644
index 3a540d3..0000000
--- a/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/sesnors/AS000000003_200303_0.xml
+++ /dev/null
@@ -1 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" standalone="yes"?><dataCollection pageCount="1" totalCount="2"><data><date>2003-03-03T00:00:00.000</date><dataType>TMIN</dataType><station>GHCND:AS000000003</station><value>13.75</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data><data><date>2003-03-03T00:00:00.000</date><dataType>TMAX</dataType><station>GHCND:AS000000003</station><value>33</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data></dataCollection>
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/stations/US000000002.xml
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/stations/US000000002.xml b/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/stations/US000000002.xml
deleted file mode 100644
index e9dc6e9..0000000
--- a/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_3/stations/US000000002.xml
+++ /dev/null
@@ -1 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" standalone="yes"?><stationCollection pageSize="100" pageCount="1" totalCount="1"><station><id>GHCND:US000000002</id><displayName>Station 2</displayName><latitude>20.000</latitude><longitude>-20.000</longitude><elevation>2000.0</elevation><locationLabels><type>ST</type><id>FIPS:1</id><displayName>State 1</displayName></locationLabels><locationLabels><type>CNTY</type><id>FIPS:-9999</id><displayName>County 2</displayName></locationLabels><locationLabels><type>CNTRY</type><id>FIPS:US</id><displayName>UNITED STATES</displayName></locationLabels></station></stationCollection>
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/sesnors/US000000004_200404_0.xml
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/sesnors/US000000004_200404_0.xml b/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/sesnors/US000000004_200404_0.xml
deleted file mode 100644
index 2dbe586..0000000
--- a/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/sesnors/US000000004_200404_0.xml
+++ /dev/null
@@ -1 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" standalone="yes"?><dataCollection pageCount="1" totalCount="2"><data><date>2004-04-04T00:00:00.000</date><dataType>PRCP</dataType><station>GHCND:US000000004</station><value>40</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data><data><date>2004-04-04T00:00:00.000</date><dataType>AWND</dataType><station>GHCND:US000000004</station><value>4</value><attributes><attribute></attribute><attribute></attribute><attribute>a</attribute><attribute></attribute></attributes></data></dataCollection>
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-vxquery/blob/16f26a65/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/stations/AS000000003.xml
----------------------------------------------------------------------
diff --git a/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/stations/AS000000003.xml b/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/stations/AS000000003.xml
deleted file mode 100644
index 4919c20..0000000
--- a/vxquery-xtest/tests/TestSources/ghcnd/half_2/quarter_4/stations/AS000000003.xml
+++ /dev/null
@@ -1 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" standalone="yes"?><stationCollection pageSize="100" pageCount="1" totalCount="1"><station><id>GHCND:AS000000003</id><displayName>Station 3</displayName><latitude>-30.000</latitude><longitude>30.000</longitude><locationLabels><type>CNTRY</type><id>FIPS:AS</id><displayName>AUSTRALIA</displayName></locationLabels></station></stationCollection>
\ No newline at end of file