quietlight/skraak.app - Change MOPOEZYXTUBS43LXSQLEZSRITOYMV4WT3BCVL2L3LG6UPLW5ABWQC

fix statistics related errors after deleting astro data from selections table

Created by AEj8dahVWy718uSSFPe9VSRJ5qX5G8pC2zvFzJJ8yzBd on July 7, 2025

MOPOEZYXTUBS43LXSQLEZSRITOYMV4WT3BCVL2L3LG6UPLW5ABWQC

Dependencies

[2] XB55XTJNPMST6UAIBIG6V5PHMHRAHGZ5AY7G6VSVW6GGVXTKS2VAC

In channels

main

Change contents

Replacement in src/worker/routes/statistics/queries.ts at line 111 [2.5688]

B:BD[2.8382] → [2.8382:8634]

  // Time filtering conditions for selections
  let selectionTimeFilter = sql``;
  if (timeConditions) {
    selectionTimeFilter = sql`
      AND s.${sql.identifier(timeConditions.selectionTimeColumn)} = ${timeConditions.selectionTimeValue}
    `;
  }

[2.8382]

[2.8634]

  // Time filtering removed from selection table - now only in file table

Replacement in src/worker/routes/statistics/queries.ts at line 172 [2.5688]

B:BD[2.10711] → [2.10711:10963]

  // Time filtering conditions for selections
  let selectionTimeFilter = sql``;
  if (timeConditions) {
    selectionTimeFilter = sql`
      AND s.${sql.identifier(timeConditions.selectionTimeColumn)} = ${timeConditions.selectionTimeValue}
    `;
  }

[2.10711]

[2.10963]

  // Time filtering removed from selection table - now only in file table

Replacement in src/worker/routes/statistics/queries.ts at line 263 [2.5688]

B:BD[2.13920] → [2.13920:14001]

  // Time filtering conditions for selections
  let selectionTimeFilter = sql``;

[2.13920]

[2.14001]

  // Time filtering conditions for files

Replacement in src/worker/routes/statistics/queries.ts at line 310 [2.5688]

B:BD[2.15526] → [2.15526:15607]

  // Time filtering conditions for selections
  let selectionTimeFilter = sql``;

[2.15526]

[2.15607]

  // Time filtering conditions for files