aboutsummaryrefslogtreecommitdiff
path: root/gsql/gsql.go
diff options
context:
space:
mode:
authorStefan Majewsky <majewsky@gmx.net>2026-11-10 00:32:16 +0100
committerStefan Majewsky <majewsky@gmx.net>2026-11-10 00:32:16 +0100
commitf082ae9a138edd1ee1bcdfc40276013064fbec7e (patch)
treec18e5e63f283912f0989e9e82701ca28ff52c332 /gsql/gsql.go
parent833e477420513a46faa4ebcc1164c50a8288a9ab (diff)
downloadgo-gg-f082ae9a138edd1ee1bcdfc40276013064fbec7e.tar.gz
replace execQuery() with new gsql.Exec() helper
Diffstat (limited to 'gsql/gsql.go')
-rw-r--r--gsql/gsql.go18
1 files changed, 17 insertions, 1 deletions
diff --git a/gsql/gsql.go b/gsql/gsql.go
index e7e2aa3..6e1cc97 100644
--- a/gsql/gsql.go
+++ b/gsql/gsql.go
@@ -8,7 +8,7 @@
// A [Handle] implementation for use with [pgx] is provided in [gg-pgx].
//
// [pgx]: https://github.com/jackc/pgx
-// [gg-pgx]: https://git.xyrillian.de/go-gg-pgx/
+// [gg-pgx]: https://pkg.go.dev/go.xyrillian.de/gg-pgx
package gsql
import (
@@ -16,6 +16,7 @@ import (
"database/sql"
"errors"
+ "go.xyrillian.de/gg/errext"
. "go.xyrillian.de/gg/option"
)
@@ -94,3 +95,18 @@ func NoneIfNoRows[T any](value T, err error) (Option[T], error) {
return None[T](), err
}
}
+
+// Exec is a shorthand for preparing and executing a one-off query that returns an [sql.Result].
+//
+// For shorthands involving [Statement.QueryRow] instead of [Statement.Exec],
+// look at Select() and SelectOne() in [gg/oblast].
+//
+// [gg/oblast]: https://pkg.go.dev/go.xyrillian.de/gg/oblast
+func Exec(ctx context.Context, db Handle, query string, args ...any) (sql.Result, error) {
+ stmt, err := db.GSQLPrepare(ctx, query, false)
+ if err != nil {
+ return nil, err
+ }
+ result, err := stmt.Exec(ctx, args)
+ return result, errext.WithCleanup(err, "Statement.Close", stmt.Close())
+}