app/include/databases.js

'use strict'
/**

 * Copyright (c) 2017~2019, OBCon Inc.

 * All rights reserved.

 */

/**

 * @file

 * @copyright 2017~2019, OBCon Inc.

 * @author gye hyun james kim [pnuskgh@gmail.com]

 */

//--- http://docs.sequelizejs.com/
const Sequelize = require('sequelize');

//--- ORM(Object Relation Mapper)
class Databases {

    constructor() {
        const pwPlain = security.decrypt(config.databases.scada.password);
        console.log("[DB scada runtime]",
          {
            host: config.databases.scada.host,
            port: config.databases.scada.port,
            user: config.databases.scada.username,
            db:   config.databases.scada.database,
            pw_len: pwPlain ? pwPlain.length : null,
            pw_mask: pwPlain ? (pwPlain.slice(0,2) + "scada" + pwPlain.slice(-2)) : null
          }
        );
        //--- OBCon_SCADA 데이터베이스
        this._scada = new Sequelize(
            config.databases.scada.database, 
            config.databases.scada.username, 
            security.decrypt(config.databases.scada.password), 
            config.databases.scada
        );

        this._data = null;
        // this._data = new Sequelize('sqlite:' + path.join(config.folder_root, config.databases.data.storage));
    }

    get scada() {
        return this._scada;
    }

    get data() {
        return this._data;
    }

    get dataTypes() {
        return Sequelize;
    }
}

module.exports = Databases;