Compare query hash

gistfile1.txt

let dump = ` CREATE TABLE CUSTOMERS(
    ID   INT              NOT NULL,
    NAME VARCHAR (20)     NOT NULL,
    AGE  INT              NOT NULL,
    ADDRESS  CHAR (25) ,
    SALARY   DECIMAL (18, 2),       
    PRIMARY KEY (ID)
 );

 CREATE OR REPLACE FUNCTION totalRecords ()
RETURNS integer AS $total$
declare
    total integer;
BEGIN
   SELECT count(*) into total FROM COMPANY;
   RETURN total;
END;
$total$ LANGUAGE plpgsql; 

CREATE TABLE User(
    ID   INT              NOT NULL,
    NAME VARCHAR (20)     NOT NULL,
    AGE  INT              NOT NULL
 );

`

const hashFun = (a, type, endQuery) => {
    let final = []
    let word = '',
        tableFound = false
    let tableHash = {}
    let b = []
    a = a.replace(/;/g, '')
    for (let i = 0; i <= a.length; i++) {
        if (!(a[i] === ' ')) {
            word += a[i]
        } else {
            if (tableFound) {
                if (final.length === 0) {
                    b = a.split(' ')
                }
                let startIndex = b.findIndex((c) => c === word)
                let endIndex = b.findIndex((c) => endQuery === c.replace(new RegExp('\n', 'g'), ''))
                final = []
                b.map((item, index) => {
                    if (index <= endIndex) {
                        final.push(item)
                    }
                })
                b.splice(startIndex, endIndex)
                word = word.replace(/\n/g, '')
                word = word.replace('(', '')
                tableHash[word] = final.join(' ')
                tableFound = false
            }
            if (new RegExp(type, 'i').test(word)) {
                tableFound = true
                tableHash
            }
            word = ''
        }
    }
    console.log(tableHash)

}

hashFun(dump, 'FUNCTION', 'plpgsql')
hashFun(dump, 'table', ')')