|
|||||
¾Æ·¡ÀÇ ¼Ò½ºÄڵ带 ±¸ÇöÇÏ¿´½À´Ï´Ù. const app = express(); const logger = require('morgan'); const bodyParser = require('body-parser'); const oracledb = require('oracledb'); const dbConfig = require('./dbConfig.js'); const ChkDate = require('./ChkDateTime.js'); //¿¹¾àÀÏÀÚ À¯È¿¼º üũ(¿äÀÏ ¹× Open½Ã°£, Á¾·á½Ã°£µî) app.use(logger('dev', {})); app.use(bodyParser.json()); app.use('/api', apiRouter); app.use('/Param/reservation', Reservation); app.use(bodyParser.urlencoded({ extended: true })); Reservation.post('/:insInfo', function (req, res) { //º¯¼ö split var splitedString = req.params.insInfo.split("&"); var InsDate = splitedString[0]; var botId = splitedString[1]; var Phone_Chk = splitedString[2]; //¿¹¾àÀÏÀÚ À¯È¿¼º °Ë»ç ½ÃÀÛ console.log('1.Param Value : ' + InsDate + ', botId : ' + botId + ', Phone : ' + Phone_Chk); console.log('2.oracle createPool'); oracledb.createPool(dbConfig) .then(function () { return ChkDate.getChkDate(botId, InsDate); }) //1. ¿äûÀÏÀÚ¿¡ ´ëÇÑ À¯È¿¼ºÃ¼Å© Return .then(function (ChkResult) { console.log('5.Result Count:' + ChkResult.length); }) .catch(function (err) { console.log(err); }); POSTÇüÅ·ΠHTTP RequestÇϸé... Reservation.post °¡ ½ÇÇàÀÌ µÇ´Â ±¸Á¶ÀÔ´Ï´Ù. ±Ã±ÝÇÑ ºÎºÐÀº... Reservation.post ³»¿¡¼ oracledb.createPool(dbConfig)À» ó¸®ÇÑÈÄ, .thenÀ¸·Î ½ÃÀÛÇÏ´Â ÇÏÀ§±¸ºÐÀÌ ¾î¶°ÇÑ ¼Ó¼ºÀ» »ó¼ÓÇÏ´Â ±¸¹®ÀÎÁö°¡ ±Ã±ÝÇÕ´Ï´Ù. oracledb.createPool(dbConfig)Àº »ó´Ü¿¡ Çѹø¸¸ ¼±¾ðÇÏ¸é µÇÁö ¾Ê³ª... ½ÍÀºµ¥.. Reservation.post »óÀ§´Ü¿¡ oracledb.createPool(dbConfig)À» Çѹø ¼±¾ðÇÏ°í.. °¢ POST À̺¥Æ®¿¡¼´Â .thenÀÌÇÏ ±¸¹®À» ¾î¶»°Ô º¯°æÇؾßÇϴ°ÇÁö.. ¾Æ¹«¸® ã¾Æµµ µ¿ÀÏÇÑ ÄÉÀ̽º°¡ ¾È³ª¿À³×¿ä. oracledb.createPool(dbConfig) Reservation.post('/:insInfo', function (req, res) { //???? ¾î¶² °´Ã¼¸¦ ¼±¾ðÇؾß, ¾Æ·¡ .thenÀÌÇÏ ±¸¹®ÀÌ Á¤»óÀÌ µÇ´ÂÁö.... .then(function () { return ChkDate.getChkDate(botId, InsDate); }) //1. ¿äûÀÏÀÚ¿¡ ´ëÇÑ À¯È¿¼ºÃ¼Å© Return .then(function (ChkResult) { console.log('5.Result Count:' + ChkResult.length); }) .catch(function (err) { console.log(err); }); } Áï, ´Ù¸¥ POST ¿äûµé¿¡¼ ´Ù½Ã oracledb.createPool(dbConfig)À» ¼±¾ðÇؾßÇÔÀÌ ¸Â´Ù¸é.. ÇöÀç »óÅ·Π°è¼Ó ó¸®Çؾ߰ÚÁö¸¸, oracledb.createPool(dbConfig)Àº »óÀ§ Çѹø¸¸ ¼±¾ðÇصµ µÇ´Â°Å¶ó¸é, ÄÚµù¿¡ È¿À²Â÷¿ø¿¡¼¶óµµ ¾î¶»°Ô º¯°æÇØ¾ß ¸Â´Â°ÇÁö Á¶¾ðÀ» ºÎŹµå¸³´Ï´Ù. |
|
| ||