Initial commit

1 files changed, 60 insertions, 0 deletions

diff --git a/dbutils/dbutils.go b/dbutils/dbutils.go
new file mode 100644
index 0000000..4082efd
--- /dev/null
+++ b/dbutils/dbutils.go
@@ -0,0 +1,60 @@
+package dbutils
+
+import (
+	"database/sql"
+	"fmt"
+	"strings"
+)
+
+func TxCommitIfOk(tx *sql.Tx, err error) error {
+	if err != nil {
+		if rollbackErr := tx.Rollback(); rollbackErr != nil {
+			return fmt.Errorf("Failed rolling back transaction with error \"%s\" while handling error %w", rollbackErr, err)
+		}
+
+		return err
+	} else {
+		if err = tx.Commit(); err != nil {
+			return err
+		}
+
+		return nil
+	}
+}
+
+func BuildInIdsSqlAndArgs(field string, ids []int) (string, []interface{}) {
+	if len(ids) == 0 {
+		return "0", []interface{}{}
+	}
+
+	sb := new(strings.Builder)
+	sb.WriteString(field)
+	sb.WriteString(" IN (?")
+
+	for i := 1; i < len(ids); i++ {
+		sb.WriteString(",?")
+	}
+	sb.WriteRune(')')
+
+	args := make([]interface{}, 0, len(ids))
+	for _, id := range ids {
+		args = append(args, interface{}(id))
+	}
+
+	return sb.String(), args
+}
+
+// GetIndexedValues
+// func GetIndexedValues(db *sql.DB, m interface{}, query, args ...interface{}) error {
+// 	mv := reflect.ValueOf(m)
+// 	mt := mv.Type()
+// 	if mt.Kind() != reflect.Map {
+// 		panic("GetIndexValue needs a map as argument m")
+// 	}
+// 	if mt.
+
+// 	rows, err := db.Query(query, args...)
+// 	if err != nil {
+// 		return err
+// 	}
+// }