Function TestDecodeRanges

internal/sheetsvalues/values_test.go:55–84

(t *testing.T)

}

func TestDecodeRanges(t *testing.T) {
	ranges, err := DecodeRanges([]byte(`[{"range":"Sheet1\\!A1","values":[["a"]]}]`))
	if err != nil {
		t.Fatalf("DecodeRanges() error = %v", err)
	}

	if len(ranges) != 1 || ranges[0].Range != "Sheet1!A1" {
		t.Fatalf("ranges = %#v", ranges)
	}

	for _, tc := range []struct {
		name string
		data string
		want string
	}{
		{name: "invalid json", data: `nope`, want: "invalid JSON data"},
		{name: "empty array", data: `[]`, want: "at least one value range"},
		{name: "null range", data: `[null]`, want: "range 0 is null"},
		{name: "empty range", data: `[{"range":"","values":[["a"]]}]`, want: "empty range"},
		{name: "missing values", data: `[{"range":"Sheet1!A1"}]`, want: "empty values"},
		{name: "empty values", data: `[{"range":"Sheet1!A1","values":[]}]`, want: "empty values"},
	} {
		t.Run(tc.name, func(t *testing.T) {
			_, gotErr := DecodeRanges([]byte(tc.data))
			if gotErr == nil || !strings.Contains(gotErr.Error(), tc.want) {
				t.Fatalf("error = %v, want %q", gotErr, tc.want)
			}
		})
	}
}