Repositories

Overview

All database access goes through repository files in src/repositories/. There is no direct Prisma access from routes, commands, or services.

Singleton Prisma client with the PostgreSQL adapter.

typescript

import { prisma } from '../repositories/database.repository.js';

Functions:

Function	Description
`getScheduleForDate(date)`	Load the full schedule for a given date
`getNext14DaysSchedule()`	Batch: load the next 14 days
`getSchedulesForDates(dates)`	Multi-date lookup
`updatePlayerAvailability(date, userId, availability)`	Set a player's availability
`upsertSchedule(date, reason, focus)`	Create or update a schedule
`addMissingDays()`	Fill in missing days
`applyRecurringToEmptySchedules()`	Apply recurring availability to empty slots
`syncUserMappingsToSchedules()`	Sync roster changes
`getSchedulesPaginated(offset)`	Paginated history
`updateScheduleReason(date, reason, focus)`	Update reason/focus

Function	Description
`getUserMappings()`	All mappings (sorted by role + order)
`addUserMapping(mapping)`	Create a new mapping
`updateUserMapping(discordId, updates)`	Update a mapping
`removeUserMapping(discordId)`	Delete a mapping
`reorderUserMappingsBatch(orderings)`	Batch reorder (drag-and-drop)

Function	Description
`getAbsencesForUser(userId)`	A player's absences
`getAllAbsences()`	All absences
`createAbsence(userId, startDate, endDate, reason)`	Create
`updateAbsence(id, data)`	Update
`deleteAbsence(id)`	Delete
`isUserAbsentOnDate(userId, date)`	Check whether a user is absent
`getAbsentUserIdsForDate(date)`	All absent users for a date
`getAbsentUserIdsForDates(dates)`	Batch check

Function	Description
`getRecurringForUser(userId)`	A player's entries
`getAllActiveRecurring()`	All active entries
`setRecurring(userId, dayOfWeek, availability)`	Set (upsert)
`clearRecurringDay(userId, dayOfWeek)`	Clear a single day
`clearRecurringAll(userId)`	Clear all entries

Function	Description
`getAllScrims()`	All scrims (newest first)
`getScrimById(id)`	A single scrim with its comments
`addScrim(data)`	Create
`updateScrim(id, data)`	Update
`deleteScrim(id)`	Delete (cascades to comments)
`getScrimStats()`	Win/loss/draw statistics
`getScrimsByDateRange(start, end)`	Date-range query

Function	Description
`getCommentsForScrim(scrimId)`	Load comments (sorted by timestamp)
`addComment(scrimId, userName, timestamp, content)`	Create
`deleteComment(id)`	Delete

Function	Description
Folder CRUD	Create, read, update, delete, sort
Strategy CRUD	Create, read, update, delete
Image management	Upload, delete
File management	Upload, delete

Function	Description
`initializeDatabaseIfEmpty()`	Create tables and defaults
`checkTablesExist()`	Schema check
`checkForMissingTables()`	Detect missing tables