8922757472

Committed 02 May 2024 11:01AM UTC coverage: 31.872% (-0.05%) from 31.923%

Build # 8922757472

Build Type

Pull #9209

github

Committed by

Will-Howard

Commit Message

fix test

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

Run Details

4731 of 38732 branches covered (12.21%)

Branch coverage included in aggregate %.

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

1 existing line in 1 file now uncovered.

27574 of 62625 relevant lines covered (44.03%)

178.35 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 / 8922757472

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