Search code examples
postgresqlgogorp

Go and postgres reinterpreting integer as nil type


I'm trying to get some old code to pass its unit tests. The test that's giving me problems is here:

func Test1(t *testing.T){
 //Code
        testDevice := Device{
                                 ID: 1,
                                 Guid: "C6",
                                 Name: "test device",
                            }  
                         err := Dbmap.Insert(&testDevice)
                         So(err, ShouldBeNil)
 //More code    
}

When I run go test, this returns:

'sql: Scan error on column index 0: converting driver.Value type <nil> ("<nil>") to a int64: invalid syntax'

This is strange because I'm passing it 1, an integer. The device struct is defined here:

type Device struct {
        ID   int64 `db:"id"`
        Guid string
        Name string
}

Here's the schema for the Postgres table it's inserting into:

CREATE TABLE devices(
ID INTEGER,
Guid VARCHAR,
Name VARCHAR
);

I've tried using the sql.NillInt64 type, but that doesn't seem to fix the problem. It feels like somehow, gorp, go, or postgres is interpreting the integer as a nil there. As a final data point, this is all running in various Docker containers, though I don't think this problem is related to Docker. Any insights?


Solution

  • The answer came down to case sensitivity interaction between Go and postgres. Peter's comment essentially answers the question, but anyone reading this might want more explanation. Go only exports objects that are capitalized, while postgres defaults to interpreting column names as lower case. So I needed structs that were uppercase mapped to lowercase columns (unless I wanted to go through quoting every single uppercase column name). To do this, use tags in your struct, essentially telling Go to call it one thing, while postgres calls it another. Your new structs should looks like this:

    type Device struct {
            ID   int64 `db:"id"`
            Guid string `db:"guid"`
            Name string `db:"name"`
    }
    

    Now just keep everything lowercase in postgres and you'll be set!