Function ExampleDB_Model_insertOnConflictDoUpdate

example_model_test.go:173–204

()

}

func ExampleDB_Model_insertOnConflictDoUpdate() {
	db := modelDB()

	var book *Book
	for i := 0; i < 2; i++ {
		book = &Book{
			ID:    100,
			Title: fmt.Sprintf("title version #%d", i),
		}
		_, err := db.Model(book).
			OnConflict("(id) DO UPDATE").
			Set("title = EXCLUDED.title").
			Insert()
		if err != nil {
			panic(err)
		}

		err = db.Model(book).WherePK().Select()
		if err != nil {
			panic(err)
		}
		fmt.Println(book)
	}

	_, err := db.Model(book).WherePK().Delete()
	if err != nil {
		panic(err)
	}

	// Output: Book<Id=100 Title="title version #0">
	// Book<Id=100 Title="title version #1">
}

func ExampleDB_Model_selectOrInsert() {
	db := modelDB()