8897010294

Committed 30 Apr 2024 02:58PM UTC coverage: 31.934% (-0.02%) from 31.949%

Build # 8897010294

Build Type

push

github

Committed by

web-flow

Commit Message

Merge pull request #9203 from ForumMagnum/master

[EA] Deploy remove deleted names from search, forum gate typing indicators, LW stuff

Run Details

4723 of 38589 branches covered (12.24%)

Branch coverage included in aggregate %.

49 of 185 new or added lines in 22 files covered. (26.49%)

7 existing lines in 5 files now uncovered.

27526 of 62396 relevant lines covered (44.12%)

178.99 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

38.89

/packages/lesswrong/server/scripts/reindexDeletedUserContent.ts

import { Globals } from "../vulcan-lib";
import { getSqlClientOrThrow } from "../../lib/sql/sqlClient"
import ElasticClient from "../search/elastic/ElasticClient";
import ElasticExporter from "../search/elastic/ElasticExporter";
import chunk from "lodash/chunk";

type DeletedUserDocument = {
  collectionName: "Posts" | "Comments" | "Sequences",
  documentId: string,
}

const reindexDeletedUserContent = async () => {
  const db = getSqlClientOrThrow();
  const docs = await db.any<DeletedUserDocument>(`
    SELECT 'Posts' "collectionName", p."_id" "documentId"
    FROM "Users" u
    JOIN "Posts" p ON u."_id" = p."userId"
    WHERE u."deleted" IS TRUE
    UNION
    SELECT 'Comments' "collectionName", c."_id" "documentId"
    FROM "Users" u
    JOIN "Comments" c ON u."_id" = c."userId"
    WHERE u."deleted" IS TRUE
    UNION
    SELECT 'Sequences' "collectionName", s."_id" "documentId"
    FROM "Users" u
    JOIN "Sequences" s ON u."_id" = s."userId"
    WHERE u."deleted" IS TRUE
  `);

  const client = new ElasticClient();
  const exporter = new ElasticExporter(client);

  const chunks = chunk(docs, 10);
  for (let i = 0; i < chunks.length; i++) {
    const chunk = chunks[i];
    // eslint-disable-next-line no-console
    console.log(`Reindexing chunk ${i} of ${chunks.length}...`);
    const promises = chunk.map(({collectionName, documentId}) => {
      return exporter.updateDocument(collectionName, documentId);
    });
    await Promise.all(promises);
  }
}

Globals.reindexDeletedUserContent = reindexDeletedUserContent;

1	import { Globals } from "../vulcan-lib";	18✔
2	import { getSqlClientOrThrow } from "../../lib/sql/sqlClient"	18✔
3	import ElasticClient from "../search/elastic/ElasticClient";	18✔
4	import ElasticExporter from "../search/elastic/ElasticExporter";	18✔
5	import chunk from "lodash/chunk";	18✔
6
7	type DeletedUserDocument = {
8	collectionName: "Posts" \| "Comments" \| "Sequences",
9	documentId: string,
10	}
11
12	const reindexDeletedUserContent = async () => {	18✔
NEW 13	const db = getSqlClientOrThrow();	×
NEW 14	const docs = await db.any<DeletedUserDocument>(`	×
15	SELECT 'Posts' "collectionName", p."_id" "documentId"
16	FROM "Users" u
17	JOIN "Posts" p ON u."_id" = p."userId"
18	WHERE u."deleted" IS TRUE
19	UNION
20	SELECT 'Comments' "collectionName", c."_id" "documentId"
21	FROM "Users" u
22	JOIN "Comments" c ON u."_id" = c."userId"
23	WHERE u."deleted" IS TRUE
24	UNION
25	SELECT 'Sequences' "collectionName", s."_id" "documentId"
26	FROM "Users" u
27	JOIN "Sequences" s ON u."_id" = s."userId"
28	WHERE u."deleted" IS TRUE
29	`);
30
NEW 31	const client = new ElasticClient();	×
NEW 32	const exporter = new ElasticExporter(client);	×
33
NEW 34	const chunks = chunk(docs, 10);	×
NEW 35	for (let i = 0; i < chunks.length; i++) {	×
NEW 36	const chunk = chunks[i];	×
37	// eslint-disable-next-line no-console
NEW 38	console.log(`Reindexing chunk ${i} of ${chunks.length}...`);	×
NEW 39	const promises = chunk.map(({collectionName, documentId}) => {	×
NEW 40	return exporter.updateDocument(collectionName, documentId);	×
41	});
NEW 42	await Promise.all(promises);	×
43	}
44	}
45
46	Globals.reindexDeletedUserContent = reindexDeletedUserContent;	18✔

ForumMagnum / ForumMagnum / 8897010294

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous