to set singular name for a table in gorm

go go-gorm
Yash Goel picture Yash Goel · Jun 16, 2017 · Viewed 12.9k times · Source 
type user struct {
    ID       int
    Username string `gorm:"size:255"`
    Name     string `gorm:"size:255"`
}

I want to create a table 'user' using this model. But the table name automatically set to 'users'. I know it is gorm's default behaviour. But I want the table name to be 'user'.

Answer

bayrinat picture bayrinat · Jun 16, 2017

Set method TableName for your struct.

func (user) TableName() string {
    return "user"
}

Link: https://gorm.io/docs/models.html#conventions

Related questions

Gorm Golang orm associations

I'm using Go with the GORM ORM. I have the following structs. The relation is simple. One Town has multiple Places and one Place belongs to one Town. type Place struct { ID int Name string Town Town } type Town struct { …

Read More
How to Create or Update a record with GORM?

Gorm has a FirstOrCreate method and a FirstOrInit but how to check afterwards if the record was actually created? I like to create a record if it does not exists and if it exists I want to update some fields.

Read More
reflect.Value.Set using unaddressable value

g.GET("/", func(c echo.Context) error { var users []models.User err := db.Find(users).Error if err != nil { fmt.Println(err) } return c.JSON(http.StatusOK, users) }) this is the code for getting and displaying users from table using …

Read More