Function TestJSONEach

tools/dbutils/json_test.go:9–17

(t *testing.T)

)

func TestJSONEach(t *testing.T) {
	result := dbutils.JSONEach("a.b")

	expected := "json_each(CASE WHEN iif(json_valid([[a.b]]), json_type([[a.b]])='array', FALSE) THEN [[a.b]] ELSE json_array([[a.b]]) END)"

	if result != expected {
		t.Fatalf("Expected\n%v\ngot\n%v", expected, result)
	}
}

func TestJSONArrayLength(t *testing.T) {
	result := dbutils.JSONArrayLength("a.b")