im.doctor/src/server/models/server/management.js

/**
 * 管理端。
 *
 * author: Sand
 * since: 2016.11.20
 */
"use strict";

let configFile = require('../../include/commons').CONFIG_FILE;
let config = require('../../resources/config/' + configFile);

let BaseModel = require('../base.model');
let ModeUtil = require("../../util/model.util");

let ImDb = require('../../repository/oracle/db/im.db');

class Management extends BaseModel {
    constructor() {
        super();
    }

    getDatabaseTables() {
        let self = this;
        let data = new Array(0);

        ImDb.execQuery({
            "sql": "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA = ?",
            "args": [config.imDbConfig.database],
            "handler": function (err, result) {
                Management.makeResponse(data, config.imDbConfig.database, err, result);

                ModeUtil.emitOK(self.eventEmitter, data);
            }
        });
    }

    static makeResponse(dbStatus, dbName, err, rows) {
        if (err) {
            dbStatus.push({
                name: dbName,
                status: 'Failed',
                message: err
            });
        } else {
            let tableList = [];
            for (let i = 0; i < rows.length; ++i) {
                tableList.push(rows[i].table_name);
            }

            let status = {
                name: dbName,
                status: 'OK',
                tables: tableList
            };

            dbStatus.push(status);
        }
    }
}

module.exports = Management;