How to handle null values in gorp Select

Question

I'm trying to get the users from a DB as follow,

var users []User
_, err := dbMap.Select(&users, "select id,username,acctstarttime,acctlastupdatedtime,acctstoptime from accounting order by id")

Here I'm using gorp. When there are null values present, this throws exception

 Select failed sql: Scan error on column index 3: unsupported driver -> Scan pair: <nil> -> *string

How can I solve this issue?. Here I used gorp because of the ease of mapping the output to a struct array.

David Budworth · Accepted Answer · 2015-09-26 14:59:32Z

2

Make whatever acctstarttime maps to a pointer to the type instead of a value of the type.

if the col is null, the pointer will be nil.

that or you can use the sql.NullXXX types, but I usually don't like those since they make everything else weird.

answered Sep 26, 2015 at 14:59

David Budworth

11.7k1 gold badge38 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1