Function TestStructWithPointerUpdate

sqlite_ptr_test.go:157–197

(t *testing.T)

}

func TestStructWithPointerUpdate(t *testing.T) {

	db := getMoviesDb()

	var lastId int64
	if res, err := db.Exec("INSERT INTO movies (title, genre, budget) VALUES ('2001: A Space Odyssey', 'Science-Fiction', 1500000)"); err != nil {
		t.Fatalf("Sqlite Exec failed: %s", err)
	} else if lastId, err = res.LastInsertId(); err != nil {
		t.Fatalf("Sqlite LastInsertId failed: %s", err)
	}

	m := &Movie{
		Id:     lastId,
		Title:  "The Usual Suspects",
		Genre:  nil,
		Budget: 6000000}

	m.Recorder = New(squirrel.NewStmtCacheProxy(db), "mysql").Bind("movies", m)
	if err := m.Update(); err != nil {
		t.Fatalf("Failed Update: %s", err)
	}

	msql := new(Movie)
	msql.loadFromSql(lastId, db)

	if !CompareStringPtr(msql.Genre, stringPtr("Science-Fiction")) {
		t.Fatal("Update should ignore nil pointers")
	}

	m.Genre = stringPtr("Crime Thriller")
	m.Recorder = New(squirrel.NewStmtCacheProxy(db), "mysql").Bind("movies", m)
	if err := m.Update(); err != nil {
		t.Fatalf("Failed Update: %s", err)
	}

	msql.loadFromSql(lastId, db)
	if !CompareStringPtr(msql.Genre, stringPtr("Crime Thriller")) {
		t.Log("msql.Genre: %v\n", *msql.Genre)
		t.Fatal("Update should ignore nil pointers")
	}
}

func getMoviesDb() *sql.DB {