Function assertEqual

app/tests/query2sql.test.ts:49–92

(
	actual: string,
	expected: string,
	joinsOrArgCount: Record<string, string> | number,
	argCount?: number,
)

}

async function assertEqual(
	actual: string,
	expected: string,
	joinsOrArgCount: Record<string, string> | number,
	argCount?: number,
) {
	const i = { i: 0 }
	const expected2 = await format(expected)
	const ky = new Kysely<DB>({
		// @ts-expect-error don't actually use CRDialect
		dialect: new CRDialect(),
	})
	const converted = actualConvert(actual, new Date())
	const compile = converted.sql!.compile(ky)
	const actual2 = unparameterize(i, compile)
	expect(await format(actual2)).toBe(expected2)
	if (typeof joinsOrArgCount === 'number') {
		expect(i.i).toBe(joinsOrArgCount)
	} else {
		async function testJoin(
			list: Array<{
				sql: RawBuilder<SqlBool>
				name: string
			}>,
		) {
			for (const x of list) {
				const compile = x.sql.compile(ky)
				const p = unparameterize(i, compile)
				const expected =
					(joinsOrArgCount as Record<string, string>)[x.name] ??
					throwExp(x.name + " can't be null dude")
				expect(await format(p)).toEqual(await format(expected))
			}
		}
		await testJoin(converted.joinNoteValueFts)
		await testJoin(converted.joinNoteFieldValue)
		await testJoin(converted.joinCardTagFts)
		await testJoin(converted.joinNoteTagFts)
		await testJoin(converted.joinCardTag)
		await testJoin(converted.joinNoteTag)
		expect(argCount).not.toBeUndefined()
		expect(i.i).toBe(argCount)
	}
}

test('empty string is null', () => {
	const sql = actualConvert('', new Date()).sql