diff options
| author | Stefan Majewsky <majewsky@gmx.net> | 2026-11-10 00:32:16 +0100 |
|---|---|---|
| committer | Stefan Majewsky <majewsky@gmx.net> | 2026-11-10 00:32:16 +0100 |
| commit | f082ae9a138edd1ee1bcdfc40276013064fbec7e (patch) | |
| tree | c18e5e63f283912f0989e9e82701ca28ff52c332 /gsql/gsql.go | |
| parent | 833e477420513a46faa4ebcc1164c50a8288a9ab (diff) | |
| download | go-gg-f082ae9a138edd1ee1bcdfc40276013064fbec7e.tar.gz | |
replace execQuery() with new gsql.Exec() helper
Diffstat (limited to 'gsql/gsql.go')
| -rw-r--r-- | gsql/gsql.go | 18 |
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()) +} |
