Skip to content
Snippets Groups Projects
Select Git revision
  • 7e4791f27162f17bf41fb60e41f55e5caee31691
  • master default protected
  • db-config-set
  • server-secure
  • revert-e208614e
  • exercise-server
  • ckh-android2
  • new-android
  • web_yjs
  • new-android3
  • calorie-save-server
  • new-android2
  • userupdate-server
  • bodytype
  • dailysearch-server
  • appfood-server
  • ckh-android
  • appdaily-server
  • web-login-server
  • jw-android
  • server-android-merge
21 results

trainer-db-adapter.js

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;