Skip to content
Snippets Groups Projects
Select Git revision
  • 5ecea6614d8b89e899de27832f8ddc5fdbdc1fa1
  • main default protected
2 results

README.md

Blame
  • trainer-db-adapter.js 1.24 KiB
    var mysql = require('mysql');
    var db_config = require('../db-config');
    var dbConfig = {
        host: db_config.host,
        port: db_config.port,
        user: db_config.user,
        password: db_config.password,
        database: db_config.database,
        connectionLimit: db_config.connectionLimit
    }
    
    var dbResult = require('../routes/result');
    var pool = mysql.createPool(dbConfig);
    var adapter = {};
    
    var trainerSearchQuery = 'SELECT * FROM trainer';
    
    adapter.trainerSearch = function(cb) {
        var resultCode = dbResult.Fail;
    
        pool.getConnection(function(err, connection) {
            if (err) { // db연결실패
                console.log(err);
                resultCode = dbResult.Fail;
                connection.release();
                cb(resultCode, []);
            } else { // db연결성공
                connection.query(trainerSearchQuery, function(err, rows) {
                    if (err) {
                        console.log(err);
                        resultCode = dbResult.Fail;
                        connection.release();
                        cb(resultCode, []);
                    } else {
                        resultCode = dbResult.OK;
                        connection.release();
                        cb(resultCode, rows);
                    }
                });
            }
        });
    }
    
    module.exports = adapter;