📦 EqualifyEverything / equalify-api

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
31import { jwtClaims } from '#src/app';
import { db, validateUuid } from '#src/utils';

export const updateReports = async ({ request, reply }) => {
    if (!validateUuid(request.body.reportId)) {
        return {
            status: 'error',
            message: 'Report ID is not a valid UUID.',
        }
    }
    else if (!(request.body.reportName || request.body.reportFilters)) {
        return {
            status: 'error',
            message: 'At least reportName and/or reportFilters are required.',
        }
    }

    await db.connect();
    const original = (await db.query(`
        SELECT * FROM "reports" WHERE "id"=$1 AND "user_id"=$2
    `, [request.body.reportId, jwtClaims.sub]))?.rows?.[0];
    await db.query(`
        UPDATE "reports" SET "name"=$1, "filters"=$2 WHERE "id"=$3 AND "user_id"=$4
    `, [request.body.reportName ?? original.name, JSON.stringify(request.body.reportFilters ?? original.filters), request.body.reportId, jwtClaims.sub]);
    await db.clean();

    return {
        status: 'success',
        message: 'Report updated successfully',
    };
}