Method formatInsert

cmd/gosqlx/cmd/sql_formatter.go:261–298

formatInsert formats INSERT statements

(stmt *ast.InsertStatement)

// formatInsert formats INSERT statements
func (f *SQLFormatter) formatInsert(stmt *ast.InsertStatement) error {
	f.writeKeyword("INSERT INTO")
	f.builder.WriteString(" " + stmt.TableName)

	if len(stmt.Columns) > 0 {
		f.builder.WriteString(" (")
		f.formatExpressionList(stmt.Columns, ", ")
		f.builder.WriteString(")")
	}

	if len(stmt.Values) > 0 {
		f.writeNewline()
		f.writeKeyword("VALUES")
		for i, row := range stmt.Values {
			if i > 0 {
				f.builder.WriteString(",")
			}
			f.builder.WriteString(" (")
			f.formatExpressionList(row, ", ")
			f.builder.WriteString(")")
		}
	}

	if stmt.Query != nil {
		f.writeNewline()
		if sel, ok := stmt.Query.(*ast.SelectStatement); ok {
			return f.formatSelect(sel)
		}
		// For SetOperation or other statement types, use Format if available
		if fmtable, ok := stmt.Query.(interface {
			Format(ast.FormatOptions) string
		}); ok {
			f.builder.WriteString(fmtable.Format(ast.FormatOptions{}))
		}
	}

	return nil
}

// formatUpdate formats UPDATE statements
func (f *SQLFormatter) formatUpdate(stmt *ast.UpdateStatement) error {