cityssm/corporate-records-manager

View on GitHub
handlers/admin/doTableCleanup.js

Summary

Maintainability
A
0 mins
Test Coverage
F
17%
import { cleanupRecordsTable } from "../../helpers/recordsDB/cleanupRecordsTable.js";
import { cleanupRecordTagsTable } from "../../helpers/recordsDB/cleanupRecordTagsTable.js";
import { cleanupRelatedRecordsTable } from "../../helpers/recordsDB/cleanupRelatedRecordsTable.js";
import { cleanupRecordStatusLogTable, cleanupRecordURLsTable, cleanupRecordCommentLogTable, cleanupRecordUsersTable } from "../../helpers/recordsDB/cleanupTable.js";
export const handler = async (request, response) => {
    const tableName = request.body.tableName;
    let recordCount = 0;
    switch (tableName) {
        case "Records":
            recordCount = await cleanupRecordsTable();
            break;
        case "RecordTags":
            recordCount = await cleanupRecordTagsTable();
            break;
        case "RecordStatusLog":
            recordCount = await cleanupRecordStatusLogTable();
            break;
        case "RecordUsers":
            recordCount = await cleanupRecordUsersTable();
            break;
        case "RecordURLs":
            recordCount = await cleanupRecordURLsTable();
            break;
        case "RelatedRecords":
            recordCount = await cleanupRelatedRecordsTable();
            break;
        case "RecordCommentLog":
            recordCount = await cleanupRecordCommentLogTable();
            break;
        default:
            return response.json({
                success: false,
                message: "Invalid tableName = " + tableName
            });
    }
    return response.json({
        success: true,
        recordCount
    });
};
export default handler;