pgxhelpers

pgx-helpers

Various helpers for jackc/pgx PostgreSQL driver for Go.

Versions

• v3 is compatible with pgx 3.x+
• v4 is compatible with pgx 4.x+

Scan row into struct

ScanStruct(r *pgx.Row, dest interface{}) error

The helper that scans a pgx.Row into destination struct passed by reference based on the db fields tags. Implementation is heavily based on the jmoiron/sqlx and utilises its reflection utilities.

package main

import (
	"time"

	"github.com/jackc/pgx"
	pgxHelpers "github.com/vgarvardt/pgx-helpers"
)

type MyEntity struct {
    ID        string    `db:"id"`
    CreatedAt time.Time `db:"created_at"`
    SomeData  string    `db:"some_data"`
}

conn, _ := pgx.Connect(pgx.ConnConfig{...})

var result MyEntity
row := conn.QueryRow("SELECT * FROM my_entity WHERE id = $1", someID)
pgxHelpers.ScanStruct(row, &result)

Scan rows into structs list

package main

import (
	"time"

	"github.com/jackc/pgx"
	pgxHelpers "github.com/vgarvardt/pgx-helpers"
)

type MyEntity struct {
    ID        string    `db:"id"`
    CreatedAt time.Time `db:"created_at"`
    SomeData  string    `db:"some_data"`
}

conn, _ := pgx.Connect(pgx.ConnConfig{...})

var results []*MyEntity
rows, _ := conn.Query("SELECT * FROM my_entity WHERE id = $1", someID)
defer rows.Close()
pgxHelpers.ScanStructs(rows, func() interface{} {
    return new(MyEntity)
}, func(r interface{}) {
    results = append(results, r.(*MyEntity))
})