Select Git revision
-
GISEONG LEE authoredGISEONG LEE authored
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;