Function handleOneComparison

shared-dom/src/language/query2sql.ts:870–893

(
	val: number,
	context: Context,
	table: 'firstReview' | 'review' | 'note' | 'card' | undefined,
	column: 'created' | 'edited' | 'due',
	comparison: Comparison | undefined,
)

}

function handleOneComparison(
	val: number,
	context: Context,
	table: 'firstReview' | 'review' | 'note' | 'card' | undefined,
	column: 'created' | 'edited' | 'due',
	comparison: Comparison | undefined,
) {
	if (comparison == null) throwExp()
	const comp = sql.raw(comparison)
	if (table == null) {
		const col = sql.raw(column)
		context.parameterizeSql(
			sql`(card.${col} ${comp} ${val} OR note.${col} ${comp} ${val})`,
		)
	} else {
		if (column === 'due') {
			context.parameterizeSql(sql`(card.due ${comp} ${val} AND card.due >= 0)`) // negative `due`s are not timestamps, but ordinals when the card is "new"
		} else {
			const tbl = sql.table(table)
			const col = sql.raw(column)
			context.parameterizeSql(sql`${tbl}.${col} ${comp} ${val}`)
		}
	}
}

function getJoinTableName(context: Context) {
	context.joinTableName++