11413733645

Committed 19 Oct 2024 02:20AM UTC coverage: 31.44% (-0.04%) from 31.476%

Build # 11413733645

Build Type

Pull #9771

github

Committed by

Raemon

Commit Message

Merge remote-tracking branch 'origin/jargonBot' into jargonBot

Pull Request Pull Request #9771: JargonBot (admin only)

Run Details

5025 of 42068 branches covered (11.94%)

Branch coverage included in aggregate %.

170 of 434 new or added lines in 37 files covered. (39.17%)

8 existing lines in 6 files now uncovered.

29588 of 68025 relevant lines covered (43.5%)

174.36 hits per line

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

71.43

/packages/lesswrong/server/repos/JargonTermsRepo.ts

import AbstractRepo from "./AbstractRepo";
import JargonTerms from "@/lib/collections/jargonTerms/collection";
import { recordPerfMetrics } from "./perfMetricWrapper";
class JargonTermsRepo extends AbstractRepo<"JargonTerms"> {
  constructor() {
    super(JargonTerms);
  }

  /**
   * Gets the most recent instance of each jargon term used in any post by the author of the given post.
   */
  getAuthorsOtherJargonTerms(userId: string, postId: string) {
    return this.any(`
      SELECT DISTINCT ON (jt.term) jt.*
      FROM "JargonTerms" jt
      JOIN "Posts" p
      ON jt."postId" = p._id
      JOIN "Revisions" jtr
      ON jt.contents_latest = jtr._id
      WHERE p."userId" = $1
      AND jt.approved IS TRUE
      AND jt.deleted IS NOT TRUE
      AND jt."postId" != $2
      ORDER BY jt.term, jtr."editedAt" DESC
    `, [userId, postId]);
  }
}

recordPerfMetrics(JargonTermsRepo);

export default JargonTermsRepo;

1	import AbstractRepo from "./AbstractRepo";	80✔
2	import JargonTerms from "@/lib/collections/jargonTerms/collection";	20✔
3	import { recordPerfMetrics } from "./perfMetricWrapper";	20✔
4	class JargonTermsRepo extends AbstractRepo<"JargonTerms"> {
5	constructor() {
NEW 6	super(JargonTerms);	×
7	}
8
9	/**
10	* Gets the most recent instance of each jargon term used in any post by the author of the given post.
11	*/
12	getAuthorsOtherJargonTerms(userId: string, postId: string) {
NEW 13	return this.any(`	×
14	SELECT DISTINCT ON (jt.term) jt.*
15	FROM "JargonTerms" jt
16	JOIN "Posts" p
17	ON jt."postId" = p._id
18	JOIN "Revisions" jtr
19	ON jt.contents_latest = jtr._id
20	WHERE p."userId" = $1
21	AND jt.approved IS TRUE
22	AND jt.deleted IS NOT TRUE
23	AND jt."postId" != $2
24	ORDER BY jt.term, jtr."editedAt" DESC
25	`, [userId, postId]);
26	}
27	}	20✔
28
29	recordPerfMetrics(JargonTermsRepo);
30
31	export default JargonTermsRepo;	20✔

ForumMagnum / ForumMagnum / 11413733645

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