From ef65c4e6d31b5df36bfff3254d614f61bf659bed Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Wed, 31 Dec 2025 01:18:37 +0900
Subject: feat(api): include note data in Card and Study route responses
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Update Card GET endpoint to return note and field values when available,
and Study GET endpoint to include note data for card display rendering.
This enables the frontend to render note-based cards with their templates.

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
---
 src/server/repositories/card.test.ts |  1 +
 src/server/repositories/card.ts      | 41 ++++++++++++++++++++++++++++++++++++
 src/server/repositories/types.ts     |  5 +++++
 3 files changed, 47 insertions(+)

(limited to 'src/server/repositories')

diff --git a/src/server/repositories/card.test.ts b/src/server/repositories/card.test.ts
index 22d0f41..64c071e 100644
--- a/src/server/repositories/card.test.ts
+++ b/src/server/repositories/card.test.ts
@@ -96,6 +96,7 @@ function createMockCardRepo(): CardRepository {
 		softDelete: vi.fn(),
 		softDeleteByNoteId: vi.fn(),
 		findDueCards: vi.fn(),
+		findDueCardsWithNoteData: vi.fn(),
 		updateFSRSFields: vi.fn(),
 	};
 }
diff --git a/src/server/repositories/card.ts b/src/server/repositories/card.ts
index 830b2f7..92811d4 100644
--- a/src/server/repositories/card.ts
+++ b/src/server/repositories/card.ts
@@ -178,6 +178,47 @@ export const cardRepository: CardRepository = {
 		return result;
 	},
 
+	async findDueCardsWithNoteData(
+		deckId: string,
+		now: Date,
+		limit: number,
+	): Promise<CardWithNoteData[]> {
+		const dueCards = await this.findDueCards(deckId, now, limit);
+
+		const cardsWithNoteData: CardWithNoteData[] = [];
+
+		for (const card of dueCards) {
+			if (!card.noteId) {
+				cardsWithNoteData.push({
+					...card,
+					note: null,
+					fieldValues: [],
+				});
+				continue;
+			}
+
+			const noteResult = await db
+				.select()
+				.from(notes)
+				.where(and(eq(notes.id, card.noteId), isNull(notes.deletedAt)));
+
+			const note = noteResult[0] ?? null;
+
+			const fieldValuesResult = await db
+				.select()
+				.from(noteFieldValues)
+				.where(eq(noteFieldValues.noteId, card.noteId));
+
+			cardsWithNoteData.push({
+				...card,
+				note,
+				fieldValues: fieldValuesResult,
+			});
+		}
+
+		return cardsWithNoteData;
+	},
+
 	async updateFSRSFields(
 		id: string,
 		deckId: string,
diff --git a/src/server/repositories/types.ts b/src/server/repositories/types.ts
index 3b910f3..8b86061 100644
--- a/src/server/repositories/types.ts
+++ b/src/server/repositories/types.ts
@@ -134,6 +134,11 @@ export interface CardRepository {
 	softDelete(id: string, deckId: string): Promise<boolean>;
 	softDeleteByNoteId(noteId: string): Promise<boolean>;
 	findDueCards(deckId: string, now: Date, limit: number): Promise<Card[]>;
+	findDueCardsWithNoteData(
+		deckId: string,
+		now: Date,
+		limit: number,
+	): Promise<CardWithNoteData[]>;
 	updateFSRSFields(
 		id: string,
 		deckId: string,
-- 
cgit v1.2.3-70-g09d2