9001473915

Committed 08 May 2024 12:04PM UTC coverage: 31.955% (+0.03%) from 31.93%

Build # 9001473915

Build Type

Pull #9209

github

Committed by

Will-Howard

Commit Message

Merge branch 'master' of github.com:ForumMagnum/ForumMagnum into wh-unique-client-ids-2024-04

Pull Request Pull Request #9209: Make clientId field in ClientIds non-nullable and unique

Run Details

4774 of 38790 branches covered (12.31%)

Branch coverage included in aggregate %.

18 of 21 new or added lines in 7 files covered. (85.71%)

9 existing lines in 2 files now uncovered.

27640 of 62645 relevant lines covered (44.12%)

177.81 hits per line

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

34.48

/packages/lesswrong/server/scripts/mongoQueryToSQL.ts

import CreateIndexQuery from "../../lib/sql/CreateIndexQuery";
import InsertQuery from "../../lib/sql/InsertQuery";
import SelectQuery from "../../lib/sql/SelectQuery";
import Table from "../../lib/sql/Table";
import UpdateQuery from "../../lib/sql/UpdateQuery";
import { getCollection, Globals } from "../vulcan-lib";

/**
 * Translates a mongo find query to SQL for debugging purposes.  Requires a server running because the query builder uses collections, etc.
 */
Globals.findToSQL = ({ tableName, selector, options }: { tableName: CollectionNameString, selector: AnyBecauseTodo, options?: MongoFindOptions<DbObject> }) => {
  const table = Table.fromCollection(getCollection(tableName));
  const select = new SelectQuery<DbObject>(table, selector, options);
  const { sql, args } = select.compile();
  // eslint-disable-next-line no-console
  console.log({ sql, args });
};

/**
 * Translates a mongo insert query to SQL for debugging purposes.  Requires a server running because the query builder uses collections, etc.
 */
Globals.insertToSQL = ({ tableName, data, options }: { tableName: CollectionNameString, data: DbObject, options?: MongoFindOptions<DbObject> }) => {
  const table = Table.fromCollection(getCollection(tableName));
  const insert = new InsertQuery<DbObject>(table, data, options);
  const { sql, args } = insert.compile();
  // eslint-disable-next-line no-console
  console.log({ sql, args });
};

Globals.rawUpdateOneToSQL = ({ tableName, selector, modifier }: { tableName: CollectionNameString, selector: AnyBecauseTodo, modifier: MongoModifier<DbObject> }) => {
  const table = Table.fromCollection(getCollection(tableName));
  const select = new UpdateQuery<DbObject>(table, selector, modifier);
  const { sql, args } = select.compile();
  // eslint-disable-next-line no-console
  console.log({ sql, args });
};

Globals.ensureIndexToSQL = ({ tableName, indexSpec, options }: { tableName: CollectionNameString, indexSpec: any, options?: any }) => {
  const table = Table.fromCollection(getCollection(tableName));
  const index = table.getIndex(Object.keys(indexSpec), options) ?? table.addIndex(indexSpec, options);
  const query = new CreateIndexQuery(table, index, true);
  const { sql, args } = query.compile();

  // eslint-disable-next-line no-console
  console.log('query', { indexName: index.getName(), sql, args });
};

1	import CreateIndexQuery from "../../lib/sql/CreateIndexQuery";	18✔
2	import InsertQuery from "../../lib/sql/InsertQuery";	18✔
3	import SelectQuery from "../../lib/sql/SelectQuery";	18✔
4	import Table from "../../lib/sql/Table";	18✔
5	import UpdateQuery from "../../lib/sql/UpdateQuery";	18✔
6	import { getCollection, Globals } from "../vulcan-lib";	18✔
7
8	/**
9	* Translates a mongo find query to SQL for debugging purposes. Requires a server running because the query builder uses collections, etc.
10	*/
11	Globals.findToSQL = ({ tableName, selector, options }: { tableName: CollectionNameString, selector: AnyBecauseTodo, options?: MongoFindOptions<DbObject> }) => {	18✔
12	const table = Table.fromCollection(getCollection(tableName));	×
13	const select = new SelectQuery<DbObject>(table, selector, options);	×
14	const { sql, args } = select.compile();	×
15	// eslint-disable-next-line no-console
16	console.log({ sql, args });	×
17	};
18
19	/**
20	* Translates a mongo insert query to SQL for debugging purposes. Requires a server running because the query builder uses collections, etc.
21	*/
22	Globals.insertToSQL = ({ tableName, data, options }: { tableName: CollectionNameString, data: DbObject, options?: MongoFindOptions<DbObject> }) => {	18✔
23	const table = Table.fromCollection(getCollection(tableName));	×
24	const insert = new InsertQuery<DbObject>(table, data, options);	×
25	const { sql, args } = insert.compile();	×
26	// eslint-disable-next-line no-console
27	console.log({ sql, args });	×
28	};
29
30	Globals.rawUpdateOneToSQL = ({ tableName, selector, modifier }: { tableName: CollectionNameString, selector: AnyBecauseTodo, modifier: MongoModifier<DbObject> }) => {	18✔
31	const table = Table.fromCollection(getCollection(tableName));	×
32	const select = new UpdateQuery<DbObject>(table, selector, modifier);	×
33	const { sql, args } = select.compile();	×
34	// eslint-disable-next-line no-console
35	console.log({ sql, args });	×
36	};
37
38	Globals.ensureIndexToSQL = ({ tableName, indexSpec, options }: { tableName: CollectionNameString, indexSpec: any, options?: any }) => {	18✔
39	const table = Table.fromCollection(getCollection(tableName));	×
40	const index = table.getIndex(Object.keys(indexSpec), options) ?? table.addIndex(indexSpec, options);	×
NEW 41	const query = new CreateIndexQuery(table, index, true);	×
42	const { sql, args } = query.compile();	×
43
44	// eslint-disable-next-line no-console
45	console.log('query', { indexName: index.getName(), sql, args });	×
46	};

ForumMagnum / ForumMagnum / 9001473915

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