/**
 * Converts CSV to Markdown Table
 *
 * @param {string} csvContent - The string content of the CSV
 * @param {string} delimiter - The character(s) to use as the CSV column delimiter
 * @param {boolean} hasHeader - Whether to use the first row of Data as headers
 * @returns {string}
 */
export function csvToMarkdown(csvContent: string, delimiter: string = ",", hasHeader: boolean = true): string {
    if (delimiter != "\t") {
        csvContent = csvContent.replace(/\t/g, "    ");
    }

    const columns = csvContent.split(/\r?\n/);

    const tabularData: string[][] = [];
    const maxRowLen: number[] = [];

    columns.forEach((e, i) => {
        if (typeof tabularData[i] == "undefined") {
            tabularData[i] = [];
        }
        const regex = new RegExp(delimiter + '(?![^"]*"\\B)');
        const row = e.split(regex);
        row.forEach((ee, ii) => {
            if (typeof maxRowLen[ii] == "undefined") {
                maxRowLen[ii] = 0;
            }

            // escape pipes and backslashes
            ee = ee.replace(/(\||\\)/g, "\\$1");

            maxRowLen[ii] = Math.max(maxRowLen[ii], ee.length);
            tabularData[i][ii] = ee;
        });
    });

    let headerOutput = "";
    let seperatorOutput = "";

    maxRowLen.forEach((len) => {
        const sizer = Array(len + 1 + 2);

        seperatorOutput += "|" + sizer.join("-");
        headerOutput += "|" + sizer.join(" ");
    });

    headerOutput += "| \n";
    seperatorOutput += "| \n";

    if (hasHeader) {
        headerOutput = "";
    }

    let rowOutput = "";
    tabularData.forEach((col, i) => {
        maxRowLen.forEach((len, y) => {
            const row = typeof col[y] == "undefined" ? "" : col[y];
            const spacing = Array((len - row.length) + 1).join(" ");
            const out = `| ${row}${spacing} `;
            if (hasHeader && i === 0) {
                headerOutput += out;
            } else {
                rowOutput += out;
            }
        });

        if (hasHeader && i === 0) {
            headerOutput += "| \n";
        } else {
            rowOutput += "| \n";
        }
    });

    return `\n\n ${headerOutput}${seperatorOutput}${rowOutput} \n\n`;
}