Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 | 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 38x 38x 38x 38x 38x 38x 38x 38x 1x 63x 63x 63x 1x 42x 42x 42x 40x 38x 37x 42x 6x 6x 36x 36x 1x 21x 21x 21x 1x 21x 21x 21x 21x 21x 21x 21x 21x 21x 21x 21x 21x 2x 19x 21x 21x 21x 21x 21x 21x 21x 21x 21x 21x 21x 21x 21x 21x 21x 21x 1x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 7x 1x 1x 1x 1x 1x 1x 1x 1x 8x 8x 8x 8x 8x 8x 8x 8x 8x 6x 8x 7x 7x 7x 7x 19x 19x 19x 19x 20x 20x 20x 20x 19x 19x 19x 16x 16x 16x 19x 19x 21x 21x 21x 21x 19x 7x 6x 8x 16x 16x 6x 6x 6x | import 'server-only'
import { sql } from 'drizzle-orm'
import { db } from '@/db'
import type { SessionPartType, SlotResult } from '@/db/schema/session-plans'
import type { BktEvidence } from './types'
/**
* Keep each libSQL response comfortably below the server response-size cap,
* even for accounts with many students and long practice histories.
*/
export const BKT_EVIDENCE_PLAYER_CHUNK_SIZE = 10
interface RawEvidenceSession {
playerId: string
evidenceJson: string | null
partTypeMap: string | null
}
interface RawProjectedEvidence {
skillsExercised?: unknown
timestamp?: unknown
isCorrect?: unknown
responseTimeMs?: unknown
hadHelp?: unknown
masteryWeight?: unknown
source?: unknown
originalSource?: unknown
timingReview?: unknown
partNumber?: unknown
}
interface RawPartType {
n?: unknown
t?: unknown
}
function parseJsonArray(value: string | null): unknown[] {
if (!value) return []
try {
const parsed: unknown = JSON.parse(value)
return Array.isArray(parsed) ? parsed : []
} catch {
return []
}
}
function optionalNumber(value: unknown): number | undefined {
return typeof value === 'number' && Number.isFinite(value) ? value : undefined
}
function optionalSource(value: unknown): SlotResult['source'] {
if (
value === 'practice' ||
value === 'recency-refresh' ||
value === 'teacher-corrected' ||
value === 'teacher-excluded'
) {
return value
}
return undefined
}
function normalizeTimestamp(value: unknown): Date | string | null {
if (typeof value === 'string') return value
if (typeof value === 'number' && Number.isFinite(value)) return new Date(value)
return null
}
function toBktEvidence(
raw: RawProjectedEvidence,
typeByPartNumber: ReadonlyMap<number, SessionPartType>
): BktEvidence | null {
if (!Array.isArray(raw.skillsExercised)) return null
const timestamp = normalizeTimestamp(raw.timestamp)
if (!timestamp) return null
const partNumber = optionalNumber(raw.partNumber)
const timingReview =
raw.timingReview && typeof raw.timingReview === 'object'
? (raw.timingReview as SlotResult['timingReview'])
: undefined
return {
skillsExercised: raw.skillsExercised.filter(
(skillId): skillId is string => typeof skillId === 'string'
),
timestamp,
isCorrect: raw.isCorrect === true || raw.isCorrect === 1,
responseTimeMs: optionalNumber(raw.responseTimeMs) ?? 0,
hadHelp: raw.hadHelp === true || raw.hadHelp === 1,
masteryWeight: optionalNumber(raw.masteryWeight),
source: optionalSource(raw.source),
originalSource: optionalSource(raw.originalSource),
timingReview,
partType: (partNumber == null ? undefined : typeByPartNumber.get(partNumber)) ?? 'linear',
}
}
async function getEvidenceChunk(
playerIds: readonly string[],
sessionCountPerPlayer: number
): Promise<RawEvidenceSession[]> {
const playerIdList = sql.join(
playerIds.map((playerId) => sql`${playerId}`),
sql`, `
)
return db.all<RawEvidenceSession>(sql`
WITH ranked_sessions AS (
SELECT
player_id,
completed_at,
id,
ROW_NUMBER() OVER (
PARTITION BY player_id
ORDER BY completed_at DESC, id DESC
) AS session_rank
FROM session_plans
WHERE player_id IN (${playerIdList})
AND status IN ('completed', 'recency-refresh')
AND completed_at IS NOT NULL
), recent_sessions AS (
SELECT player_id, completed_at, id
FROM ranked_sessions
WHERE session_rank <= ${sessionCountPerPlayer}
)
SELECT
recent_sessions.player_id AS playerId,
(
SELECT json_group_array(json_object(
'skillsExercised', json_extract(value, '$.skillsExercised'),
'timestamp', json_extract(value, '$.timestamp'),
'isCorrect', json_extract(value, '$.isCorrect'),
'responseTimeMs', json_extract(value, '$.responseTimeMs'),
'hadHelp', json_extract(value, '$.hadHelp'),
'masteryWeight', json_extract(value, '$.masteryWeight'),
'source', json_extract(value, '$.source'),
'originalSource', json_extract(value, '$.originalSource'),
'timingReview', json_extract(value, '$.timingReview'),
'partNumber', json_extract(value, '$.partNumber')
))
FROM json_each(session_plans.results)
) AS evidenceJson,
(
SELECT json_group_array(json_object(
'n', json_extract(value, '$.partNumber'),
't', json_extract(value, '$.type')
))
FROM json_each(session_plans.parts)
) AS partTypeMap
FROM recent_sessions
INNER JOIN session_plans ON session_plans.id = recent_sessions.id
ORDER BY recent_sessions.completed_at DESC, recent_sessions.id DESC
`)
}
/**
* Load only the attempt fields used by BKT for each player's recent sessions.
*
* The per-player limit is applied inside SQLite before any JSON is returned,
* and players are queried in bounded sequential chunks. This prevents a large
* household/classroom history from exceeding libSQL's response-size limit.
*/
export async function batchGetRecentBktEvidence(
playerIds: readonly string[],
sessionCountPerPlayer = 100
): Promise<Map<string, BktEvidence[]>> {
const resultMap = new Map<string, BktEvidence[]>()
const uniquePlayerIds = [...new Set(playerIds.filter(Boolean))]
const sessionLimit = Math.max(0, Math.floor(sessionCountPerPlayer))
if (uniquePlayerIds.length === 0 || sessionLimit === 0) return resultMap
for (let offset = 0; offset < uniquePlayerIds.length; offset += BKT_EVIDENCE_PLAYER_CHUNK_SIZE) {
const chunk = uniquePlayerIds.slice(offset, offset + BKT_EVIDENCE_PLAYER_CHUNK_SIZE)
const sessions = await getEvidenceChunk(chunk, sessionLimit)
for (const session of sessions) {
const partTypes = parseJsonArray(session.partTypeMap) as RawPartType[]
const typeByPartNumber = new Map<number, SessionPartType>()
for (const part of partTypes) {
if (typeof part.n === 'number' && typeof part.t === 'string') {
typeByPartNumber.set(part.n, part.t as SessionPartType)
}
}
let evidence = resultMap.get(session.playerId)
if (!evidence) {
evidence = []
resultMap.set(session.playerId, evidence)
}
for (const raw of parseJsonArray(session.evidenceJson) as RawProjectedEvidence[]) {
if (!raw || typeof raw !== 'object') continue
const normalized = toBktEvidence(raw, typeByPartNumber)
if (normalized) evidence.push(normalized)
}
}
}
for (const evidence of resultMap.values()) {
evidence.sort((a, b) => new Date(b.timestamp).getTime() - new Date(a.timestamp).getTime())
}
return resultMap
}
|