codeiq/internal/graph/cypher_test.go at main · RandomCodeSpace/codeiq · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
package graph_test

import (
	"path/filepath"
	"testing"

	"github.com/randomcodespace/codeiq/internal/graph"
)

func TestCypherReturnsRows(t *testing.T) {
	s, err := graph.Open(filepath.Join(t.TempDir(), "g.kuzu"))
	if err != nil {
		t.Fatal(err)
	}
	defer s.Close()

	// Kuzu requires schema before insert; run a trivial CREATE NODE TABLE
	// and INSERT, then SELECT.
	if _, err := s.Cypher("CREATE NODE TABLE Tiny(id STRING, PRIMARY KEY(id))"); err != nil {
		t.Fatalf("create table: %v", err)
	}
	if _, err := s.Cypher("CREATE (:Tiny {id: 'a'})"); err != nil {
		t.Fatalf("insert: %v", err)
	}
	rows, err := s.Cypher("MATCH (n:Tiny) RETURN n.id AS id")
	if err != nil {
		t.Fatalf("select: %v", err)
	}
	if len(rows) != 1 {
		t.Fatalf("want 1 row, got %d", len(rows))
	}
	if rows[0]["id"] != "a" {
		t.Fatalf("want id=a, got %v", rows[0]["id"])
	}
}

func TestCypherDDLReturnsEmpty(t *testing.T) {
	s, err := graph.Open(filepath.Join(t.TempDir(), "g.kuzu"))
	if err != nil {
		t.Fatal(err)
	}
	defer s.Close()

	rows, err := s.Cypher("CREATE NODE TABLE T(id STRING, PRIMARY KEY(id))")
	if err != nil {
		t.Fatalf("ddl: %v", err)
	}
	// DDL may report 0 rows or a single status row depending on Kuzu;
	// the contract is "no error". The exact row count is not part of the
	// API surface for DDL.
	_ = rows
}

func TestCypherWithParams(t *testing.T) {
	s, err := graph.Open(filepath.Join(t.TempDir(), "g.kuzu"))
	if err != nil {
		t.Fatal(err)
	}
	defer s.Close()

	if _, err := s.Cypher("CREATE NODE TABLE Tiny(id STRING, PRIMARY KEY(id))"); err != nil {
		t.Fatalf("create table: %v", err)
	}
	if _, err := s.Cypher("CREATE (:Tiny {id: 'a'})"); err != nil {
		t.Fatalf("insert: %v", err)
	}
	rows, err := s.Cypher(
		"MATCH (n:Tiny) WHERE n.id = $wanted RETURN n.id AS id",
		map[string]any{"wanted": "a"},
	)
	if err != nil {
		t.Fatalf("parameterized select: %v", err)
	}
	if len(rows) != 1 {
		t.Fatalf("want 1 row, got %d", len(rows))
	}
	if rows[0]["id"] != "a" {
		t.Fatalf("want id=a, got %v", rows[0]["id"])
	}
}

func TestCypherOnClosedStoreErrors(t *testing.T) {
	s, err := graph.Open(filepath.Join(t.TempDir(), "g.kuzu"))
	if err != nil {
		t.Fatal(err)
	}
	if err := s.Close(); err != nil {
		t.Fatal(err)
	}
	if _, err := s.Cypher("RETURN 1"); err == nil {
		t.Fatal("expected error on closed store")
	}
}