alexy4744

import { Constructor } from "@mikro-orm/core";
import { EntityRepository, Knex } from "@mikro-orm/postgresql";

type Node = string;

export interface ClosureTableRepository<Entity> extends EntityRepository<Entity> {
  containsDescendant(parent: Node, descendant: Node): Promise<boolean>;
  findDescendants(parent: Node): Knex.QueryBuilder;
  insertLeafNode(leaf: Node, parent: Node): Promise<void>;
  insertRootNode(root: Node): Promise<void>;

alexy4744

-- Retrieve descendants
-- ====================
-- retrieve descendants of #4
SELECT c.*
  FROM Comments AS c
    JOIN TreePaths AS t ON c.comment_id = t.descendant
 WHERE t.ancestor = 4;


-- Retrieve ancestors

alexy4744

  public static int[] merge(int[] a, int[] b) { 
    int[] c = new int[a.length + b.length];

    int i = 0;
    int j = 0;
    int k = 0;

    while (i < a.length && j < b.length) {
      if (a[i] < b[j]) c[k++] = a[i++];
      else c[k++] = b[j++];

alexy4744

{
  /* EDITOR SETTINGS */
  "editor.detectIndentation": true,
  "editor.fontSize": 18,
  "editor.fontFamily": "Operator Mono Lig",
  "editor.fontLigatures": true,
  "editor.insertSpaces": true,
  "editor.tabSize": 2,
  "editor.tokenColorCustomizations": {
    "textMateRules": [