sql-slog/stmt_args.go at main · akm/sql-slog · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
package sqlslog

import (
	"database/sql/driver"
	"fmt"
	"slices"
	"strings"
)

func cmpNamedValueByOrdinal(a, b driver.NamedValue) int {
	return a.Ordinal - b.Ordinal
}

func formatNamedValues(args []driver.NamedValue) string {
	if len(args) == 0 {
		return "[]"
	}
	if !slices.ContainsFunc(args, func(arg driver.NamedValue) bool { return arg.Name == "" }) {
		return formatNamedValuesWithNames(args)
	}
	if !slices.ContainsFunc(args, func(arg driver.NamedValue) bool { return arg.Name != "" }) {
		return formatNamedValuesWithoutNames(args)
	}
	return formatNamedValuesWithMixedNames(args)
}

func formatNamedValuesWithNames(args []driver.NamedValue) string {
	var b strings.Builder
	b.WriteString("{")
	for i, arg := range args {
		if i > 0 {
			b.WriteString(",")
		}
		fmt.Fprintf(&b, "%s:", arg.Name)
		b.WriteString(formatValue(arg.Value))
	}
	b.WriteString("}")
	return b.String()
}

func formatNamedValuesWithoutNames(args []driver.NamedValue) string {
	if !slices.IsSortedFunc(args, cmpNamedValueByOrdinal) {
		slices.SortFunc(args, cmpNamedValueByOrdinal)
	}
	var b strings.Builder
	b.WriteString("[")
	for i, arg := range args {
		if i > 0 {
			b.WriteString(",")
		}
		b.WriteString(formatValue(arg.Value))
	}
	b.WriteString("]")
	return b.String()
}

func formatNamedValuesWithMixedNames(args []driver.NamedValue) string {
	var b strings.Builder
	b.WriteString("[")
	for i, arg := range args {
		if i > 0 {
			b.WriteString(",")
		}
		fmt.Fprintf(&b, "[%d]%s:", arg.Ordinal, arg.Name)
		b.WriteString(formatValue(arg.Value))
	}
	b.WriteString("]")
	return b.String()
}

func formatValues(values []driver.Value) string {
	if len(values) == 0 {
		return "[]"
	}
	var b strings.Builder
	b.WriteString("[")
	for i, value := range values {
		if i > 0 {
			b.WriteString(",")
		}
		b.WriteString(formatValue(value))
	}
	b.WriteString("]")
	return b.String()
}

func formatValue(v any) string {
	switch v := v.(type) {
	case string:
		return fmt.Sprintf("%q", v)
	case []byte:
		return fmt.Sprintf("%q", v)
	default:
		return fmt.Sprintf("%v", v)
	}
}