📦 EqualifyEverything / equalify-api

📄 addResults.ts · 16 lines
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16import { jwtClaims } from '#src/app';
import { formatId, db } from '#src/utils';

export const addResults = async ({ request, reply }) => {
    await db.connect();
    const id = (await db.query(`
        INSERT INTO "results" ("user_id") VALUES ($1) RETURNING "id"
    `, [jwtClaims.sub])).rows?.[0]?.id;
    await db.clean();

    return {
        status: 'success',
        message: 'Result added successfully',
        result: formatId(id),
    };
}