Support for custom primitive types? about gorm HOT 6 CLOSED

func (role Role) Value() (driver.Value, error) {
return string(role), nil
}
func (role *Role) Scan(value interface{}) error {
*role = Role(string(value))
}

from gorm.

@qmn1711 you should provide a correct data type for gorm

type User struct {
	Id    int64
	Email string
	Role  Role `gorm:"type:VARCHAR"`
}

assume as your Role valuer return string

from gorm.

You need to implement a Scanner interface for the new type, then database driver could know how to store the data to database. http://golang.org/pkg/database/sql/#Scanner

from gorm.

Thanks

On Sun, Jan 5, 2014 at 3:57 PM, Jinzhu [email protected] wrote:

Closed #47 https://github.com/jinzhu/gorm/issues/47.

—
Reply to this email directly or view it on GitHubhttps://github.com/jinzhu/gorm/issues/47
.

from gorm.

import database/sql/driver

func (role Role) Value() (driver.Value, error) {
return string(role), nil
}
func (role *Role) Scan(value interface{}) error {
value,_ = value.(string)
*role = Role(string(value))
}

More Complete

from gorm.

It only works in golang, but in postgresql the role column is still defined as a text when I run db.CreateTable(&User{})

Then I tried to define the custom type for role column

type User struct {
	Id    int64
	Email string
	Role  Role `gorm:"type:role"`
}

This time an error will be thrown: pq: type "role" does not exist

Did I implement the wrong way or gorm haven't covered mapping custom type between golang and postgresql?

from gorm.