diff options
Diffstat (limited to 'backend')
| -rw-r--r-- | backend/package.json | 5 | ||||
| -rw-r--r-- | backend/pnpm-lock.yaml | 3 | ||||
| -rw-r--r-- | backend/prisma/seed.ts | 8 | ||||
| -rw-r--r-- | backend/schema.prisma | 11 | ||||
| -rw-r--r-- | backend/src/index.ts | 3 | ||||
| -rw-r--r-- | backend/src/routes/gameRoutes.ts | 19 |
6 files changed, 38 insertions, 11 deletions
diff --git a/backend/package.json b/backend/package.json index 4686f00..b5873c7 100644 --- a/backend/package.json +++ b/backend/package.json @@ -5,9 +5,11 @@ "main": "index.js", "scripts": { "test": "echo \"Error: no test specified\" && exit 1", - "seed": "ts-node prisma/seed.ts", "dev": "ts-node-dev src/index.ts" }, + "prisma": { + "seed": "ts-node prisma/seed.ts" + }, "keywords": [], "author": "", "license": "ISC", @@ -31,6 +33,7 @@ "@types/node": "^24.0.3", "@types/sqlite3": "^5.1.0", "prisma": "^6.10.1", + "ts-node": "^10.9.2", "ts-node-dev": "^2.0.0", "typescript": "^5.8.3" } diff --git a/backend/pnpm-lock.yaml b/backend/pnpm-lock.yaml index f84146a..2122141 100644 --- a/backend/pnpm-lock.yaml +++ b/backend/pnpm-lock.yaml @@ -60,6 +60,9 @@ importers: prisma: specifier: ^6.10.1 version: 6.10.1(typescript@5.8.3) + ts-node: + specifier: ^10.9.2 + version: 10.9.2(@types/node@24.0.7)(typescript@5.8.3) ts-node-dev: specifier: ^2.0.0 version: 2.0.0(@types/node@24.0.7)(typescript@5.8.3) diff --git a/backend/prisma/seed.ts b/backend/prisma/seed.ts index d0e3c73..4222708 100644 --- a/backend/prisma/seed.ts +++ b/backend/prisma/seed.ts @@ -1,14 +1,12 @@ -import { PrismaClient } from '@prisma/client'; +import { PrismaClient } from "@prisma/client"; const prisma = new PrismaClient(); async function main() { await prisma.game.createMany({ - data: [ - { name: 'Dancerush' }, - ], + data: [{ internalName: "dancerush", formattedName: "DANCERUSH STARDOM", description: "A suffle dancing game from KONAMI"}], }); - console.log('Initial seed data inserted'); + console.log("Initial seed data inserted"); } main() diff --git a/backend/schema.prisma b/backend/schema.prisma index 88a131f..3b91f85 100644 --- a/backend/schema.prisma +++ b/backend/schema.prisma @@ -26,16 +26,17 @@ model Session { } model Game { - id Int @id @default(autoincrement()) - name String @unique + internalName String @id + formattedName String + description String scores Score[] } model Score { id Int @id @default(autoincrement()) - gameId Int + gameInternalName String userId Int - data Json // arbitrary data in json format - game Game @relation(fields: [gameId], references: [id]) + data Json + game Game @relation(fields: [gameInternalName], references: [internalName]) user User @relation(fields: [userId], references: [id]) } diff --git a/backend/src/index.ts b/backend/src/index.ts index 3e2c559..c776ce1 100644 --- a/backend/src/index.ts +++ b/backend/src/index.ts @@ -8,6 +8,7 @@ import { startSessionCleanup } from './utils/session'; // Routes import * as authRoutes from './routes/authRoutes'; import * as userRoutes from './routes/userRoutes'; +import * as gameRoutes from './routes/gameRoutes'; const app = express(); const port = 5000; @@ -49,6 +50,8 @@ app.post('/api/logout', requireAuth, authRoutes.handleLogout); app.get('/api/me', userRoutes.handleMeRoute); app.get('/api/session', userRoutes.handleGetCurrentSession); +app.get('/api/supportedGames', gameRoutes.handleGetSupportedGames); + app.listen(port, () => { console.log(`Server listening on port ${port}`); }); diff --git a/backend/src/routes/gameRoutes.ts b/backend/src/routes/gameRoutes.ts new file mode 100644 index 0000000..26e7171 --- /dev/null +++ b/backend/src/routes/gameRoutes.ts @@ -0,0 +1,19 @@ +import express from 'express'; +import { prisma } from '../config/db'; + +export const handleGetSupportedGames = async (req: express.Request, res: express.Response) => { + try { + const supportedGames = await prisma.game.findMany({ + select: { + internalName: true, + formattedName: true, + description: true + } + }); + res.status(200).json(supportedGames); + + } catch (error) { + console.error('Supported Games endpoint error:', error); + res.status(500).json({ error: 'Internal server error. Unable to fetch supported games' }); + } +} |