golang,gorm实现mysql的upsert

兰博lamb

已于 2024-04-23 16:43:19 修改

阅读量225

点赞数 3

文章标签： golang mysql android

于 2024-04-23 15:56:26 首次发布

本文链接：https://blog.csdn.net/linsonggao/article/details/138129174

版权

golang,gorm实现mysql的upsert

1.使用gorm的原生mysql支持

db.Exec("insert into tbl_referral_link_member_retain
                    (report_date,referral_link_id,retain_count)
                    VALUES
                    (?,?,?)
                    ON DUPLICATE KEY UPDATE
                    retain_count = ?", "2024-04-23",1,gorm.Expr("retain_count + ?", 1))

2.使用clauses

linkRetain := report.ReferralLinkMemberRetain{
					ReportDate:           reportDate,
					ReferralLinkId:       int32(int_link_id),
					RetainCount:          uv,
				}
DbReport.Clauses(
					clause.OnConflict{
						Columns: []clause.Column{{Name: "referral_link_id"}, {Name: "report_date"}},
						DoUpdates: clause.Assignments(
							map[string]interface{}{
								"retain_count": gorm.Expr("retain_count+ ?", uv),
								"updated_at":   nowFormat,
							},
						),
					},
				).Create(&linkRetain)