kratos-utils/common/sql.go

package common

import "strings"

// SqlStrReplaceSingleQuotes 防止sql注入 单引号
func SqlStrReplaceSingleQuotes(str string) string {
	if strings.Contains(str, "'") {
		str = strings.Replace(str, "'", "\\'", -1)
	}
	return str
}

// SqlStrReplaceDoubleQuotes 防止sql注入 双引号
func SqlStrReplaceDoubleQuotes(str string) string {
	if strings.Contains(str, "\"") {
		str = strings.Replace(str, "\"", "\\\"", -1)
	}
	return str
}