Method ConvertValueForField

contrib/drivers/pgsql/pgsql_convert.go:25–48

ConvertValueForField converts value to database acceptable value.

(ctx context.Context, fieldType string, fieldValue any)

// ConvertValueForField converts value to database acceptable value.
func (d *Driver) ConvertValueForField(ctx context.Context, fieldType string, fieldValue any) (any, error) {
	if g.IsNil(fieldValue) {
		return d.Core.ConvertValueForField(ctx, fieldType, fieldValue)
	}

	var fieldValueKind = reflect.TypeOf(fieldValue).Kind()

	if fieldValueKind == reflect.Slice {
		// For bytea type, pass []byte directly without any conversion.
		if _, ok := fieldValue.([]byte); ok && gstr.Contains(fieldType, "bytea") {
			return d.Core.ConvertValueForField(ctx, fieldType, fieldValue)
		}
		// For pgsql, json or jsonb require '[]'
		if !gstr.Contains(fieldType, "json") {
			fieldValue = gstr.ReplaceByMap(gconv.String(fieldValue),
				map[string]string{
					"[": "{",
					"]": "}",
				},
			)
		}
	}
	return d.Core.ConvertValueForField(ctx, fieldType, fieldValue)
}

// CheckLocalTypeForField checks and returns corresponding local golang type for given db type.
// The parameter `fieldType` is in lower case, like: