-
Type:
Task
-
-
Priority:
Normal
-
Resolution:
Done
-
Component/s:
None
-
-
-
Sprint:
SM1PD-2019 E, SM1PD-2020 A, SM1PD-2020 B, SM1PD-2020 C, SM1PD-2020 D
The spsaitActor 
"experiment" scripting already uses SQL tables to track commands, group exposures, and annotate results.
Convert that to the visit_set, etc. tables in the opDb. Note that these tables may not have been properly discussed with LAM – the changes were made as part of a much larger opDb reorganization. So please review the schema first...
{"report":{"apdex":0,"isInitial":true,"journeyId":"a8e3014a-6b43-45af-bb14-3cb0f8da0bfd","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":13709.300000190735,"redirectCount":0,"resourceLoadedEnd":13405.60000038147,"resourceLoadedStart":850,"resourceTiming":[{"duration":6.600000381469727,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/6857d0cccf13aeaceb2c3277c6bf3892-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":850,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":850,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":856.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":6.699999809265137,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/4ca5cf1725eaa25a0e132608060337f8-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/53bc49863274d15a772d711431705c0c/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,jira.general,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":850.2000007629395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":850.2000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":856.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":4.699999809265137,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/8.0.5/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":854.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":854.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":858.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":4.800000190734863,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/6f741955bf751f5684bb05515ecce171-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":854.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":854.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":859.2000007629395,"responseStart":0,"secureConnectionStart":0},{"duration":5.300000190734863,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/9b2891edfaa54fe476fe450e110e4428-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":854.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":854.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":859.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":12521.60000038147,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/71200f8ce5613e097dcbc84ab48f0df3-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":854.8000001907349,"connectEnd":854.8000001907349,"connectStart":854.8000001907349,"domainLookupEnd":854.8000001907349,"domainLookupStart":854.8000001907349,"fetchStart":854.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1045,"responseEnd":13376.400000572205,"responseStart":6975,"secureConnectionStart":854.8000001907349},{"duration":12550.39999961853,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/47d93b27a0f146b1bd3f1d197220131e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/53bc49863274d15a772d711431705c0c/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,jira.general,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":855.2000007629395,"connectEnd":1246.7000007629395,"connectStart":865.3000001907349,"domainLookupEnd":865.3000001907349,"domainLookupStart":865.3000001907349,"fetchStart":855.2000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":1246.7000007629395,"responseEnd":13405.60000038147,"responseStart":6779.700000762939,"secureConnectionStart":1060.2000007629395},{"duration":5483.300000190735,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/70bb2263e59e7e1f04fbd137c80b895b-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":855.4000005722046,"connectEnd":1259.2000007629395,"connectStart":865.7000007629395,"domainLookupEnd":865.7000007629395,"domainLookupStart":865.7000007629395,"fetchStart":855.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":1259.3000001907349,"responseEnd":6338.700000762939,"responseStart":6338.10000038147,"secureConnectionStart":1061.9000005722046},{"duration":5485.699999809265,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":855.6000003814697,"connectEnd":1269.6000003814697,"connectStart":865.5,"domainLookupEnd":865.5,"domainLookupStart":865.5,"fetchStart":855.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":1269.7000007629395,"responseEnd":6341.300000190735,"responseStart":6340.700000762939,"secureConnectionStart":1066.5},{"duration":5018.800000190735,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":855.8000001907349,"connectEnd":1271.8000001907349,"connectStart":865.8000001907349,"domainLookupEnd":865.8000001907349,"domainLookupStart":865.8000001907349,"fetchStart":855.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1271.9000005722046,"responseEnd":5874.60000038147,"responseStart":5874,"secureConnectionStart":1067},{"duration":5486.599999427795,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/69508eac48a2781e76116ef9aaf97558-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/8.0.5/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":855.9000005722046,"connectEnd":855.9000005722046,"connectStart":855.9000005722046,"domainLookupEnd":855.9000005722046,"domainLookupStart":855.9000005722046,"fetchStart":855.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":5875.200000762939,"responseEnd":6342.5,"responseStart":6341.60000038147,"secureConnectionStart":855.9000005722046},{"duration":11.800000190734863,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/cddefc452def736b814cb1124eb8715f-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/6d15dbc1919cf2c5ddb9c9153d7f06f9/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":856,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":856,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":867.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":5684.10000038147,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/rest/api/1.0/shortcuts/803005/36457a83252da76e0efa441a4fb3275c/shortcuts.js?context=issuenavigation&context=issueaction","startTime":856.3000001907349,"connectEnd":856.3000001907349,"connectStart":856.3000001907349,"domainLookupEnd":856.3000001907349,"domainLookupStart":856.3000001907349,"fetchStart":856.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":6339,"responseEnd":6540.400000572205,"responseStart":6539.700000762939,"secureConnectionStart":856.3000001907349},{"duration":2.299999237060547,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/1e83d960b274809d77d87cc5d08ac9f0-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/4a9288299d147101bf66484f4be48925/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":889.7000007629395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":889.7000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":892,"responseStart":0,"secureConnectionStart":0},{"duration":8403,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/d40a034b2ad49fe248d3d34e35e494ff-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/4a9288299d147101bf66484f4be48925/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":889.9000005722046,"connectEnd":889.9000005722046,"connectStart":889.9000005722046,"domainLookupEnd":889.9000005722046,"domainLookupStart":889.9000005722046,"fetchStart":889.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":7544.900000572205,"responseEnd":9292.900000572205,"responseStart":9292.20000076294,"secureConnectionStart":889.9000005722046},{"duration":9648.900000572205,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":1045.3000001907349,"connectEnd":1045.3000001907349,"connectStart":1045.3000001907349,"domainLookupEnd":1045.3000001907349,"domainLookupStart":1045.3000001907349,"fetchStart":1045.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":9505.20000076294,"responseEnd":10694.20000076294,"responseStart":10693.60000038147,"secureConnectionStart":1045.3000001907349},{"duration":11106.39999961853,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":1045.4000005722046,"connectEnd":1045.4000005722046,"connectStart":1045.4000005722046,"domainLookupEnd":1045.4000005722046,"domainLookupStart":1045.4000005722046,"fetchStart":1045.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":10694.70000076294,"responseEnd":12151.800000190735,"responseStart":12151.10000038147,"secureConnectionStart":1045.4000005722046}],"threshold":1000,"fetchStart":0,"domainLookupStart":13,"domainLookupEnd":224,"connectStart":224,"connectEnd":620,"secureConnectionStart":420,"requestStart":620,"responseStart":845,"responseEnd":1044,"domLoading":848,"domInteractive":13772,"domContentLoadedEventStart":13772,"domContentLoadedEventEnd":13815,"domComplete":14075,"loadEventStart":14075,"loadEventEnd":14077,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"ca2aae12ea3991","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":84,"dbReadsTimeInMs":18,"dbConnsTimeInMs":22,"applicationHash":"1f96e09b3c60279a408a2ae47be3c745f571388b","experiments":[]}}
I think that this design work for us, I would have to add one experiment table which groups visits together.
We would prefer to keep our own sqlite database up to date at least as a first step.
What is unclear to me in this schema is which piece of software handle a given table.