Function handleLabel

shared-dom/src/language/query2sql.ts:649–815

(node: QueryString | QueryRegex, context: Context)

}

function handleLabel(node: QueryString | QueryRegex, context: Context) {
	switch (node.label) {
		case tag: {
			buildTagSearch(node, context)
			break
		}
		case template: {
			if (node.type === 'Regex') {
				context.regexpWithFlags(node, `template.name`)
			} else {
				context.joinTemplateNameFts = true
				context.like(node, 'templateNameFts', 'name')
			}
			break
		}
		case templateId: {
			if (node.type === 'Regex') throwExp()
			const equals = sql.raw(node.negate ? '!=' : '=')
			context.parameterizeSql(sql`note.templateId ${equals} ${node.value}`)
			break
		}
		case cardId: {
			if (node.type === 'Regex') throwExp()
			const equals = sql.raw(node.negate ? '!=' : '=')
			context.parameterizeSql(sql`card.id ${equals} ${node.value}`)
			break
		}
		case noteId: {
			if (node.type === 'Regex') throwExp()
			const equals = sql.raw(node.negate ? '!=' : '=')
			context.parameterizeSql(sql`note.id ${equals} ${node.value}`)
			break
		}
		case setting: {
			if (node.type === 'Regex') {
				context.regexpWithFlags(node, `cardSetting.name`)
			} else {
				context.joinCardSettingNameFts = true
				context.like(node, 'cardSettingNameFts', 'name')
			}
			break
		}
		case settingId: {
			if (node.type === 'Regex') throwExp()
			const equals = sql.raw(node.negate ? '!=' : '=')
			context.parameterizeSql(sql`card.cardSettingId ${equals} ${node.value}`)
			break
		}
		case kind: {
			if (node.type === 'Regex') throwExp()
			context.joinLatestReview = true
			const n = serializeKind(node.value as KindEnum)
			const equals = sql.raw(node.negate ? 'IS NOT' : 'IS')
			context.parameterizeSql(sql`latestReview.kind ${equals} ${n}`)
			break
		}
		case state: {
			if (node.type === 'Regex') throwExp()