diff options
| author | nsfisis <54318333+nsfisis@users.noreply.github.com> | 2026-01-12 18:09:14 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2026-01-12 18:09:14 +0900 |
| commit | 188c49e6ae0dfa0af052a001bc40c26d448b1583 (patch) | |
| tree | f0cebd927c2292a40f123a694c6aa561768ad7a3 /src/server/repositories/card.ts | |
| parent | f8e4be9b36a16969ac53bd9ce12ce8064be10196 (diff) | |
| parent | 1732c543f4bc98ec6a4c7ea13c3e4762933421d8 (diff) | |
| download | kioku-188c49e6ae0dfa0af052a001bc40c26d448b1583.tar.gz kioku-188c49e6ae0dfa0af052a001bc40c26d448b1583.tar.zst kioku-188c49e6ae0dfa0af052a001bc40c26d448b1583.zip | |
Display daily card count on deck list page
Diffstat (limited to 'src/server/repositories/card.ts')
| -rw-r--r-- | src/server/repositories/card.ts | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/src/server/repositories/card.ts b/src/server/repositories/card.ts index 04425a2..ac03bc6 100644 --- a/src/server/repositories/card.ts +++ b/src/server/repositories/card.ts @@ -204,6 +204,20 @@ export const cardRepository: CardRepository = { return result; }, + async countDueCards(deckId: string, now: Date): Promise<number> { + const result = await db + .select({ count: sql<number>`count(*)::int` }) + .from(cards) + .where( + and( + eq(cards.deckId, deckId), + isNull(cards.deletedAt), + lte(cards.due, now), + ), + ); + return result[0]?.count ?? 0; + }, + async findDueCardsWithNoteData( deckId: string, now: Date, |