1 files changed, 65 insertions, 1 deletions
diff --git a/internal/storage/db_test.go b/internal/storage/db_test.go
index 5c447af..82c8262 100644
--- a/internal/storage/db_test.go
+++ b/internal/storage/db_test.go
@@ -41,7 +41,6 @@ func TestCreateTask_AndGetTask(t *testing.T) {
 			Type:         "claude",
 			Model:        "sonnet",
 			Instructions: "do it",
-			ProjectDir:   "/tmp",
 			MaxBudgetUSD: 2.5,
 		},
 		Priority:  task.PriorityHigh,
@@ -1154,3 +1153,68 @@ func TestExecution_StoreAndRetrieveChangestats(t *testing.T) {
 	}
 }
 
+func TestCreateProject(t *testing.T) {
+	db := testDB(t)
+	defer db.Close()
+
+	p := &task.Project{
+		ID:        "proj-1",
+		Name:      "claudomator",
+		RemoteURL: "/bare/claudomator.git",
+		LocalPath: "/workspace/claudomator",
+		Type:      "web",
+	}
+	if err := db.CreateProject(p); err != nil {
+		t.Fatalf("CreateProject: %v", err)
+	}
+	got, err := db.GetProject("proj-1")
+	if err != nil {
+		t.Fatalf("GetProject: %v", err)
+	}
+	if got.Name != "claudomator" {
+		t.Errorf("Name: want claudomator, got %q", got.Name)
+	}
+	if got.LocalPath != "/workspace/claudomator" {
+		t.Errorf("LocalPath: want /workspace/claudomator, got %q", got.LocalPath)
+	}
+}
+
+func TestListProjects(t *testing.T) {
+	db := testDB(t)
+	defer db.Close()
+
+	for _, p := range []*task.Project{
+		{ID: "p1", Name: "alpha", Type: "web"},
+		{ID: "p2", Name: "beta", Type: "android"},
+	} {
+		if err := db.CreateProject(p); err != nil {
+			t.Fatalf("CreateProject: %v", err)
+		}
+	}
+	list, err := db.ListProjects()
+	if err != nil {
+		t.Fatalf("ListProjects: %v", err)
+	}
+	if len(list) != 2 {
+		t.Errorf("want 2 projects, got %d", len(list))
+	}
+}
+
+func TestUpdateProject(t *testing.T) {
+	db := testDB(t)
+	defer db.Close()
+
+	p := &task.Project{ID: "p1", Name: "original", Type: "web"}
+	if err := db.CreateProject(p); err != nil {
+		t.Fatalf("CreateProject: %v", err)
+	}
+	p.Name = "updated"
+	if err := db.UpdateProject(p); err != nil {
+		t.Fatalf("UpdateProject: %v", err)
+	}
+	got, _ := db.GetProject("p1")
+	if got.Name != "updated" {
+		t.Errorf("Name after update: want updated, got %q", got.Name)
+	}
+}
+