{"id":11798,"date":"2021-09-15T00:00:07","date_gmt":"2021-09-15T07:00:07","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=11798"},"modified":"2025-06-13T21:22:56","modified_gmt":"2025-06-14T04:22:56","slug":"how-to-query-json-data-n1ql-node-js-couchbase","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/how-to-query-json-data-n1ql-node-js-couchbase\/","title":{"rendered":"Node.js \ubc0f Couchbase\uc6a9 SQL++\ub97c \uc0ac\uc6a9\ud558\uc5ec JSON \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"

\uc624\ub298\uc774 \ubc14\ub85c \uadf8 \ub0a0\uc785\ub2c8\ub2e4.<\/strong> Node.js \uc571\uc774 \"\uac00\uc838 \uc624\uae30\"\ub97c \ud559\uc2b5\ud569\ub2c8\ub2e4.<\/p>\n

\uc774 \uae30\ubcf8 \ud29c\ud1a0\ub9ac\uc5bc\uc744 \ub530\ub77c Couchbase\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\uae30 \uc704\ud574 SQL++(\uc77c\uba85 N1QL) \ucffc\ub9ac\ub97c \uc804\uc1a1\ud558\ub294 Node.js \uc571\uc6a9 REST API\ub97c \uad6c\ucd95\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6cc\ubcf4\uc138\uc694.<\/p>\n

\uc774 \uac8c\uc2dc\ubb3c\uc740 \ub2e4\uc74c\uc5d0 \ub300\ud55c \uc18c\uac1c \uc2dc\ub9ac\uc988\ub97c \uc774\uc5b4\uac11\ub2c8\ub2e4. \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc640 \ud568\uaed8 Node.js \uc0ac\uc6a9<\/a>\ub2e4\uc74c\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4. \ube44\ub3d9\uae30 \ud568\uc218<\/a> \uadf8\ub9ac\uace0 Node.js \ubc0f Express\ub85c REST API \uad6c\ucd95\ud558\uae30<\/a>.<\/p>\n

\uc624\ub298\uc758 \uac8c\uc2dc\ubb3c\uc740 \uc9c1\uc811 \ubb38\uc11c \uac80\uc0c9\uc744 \uc704\ud55c REST API\ub97c \uad6c\ucd95\ud55c \ud6c4 \uc774\uc804 \uac8c\uc2dc\ubb3c\uc5d0\uc11c \uc911\ub2e8\ub41c \ubd80\ubd84\uc744 \uc774\uc5b4\uc11c \ub2e4\ub8f9\ub2c8\ub2e4.<\/p>\n

\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815<\/h2>\n

This post assumes you have installed the `travel-sample` Bucket that comes with all \uce74\uc6b0\uce58\ubca0\uc774\uc2a4<\/a> \uc124\uce58. \uc790\ub3d9\uc73c\ub85c \uc0dd\uc131\ub418\ub294 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uace0 \uc644\uc804\ud788 \ubc18\ubcf5 \uac00\ub2a5\ud55c \ud2b9\uc815 \ubb38\uc11c \uae30\uc900\uc774 \uc0ac\uc6a9\ub418\ubbc0\ub85c \uc774 \ub370\uc774\ud130 \uc9d1\ud569\uc744 \uc124\uce58\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n

\uae30\ubcf8 \uc5f0\uacb0 \ubc0f REST API \uae30\ubc18\uc740 \uc774\ubbf8 \ub2e4\uc74c\uc5d0\uc11c \uc124\uba85\ud569\ub2c8\ub2e4. \uc9c0\ub09c\uc8fc\uc5d0 \ud568\uaed8 \ub9cc\ub4e0 \uc2a4\ud06c\ub9bd\ud2b8<\/a>. \uc624\ub298\uc758 \ucf54\ub4dc \uc0d8\ud50c\uc5d0 \ud3ec\ud568\ud560 \uc608\uc815\uc774\uc9c0\ub9cc \uc790\uc138\ud55c \uc124\uba85\uc740 \uc774\uc804 \uac8c\uc2dc\ubb3c(\uc704 \ub9c1\ud06c)\uc744 \ubaa8\ub450 \uc77d\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

\ub610\ud55c \uc624\ub298\uc758 \uc608\uc81c\uc5d0\uc11c\ub294 \ub2e8\uc21c\ud654\ub97c \uc704\ud574 \uae30\ubcf8 \ubc94\uc704\uc640 \uceec\ub809\uc158\uc744 \uc0ac\uc6a9\ud558\uaca0\uc2b5\ub2c8\ub2e4. \ud3c9\uc18c\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c JSON \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud560 \ub54c\ub294 JavaScript, Node.js \ubc0f NoSQL \ubb38\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud574 \uae30\ubcf8\uc801\uc73c\ub85c \uc798 \uc54c\uace0 \uc788\ub2e4\uace0 \uac00\uc815\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

N1QL \ucffc\ub9ac \uc774\ud574<\/h2>\n

\uadf8\ub9ac\uace0 N1QL \ucffc\ub9ac \uc5b8\uc5b4<\/a> \ub294 \uba87 \uac00\uc9c0 \uc608\uc678\ub97c \uc81c\uc678\ud558\uba74 SQL\uacfc \uac70\uc758 \ub3d9\uc77c\ud569\ub2c8\ub2e4.<\/p>\n

When a N1QL query requests a specific column from a Bucket, it returns a list of all matching JSON documents in the Bucket. If there is no data in the document for the column then you get a `NULL` value, unless it is filtered out with a `WHERE` clause.<\/p>\n

\ubb38\uc11c\ub97c \ucffc\ub9ac\ud558\ub824\uba74 \ucd5c\uc18c\ud55c \ubb38\uc11c\uc5d0\uc11c \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ud2b9\uc815 \uc5f4\uc5d0 \ub300\ud574 \uc815\uc758\ub41c \ubcf4\uc870 \uc778\ub371\uc2a4\uac00 \uc788\uc73c\uba74 \ucffc\ub9ac \uc131\ub2a5\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<\/p>\n

\uc774 \ub450 \uc778\ub371\uc2a4\ub294 \ubaa8\ub450 \ucffc\ub9ac \uc790\uccb4\ub85c \ub9cc\ub4e4 \uc218 \uc788\uc73c\uba70 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ud1b5\ud574 \ub610\ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc6f9 \ucf58\uc194<\/a>. \uc2e4\uc81c\ub85c \uc6f9 \ucf58\uc194\uc5d0\uc11c \uc778\ub371\uc2a4\ub97c \ud0d0\uc0c9\ud558\uc5ec \uc774\ub7ec\ud55c \uc778\ub371\uc2a4\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uace0 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4dc\ub294 \ub370 \uc0ac\uc6a9\ub41c \ucffc\ub9ac\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

<\/div>\n

\"Couchbase<\/a><\/p>\n

<\/div>\n

\uc704 \uc608\uc81c\uc5d0\uc11c\ub294 \uc5f4\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 \uc778\ub371\uc2a4\uac00 \uc0dd\uc131\ub429\ub2c8\ub2e4. \ub3c4\uc2dc<\/code> \uc5d0 \uc788\ub294 \ubaa8\ub4e0 \ubb38\uc11c \ub0b4\uc5d0\uc11c \uc5ec\ud589 \uc0d8\ud50c<\/code> \ubc84\ud0b7.<\/p>\n

\uc0d8\ud50c \ucffc\ub9ac<\/h2>\n

\ucf54\ub4dc\ub97c \uc791\uc131\ud558\uae30 \uc804\uc5d0 \uc6f9 \ucf58\uc194\uc5d0\uc11c \uc9c1\uc811 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uc5ec \uc608\uc0c1\ud55c \uacb0\uacfc\ub97c \ubc18\ud658\ud558\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc6f9 \ucf58\uc194\uc5d0\uc11c \ucffc\ub9ac<\/code> \ud0ed\uc744 \ud074\ub9ad\ud558\uace0 \ub2e4\uc74c \ucffc\ub9ac\ub97c \uc785\ub825\ud55c \ub2e4\uc74c \uc2e4\ud589<\/code>.<\/p>\n

SELECT * FROM `travel-sample` WHERE city = 'Los Angeles';\r\n<\/pre>\n
<\/div>\n
\ucf58\uc194\uc5d0 323\uac1c\uc758 \ubb38\uc11c\uac00 \uc77c\uce58\ud558\ub294 \uacb0\uacfc\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4. \ud638\ud154, \uacf5\ud56d \ub4f1 \uc5ec\ub7ec \ubb38\uc11c\uac00 \ud63c\ud569\ub418\uc5b4 \ubc18\ud658\ub41c\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud558\uc138\uc694. \uc720\ud615<\/code> \uceec\ub7fc\uc774 \uc788\uc2b5\ub2c8\ub2e4. (\uc9c0\uae08\uc740 \"\uc5f4\"\uc774\ub77c\uace0 \ub9d0\ud558\uc9c0\ub9cc \uc2e4\uc81c\ub85c\ub294 \ub2e4\ub978 \uac1d\uccb4 \uc548\uc5d0 \ud3ec\ud568\ub420 \uc218 \uc788\ub294 JSON \uac1d\uccb4\/\uc694\uc18c\uc785\ub2c8\ub2e4).<\/p>\n
\uc544\ub798 \uc608\uc2dc\uc640 \uac19\uc774 \uba87 \uac1c\uc758 \uc5f4\ub9cc \ubc18\ud658\ud558\ub3c4\ub85d \ucffc\ub9ac\ub97c \uc870\uc815\ud569\ub2c8\ub2e4.<\/p>\n
SELECT type, name, city FROM `travel-sample` WHERE city = 'Los Angeles';\r\n<\/pre>\n
<\/div>\n
\"Couchbase<\/a><\/p>\n
<\/div>\n
\ucffc\ub9ac \ud568\uc218 \uc791\uc131<\/h2>\n
\ub098\uba38\uc9c0 \ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uae30 \uc804\uc5d0 \uba3c\uc800 \uc804\ub2ec\uc758 \uae30\ubcf8 \uc0ac\ud56d\ubd80\ud130 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. Node.js SDK\ub97c \uc0ac\uc6a9\ud55c \ucffc\ub9ac<\/a>.<\/p>\n
\uc644\uc804\ud55c \ud615\uc2dd\uc758 \ucffc\ub9ac \ubb38\uc790\uc5f4\uc744 \uc804\ub2ec\ud558\ub294 \ub300\uc2e0 \ub0b4\uc7a5\ub41c \uc790\ub9ac \ud45c\uc2dc\uc790\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc7ac\uc0ac\uc6a9 \uac00\ub2a5\ud55c \ucf54\ub4dc\ub85c \ub9cc\ub4dc\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 \uba85\uba85\ub41c \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4: \ucffc\ub9ac\uc5d0\ub294 \ud50c\ub808\uc774\uc2a4\ud640\ub354 \ubcc0\uc218\uac00 \ud3ec\ud568\ub418\uba70, \uc0ac\uc6a9\ud560 \uac12\uc774 \ud3ec\ud568\ub41c \ubcc0\uc218\ub97c \uc804\ub2ec\ud569\ub2c8\ub2e4.<\/p>\n
\uba3c\uc800 \ucffc\ub9ac \ubcc0\uc218\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4:<\/p>\n
const querystr = `SELECT type, name, city FROM \\`travel-sample\\` WHERE city = $CITY;`\r\n<\/pre>\n
<\/div>\n
\uadf8\ub7f0 \ub2e4\uc74c \uc785\ub825 \ub9e4\uac1c\ubcc0\uc218 \ubcc0\uc218\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4:<\/p>\n
const params = { parameters: { CITY: 'Los Angeles' }}\r\n<\/pre>\n
<\/div>\n
\uadf8\ub7f0 \ub2e4\uc74c \uc774 \ub450 \uac00\uc9c0\ub97c \ud074\ub7ec\uc2a4\ud130 \ucffc\ub9ac \ud568\uc218\uc5d0 \uc804\ub2ec\ud558\uc5ec \uacb0\uacfc\ub97c \uc2dc\uc791\ud558\uace0 \ubc18\ud658\ud569\ub2c8\ub2e4:<\/p>\n
  let result = await cluster.query(querystr, params)\r\n<\/pre>\n
<\/div>\n
\uc774\uc81c \uc0ac\uc6a9\uc790\uac00 \ub9cc\ub4e0 \ubaa8\ub4e0 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
  async function getQuery(){\r\n    const querystr = `SELECT type, name, city FROM \\`travel-sample\\` WHERE city = $CITY;`\r\n    const params = { parameters: { CITY: 'Los Angeles' }}\r\n\r\n    try {\r\n      let result = await cluster.query(querystr, params)\r\n      console.log(\"Result:\", result)\r\n      return result\r\n    } catch (error) {\r\n      console.error(\"Query failed: \", error)\r\n    }\r\n  };\r\n<\/pre>\n
<\/div>\n
\ucffc\ub9ac REST\ud654<\/h2>\n
\ub2e4\uc74c \ub2e8\uacc4\ub294 \uc774 \ucffc\ub9ac \ud568\uc218\ub97c \uc774\uc804 REST API \ucf54\ub4dc \uc608\uc81c\uc5d0 \ucd94\uac00\ud558\uc5ec \uc785\ub825\ub41c \ub3c4\uc2dc \uc774\ub984\uc744 \uac00\uc838\uc640 \ube0c\ub77c\uc6b0\uc800\uc5d0 HTTP \uacb0\uacfc\ub97c \ub2e4\uc2dc \ubc18\ud658\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n
\uba3c\uc800 \uc544\ub798\uc640 \uac19\uc774 \ub3c4\uc2dc \uc774\ub984\uc5d0 \ub300\ud55c \ubcc0\uc218\ub97c \ud568\uc218\uc5d0 \uc804\ub2ec\ud569\ub2c8\ub2e4:<\/p>\n
  async function getQuery(cityname){...\r\n<\/pre>\n
<\/div>\n
Then, create a query endpoint (instead of the `get` route we used in an earlier post) and move the logic for the REST response into that function.<\/p>\n
  app.get('\/query\/:cityname',\r\n    runAsync(async (req, res) => {\r\n      var cityname = req.params.cityname;\r\n\r\n      var querystr = `SELECT type, name, city FROM \\`travel-sample\\` WHERE city = $CITY;`\r\n      var params = { parameters: { CITY: cityname}}\r\n\r\n      await cluster.query(querystr, params, function(err, result){\r\n        res.json(result)\r\n      })\r\n  }));\r\n<\/pre>\n
<\/div>\n
\uadf8\ub7ec\uba74 \uc544\ub798 \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 \uc6f9 \ube0c\ub77c\uc6b0\uc800 \ub610\ub294 Postman REST API \ub3c4\uad6c\uc5d0\uc11c REST \ud638\ucd9c\uc5d0\uc11c RAW JSON\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n
<\/div>\n
\"couchbase<\/a><\/p>\n
<\/div>\n
\uc804\uccb4 \ucf54\ub4dc \uc608\uc81c<\/h2>\n
\ub2e4\uc74c\uc740 \uc804\uccb4 \uc0d8\ud50c \ucf54\ub4dc \uacb0\uacfc\uc785\ub2c8\ub2e4. \ucc38\uc870\ub97c \uc704\ud574 \ub2e4\ub978 \ubb38\uc11c\uc758 \uc77c\ubd80 \uc774\uc804 \ucf54\ub4dc\uac00 \uc720\uc9c0\ub429\ub2c8\ub2e4.<\/p>\n
var app = require('express')();\r\nvar couchbase = require(\"couchbase\");\r\n\r\nasync function main(){\r\n  app.get('\/get\/:docid',\r\n    runAsync(async (req, res) => {\r\n      var docid = req.params.docid;\r\n      var docjson = await getDoc(docid, function(err, result){\r\n        res.json(result.content)\r\n      });\r\n  }));\r\n\r\n  app.get('\/query\/:cityname',\r\n    runAsync(async (req, res) => {\r\n      var cityname = req.params.cityname;\r\n      var querystr = `SELECT type, name, city FROM \\`travel-sample\\` WHERE city = $CITY;`\r\n      var params = { parameters: { CITY: cityname}}\r\n      await cluster.query(querystr, params, function(err, result){\r\n        res.json(result)\r\n      })\r\n  }));\r\n\r\n  app.listen(3000, () => console.log('Listening on port 3000'));\r\n\r\n  function runAsync (callback) {\r\n    return function (req, res, next) {\r\n      callback(req, res, next)\r\n      .catch(next)\r\n    }\r\n  }\r\n\r\n  var cluster = new couchbase.Cluster(\"couchbase:\/\/localhost\", {\r\n    username: \"Administrator\",\r\n    password: \"Administrator\"\r\n  });\r\n\r\n  var bucket = cluster.bucket(\"travel-sample\");\r\n  var collection = bucket.defaultCollection();\r\n\r\n  var getDoc = async (key) => {\r\n      var result = await collection.get(key);\r\n      console.log(result)\r\n      return result\r\n  }\r\n}\r\n\r\nmain();\r\n<\/pre>\n
<\/div>\n
\uacb0\ub860<\/h2>\n
\uc774 \ud504\ub85c\uc81d\ud2b8\uc5d0 \uc801\uc6a9\ud560 \uc218 \uc788\ub294 \uc0c8\ub85c\uc6b4 \ubc29\ud5a5\uc774 \ub9ce\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc6b0\uc120, \uc801\uc808\ud55c \uc624\ub958 \ucea1\ucc98\ub97c \ud3ec\ud568\ud558\uac70\ub098 \ucf58\uc194\uc5d0 \ub85c\uadf8 \uc815\ubcf4\ub97c \ucd9c\ub825\ud558\uac70\ub098 results.rows<\/code> \uac1d\uccb4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud45c \ud615\uc2dd\uc758 \uacb0\uacfc\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n
\ub2e4\uc74c\uacfc \uac19\uc774 \uad8c\uc7a5\ud569\ub2c8\ub2e4. Node.js SDK\uc758 \ucffc\ub9ac \uc0ac\uc6a9\uc5d0 \ub300\ud55c Couchbase \uc124\uba85\uc11c\ub97c \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uc138\uc694.<\/a>.<\/p>\n
\ub098\uba38\uc9c0 Node.js + Couchbase \ubc29\ubc95 \uc2dc\ub9ac\uc988\ub3c4 \ud655\uc778\ud574 \ubcf4\uc138\uc694:<\/em><\/p>\n