Function renderInsert

pkg/formatter/render.go:381–437

(i *ast.InsertStatement, opts ast.FormatOptions)

}

func renderInsert(i *ast.InsertStatement, opts ast.FormatOptions) string {
	if i == nil {
		return ""
	}
	f := newNodeFormatter(opts)
	sb := f.sb

	if i.With != nil {
		sb.WriteString(renderWith(i.With, f))
		sb.WriteString(f.clauseSep())
	}

	sb.WriteString(f.kw("INSERT INTO"))
	sb.WriteString(" ")
	sb.WriteString(i.TableName)

	if len(i.Columns) > 0 {
		sb.WriteString(" (")
		sb.WriteString(exprListSQL(i.Columns))
		sb.WriteString(")")
	}

	if i.Query != nil {
		sb.WriteString(f.clauseSep())
		sb.WriteString(FormatStatement(i.Query, opts))
	} else if len(i.Values) > 0 {
		sb.WriteString(f.clauseSep())
		sb.WriteString(f.kw("VALUES"))
		sb.WriteString(" ")
		rows := make([]string, len(i.Values))
		for idx, row := range i.Values {
			vals := make([]string, len(row))
			for j, v := range row {
				vals[j] = exprSQL(v)
			}
			rows[idx] = "(" + strings.Join(vals, ", ") + ")"
		}
		sb.WriteString(strings.Join(rows, ", "))
	}

	if i.OnConflict != nil {
		sb.WriteString(onConflictSQL(i.OnConflict))
	}

	if len(i.Returning) > 0 {
		sb.WriteString(f.clauseSep())
		sb.WriteString(f.kw("RETURNING"))
		sb.WriteString(" ")
		sb.WriteString(exprListSQL(i.Returning))
	}

	if opts.AddSemicolon {
		sb.WriteString(";")
	}

	return f.result()
}