diff options
| author | Stefan Majewsky <majewsky@gmx.net> | 2026-11-15 23:25:01 +0100 |
|---|---|---|
| committer | Stefan Majewsky <majewsky@gmx.net> | 2026-11-15 23:25:01 +0100 |
| commit | 0aaaa36644ec4671e20a93fb12939612410c802e (patch) | |
| tree | 81a26f46de45c1320489ed6ae3271b779e6ef680 /oblast/select.go | |
| parent | 1d81d624c83bf250d2ab0d76ba4705d71fce7e88 (diff) | |
| download | go-gg-0aaaa36644ec4671e20a93fb12939612410c802e.tar.gz | |
gsql, oblast: add more small helper functions
Diffstat (limited to 'oblast/select.go')
| -rw-r--r-- | oblast/select.go | 32 |
1 files changed, 26 insertions, 6 deletions
diff --git a/oblast/select.go b/oblast/select.go index a0d10d5..cf21c9f 100644 --- a/oblast/select.go +++ b/oblast/select.go @@ -287,21 +287,41 @@ func startSelectValueQuery(ctx context.Context, db gsql.Handle, query string, ar // or whatever the equivalent for the DB handle in question is. // // If there are no rows in the result set, [sql.ErrNoRows] is returned. -func SelectOne[T any](ctx context.Context, db gsql.Handle, query string, args ...any) (T, error) { +// +// There are also [SelectTwo] or [SelectThree] for ad-hoc queries returning more than one value. +// Beyond two or three return values, it is usually more readable to declare an (ad-hoc) struct type and use either [Store.SelectOne] or [TupleSelectOne]. +func SelectOne[T any](ctx context.Context, db gsql.Handle, query string, args ...any) (result T, err error) { // NOTE: This function body should be as short as possible to reduce the binary size after monomorphization. // Any expression that does not depend on type R should be factored out into a reusable function. - var result T - err := selectOneValue(ctx, db, &result, query, args) - return result, err + err = selectOneRowOfValues(ctx, db, []any{&result}, query, args) + return +} + +// SelectTwo is like [SelectOne], but for queries returning exactly one row containing exactly *two* values. +func SelectTwo[T, U any](ctx context.Context, db gsql.Handle, query string, args ...any) (result1 T, result2 U, err error) { + // NOTE: This function body should be as short as possible to reduce the binary size after monomorphization. + // Any expression that does not depend on type R should be factored out into a reusable function. + + err = selectOneRowOfValues(ctx, db, []any{&result1, &result2}, query, args) + return +} + +// SelectThree is like [SelectOne], but for queries returning exactly one row containing exactly *three* values. +func SelectThree[T, U, V any](ctx context.Context, db gsql.Handle, query string, args ...any) (result1 T, result2 U, result3 V, err error) { + // NOTE: This function body should be as short as possible to reduce the binary size after monomorphization. + // Any expression that does not depend on type R should be factored out into a reusable function. + + err = selectOneRowOfValues(ctx, db, []any{&result1, &result2, &result3}, query, args) + return } -func selectOneValue(ctx context.Context, db gsql.Handle, target any, query string, args []any) error { +func selectOneRowOfValues(ctx context.Context, db gsql.Handle, targets []any, query string, args []any) error { stmt, err := db.GSQLPrepare(ctx, query, false) if err != nil { return err } - err = stmt.QueryRow(ctx, args, []any{target}) + err = stmt.QueryRow(ctx, args, targets) return errext.WithCleanup(err, "Stmt.Close", stmt.Close()) } |
