Function TestSearchMemories

pkg/memory/database/sqlite/sqlite_test.go:171–235

(t *testing.T)

}

func TestSearchMemories(t *testing.T) {
	t.Parallel()
	db := setupTestDB(t)
	ctx := t.Context()

	testMemories := []database.UserMemory{
		{ID: "1", CreatedAt: time.Now().Format(time.RFC3339), Memory: "User prefers dark mode", Category: "preference"},
		{ID: "2", CreatedAt: time.Now().Format(time.RFC3339), Memory: "Project uses Go and React", Category: "project"},
		{ID: "3", CreatedAt: time.Now().Format(time.RFC3339), Memory: "User likes Go for backend", Category: "preference"},
		{ID: "4", CreatedAt: time.Now().Format(time.RFC3339), Memory: "Deploy to AWS us-east-1", Category: "project"},
	}
	for _, m := range testMemories {
		require.NoError(t, db.AddMemory(ctx, m))
	}

	t.Run("single keyword", func(t *testing.T) {
		results, err := db.SearchMemories(ctx, "Go", "")
		require.NoError(t, err)
		assert.Len(t, results, 2)
	})

	t.Run("multi-word AND", func(t *testing.T) {
		results, err := db.SearchMemories(ctx, "Go backend", "")
		require.NoError(t, err)
		assert.Len(t, results, 1)
		assert.Equal(t, "3", results[0].ID)
	})

	t.Run("category filter only", func(t *testing.T) {
		results, err := db.SearchMemories(ctx, "", "preference")
		require.NoError(t, err)
		assert.Len(t, results, 2)
	})

	t.Run("keyword plus category", func(t *testing.T) {
		results, err := db.SearchMemories(ctx, "Go", "project")
		require.NoError(t, err)
		assert.Len(t, results, 1)
		assert.Equal(t, "2", results[0].ID)
	})

	t.Run("empty query returns all", func(t *testing.T) {
		results, err := db.SearchMemories(ctx, "", "")
		require.NoError(t, err)
		assert.Len(t, results, 4)
	})

	t.Run("no matches", func(t *testing.T) {
		results, err := db.SearchMemories(ctx, "nonexistent", "")
		require.NoError(t, err)
		assert.Empty(t, results)
	})

	t.Run("case insensitive", func(t *testing.T) {
		results, err := db.SearchMemories(ctx, "go", "")
		require.NoError(t, err)
		assert.Len(t, results, 2)
	})