a2dcf67396
Some checks failed
CI / build-and-test (pull_request) Has been cancelled
- Add PLAN.md and sync backend docs, .env.example, API doc (404 details) - Document mock DB and PORT/API_PORT in docs/backend.md; README monorepo + frontend/.env.example - Migration 002: finish_place column, status registered; mapper and mock DB updated - Frontend: registered status, finishPlace, calendar year/month filters, pace sparkline - Extract createApp for tests; supertest + tsx; GitHub Actions CI Made-with: Cursor
93 lines
2.3 KiB
TypeScript
93 lines
2.3 KiB
TypeScript
/** Row shape returned by PostgreSQL (snake_case). */
|
|
export interface RaceRow {
|
|
id: string;
|
|
race_date: string;
|
|
title: string;
|
|
distance_km: string;
|
|
status: string | null;
|
|
official_url: string | null;
|
|
start_time: string | null;
|
|
cluster_schedule: string | null;
|
|
bib_pickup: string | null;
|
|
bib_number: string | null;
|
|
finish_time: string | null;
|
|
finish_place: string | null;
|
|
notes: string | null;
|
|
created_at: string;
|
|
updated_at: string | null;
|
|
}
|
|
|
|
/** API shape (camelCase). */
|
|
export interface RaceDto {
|
|
id: string;
|
|
date: string;
|
|
title: string;
|
|
distanceKm: number;
|
|
status: string | null;
|
|
officialUrl: string | null;
|
|
startTime: string | null;
|
|
clusterSchedule: string | null;
|
|
bibPickup: string | null;
|
|
bibNumber: string | null;
|
|
finishTime: string | null;
|
|
finishPlace: string | null;
|
|
notes: string | null;
|
|
createdAt: string;
|
|
updatedAt: string | null;
|
|
}
|
|
|
|
/** Convert a DB row to the API DTO (camelCase). */
|
|
export function rowToDto(row: RaceRow): RaceDto {
|
|
return {
|
|
id: row.id,
|
|
date: row.race_date,
|
|
title: row.title,
|
|
distanceKm: parseFloat(row.distance_km),
|
|
status: row.status,
|
|
officialUrl: row.official_url,
|
|
startTime: row.start_time,
|
|
clusterSchedule: row.cluster_schedule,
|
|
bibPickup: row.bib_pickup,
|
|
bibNumber: row.bib_number,
|
|
finishTime: row.finish_time,
|
|
finishPlace: row.finish_place,
|
|
notes: row.notes,
|
|
createdAt: row.created_at,
|
|
updatedAt: row.updated_at,
|
|
};
|
|
}
|
|
|
|
/** Map incoming camelCase body fields to snake_case column names. */
|
|
const FIELD_MAP: Record<string, string> = {
|
|
date: "race_date",
|
|
title: "title",
|
|
distanceKm: "distance_km",
|
|
status: "status",
|
|
officialUrl: "official_url",
|
|
startTime: "start_time",
|
|
clusterSchedule: "cluster_schedule",
|
|
bibPickup: "bib_pickup",
|
|
bibNumber: "bib_number",
|
|
finishTime: "finish_time",
|
|
finishPlace: "finish_place",
|
|
notes: "notes",
|
|
};
|
|
|
|
/**
|
|
* Convert a partial camelCase body into { columns, values, placeholders }
|
|
* suitable for SQL INSERT / UPDATE.
|
|
*/
|
|
export function bodyToColumns(body: Record<string, unknown>) {
|
|
const columns: string[] = [];
|
|
const values: unknown[] = [];
|
|
|
|
for (const [camel, snake] of Object.entries(FIELD_MAP)) {
|
|
if (camel in body) {
|
|
columns.push(snake);
|
|
values.push(body[camel]);
|
|
}
|
|
}
|
|
|
|
return { columns, values };
|
|
}
|