Hello everyone) I use Laravel, MariaDB. For example, we have a table like this, let's say categories. id name _lft _rgt parent_id path is_folder 1373 Windows 1 10 NULL 1373 1 1374 Glass unit 2 7 1373 1373.1374 1 1375…
I have an array of objects. Each contains a "lv" property, which is an integer >= 0. [ {lv: 0, name: "A"}, {lv: 1, name: "B"}, {lv: 1, name: "C"}, {lv: 2, name: "D"}, {lv: 3, name: "E"}, {lv: 1,…
I'm working on web app using nestJs/postgres/redis. What is the best way (best data structure) to cache following postgres table (hierarchy) to Redis ? space: name another attribute users (one2many) folders: spaceId name users (one2many) files: folderId spaceId name users…
This code converts string into an array tree, but does so with a bug - // I have this input const input = "(1 (2 (4 5 6 (7) 108 (9)) 3))"; // and this function class TreeNode { constructor(value)…
Let's edit a text block in Figma as shown in the image: Figma Plugin API gives the following segments for this text block: const segments = [ { "characters": "Lorem ", "fontWeight": 400, "listOptions": { "type": "NONE" }, "indentation": 0,…
I am trying to build a Tree based on data to be found in a dictionary. I know that this could be achieved using recursion, but I am facing troubles solving this problem. The goal would be to construct a…
Here's my code to set up tree nodes. class TreeNode { constructor(value, left, right, level) { this.value = value; this.left = left; this.right = right; this.level = level } } Here's my code to find the leftmost node at each…
I am new to MySQL and can't find the right answer so im hoping you guys can help me out. I have 3 tables. Applications (columns: appli_num (PK), appli_title) Modules (columns: appli_num (PK), modu_num (PK), modu_title) and modules is a…
I am having Array of object like below [ { "HLT": "Infections NEC", "LLT": "Adrenalitis", "HLGT": "Infections - pathogen unspecified", "PT": "Adrenalitis", "SOC": "Infections and infestations" }, { "HLT": "Adrenal neoplasms", "LLT": "Adrenal cyst", "HLGT": "Adrenal gland disorders", "PT": "Adrenal…
I am trying to build a tree array from a flat array of objects. The category field is structured as an array because it can have n categories let data = [ { category: [ "Kat1" ], otherFields: [ "Document…