Method RenderLinearValues

core/internal/dialect/sqlite.go:1460–1533

(ctx Context, m *qcode.Mutate, renderRoot func())

}

func (d *SQLiteDialect) RenderLinearValues(ctx Context, m *qcode.Mutate, renderRoot func()) {
	// Custom implementation for Linear Execution values that handles variable injection
	ctx.WriteString(`(SELECT `)

	hasPK := false
	first := true
	for _, col := range m.Cols {
		if !first {
			ctx.WriteString(`, `)
		}
		first = false
		if m.Ti.IsPKCol(col.Col.Name) {
			hasPK = true
		}

		if col.Set && col.Value != "" {
			if strings.HasPrefix(col.Value, "$") {
				ctx.WriteString(`(SELECT id FROM _gj_ids WHERE k='`)
				ctx.WriteString(col.Value[1:])
				ctx.WriteString(`')`)
			} else {
				if strings.HasPrefix(col.Value, "sql:") {
					ctx.WriteString(`(`)
					ctx.WriteString(col.Value[4:])
					ctx.WriteString(`)`)
				} else {
					ctx.WriteString("'")
					ctx.WriteString(strings.ReplaceAll(col.Value, "'", "''"))
					ctx.WriteString("'")
				}
			}
		} else {
            if m.Array {
			    ctx.WriteString(`json_extract(value, '$.`)
            } else {
                ctx.WriteString(`json_extract(`)
                renderRoot()
                ctx.WriteString(`, '$.`)
                if len(m.Path) > 0 {
                    ctx.WriteString(strings.Join(m.Path, "."))
                    ctx.WriteString(`.`)
                }
            }
			ctx.WriteString(col.FieldName)
			ctx.WriteString(`')`)
		}
		ctx.WriteString(` AS `)
		ctx.Quote(col.FieldName)
	}
	
	if !hasPK {
		if !first {
			ctx.WriteString(`, `)
		}
		if m.Array {
			renderImplicitPKExtractArray(ctx, m)
		} else {
			renderImplicitPKExtractSingle(ctx, m, renderRoot)