pgxscan

func All ¶

func All[T any](ctx context.Context, exec Queryer, m scan.Mapper[T], sql string, args ...any) ([]T, error)

All scans all rows from the query and returns a slice []T of all rows using a [StdQueryer] this is for use with *sql.DB, *sql.Tx or *sql.Conn or any similar implementations that return *sql.Rows

func Cursor ¶

func Cursor[T any](ctx context.Context, exec Queryer, m scan.Mapper[T], sql string, args ...any) (scan.ICursor[T], error)

Cursor returns a cursor that works similar to *sql.Rows

func Each ¶ added in v0.6.1

func Each[T any](ctx context.Context, exec Queryer, m scan.Mapper[T], query string, args ...any) func(func(T, error) bool)

Each returns a function that can be used to iterate over the rows of a query this function works with range-over-func so it is possible to do

for val, err := range scan.Each(ctx, exec, m, query, args...) {
    if err != nil {
        return err
    }
    // do something with val
}

func One ¶

func One[T any](ctx context.Context, exec Queryer, m scan.Mapper[T], sql string, args ...any) (T, error)

One scans a single row from the query and maps it to T using a [StdQueryer] this is for use with *sql.DB, *sql.Tx or *sql.Conn or any similar implementations that return *sql.Rows