/
pgxtra.go
41 lines (34 loc) · 970 Bytes
/
pgxtra.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
package pgxtra
import (
"context"
"github.com/jackc/pgtype"
"github.com/jackc/pgx/v4"
)
const retrieveCustomEnumArrayTypes = `SELECT arrtype.oid, arrtype.typname FROM pg_type arrtype
JOIN pg_type enumtype ON arrtype.typelem = enumtype.oid AND arrtype.typcategory = 'A'
WHERE enumtype.typcategory = 'E'`
func RegisterEnumArrayTypes(conn *pgx.Conn) error {
enumTypes, err := fetchEnumArrayTypesInfo(conn)
if err != nil {
return err
}
for k, v := range enumTypes {
conn.ConnInfo().RegisterDataType(pgtype.DataType{Value: &pgtype.EnumArray{}, Name: v, OID: k})
}
return nil
}
func fetchEnumArrayTypesInfo(conn *pgx.Conn) (map[uint32]string, error) {
rows, err := conn.Query(context.Background(), retrieveCustomEnumArrayTypes)
if err != nil {
return nil, err
}
defer rows.Close()
enumTypes := make(map[uint32]string)
for rows.Next() {
var oid uint32
var name string
rows.Scan(&oid, &name)
enumTypes[oid] = name
}
return enumTypes, nil
}