2d:null 2e:["$","title",null,{"children":"Query Combination | Kasi Viswanath | Observable"}] 33:[{"id":"07cd6091a910a70ab37985b9c3bed1b1ef8d06e917a6a013e3846336a4f8c62f6233b5c2c5097206ef5de227d3d08e68df4274c22f0962cd163bc72f009998be","href":"https://static.observableusercontent.com/files/07cd6091a910a70ab37985b9c3bed1b1ef8d06e917a6a013e3846336a4f8c62f6233b5c2c5097206ef5de227d3d08e68df4274c22f0962cd163bc72f009998be","name":"query_combinations_def@1.png","type":"image/png","lastModified":1696997471566.104,"size":110453},{"id":"f4f24a2e4ede566d6ce396e8d3c65756f685e930719fe7a133740b414fa963c8e400792bd37368e99624ded19d01ae6b8c75ec151056fadce7ec55af98460058","href":"https://static.observableusercontent.com/files/f4f24a2e4ede566d6ce396e8d3c65756f685e930719fe7a133740b414fa963c8e400792bd37368e99624ded19d01ae6b8c75ec151056fadce7ec55af98460058","name":"simple_complex_query_comb.png","type":"image/png","lastModified":1696997708073.838,"size":109473},{"id":"932ad12f35abf267a6a24faa90efdac2226c909e38bd5c6be4f00eb5c5d0c4224ed8f39db8049f09e95cbaf969c214905b5885422bd2deac9339d0eb3fdc29ca","href":"https://static.observableusercontent.com/files/932ad12f35abf267a6a24faa90efdac2226c909e38bd5c6be4f00eb5c5d0c4224ed8f39db8049f09e95cbaf969c214905b5885422bd2deac9339d0eb3fdc29ca","name":"simple_complex_query_comb@1.png","type":"image/png","lastModified":1696997809419.536,"size":96326},{"id":"a12f23a0827b82df62a22d7e17a988a9a41265b22786239b75b80c0e6098bcb3e2cac40517bc562d25292dcd7c9e95dc5cda33eee03d5cb26d2609cf3a99578b","href":"https://static.observableusercontent.com/files/a12f23a0827b82df62a22d7e17a988a9a41265b22786239b75b80c0e6098bcb3e2cac40517bc562d25292dcd7c9e95dc5cda33eee03d5cb26d2609cf3a99578b","name":"simple_complex_query_comb@2.png","type":"image/png","lastModified":1696998453031.38,"size":96327}] 31:{"id":"9081f5a5a37d3e53","slug":"query-combination-documentation","title":"Query Combination","thumbnail":"b7c1c0be04c19e97d53c5ee64d4ae57f20b2df7f6497ea4e21c1f5a8f6d5766f","access_level":"public","create_time":"$D2023-10-09T20:54:18.747Z","update_time":"$D2023-12-05T22:11:36.903Z","view_time":null,"first_public_time":"$D2023-10-09T20:54:18.747Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"b760ea566a896d7d","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":"starter_2024"},"version":305,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"fcd94e1c1ca12ae9","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":null}],"members":[{"type":"individual","id":"be0076fec73aa550","login":"john-guerra","name":"John Alexis Guerra Gómez","avatar_url":"https://avatars-next.observableusercontent.com/21638cee44bb0ea70798da725b57111a5d3e2acebcd14524565992f7d1594aed","tier":null,"role":"editor"},{"type":"individual","id":"fcd94e1c1ca12ae9","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"fb28ec1f4856bd04","slug":"benchmark-tools","title":"Benchmark tools","owner":{"id":"b760ea566a896d7d","login":"kasivisu4","name":"Kasi Viswanath"}},"type":"notebook","body":{"title":"Query Combination","cells":[{"id":0,"value":"# Query Combination\n\nA Query Combination refers to a structured sequence of queries and criteria, often represented as a regular expression or similar encoding, used for generating specific sets of sample values used for Query generator","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":45,"value":"simple_complex_query_comb = FileAttachment(\"simple_complex_query_comb@2.png\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"we use cars dataset provided by the observable stdlib to generate the queries","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":62,"value":"Inputs.table(cars)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":298,"value":"new Set(cars.map((d) => d.name))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":247,"value":"

Example1 : '1C-RV'

${viewof query1} The query combination encodes to select a categorical attribute in the dataset with random values selected. As there is only one categorical attribute name in cars dataset, it should select name attribute with different values

${generateTable({ data: selectValues(data1) })}

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":268,"value":"

Example2 : '1C-RV + 1Q-RV'

${viewof query2} The query combination encodes to select a categorical attribute in the dataset with random values selected and also select a quantitative attribute with random range.

${generateTable({ data: selectValues(data2) })}

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":293,"value":"Try changing the query combination based on above defination","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":281,"value":"viewof query = Inputs.text({\n label: \"Query Combination\",\n value: \"1C-RV\",\n submit: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":283,"value":"generateTable({ data: selectValues(data) })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"viewof query1 = Inputs.text({\n label: \"Query Combination\",\n value: \"1C-RV\",\n readonly: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"viewof query2 = Inputs.text({\n label: \"Query Combination\",\n value: \"1C-RV + 1Q-RV\",\n readonly: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":285,"value":"data = queriesGenerator(cars, {\n queryCombinations: query\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"function selectValues(queries) {\n //Select the first value\n let query = Object.values(queries[0])[0];\n let res = {};\n for (let sampleAttr of query.values()) {\n res[sampleAttr[\"attr\"]] = {\n selected: sampleAttr[\"selected\"],\n type: sampleAttr[\"type\"]\n };\n }\n return res;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"data1 = queriesGenerator(cars, {\n queryCombinations: query1\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":230,"value":"data2 = queriesGenerator(cars, {\n queryCombinations: query2\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"function generateTable({\n data = [],\n columns = 6,\n maxLengthforString = 15\n} = {}) {\n let target = html``;\n for (let [attr, details] of Object.entries(data)) {\n let { type, selected } = details;\n let attributeDiv = html`

${\n type === \"C\" ? `${selected.length} values` : `Range`\n } selected | Attribute : ${attr}

`;\n if (type === \"Q\") {\n attributeDiv.appendChild(\n htl.html`

${JSON.stringify(selected)}

`\n );\n } else {\n for (let row of selected) {\n attributeDiv.appendChild(\n html`

${\n row.length > maxLengthforString\n ? row.slice(0, maxLengthforString) + \"...\"\n : row\n }

`\n );\n }\n }\n target.appendChild(attributeDiv);\n target.appendChild(html`

---

`);\n }\n return target;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"import { queriesGenerator } from \"@kasivisu4/queries-generator\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 32:"$31:body"