/**
    Framework for building object relational database apps
    Copyright (C) 2019  John Rogelstad

    This program is free software: you can redistribute it and/or modify
    it under the terms of the GNU Affero General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU Affero General Public License for more details.

    You should have received a copy of the GNU Affero General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>.
**/
/*jslint node*/
(function (exports) {
    "use strict";

    const {
        Tools
    } = require("./tools");

    const tools = new Tools();

    exports.Modules = function () {
        // ..........................................................
        // PUBLIC
        //

        let that = {};

        /**
          Return modules.

          @param {Object} Request payload
          @param {Object} [payload.client] Database client
          @return {Object}
        */
        that.getModules = function (obj) {
            return new Promise(function (resolve, reject) {
                let sql = (
                    "SELECT name, script, version, to_json(dependencies) " +
                    "AS dependencies " +
                    "FROM \"_module\";"
                );

                // Query routes
                obj.client.query(sql, function (err, resp) {
                    if (err) {
                        reject(err);
                        return;
                    }

                    // Send back result
                    resolve(tools.sanitize(resp.rows));
                });
            });
        };

        return that;
    };

}(exports));


@@ -1541,16 +1541,37 @@
 module%5C%22
+ WHERE NOT is_deleted
 ;%22%0A     

Update modules.js