compileValidSQL.tsx

#!/usr/bin/env node

const c = require('ansi-colors');

// Create an object to store the parsed arguments
let args = {
    inputDir: './logs/rest/',
    outputDir: './logs/rest/',
    verbose: false,
};


// parse command line arguments
for (let i = 2; i < process.argv.length; i++) {

    const arg = process.argv[i];

    // noinspection FallThroughInSwitchStatementJS
    switch (arg) {
        case '--input':
        case '-i':
            args.inputDir = process.argv[++i];
            break;
        case '--output':
        case '-o':
            args.outputDir = process.argv[++i];
            break;
        case '--verbose':
        case '-v':
            args.verbose = true;
            break;
        case '--help':
        case '-h':
            console.log(c.cyan('Usage:'));
            console.log(c.cyan('--input or -i: Input directory'));
            console.log(c.cyan('--output or -o: Output directory'));
            console.log(c.cyan('--verbose or -v: Enable verbose mode'));
            process.exit(0);
        default:
            console.error(`Unknown argument: ${arg}`);
            process.exit(1);
    }
}

// print parsed arguments if verbose mode is enabled
if (args.verbose) {
    console.log(c.cyan('Parsed arguments:'));
    console.log(c.cyan(JSON.stringify(args, null, 4)));
}

interface iApiResponseLine {
    "method": "GET" | "PUT" | "POST" | "DELETE",
    "table": string,
    "CarbonPHP\\Restful\\RestSettings::$externalRestfulRequestsAPI": boolean,
    "argv": [
        any[],
        any,
        any
    ],
    "stmt": {
        // ['stmt']['sql']
        sql: string, // sql
        injections: { [injectionNumber: string]: string },
        debugDumpParams: string[]
    }
}


interface iRestfulTestFile {
    [testName: string]: iApiResponseLine[]
}

const util = require('util');

const exec = util.promisify(require('child_process').exec);

const fs = require('fs');

(async () => {


    let jsonValidSqlFiles: iRestfulTestFile[] = [],
        validExternalRequests: iApiResponseLine[] = [];


    const ManifestFile = 'validSQL.json';

    fs.readdirSync(args.inputDir).forEach((file) => {

        if (file === ManifestFile) {

            return;

        }

        const {readFileSync} = require("fs");

        const resource = readFileSync(`${args.inputDir}${file}`, 'utf8');

        const json = JSON.parse(resource)

        if (json === undefined) {

            console.error(`Failed to parse ${file} as JSON`);

            return;

        }

        jsonValidSqlFiles.push(json);

    });

    jsonValidSqlFiles.forEach(apiRequest => {

        Object.keys(apiRequest).forEach(testName => {

            Object.keys(apiRequest[testName]).forEach(restCallInfo => {

                apiRequest[testName][restCallInfo].forEach(singleSqlInfoObject => {

                    if (true === singleSqlInfoObject['CarbonPHP\\Restful\\RestSettings::$externalRestfulRequestsAPI']) {

                        singleSqlInfoObject.stmt.debugDumpParams = singleSqlInfoObject.stmt.debugDumpParams.slice(0,2)

                        // change this to only the sql statement
                        validExternalRequests.push(singleSqlInfoObject.stmt)

                    }

                })

            })

        });

    });

    // @link https://stackoverflow.com/questions/12941083/execute-and-get-the-output-of-a-shell-command-in-node-js
    const {stdout} = await exec('git rev-parse HEAD')

    const revision = stdout.trim();

    fs.writeFileSync(args.outputDir + ManifestFile, JSON.stringify({
        "revision": revision,
        "validSQL": validExternalRequests
    }, undefined, 4));

})()