1
2
3
4
5
6
7

// Update single attribute, similar with `Update`
db.Model(&user).UpdateColumn("name", "hello")
//// UPDATE users SET name='hello' WHERE id = 111;
// Update multiple attributes, similar with `Updates`
db.Model(&user).UpdateColumns(User{Name: "hello", Age: 18})
//// UPDATE users SET name='hello', age=18 WHERE id = 111;

1

db.Model(&User{Model: Model{ID: 1}}).UpdateColumn("name", "hello")

1
2
3

// Update single attribute if it is changed
db.Model(&user).Update("name", "hello")
//// UPDATE users SET name='hello', updated_at='2013-11-17 21:34:10' WHERE id=111;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

type Product struct {
	gorm.Model
	Code         string
	Price        uint
	Applications []Application
}
type Application struct {
	gorm.Model
	Name      string
	ProductID uint
}
func main() {
	// Migrate the schema
	db.AutoMigrate(&Product{}, &Application{})
	// Create
	db.Create(&Product{Code: "L1212", Price: 1000})
	// Read
	var product Product
	db.First(&product, 1) // find product with id 1
	product.Applications = []Application{
		{
			Name: "test",
		},
	}
	// Update - update product's price to 2000
	db.Model(&product).Update("Price", 1000)
    // UPDATE products SET price = '1000', updated_at = '2019-01-29 21:58:52'  WHERE products.deleted_at IS NULL
	// INSERT INTO applications (created_at,updated_at,deleted_at,name,product_id) VALUES ('2019-01-29 21:58:52','2019-01-29 21:58:52',NULL,'test','0')
}

1
2
3
4
5
6
7
8
9
10

// Model specify the model you would like to run db operations
//    // update all users's name to `hello`
//    db.Model(&User{}).Update("name", "hello")
//    // if user's primary key is non-blank, will use it as condition, then will only update the user's name to `hello`
//    db.Model(&user).Update("name", "hello")
func (s *DB) Model(value interface{}) *DB {
	c := s.clone()
	c.Value = value
	return c
}

1
2
3
4
5
6
7
8
9
10
11
12

// Update update attributes with callbacks, refer: https://jinzhu.github.io/gorm/crud.html#update
func (s *DB) Update(attrs ...interface{}) *DB {
	return s.Updates(toSearchableMap(attrs...), true)
}
// Updates update attributes with callbacks, refer: https://jinzhu.github.io/gorm/crud.html#update
func (s *DB) Updates(values interface{}, ignoreProtectedAttrs ...bool) *DB {
	return s.NewScope(s.Value).
		Set("gorm:ignore_protected_attrs", len(ignoreProtectedAttrs) > 0).
		InstanceSet("gorm:update_interface", values).
		callCallbacks(s.parent.callbacks.updates).db
}

1
2
3
4
5
6
7
8

func saveAfterAssociationsCallback(scope *Scope) {
    // 判断是否存在关系关系然后更新bala bala...
    for _, field := range scope.Fields() {
		autoUpdate, autoCreate, saveReference, relationship := saveAssociationCheck(scope, field)
        //...
    }
    //...
}