Function ExampleDB_Model_bulkUpdateSlice

example_model_test.go:927–957

()

}

func ExampleDB_Model_bulkUpdateSlice() {
	db := modelDB()

	books := []Book{{
		ID:        1,
		Title:     "updated book 1",
		UpdatedAt: time.Now(),
	}, {
		ID:        2,
		Title:     "updated book 2",
		UpdatedAt: time.Now(),
	}}

	// UPDATE "books" AS "book"
	// SET "title" = _data."title"
	// FROM (VALUES ('updated book 1', 1), ('updated book 2', 2)) AS _data("title", "id")
	// WHERE "book"."id" = _data."id"
	_, err := db.Model(&books).Column("title", "updated_at").Update()
	if err != nil {
		panic(err)
	}

	books = nil
	err = db.Model(&books).Order("id").Select()
	if err != nil {
		panic(err)
	}

	fmt.Println(books)
	// Output: [Book<Id=1 Title="updated book 1"> Book<Id=2 Title="updated book 2"> Book<Id=3 Title="book 3">]
}

func ExampleDB_Model_delete() {
	db := modelDB()