Changeset: e1bddac05bb2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e1bddac05bb2
Added Files:
sql/test/nested/Tests/events.ndjson
sql/test/nested/Tests/events.test.in
Removed Files:
sql/test/nested/Tests/events.json
sql/test/nested/Tests/fileloader.test.in
Modified Files:
sql/test/nested/Tests/All
Branch: nested
Log Message:
add events test
diffs (123 lines):
diff --git a/sql/test/nested/Tests/All b/sql/test/nested/Tests/All
--- a/sql/test/nested/Tests/All
+++ b/sql/test/nested/Tests/All
@@ -1,6 +1,6 @@
simple
basic
-fileloader
+events
webclicks
array
composite
diff --git a/sql/test/nested/Tests/events.json
b/sql/test/nested/Tests/events.json
deleted file mode 100644
--- a/sql/test/nested/Tests/events.json
+++ /dev/null
@@ -1,4 +0,0 @@
-[
- {"id": 1, "type": "click"},
- {"id": 2, "type": "scroll"}
-]
diff --git a/sql/test/nested/Tests/events.ndjson
b/sql/test/nested/Tests/events.ndjson
new file mode 100644
--- /dev/null
+++ b/sql/test/nested/Tests/events.ndjson
@@ -0,0 +1,10 @@
+{"eventid":"485760192-802281786","jodpsid":"599981478","jodpuid":"na","event":"link_click","timestamp":"2023-03-31T12:20:30.372+00:00","screen_height":"960","screen_width":"432","user_agent":"Mozilla/5.0
(Linux; Android 11; moto g(9) plus Build/RPAS31.Q2-59-17-4-5-5; wv)
AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.116 Mobile
Safari/537.36","language":"nl-NL","browser":"Google
Inc.","ga_cid":"","category":"internal clicks","action":"click
button","label":"na","value":0,"location":[{"key":"hostname","value":"loyalty-app.business.com"},{"key":"path","value":"/profile/checkout-prefs/buying-stamps"},{"key":"pageType","value":"profile"},{"key":"pageSubType","value":"checkout-prefs"},{"key":"referrer","value":"http://localhost/"}],"queries":[],"user":[{"key":"avgProfilingAllowed","value":"True"},{"key":"customerId","value":"2f0acf27-162f-41a6-a719-971a1689ee8f"},{"key":"loyaltyNumber","value":"2622304763368"},{"key":"termsAndConditionsAccepted","value":"True"}],"ev
ent_context":[{"key":"clickClasses","value":"bus-icon"},{"key":"clickElement","value":"svg.bus-icon"},{"key":"clickElementDataset","value":"{'v-165e7ee6':
'', 'v-97c001ee': '', 'vA6a076b6':
''}"},{"key":"clickId","value":""},{"key":"isButton","value":"True"},{"key":"hasButtonStyling","value":"True"},{"key":"isClick","value":"True"},{"key":"isLink","value":"False"}],"component":[{"key":"path","value":"[]"}],"ecommerce":{"actionfields":[],"objects":[]},"timestamp_processed":"2023-03-31T12:20:32.199195+00:00","banner":[],"bloomreach":[],"promos":[],"search":[],"filters":[],"message":[],"device":[]}
+{"eventid":"117802203-932001475","jodpsid":"148697209","jodpuid":"na","event":"link_click","timestamp":"2023-03-31T12:34:28.539+00:00","screen_height":"800","screen_width":"360","user_agent":"Mozilla/5.0
(Linux; Android 13; SM-G981B Build/TP1A.220624.014; wv) AppleWebKit/537.36
(KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.116 Mobile
Safari/537.36","language":"en-GB","browser":"Google
Inc.","ga_cid":"","category":"internal clicks","action":"click
button","label":"gratis hak groentenzak 550 gram 440
punten","value":0,"location":[{"key":"hostname","value":"loyalty-app.business.com"},{"key":"path","value":"/promotions/redeem-offers"},{"key":"pageType","value":"promotions"},{"key":"pageSubType","value":"redeem-offers"},{"key":"referrer","value":"http://localhost/"}],"queries":[],"user":[{"key":"avgProfilingAllowed","value":"True"},{"key":"customerId","value":"395166b9-4eb6-42bb-b280-dc179c344f4a"},{"key":"loyaltyNumber","value":"2622321627292"},{"key":"termsAndConditionsAccepted",";
value":"True"}],"event_context":[{"key":"clickClasses","value":"bus-heading|title|h6"},{"key":"clickElement","value":"h4#title.bus-heading.title.h6"},{"key":"clickElementDataset","value":"{'v-03b55890':
'', 'v-0611c6a8': '', 'v-6572041b':
''}"},{"key":"clickId","value":"title"},{"key":"isButton","value":"True"},{"key":"hasButtonStyling","value":"False"},{"key":"isClick","value":"True"},{"key":"isLink","value":"False"}],"component":[{"key":"path","value":"[]"}],"ecommerce":{"actionfields":[],"objects":[]},"timestamp_processed":"2023-03-31T12:34:29.198389+00:00","banner":[],"bloomreach":[],"promos":[],"search":[],"filters":[],"message":[],"device":[]}
+{"eventid":"211367219-800698857","jodpsid":"501479232","jodpuid":"na","event":"link_click","timestamp":"2023-03-31T11:28:12.97+00:00","screen_height":"854","screen_width":"385","user_agent":"Mozilla/5.0
(Linux; Android 12; SM-A125F Build/SP1A.210812.016; wv) AppleWebKit/537.36
(KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.116 Mobile
Safari/537.36","language":"nl-BE","browser":"Google
Inc.","ga_cid":"","category":"internal clicks","action":"click
button","label":"uitleg
overslaan","value":0,"location":[{"key":"hostname","value":"loyalty-app.business.com"},{"key":"path","value":"/onboarding"},{"key":"pageType","value":"onboarding"},{"key":"pageSubType","value":"onboarding"},{"key":"referrer","value":"http://localhost/"}],"queries":[],"user":[],"event_context":[{"key":"clickClasses","value":"bus-button|tertiary|block"},{"key":"clickElement","value":"button.bus-button.tertiary.block"},{"key":"clickElementDataset","value":"{'vA6a076b6':
'', 'v-65263ad0': '', 'label': 'Uitleg overslaa
n', 'testid': 'skip-to-end-button', 'v-5ab90eec':
''}"},{"key":"clickId","value":""},{"key":"isButton","value":"True"},{"key":"hasButtonStyling","value":"True"},{"key":"isClick","value":"True"},{"key":"isLink","value":"False"}],"component":[{"key":"path","value":"[]"}],"ecommerce":{"actionfields":[],"objects":[]},"timestamp_processed":"2023-03-31T11:28:13.649848+00:00","banner":[],"bloomreach":[],"promos":[],"search":[],"filters":[],"message":[],"device":[]}
+{"eventid":"934365354-552142910","jodpsid":"345133643","jodpuid":"na","event":"link_click","timestamp":"2023-03-31T12:46:21.284+00:00","screen_height":"915","screen_width":"412","user_agent":"Mozilla/5.0
(Linux; Android 13; SM-A536B Build/TP1A.220624.014; wv) AppleWebKit/537.36
(KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.58 Mobile
Safari/537.36","language":"nl-NL","browser":"Google
Inc.","ga_cid":"","category":"internal clicks","action":"click
button","label":"sluiten","value":0,"location":[{"key":"hostname","value":"loyalty-app.business.com"},{"key":"path","value":"/digital-stamps"},{"key":"pageType","value":"digital-stamps"},{"key":"pageSubType","value":"digital-stamps"},{"key":"referrer","value":"http://localhost/"}],"queries":[],"user":[{"key":"avgProfilingAllowed","value":"True"},{"key":"customerId","value":"6c4c6935-56fb-4432-8964-16e74aa90069"},{"key":"loyaltyNumber","value":"2622316106849"},{"key":"termsAndConditionsAccepted","value":"True"}],"event_context":[{"key":"c
lickClasses","value":"bus-button|block"},{"key":"clickElement","value":"button.bus-button.block"},{"key":"clickElementDataset","value":"{'vA6a076b6':
'', 'vEc29b9b6': '', 'label': 'Sluiten', 'v-7b5c547c':
''}"},{"key":"clickId","value":""},{"key":"isButton","value":"True"},{"key":"hasButtonStyling","value":"True"},{"key":"isClick","value":"True"},{"key":"isLink","value":"False"}],"component":[{"key":"path","value":"[]"}],"ecommerce":{"actionfields":[],"objects":[]},"timestamp_processed":"2023-03-31T12:46:19.66722+00:00","banner":[],"bloomreach":[],"promos":[],"search":[],"filters":[],"message":[],"device":[]}
+{"eventid":"189473206-822966684","jodpsid":"839983060","jodpuid":"na","event":"link_click","timestamp":"2023-03-31T11:35:10.497+00:00","screen_height":"960","screen_width":"432","user_agent":"Mozilla/5.0
(Linux; Android 12; motorola edge 20 Build/S1RGS32.53-18-22-25; wv)
AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.116 Mobile
Safari/537.36","language":"nl-NL","browser":"Google
Inc.","ga_cid":"","category":"internal clicks","action":"click
button","label":"ik ga
zoeken","value":0,"location":[{"key":"hostname","value":"loyalty-app.business.com"},{"key":"path","value":"/home"},{"key":"pageType","value":"home"},{"key":"pageSubType","value":"home"},{"key":"referrer","value":"http://localhost/"}],"queries":[],"user":[{"key":"avgProfilingAllowed","value":"True"},{"key":"customerId","value":"993c7a54-4579-4994-a6bd-3c4dc85033bc"},{"key":"loyaltyNumber","value":"2622283539770"},{"key":"termsAndConditionsAccepted","value":"True"}],"event_context":[{"key":"clickClasses";
,"value":"bus-button|action|block"},{"key":"clickElement","value":"button.bus-button.action.block"},{"key":"clickElementDataset","value":"{'vA6a076b6':
'', 'v-138f572a': '', 'label': 'Ik ga
zoeken'}"},{"key":"clickId","value":""},{"key":"isButton","value":"True"},{"key":"hasButtonStyling","value":"True"},{"key":"isClick","value":"True"},{"key":"isLink","value":"False"}],"component":[{"key":"path","value":"[]"}],"ecommerce":{"actionfields":[],"objects":[]},"timestamp_processed":"2023-03-31T11:35:11.51864+00:00","banner":[],"bloomreach":[],"promos":[],"search":[],"filters":[],"message":[],"device":[]}
+{"eventid":"399902141-848858337","jodpsid":"766994168","jodpuid":"na","event":"link_click","timestamp":"2023-03-31T11:35:22.554+00:00","screen_height":"854","screen_width":"384","user_agent":"Mozilla/5.0
(Linux; Android 11; BE2029 Build/RKQ1.201217.002; wv) AppleWebKit/537.36
(KHTML, like Gecko) Version/4.0 Chrome/89.0.4389.105 Mobile
Safari/537.36","language":"nl-NL","browser":"Google
Inc.","ga_cid":"","category":"internal clicks","action":"click
button","label":"gratis
boodschappen","value":0,"location":[{"key":"hostname","value":"loyalty-app.business.com"},{"key":"path","value":"/promotions/redeem-offers"},{"key":"pageType","value":"promotions"},{"key":"pageSubType","value":"redeem-offers"},{"key":"referrer","value":"http://localhost/"}],"queries":[],"user":[{"key":"avgProfilingAllowed","value":"True"},{"key":"customerId","value":"a860e141-fb0a-4bb3-afcf-d9d5d1ebe4da"},{"key":"loyaltyNumber","value":"2622346263024"},{"key":"termsAndConditionsAccepted","value":"True"}],"event_cont
ext":[{"key":"clickClasses","value":"jx-tab__button|jx-tab__button--active"},{"key":"clickElement","value":"button.jx-tab__button.jx-tab__button--active"},{"key":"clickElementDataset","value":"{'v-41245453':
'', 'testid':
'tab-button-active'}"},{"key":"clickId","value":""},{"key":"isButton","value":"True"},{"key":"hasButtonStyling","value":"False"},{"key":"isClick","value":"True"},{"key":"isLink","value":"False"}],"component":[{"key":"path","value":"[]"}],"ecommerce":{"actionfields":[],"objects":[]},"timestamp_processed":"2023-03-31T11:35:24.125194+00:00","banner":[],"bloomreach":[],"promos":[],"search":[],"filters":[],"message":[],"device":[]}
+{"eventid":"661423997-425196447","jodpsid":"736286311","jodpuid":"na","event":"link_click","timestamp":"2023-03-31T12:28:38.091+00:00","screen_height":"915","screen_width":"412","user_agent":"Mozilla/5.0
(Linux; Android 13; SM-A526B Build/TP1A.220624.014; wv) AppleWebKit/537.36
(KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.116 Mobile
Safari/537.36","language":"nl-NL","browser":"Google
Inc.","ga_cid":"","category":"internal clicks","action":"click
button","label":"na","value":0,"location":[{"key":"hostname","value":"loyalty-app.business.com"},{"key":"path","value":"/home"},{"key":"pageType","value":"home"},{"key":"pageSubType","value":"home"},{"key":"referrer","value":"http://localhost/"}],"queries":[],"user":[{"key":"avgProfilingAllowed","value":"True"},{"key":"customerId","value":"b2fb4e35-116a-412e-988c-e6b2e924ccb1"},{"key":"loyaltyNumber","value":"2622301475486"},{"key":"termsAndConditionsAccepted","value":"True"}],"event_context":[{"key":"clickClasses","value":"bus-button|c
lose-button|tertiary|circle"},{"key":"clickElement","value":"button.bus-button.close-button.tertiary.circle"},{"key":"clickElementDataset","value":"{'vA6a076b6':
'', 'v-138f572a': '', 'label':
''}"},{"key":"clickId","value":""},{"key":"isButton","value":"True"},{"key":"hasButtonStyling","value":"True"},{"key":"isClick","value":"True"},{"key":"isLink","value":"False"}],"component":[{"key":"path","value":"[]"}],"ecommerce":{"actionfields":[],"objects":[]},"timestamp_processed":"2023-03-31T12:28:38.870154+00:00","banner":[],"bloomreach":[],"promos":[],"search":[],"filters":[],"message":[],"device":[]}
+{"eventid":"945495833-863960878","jodpsid":"126191039","jodpuid":"na","event":"link_click","timestamp":"2023-03-31T11:51:09.027+00:00","screen_height":"800","screen_width":"360","user_agent":"Mozilla/5.0
(Linux; Android 13; SM-A528B Build/TP1A.220624.014; wv) AppleWebKit/537.36
(KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.116 Mobile
Safari/537.36","language":"nl-NL","browser":"Google
Inc.","ga_cid":"","category":"internal clicks","action":"click
button","label":"ik heb al een business
account","value":0,"location":[{"key":"hostname","value":"loyalty-app.business.com"},{"key":"path","value":"/onboarding"},{"key":"pageType","value":"onboarding"},{"key":"pageSubType","value":"onboarding"},{"key":"referrer","value":"http://localhost/"}],"queries":[],"user":[],"event_context":[{"key":"clickClasses","value":"bus-button|mb-4x|secondary|block"},{"key":"clickElement","value":"button.bus-button.mb-4x.secondary.block"},{"key":"clickElementDataset","value":"{'vA6a076b6':
'', 'label': 'Ik h
eb al een business account', 'testid': 'login', 'v-7b5c547c':
''}"},{"key":"clickId","value":""},{"key":"isButton","value":"True"},{"key":"hasButtonStyling","value":"True"},{"key":"isClick","value":"True"},{"key":"isLink","value":"False"}],"component":[{"key":"path","value":"[]"}],"ecommerce":{"actionfields":[],"objects":[]},"timestamp_processed":"2023-03-31T11:51:10.367537+00:00","banner":[],"bloomreach":[],"promos":[],"search":[],"filters":[],"message":[],"device":[]}
+{"eventid":"353798890-170948489","jodpsid":"296455225","jodpuid":"na","event":"link_click","timestamp":"2023-03-31T11:42:54.083+00:00","screen_height":"854","screen_width":"384","user_agent":"Mozilla/5.0
(Linux; Android 13; SM-A536B Build/TP1A.220624.014; wv) AppleWebKit/537.36
(KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.116 Mobile
Safari/537.36","language":"nl-NL","browser":"Google
Inc.","ga_cid":"","category":"internal clicks","action":"click
button","label":"vernieuwen","value":0,"location":[{"key":"hostname","value":"loyalty-app.business.com"},{"key":"path","value":"/home"},{"key":"pageType","value":"home"},{"key":"pageSubType","value":"home"},{"key":"referrer","value":"http://localhost/"}],"queries":[],"user":[{"key":"avgProfilingAllowed","value":"True"},{"key":"customerId","value":"821eba79-c204-4d51-874f-f4c28eb37111"},{"key":"loyaltyNumber","value":"2622310121442"},{"key":"termsAndConditionsAccepted","value":"True"}],"event_context":[{"key":"clickClasses","value":"bus-
button|refresh-home-balance|retry|secondary|compact|disabled"},{"key":"clickElement","value":"button.bus-button.refresh-home-balance.retry.secondary.compact.disabled"},{"key":"clickElementDataset","value":"{'vA6a076b6':
'', 'vCb7866be': '', 'label':
'Vernieuwen'}"},{"key":"clickId","value":""},{"key":"isButton","value":"True"},{"key":"hasButtonStyling","value":"True"},{"key":"isClick","value":"True"},{"key":"isLink","value":"False"}],"component":[{"key":"path","value":"[]"}],"ecommerce":{"actionfields":[],"objects":[]},"timestamp_processed":"2023-03-31T11:42:53.548653+00:00","banner":[],"bloomreach":[],"promos":[],"search":[],"filters":[],"message":[],"device":[]}
+{"eventid":"127285980-850004417","jodpsid":"495681580","jodpuid":"na","event":"link_click","timestamp":"2023-03-31T12:15:32.352+00:00","screen_height":"800","screen_width":"360","user_agent":"Mozilla/5.0
(Linux; Android 13; SM-A528B Build/TP1A.220624.014; wv) AppleWebKit/537.36
(KHTML, like Gecko) Version/4.0 Chrome/111.0.5563.116 Mobile
Safari/537.36","language":"nl-NL","browser":"Google
Inc.","ga_cid":"","category":"internal clicks","action":"click
button","label":"inloggen","value":0,"location":[{"key":"hostname","value":"loyalty-app.business.com"},{"key":"path","value":"/user/login"},{"key":"pageType","value":"user"},{"key":"pageSubType","value":"login"},{"key":"referrer","value":"http://localhost/"}],"queries":[],"user":[],"event_context":[{"key":"clickClasses","value":"bus-button|block"},{"key":"clickElement","value":"button.bus-button.block"},{"key":"clickElementDataset","value":"{'vA6a076b6':
'', 'v-175b769c': '', 'label': 'Inloggen', 'testid':
'login-button'}"},{"key":"clic
kId","value":""},{"key":"isButton","value":"True"},{"key":"hasButtonStyling","value":"True"},{"key":"isClick","value":"True"},{"key":"isLink","value":"False"}],"component":[{"key":"path","value":"[]"}],"ecommerce":{"actionfields":[],"objects":[]},"timestamp_processed":"2023-03-31T12:15:33.708622+00:00","banner":[],"bloomreach":[],"promos":[],"search":[],"filters":[],"message":[],"device":[]}
diff --git a/sql/test/nested/Tests/events.test.in
b/sql/test/nested/Tests/events.test.in
new file mode 100644
--- /dev/null
+++ b/sql/test/nested/Tests/events.test.in
@@ -0,0 +1,55 @@
+statement ok
+CREATE TYPE kv AS (
+ key VARCHAR,
+ value VARCHAR
+)
+
+statement ok
+CREATE TYPE oelement AS (
+ type VARCHAR,
+ id VARCHAR,
+ attributes kv[]
+)
+
+statement ok
+CREATE TYPE ecommerce_type AS (
+ actionfields kv[],
+ objects oelement[]
+)
+
+statement ok
+CREATE TABLE events(
+ eventid VARCHAR,
+ jodpsid VARCHAR,
+ jodpuid VARCHAR,
+ event VARCHAR,
+ "timestamp" TIMESTAMP WITH TIME ZONE,
+ label VARCHAR,
+ value INTEGER,
+ screen_height VARCHAR,
+ screen_width VARCHAR,
+ user_agent VARCHAR,
+ language VARCHAR,
+ browser VARCHAR,
+ ga_cid VARCHAR, -- Google Analytics Client ID
+ category VARCHAR,
+ action VARCHAR,
+ location kv[],
+ "user" kv[], -- Use quotes as 'user' is a reserved keyword
+ event_context kv[],
+ component kv[],
+ queries kv[],
+ ecommerce ecommerce_type,
+ timestamp_processed TIMESTAMP WITH TIME ZONE,
+ banner kv[],
+ bloomreach kv[],
+ promos kv[],
+ search kv[],
+ filters kv[],
+ message kv[],
+ device kv[]
+)
+
+statement ok
+insert into events select * from read_ndjson(r'$TSTSRCDIR/events.ndjson')
+
diff --git a/sql/test/nested/Tests/fileloader.test.in
b/sql/test/nested/Tests/fileloader.test.in
deleted file mode 100644
--- a/sql/test/nested/Tests/fileloader.test.in
+++ /dev/null
@@ -1,23 +0,0 @@
-statement ok
-create type event as (id int, type varchar)
-
-query IT
-select t.id, t.type from ( select cast(t.json as event) as t from (select json
from r'$TSTSRCDIR/events.json') t );
-----
-1
-click
-2
-scroll
-
-query T
-select cast(t.json as event) from (select json from r'$TSTSRCDIR/events.json')
t
-----
-(1, "click")
-(2, "scroll")
-
-#query T
-#select cast(cast(t.json as event) as json) from (select json from
r'$TSTSRCDIR/events.json') t
-#----
-
-statement ok
-drop type event
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
