aboutsummaryrefslogtreecommitdiffhomepage
path: root/src/server/repositories/review-log.ts
diff options
context:
space:
mode:
Diffstat (limited to 'src/server/repositories/review-log.ts')
-rw-r--r--src/server/repositories/review-log.ts21
1 files changed, 1 insertions, 20 deletions
diff --git a/src/server/repositories/review-log.ts b/src/server/repositories/review-log.ts
index 97488d2..c8950d6 100644
--- a/src/server/repositories/review-log.ts
+++ b/src/server/repositories/review-log.ts
@@ -1,7 +1,5 @@
-import { and, eq, gte, sql } from "drizzle-orm";
-import { getStartOfStudyDayBoundary } from "../../shared/date.js";
import { db } from "../db/index.js";
-import { CardState, cards, reviewLogs } from "../db/schema.js";
+import { reviewLogs } from "../db/schema.js";
import type { ReviewLog, ReviewLogRepository } from "./types.js";
export const reviewLogRepository: ReviewLogRepository = {
@@ -31,21 +29,4 @@ export const reviewLogRepository: ReviewLogRepository = {
}
return reviewLog;
},
-
- async countTodayNewCardReviews(deckId: string, now: Date): Promise<number> {
- const startOfDay = getStartOfStudyDayBoundary(now);
-
- const result = await db
- .select({ count: sql<number>`count(distinct ${reviewLogs.cardId})::int` })
- .from(reviewLogs)
- .innerJoin(cards, eq(reviewLogs.cardId, cards.id))
- .where(
- and(
- eq(cards.deckId, deckId),
- eq(reviewLogs.state, CardState.New),
- gte(reviewLogs.reviewedAt, startOfDay),
- ),
- );
- return result[0]?.count ?? 0;
- },
};