Database Debug

[ChrisSchinnerl]

The one thing that was nice about Gorm is that its library had a .Debug() somewhere, forget whether it was on the database or the transaction. When working with complex queries I regularly find myself extracting query and args and logging those separately. When I'm really deep in the weeds I use this little util that prints the actual query:

func DebugQuery(query string, args []any) string {
	for _, v := range args {
		index := strings.Index(query, "?")
		if index == -1 {
			continue
		}

		var value string
		if _, ok := v.(string); ok {
			value = fmt.Sprintf("%q", v)
		} else {
			value = fmt.Sprint(v)
		}

		query = string(query[:index]) + value + string(query[index+1:])
	}
	return query
}

It would be nice if we would have a Debug on our MainDatabase or MainDatabaseTx that calls this method and prints the query being executed.