diff options
| author | nsfisis <54318333+nsfisis@users.noreply.github.com> | 2026-02-02 22:42:51 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2026-02-02 22:42:51 +0900 |
| commit | fc208d960e137dd36590908145a13d8501144b7a (patch) | |
| tree | 3f302c9c531c7ba25e2c5ad74c44b086df03a0d7 /src/server/repositories/card.ts | |
| parent | c20922a1aa339e34b4bed3747222f4b9d9941cd6 (diff) | |
| parent | d4489f24a05911d1395e8473fe86c3442d9397ee (diff) | |
| download | kioku-fc208d960e137dd36590908145a13d8501144b7a.tar.gz kioku-fc208d960e137dd36590908145a13d8501144b7a.tar.zst kioku-fc208d960e137dd36590908145a13d8501144b7a.zip | |
Merge pull request #11 from nsfisis/claude/investigate-learning-schedule-plOdQ
Implement study day boundary at 3:00 AM for due card logic
Diffstat (limited to 'src/server/repositories/card.ts')
| -rw-r--r-- | src/server/repositories/card.ts | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/server/repositories/card.ts b/src/server/repositories/card.ts index ac03bc6..2f14149 100644 --- a/src/server/repositories/card.ts +++ b/src/server/repositories/card.ts @@ -1,4 +1,5 @@ -import { and, eq, isNull, lte, sql } from "drizzle-orm"; +import { and, eq, isNull, lt, sql } from "drizzle-orm"; +import { getEndOfStudyDayBoundary } from "../../shared/date.js"; import { db } from "../db/index.js"; import { CardState, @@ -189,6 +190,7 @@ export const cardRepository: CardRepository = { now: Date, limit: number, ): Promise<Card[]> { + const boundary = getEndOfStudyDayBoundary(now); const result = await db .select() .from(cards) @@ -196,7 +198,7 @@ export const cardRepository: CardRepository = { and( eq(cards.deckId, deckId), isNull(cards.deletedAt), - lte(cards.due, now), + lt(cards.due, boundary), ), ) .orderBy(cards.due) @@ -205,6 +207,7 @@ export const cardRepository: CardRepository = { }, async countDueCards(deckId: string, now: Date): Promise<number> { + const boundary = getEndOfStudyDayBoundary(now); const result = await db .select({ count: sql<number>`count(*)::int` }) .from(cards) @@ -212,7 +215,7 @@ export const cardRepository: CardRepository = { and( eq(cards.deckId, deckId), isNull(cards.deletedAt), - lte(cards.due, now), + lt(cards.due, boundary), ), ); return result[0]?.count ?? 0; |