Changeset: cb3fc7507a9b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/cb3fc7507a9b
Modified Files:
sql/test/nested/Tests/webclicks.json
sql/test/nested/Tests/webclicks.test.in
Branch: nested
Log Message:
add complexity to webclicks test
diffs (truncated from 376 to 300 lines):
diff --git a/sql/test/nested/Tests/webclicks.json
b/sql/test/nested/Tests/webclicks.json
--- a/sql/test/nested/Tests/webclicks.json
+++ b/sql/test/nested/Tests/webclicks.json
@@ -1,76 +1,214 @@
-[{
- "eventid": "996257967-103007874",
- "event": "productDetail",
- "timestamp": "2024-11-30 22:13:37.823000",
- "location": {
- "list": [{
- "element": {
- "key": "hash",
- "value": "da39a3ee5e6b4b0d3255bfef95601890afd80709"
- }
- }, {
- "element": {
- "key": "hostname",
- "value": "e13dacd9566ecf8efd4aff212960c02de20aa110"
- }
- }, {
- "element": {
- "key": "pageSubType",
- "value": "d5d4cd07616a542891b7ec2d0257b3a24b69856e"
- }
- }, {
- "element": {
- "key": "pageType",
- "value": "6b5cdf4073b8166e5cc01a2532469d2e356eebfd"
- }
- }, {
- "element": {
- "key": "pathname",
- "value": "0b28998c6a5efc0afb854752b1bba65f37c70230"
- }
- }, {
- "element": {
- "key": "protocol",
- "value": "c3437dbc7c1255d3a21d444d86ebf2e9234c22bd"
- }
- }, {
- "element": {
- "key": "referrer",
- "value": "27bbe94658bf6bd4c431052e2065de0457ec8546"
- }
- }, {
- "element": {
- "key": "search",
- "value": "da39a3ee5e6b4b0d3255bfef95601890afd80709"
- }
- }, {
- "element": {
- "key": "state",
- "value": "da39a3ee5e6b4b0d3255bfef95601890afd80709"
- }
- }, {
- "element": {
- "key": "title",
- "value": "d08339b839a6716a96334736c1c769091a0a8644"
- }
- }]
- },
- "user": {
- "list": [{
- "element": {
- "key": "customerId",
- "value": "d5d4cd07616a542891b7ec2d0257b3a24b69856e"
- }
- }, {
- "element": {
- "key": "customerType",
- "value": "d5d4cd07616a542891b7ec2d0257b3a24b69856e"
- }
- }, {
- "element": {
- "key": "isAuthenticated",
- "value": "7cb6efb98ba5972a9b5090dc2e517fe14d12cb04"
- }
- }]
- }
-}]
+[
+ {
+ "eventid": "996257967-103007874",
+ "sessionid":
"47f07c1399c9c6bd1012861f9c5c958e042732e259b909e077f7e8967b650c75",
+ "userid":
"8359e1f53c300c44ee0e8ba1610f620c589258a8a4752ea089cfc44fee51ff64",
+ "event": "productDetail",
+ "timestamp": "2024-11-30 22:13:37.823000",
+ "user_agent": "Mozilla/5.0 (Linux; Android 10; AGR-W09; HMSCore
6.14.0.321) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.5735.196
HuaweiBrowser/15.0.4.312 Mobile Safari/537.36",
+ "location": {
+ "list": [{
+ "element": {
+ "key": "hash",
+ "value": "da39a3ee5e6b4b0d3255bfef95601890afd80709"
+ }
+ }, {
+ "element": {
+ "key": "hostname",
+ "value": "e13dacd9566ecf8efd4aff212960c02de20aa110"
+ }
+ }, {
+ "element": {
+ "key": "pageSubType",
+ "value": "d5d4cd07616a542891b7ec2d0257b3a24b69856e"
+ }
+ }, {
+ "element": {
+ "key": "pageType",
+ "value": "6b5cdf4073b8166e5cc01a2532469d2e356eebfd"
+ }
+ }, {
+ "element": {
+ "key": "pathname",
+ "value": "0b28998c6a5efc0afb854752b1bba65f37c70230"
+ }
+ }, {
+ "element": {
+ "key": "protocol",
+ "value": "c3437dbc7c1255d3a21d444d86ebf2e9234c22bd"
+ }
+ }, {
+ "element": {
+ "key": "referrer",
+ "value": "27bbe94658bf6bd4c431052e2065de0457ec8546"
+ }
+ }, {
+ "element": {
+ "key": "search",
+ "value": "da39a3ee5e6b4b0d3255bfef95601890afd80709"
+ }
+ }, {
+ "element": {
+ "key": "state",
+ "value": "da39a3ee5e6b4b0d3255bfef95601890afd80709"
+ }
+ }, {
+ "element": {
+ "key": "title",
+ "value": "d08339b839a6716a96334736c1c769091a0a8644"
+ }
+ }]
+ },
+ "user": {
+ "list": [{
+ "element": {
+ "key": "customerId",
+ "value": "d5d4cd07616a542891b7ec2d0257b3a24b69856e"
+ }
+ }, {
+ "element": {
+ "key": "customerType",
+ "value": "d5d4cd07616a542891b7ec2d0257b3a24b69856e"
+ }
+ }, {
+ "element": {
+ "key": "isAuthenticated",
+ "value": "7cb6efb98ba5972a9b5090dc2e517fe14d12cb04"
+ }
+ }]
+ },
+ "ecommerce": {
+ "name": "detail",
+ "actionfields": {
+ "list": [{
+ "element": {
+ "key": null,
+ "value": null
+ }
+ }]
+ },
+ "objects": {
+ "list": [{
+ "element": {
+ "type": "product",
+ "id": null,
+ "attributes": {
+ "list": [{
+ "element": {
+ "key": "brand",
+ "value":
"b8884d21754edbf713af7000a67eac0efd5df8ea"
+ }
+ }]
+ }
+ }
+ }]
+ }
+ }
+ },
+ {
+ "eventid": "996257967-103007874",
+ "sessionid":
"47f07c1399c9c6bd1012861f9c5c958e042732e259b909e077f7e8967b650c75",
+ "userid":
"8359e1f53c300c44ee0e8ba1610f620c589258a8a4752ea089cfc44fee51ff64",
+ "event": "productDetail",
+ "timestamp": "2024-11-30 22:13:37.823000",
+ "user_agent": "Mozilla/5.0 (Linux; Android 10; AGR-W09; HMSCore
6.14.0.321) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.5735.196
HuaweiBrowser/15.0.4.312 Mobile Safari/537.36",
+ "location": {
+ "list": [{
+ "element": {
+ "key": "hash",
+ "value": "da39a3ee5e6b4b0d3255bfef95601890afd80709"
+ }
+ }, {
+ "element": {
+ "key": "hostname",
+ "value": "e13dacd9566ecf8efd4aff212960c02de20aa110"
+ }
+ }, {
+ "element": {
+ "key": "pageSubType",
+ "value": "d5d4cd07616a542891b7ec2d0257b3a24b69856e"
+ }
+ }, {
+ "element": {
+ "key": "pageType",
+ "value": "6b5cdf4073b8166e5cc01a2532469d2e356eebfd"
+ }
+ }, {
+ "element": {
+ "key": "pathname",
+ "value": "0b28998c6a5efc0afb854752b1bba65f37c70230"
+ }
+ }, {
+ "element": {
+ "key": "protocol",
+ "value": "c3437dbc7c1255d3a21d444d86ebf2e9234c22bd"
+ }
+ }, {
+ "element": {
+ "key": "referrer",
+ "value": "27bbe94658bf6bd4c431052e2065de0457ec8546"
+ }
+ }, {
+ "element": {
+ "key": "search",
+ "value": "da39a3ee5e6b4b0d3255bfef95601890afd80709"
+ }
+ }, {
+ "element": {
+ "key": "state",
+ "value": "da39a3ee5e6b4b0d3255bfef95601890afd80709"
+ }
+ }, {
+ "element": {
+ "key": "title",
+ "value": "d08339b839a6716a96334736c1c769091a0a8644"
+ }
+ }]
+ },
+ "user": {
+ "list": [{
+ "element": {
+ "key": "customerId",
+ "value": "d5d4cd07616a542891b7ec2d0257b3a24b69856e"
+ }
+ }, {
+ "element": {
+ "key": "customerType",
+ "value": "d5d4cd07616a542891b7ec2d0257b3a24b69856e"
+ }
+ }, {
+ "element": {
+ "key": "isAuthenticated",
+ "value": "7cb6efb98ba5972a9b5090dc2e517fe14d12cb04"
+ }
+ }]
+ },
+ "ecommerce": {
+ "name": "detail",
+ "actionfields": {
+ "list": [{
+ "element": {
+ "key": null,
+ "value": null
+ }
+ }]
+ },
+ "objects": {
+ "list": [{
+ "element": {
+ "type": "product",
+ "id": null,
+ "attributes": {
+ "list": [{
+ "element": {
+ "key": "brand",
+ "value":
"b8884d21754edbf713af7000a67eac0efd5df8ea"
+ }
+ }]
+ }
+ }
+ }]
+ }
+ }
+ }
+]
diff --git a/sql/test/nested/Tests/webclicks.test.in
b/sql/test/nested/Tests/webclicks.test.in
--- a/sql/test/nested/Tests/webclicks.test.in
+++ b/sql/test/nested/Tests/webclicks.test.in
@@ -11,25 +11,47 @@ statement ok
create type loc as (list elem[])
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
