Foreign keys in GORM not updated-Golang-php.cn

Foreign keys in GORM not updated

WBOY

Release： 2024-02-09 11:57:07

forward

1098 people have browsed it

GORM 中的外键未更新

When I was using GORM recently, I found a problem - the foreign key was not updated. When I updated the value of the foreign key field in the related table, it was not updated synchronously to the other table. Through investigation and research, I found that this is because GORM does not automatically update foreign key fields by default. This problem has been bothering me for a while, so I decided to share the solution with everyone. In this article, I will show you how to use GORM to correctly update foreign key fields to avoid this problem.

Question content

I have two desks, one is the company

type Company struct {
    Id        uuid.UUID `gorm:"column:id;primaryKey;"`
    CreatedAt time.Time `gorm:"index;column:createdAt"`
    UpdatedAt time.Time `gorm:"index;column:updatedAt"`
    Name      string    `gorm:"column:name" binding:"required"`
}

Copy after login

The other is product_entitlement

type ProductEntitlement struct {
ID        uuid.UUID
CreatedAt time.Time `gorm:"index;column:createdAt"`
UpdatedAt time.Time `gorm:"index;column:updatedAt"`
Type       string    `gorm:"column:type" binding:"required"`
CompanyID  uuid.UUID `gorm:"column:companyId;size:36"`
Company    Company   `gorm:"foreignKey:CompanyID"`
}

Copy after login

CompanyID is a foreign key. CompanyID contains the value from Company.Id

After the update insert is completed, new rows will be inserted every time. This is the code we are using

func UpdateEntitlement(c *gin.Context) {
cid := c.Param("companyId")
    id := c.Param("entitlementId")
    eid := uuid.MustParse(id)
    log.Println(eid)
    uid := uuid.MustParse(cid)
    log.Println(uid)
    var entitlementRequest entities.ProductEntitlement
    if err := c.BindJSON(&entitlementRequest); err != nil {
        log.Println(err)
        fmt.Println("ERROR: ", err)
        c.JSON(400, gin.H{"error": "Invalid JSON format"})
        return
    }
    if err := database.DB.Clauses(clause.OnConflict{
        Columns:   []clause.Column{{Name: "id"}},
        UpdateAll: true,
    }).Create(&entitlementRequest).Error; err != nil {
        log.Println(err)
    }
}

Copy after login

But it always fails and gives error

BD820BD3F94A2A45E18ED8E8094EF395

I want to update Product_entitlement if the ID exists, else create a new one

The URL is as follows, http://localhost:8080/company/{{companyId}}/product/{{companyId}} and use the PUT method The body is

{"Type": "Automatic"}

Workaround

If it helps someone, we can use the FirstOrCreate function to check if the id exists and updates it, or creates a new one if it doesn't exist.

To assign a foreign key, we need to assign the value to the related table,

entitlementRequest.CompanyID = uid

func UpdateEntitlement(c *gin.Context) {
    cid := c.Param("companyId")
    uid := uuid.MustParse(cid)
    eid := c.Param("entitlementId")
    nid := uuid.MustParse(eid)
    var entitlementRequest entities.ProductEntitlement
    entitlementRequest.CompanyID = uid

    if err := c.BindJSON(&entitlementRequest); err != nil {
        fmt.Println("ERROR: ", err)
        c.JSON(400, gin.H{"error": "Invalid JSON format"})
        return
    }
    if err := database.DB.Where("id = ?", nid).
        Assign(entitlementRequest).
        FirstOrCreate(&entitlementRequest).Error; err != nil {
        c.JSON(http.StatusBadRequest, gin.H{"error": "Record not found!"})
        return
    }
    c.JSON(http.StatusOK, gin.H{"error": "Product entitlement upserted successfully"})
}

Copy after login

The above is the detailed content of Foreign keys in GORM not updated. For more information, please follow other related articles on the PHP Chinese website!