Method RenderValPrefix

core/internal/dialect/sqlite.go:280–332

(ctx Context, ex *qcode.Exp)

}

func (d *SQLiteDialect) RenderValPrefix(ctx Context, ex *qcode.Exp) bool {
	if ex.Op == qcode.OpHasKey {
		ctx.WriteString(`json_extract(`)
		ctx.ColWithTable(ex.Left.Col.Table, ex.Left.Col.Name)
		ctx.WriteString(`, '$."' || `)
		if ex.Right.ValType == qcode.ValVar {
			ctx.AddParam(Param{Name: ex.Right.Val, Type: "text"})
		} else {
			ctx.WriteString(fmt.Sprintf("'%s'", ex.Right.Val))
		}
		ctx.WriteString(` || '"') IS NOT NULL`)
		return true
	}

	if ex.Op == qcode.OpHasKeyAny || ex.Op == qcode.OpHasKeyAll {
		op := " OR "
		if ex.Op == qcode.OpHasKeyAll {
			op = " AND "
		}
		ctx.WriteString(`(`)
		if ex.Right.ValType == qcode.ValVar {
			// Variable case: use json_each on the variable
			// EXISTS (SELECT 1 FROM json_each($var) WHERE json_extract(col, '$."' || value || '"') IS NOT NULL)
			if ex.Op == qcode.OpHasKeyAll {
				ctx.WriteString(`NOT EXISTS (SELECT 1 FROM json_each(`)
			} else {
				ctx.WriteString(`EXISTS (SELECT 1 FROM json_each(`)
			}
			ctx.AddParam(Param{Name: ex.Right.Val, Type: "json"})
			ctx.WriteString(`) WHERE json_extract(`)
			ctx.ColWithTable(ex.Left.Col.Table, ex.Left.Col.Name)
			ctx.WriteString(`, '$."' || value || '"') IS `)
			if ex.Op == qcode.OpHasKeyAll {
				ctx.WriteString(`NULL)`)
			} else {
				ctx.WriteString(`NOT NULL)`)
			}
		} else {
			// Literal list case
			for i, val := range ex.Right.ListVal {
				if i != 0 {
					ctx.WriteString(op)
				}
				ctx.WriteString(`json_extract(`)
				ctx.ColWithTable(ex.Left.Col.Table, ex.Left.Col.Name)
				ctx.WriteString(`, '$."` + val + `"') IS NOT NULL`)
			}
		}
		ctx.WriteString(`)`)
		return true
	}
	return false
}

func (d *SQLiteDialect) RenderTsQuery(ctx Context, ti sdata.DBTable, ex *qcode.Exp) {
	// SQLite FTS5: For content-backed FTS, we need to query the FTS virtual table