analytics/loadTest/docker/testRunner/tests/BestPracticeWorkbook/BestPracticeWorkbook.mjs

import { sleep, group } from "k6";
import http from "k6/http";


// Best Practice Workbook
module.exports = function main(token) {
  let response;
  console.log("inside the workbook");
  
  const startDay = Math.floor(Math.random() * 31) + 1;
  const endDay = Math.floor(Math.random() * 31) + 1;
  response = http.post(
    'https://analytics-api-perf.dev.stratanetwork.net/api/v1/data-marts/1307/query',
    `{"rows":[{"name":"Rollup","dataColumnId":575222,"columnAlias":"ROLLUP_AOO3Z","sortDirection":"asc"}],"values":[{"name":"2019_Cases","dataColumnId":585958,"calculationDataColumnIds":[585958],"aliasedIds":["585958"],"columnAlias":"PIVOT_ENCOUNTERRECORDNUMBER_265SK_0","groupValueIndex":0,"groupId":"FS9QQ","valueId":"PZTGR","calculation":"count(distinct [585958])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"K8JW6","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_VRHW7","columnType":"date","values":["2019"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["585958"]}]}]},{"name":"2020_Cases","dataColumnId":585958,"calculationDataColumnIds":[585958],"aliasedIds":["585958"],"columnAlias":"PIVOT_ENCOUNTERRECORDNUMBER_265SK_1","groupValueIndex":1,"groupId":"FS9QQ","valueId":"PZTGR","calculation":"count(distinct [585958])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"K8JW6","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_VRHW7","columnType":"date","values":["2020"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["585958"]}]}]},{"name":"2019_Total Charges","dataColumnId":586855,"calculationDataColumnIds":[586855],"aliasedIds":["586855"],"columnAlias":"PIVOT_TOTALCHARGES_48H1J_0","groupValueIndex":0,"groupId":"FS9QQ","valueId":"D8RZO","calculation":"sum([586855])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"K8JW6","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_VRHW7","columnType":"date","values":["2019"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["586855"]}]}]},{"name":"2020_Total Charges","dataColumnId":586855,"calculationDataColumnIds":[586855],"aliasedIds":["586855"],"columnAlias":"PIVOT_TOTALCHARGES_48H1J_1","groupValueIndex":1,"groupId":"FS9QQ","valueId":"D8RZO","calculation":"sum([586855])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"K8JW6","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_VRHW7","columnType":"date","values":["2020"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["586855"]}]}]},{"name":"2019_Total Costs","dataColumnId":586856,"calculationDataColumnIds":[586856],"aliasedIds":["586856"],"columnAlias":"PIVOT_TOTALCOSTS_LPFBQ_0","groupValueIndex":0,"groupId":"FS9QQ","valueId":"K5GVD","calculation":"sum([586856])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"K8JW6","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_VRHW7","columnType":"date","values":["2019"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["586856"]}]}]},{"name":"2020_Total Costs","dataColumnId":586856,"calculationDataColumnIds":[586856],"aliasedIds":["586856"],"columnAlias":"PIVOT_TOTALCOSTS_LPFBQ_1","groupValueIndex":1,"groupId":"FS9QQ","valueId":"K5GVD","calculation":"sum([586856])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"K8JW6","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_VRHW7","columnType":"date","values":["2020"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["586856"]}]}]}],"warnings":[],"filterGroups":[{"logicalOperator":"and","filters":[{"id":"N1Q3F","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_AHA9P","columnType":"date","values":["01/${startDay}/2018","01/${endDay}/2020"],"conditions":[],"filterType":"calendar","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[539377]}]}],"withTotals":true,"rowLimit":10000}`,
    {
      headers: {
        authorization: `Bearer ${token}`,
        Accept: '*/*',
        "Accept-Encoding": "gzip, deflate, br",
        "Clientappname": 'strata-analytics',
        'content-type': 'application/json',
        'sec-ch-ua': '"Google Chrome";v="113", "Chromium";v="113", "Not-A.Brand";v="24"',
        'sec-ch-ua-mobile': '?0',
        'sec-ch-ua-platform': '"Windows"',
      },
    }
  )
  console.log(response.status, "status code");

  response = http.post(
    'https://analytics-api.dev.stratanetwork.net/api/v1/data-marts/1307/datacolumn/values',
    '{"dataColumnId":539377,"datePart":"year","filter":{"id":"GFETD","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_ZIC1I","columnType":"date","values":["2019","2020"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[]},"rowLimit":31}',
    {
      headers: {
        authorization: `Bearer ${token}`,
        clientappname: 'strata-analytics',
        'content-type': 'application/json',
        'sec-ch-ua': '"Not.A/Brand";v="8", "Chromium";v="114", "Google Chrome";v="114"',
        'sec-ch-ua-mobile': '?0',
        'sec-ch-ua-platform': '"Windows"',
      },
    }
  )

  response = http.post(
    'https://analytics-api.dev.stratanetwork.net/api/v1/data-marts/1307/query',
    // add randomization
    `{"rows":[{"name":"Patient Type","dataColumnId":564543,"columnAlias":"NAME_OXV4H","sortDirection":"asc"}],"values":[{"name":"2019_Total Charges","dataColumnId":586855,"calculationDataColumnIds":[586855],"aliasedIds":["586855"],"columnAlias":"PIVOT_TOTALCHARGES_RK2QL_0","groupValueIndex":0,"groupId":"NNXYG","valueId":"ES7QJ","calculation":"sum([586855])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"GFETD","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_ZIC1I","columnType":"date","values":["2019"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["586855"]}]}]},{"name":"2020_Total Charges","dataColumnId":586855,"calculationDataColumnIds":[586855],"aliasedIds":["586855"],"columnAlias":"PIVOT_TOTALCHARGES_RK2QL_1","groupValueIndex":1,"groupId":"NNXYG","valueId":"ES7QJ","calculation":"sum([586855])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"GFETD","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_ZIC1I","columnType":"date","values":["2020"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["586855"]}]}]},{"name":"2019_Total Costs","dataColumnId":586856,"calculationDataColumnIds":[586856],"aliasedIds":["586856"],"columnAlias":"PIVOT_TOTALCOSTS_NIT3O_0","groupValueIndex":0,"groupId":"NNXYG","valueId":"F6OR3","calculation":"sum([586856])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"GFETD","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_ZIC1I","columnType":"date","values":["2019"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["586856"]}]}]},{"name":"2020_Total Costs","dataColumnId":586856,"calculationDataColumnIds":[586856],"aliasedIds":["586856"],"columnAlias":"PIVOT_TOTALCOSTS_NIT3O_1","groupValueIndex":1,"groupId":"NNXYG","valueId":"F6OR3","calculation":"sum([586856])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"GFETD","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_ZIC1I","columnType":"date","values":["2020"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["586856"]}]}]},{"name":"2019_Total Actual Payments","dataColumnId":586854,"calculationDataColumnIds":[586854],"aliasedIds":["586854"],"columnAlias":"PIVOT_TOTALACTUALPAYMENTS_O29XX_0","groupValueIndex":0,"groupId":"NNXYG","valueId":"YAE7N","calculation":"sum([586854])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"GFETD","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_ZIC1I","columnType":"date","values":["2019"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["586854"]}]}]},{"name":"2020_Total Actual Payments","dataColumnId":586854,"calculationDataColumnIds":[586854],"aliasedIds":["586854"],"columnAlias":"PIVOT_TOTALACTUALPAYMENTS_O29XX_1","groupValueIndex":1,"groupId":"NNXYG","valueId":"YAE7N","calculation":"sum([586854])","filterGroups":[{"logicalOperator":"and","filters":[{"id":"GFETD","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_ZIC1I","columnType":"date","values":["2020"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[],"aliasedDataColumnIds":["586854"]}]}]}],"warnings":[],"filterGroups":[{"logicalOperator":"and","filters":[{"id":"221UQ","dataMartId":1307,"name":"Calendar Date Time","dataColumnName":"Calendar Date Time","dataColumnId":539377,"sqlColumnName":"CALENDARDATETIME_MD2OV","columnType":"date","values":["2019","2020"],"conditions":[],"filterType":"list","listUseNotIn":false,"datePart":"year","dateTimeFrameOffset":0,"dateTimeFrameOffsetDisplay":0,"dateTimeFrameCount":0,"dateTimeFrameCountDisplay":0,"isCustom":false,"relatedDataColumnIds":[539377]}]}],"withTotals":true,"rowLimit":10000}`,
    {
      headers: {
        authorization: `Bearer ${token}`,
        clientappname: 'strata-analytics',
        'content-type': 'application/json',
        'sec-ch-ua': '"Not.A/Brand";v="8", "Chromium";v="114", "Google Chrome";v="114"',
        'sec-ch-ua-mobile': '?0',
        'sec-ch-ua-platform': '"Windows"',
      },
    }
  )
}