Golang declaring variables as NULLs

Question

As per the example below, I need to get email and firstname and dateofbirth and so on as NullStrings and NullTimes as required, as my User struct is using them. How do I declare variables as NULLs

package entities

import (
    "database/sql"
    "github.com/go-sql-driver/mysql"
    "testing"
    "time"
)

var (
    email          = sql.NullString("[email protected]") << Does not work
    hashedPassword = "password"
    firstName      = "Lee"
    lastName       = "Brooks"
    dateOfBirth    = time.Now
    height         = 1.85
    weight         = 101.3
)

func privacyConcernedUser() *User {
    return &User{
        Email:          email, << These all complain eg: cannot use Email (type string) as type sql.NullString in field value
        HashedPassword: hashedPassword,
        FirstName:      firstName,
        LastName:       lastName,
    }
}

az_ · Accepted Answer · 2014-01-17 02:00:17Z

12

sql.NullString isn't a drop-in replacement for the string type, you have to some work with it.

package main

import "database/sql"
import "fmt"

type User struct {
    Name string
}

func main() {
    var nsName sql.NullString
    if err := nsName.Scan("User's Name"); err != nil {
        panic(err)
    }
    user := &User{Name: nsName.String}
    fmt.Println(user)
}

You can check if the NullString is valid with nsName.Valid.

http://golang.org/pkg/database/sql/#NullString

answered Jan 17, 2014 at 2:00

az_

6461 gold badge6 silver badges13 bronze badges

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

Comments

Lee · Accepted Answer · 2020-04-17 08:52:25Z

7

sql.NullString("[email protected]") << Does not work

Try:

sql.NullString{"[email protected]", true}

see http://golang.org/pkg/database/sql/#NullString

edited Apr 17, 2020 at 8:52

Lee

8,81415 gold badges58 silver badges92 bronze badges

answered Jun 3, 2014 at 16:22

mattes

9,5199 gold badges53 silver badges77 bronze badges

Collectives™ on Stack Overflow

Golang declaring variables as NULLs

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related