Function ExampleDB_Model_updateUseZeroBool

example_model_test.go:799–841

()

}

func ExampleDB_Model_updateUseZeroBool() {
	type Event struct {
		ID     int
		Active bool `pg:",use_zero"`
	}

	db := pg.Connect(pgOptions())
	defer db.Close()

	err := db.Model((*Event)(nil)).CreateTable(&orm.CreateTableOptions{
		Temp: true,
	})
	if err != nil {
		panic(err)
	}

	event := &Event{
		ID:     1,
		Active: true,
	}
	_, err = db.Model(event).Insert()
	if err != nil {
		panic(err)
	}

	fmt.Println(event)

	event.Active = false
	_, err = db.Model(event).WherePK().UpdateNotZero()
	if err != nil {
		panic(err)
	}

	event2 := new(Event)
	err = db.Model(event2).Where("id = ?", 1).Select()
	if err != nil {
		panic(err)
	}

	fmt.Println(event2)
	// Output: &{1 true}
	// &{1 false}
}

func ExampleDB_Model_updateSomeColumns() {
	db := modelDB()