From f082ae9a138edd1ee1bcdfc40276013064fbec7e Mon Sep 17 00:00:00 2001 From: Stefan Majewsky Date: Tue, 10 Nov 2026 00:32:16 +0100 Subject: replace execQuery() with new gsql.Exec() helper --- gsql/gsql.go | 18 +++++++++++++++++- 1 file changed, 17 insertions(+), 1 deletion(-) (limited to 'gsql/gsql.go') 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()) +} -- cgit v1.3.1