Describe the feature run the code below package main import ( "gorm.io/driver/sqlite" "gorm.io/gorm" ) type Product struct { id int code string price uint } func main() { db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{}) if err != nil { panic("failed to connect databa...

We have a following struct: Embedding: type Embedding struct { Embedded Name string `gorm:"index"` <...> } Embedded: type Embedded struct { ID uuid.UUID `gorm:"primaryKey;type:uuid"` CreatedAt time.Time `gorm:"index:,sort:desc"` UpdatedAt time.Time } func (e *Embedded) Befo...

GORM Playground Link I will try to prepare a Playground PoC for this issue. Description We are using Gorm with Postgres gorm.io/driver/postgres v1.4.6. On Gorm version gorm.io/gorm v1.24.4, upserts no longer update the primary key of the object if the object was updated instead of created. Gorm stil...

GORM Playground Link go-gorm/playground#561 Description do AutoMigrate twice, it will failed on uniqueIndex column type User struct { gorm.Model Name string `gorm:"uniqueIndex;size:255"` } 2023/02/04 17:37:52 /home/runner/go/pkg/mod/gorm.io/driver/[email protected]/migrator.go:339 ERROR: rela...

Description Specifying a limit of 0 results in all rows being returned instead of none due to https://github.com/go-gorm/gorm/blob/master/clause/limit.go#L36. For example: db.Table().Limit(0).Offset(0).Find(&test)

Your Question Rails has with_lock feature , it mean BEGIN SELECT * FROM {table_name} WHERE {pkey} = {pkey_value} FOR UPDATE // obj values renew by this select ...... COMMIT or ROLLBACK and use gorm maybe like var item Item{} db.First(&item) // check status / validation here without...

What is the correct way to lock when using FirstOrCreate? Hi, I'm using FirstOrCreate in order to perform a pretty standard upsert operation. It seems that its implementation doesn't lock the involved table (at least from what it looks like here), so I was wondering, what is the correct syntax to u...

Hi! I found some problem with indexes in PostgreSQL. For example, you have some table type USER struct { gorm.Model Name string `json:"name" gorm:"type:varchar(64);not null"` Country string `json:"country" gorm:"index:idx_country"` } and you want to change name for Country index, like a...

Your Question I use MySql binary(16) to store UUID generated from google uuid pkg. When under '.Debug()' mode, like db.Debug().Create()... on the output of SQL statement, some uuid will be output as '', but some uuid will be output as '%5ČA\[email protected]"\ufffd4\ufffd q! \ufffd' which is invalid UTF-8. Ex...

I use MySql binary(16) to store UUID generated from google uuid pkg. When under '.Debug()' mode, like db.Debug().Create()... on the output of SQL statement, some uuid will be output as '', but some uuid will be output as '%5ČA\[email protected]"\ufffd4\ufffd q! \ufffd' which is invalid UTF-8.