apex-mle-require-module.js

// fetch the library from the table
const loadFromDatabase = (moduleName) => {
    const result = apex.conn.execute(`

    select source
      from javascript_modules
     where module_name = :name

    `, {
        name: moduleName
    }, {
        fetchInfo: {
            SOURCE: {
                type: apex.db.STRING
            }
        }
    });
    return result.rows[0].SOURCE;
};

// module decoration. similar to how node.js operates
const decorateModule = (module) => `
    (function () {
        let exports = {},
            module = {exports: exports};
        ${module};
        return module.exports;
    })();
`;

// cache modules in case they are required multiple times
const moduleCache = {};

// expose the requireModule function globally
globalThis.requireModule = (moduleName) => {
    if (!moduleCache[moduleName]) {
        const moduleString = decorateModule(loadFromDatabase(moduleName));
        moduleCache[moduleName] = Polyglot.eval('js', moduleString);
    }
    return moduleCache[moduleName];
};