Golang将变量声明为NULL
发布时间:2020-12-16 19:04:17 所属栏目:大数据 来源:网络整理
导读:根据下面的示例,我需要根据需要获取电子邮件,firstname和dateofbirth等NullStrings和NullTimes,因为我的User结构正在使用它们.如何将变量声明为NULL package entitiesimport ( "database/sql" "github.com/go-sql-driver/mysql" "testing" "time")var ( emai
根据下面的示例,我需要根据需要获取电子邮件,firstname和dateofbirth等NullStrings和NullTimes,因为我的User结构正在使用它们.如何将变量声明为NULL
package entities import ( "database/sql" "github.com/go-sql-driver/mysql" "testing" "time" ) var ( email = sql.NullString("leebrooks0@gmail.com") << 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,} }
sql.NullString不是字符串类型的替代品,你必须使用它.
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) } 您可以使用nsName.Valid检查NullString是否有效. http://golang.org/pkg/database/sql/#NullString (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |