Function EncodeSQLStringWithFlags

pkg/sql/lexbase/encode.go:154–209

EncodeSQLStringWithFlags writes a string literal to buf. All unicode and non-printable characters are escaped. flags controls the output format: if encodeBareString is set, the output string will not be wrapped in quotes if the strings contains no special characters.

(buf *bytes.Buffer, in string, flags EncodeFlags)

// will not be wrapped in quotes if the strings contains no special
// characters.
func EncodeSQLStringWithFlags(buf *bytes.Buffer, in string, flags EncodeFlags) {
	// See http://www.postgresql.org/docs/9.4/static/sql-syntax-lexical.html
	start := 0
	skipEscape := flags.HasFlags(EncSkipEscapeString)
	escapedString := false
	bareStrings := flags.HasFlags(EncBareStrings)
	// Loop through each unicode code point.
	for i, r := range in {
		if i < start {
			continue
		}
		ch := byte(r)
		if r >= minPrintableChar && r <= maxPrintableChar {
			if mustQuoteMap[ch] {
				// We have to quote this string - ignore bareStrings setting
				bareStrings = false
			}
			if !stringencoding.NeedEscape(ch) && ch != '\'' {
				continue
			}
		}

		// If non-ASCII characters are allowed,
		// skip escaping and write the original UTF-8 character.
		if r > maxPrintableChar && skipEscape {
			continue
		}

		if !skipEscape && !escapedString {
			buf.WriteString("e'") // begin e'xxx' string
			escapedString = true
		}
		buf.WriteString(in[start:i])

		ln := utf8.RuneLen(r)
		if ln < 0 {
			start = i + 1
		} else {
			start = i + ln
		}
		// If we skip escaping, we don't write the slash char before the
		// quote char, so we will  write the quote char directly.
		stringencoding.EncodeEscapedChar(buf, in, r, ch, i, '\'', !skipEscape)
	}

	quote := !escapedString && !bareStrings && !skipEscape
	if quote {
		buf.WriteByte('\'') // begin 'xxx' string if nothing was escaped
	}
	if start < len(in) {
		buf.WriteString(in[start:])
	}
	if !skipEscape && (escapedString || quote) {
		buf.WriteByte('\'')
	}
}

// EncodeSQLBytes encodes the SQL byte array in 'in' to buf, to a