Method SQL

pkg/sql/ast/sql.go:1072–1116

SQL returns the full SQL string for this MERGE statement including the target, source, ON condition, and all WHEN MATCHED/NOT MATCHED clauses.

()

// SQL returns the full SQL string for this MERGE statement including the target,
// source, ON condition, and all WHEN MATCHED/NOT MATCHED clauses.
func (m *MergeStatement) SQL() string {
	if m == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)
	sb.WriteString("MERGE INTO ")
	sb.WriteString(tableRefSQL(&m.TargetTable))
	if m.TargetAlias != "" {
		sb.WriteString(" ")
		sb.WriteString(m.TargetAlias)
	}
	sb.WriteString(" USING ")
	sb.WriteString(tableRefSQL(&m.SourceTable))
	if m.SourceAlias != "" {
		sb.WriteString(" ")
		sb.WriteString(m.SourceAlias)
	}
	sb.WriteString(" ON ")
	sb.WriteString(exprSQL(m.OnCondition))

	for _, when := range m.WhenClauses {
		sb.WriteString(" WHEN ")
		switch when.Type {
		case "MATCHED":
			sb.WriteString("MATCHED")
		case "NOT_MATCHED":
			sb.WriteString("NOT MATCHED")
		case "NOT_MATCHED_BY_SOURCE":
			sb.WriteString("NOT MATCHED BY SOURCE")
		default:
			sb.WriteString(when.Type)
		}
		if when.Condition != nil {
			sb.WriteString(" AND ")
			sb.WriteString(exprSQL(when.Condition))
		}
		sb.WriteString(" THEN ")
		if when.Action != nil {
			sb.WriteString(mergeActionSQL(when.Action))
		}
	}

	return sb.String()
}

// DML types from dml.go