{"id":32198,"date":"2022-11-03T02:39:33","date_gmt":"2023-12-18T04:06:21","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/"},"modified":"2024-04-28T22:41:55","modified_gmt":"2024-04-28T14:41:55","slug":"%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/","title":{"rendered":"\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecePostgreSQL\/PostGIS\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e"},"content":{"rendered":"<h1>\u9996\u5148<\/h1>\n<p>\u5173\u4e8e\u4e4b\u524d\u4f7f\u7528\u7684\u77e2\u91cf\u74e6\u7247\u521b\u5efa\u7a0b\u5e8f\uff0c\u7531\u4e8e\u9700\u8981\u5347\u7ea7nodejs\u7248\u672c\uff0c\u6240\u4ee5\u9700\u8981\u6d4b\u8bd5\u4e3b\u8981\u7684nodejs\u6a21\u5757\u662f\u5426\u80fd\u5728nodejs v18\u4e0a\u8fd0\u884c\u3002<\/p>\n<p>\u6211\u6253\u7b97\u5728\u8fd9\u7bc7\u6587\u7ae0\u4e2d\u91cd\u65b0\u603b\u7ed3\u4e00\u4e0b\u5173\u4e8e\u4ecePostgreSQL\/PostGIS\u8bfb\u53d6\u6570\u636e\u548c\u4ee5GeoJSON\u5e8f\u5217\u65b9\u5f0f\u5199\u5165\u7684\u65b9\u6cd5\uff0c\u4ee5\u4fbf\u5728\u8fd9\u4e2a\u673a\u4f1a\u4e0a\u505a\u4e9b\u7b14\u8bb0\u3002<\/p>\n<p>\u8fd9\u6b21\u7684\u7ec3\u4e60\u4ed3\u5e93\u5728\u8fd9\u91cc\uff1ahttps:\/\/github.com\/ubukawa\/ex-postgis<\/p>\n<p>\u6b64\u5916\uff0c\u76ee\u524d\u6b63\u5728\u904b\u884c\u7684\u7a0b\u5f0f\u662f\u4f7f\u7528 nodejs v.16 \u904b\u884c\u7684\uff0c\u4f46\u5132\u5b58\u5eab\u4f4d\u65bc\u4ee5\u4e0b\u7db2\u5740\uff1ahttps:\/\/github.com\/unvt\/produce-gsc-6\u3002\u9019\u500b\u7a0b\u5f0f\u662f\u57fa\u65bc @hfu \u5148\u751f\u7684\u958b\u767c\u9032\u884c\u7684\u3002<\/p>\n<h2>\u8bf7\u6ce8\u610f<\/h2>\n<p>\u8fd9\u6b21\u7684\u7ec3\u4e60\u91cd\u70b9\u653e\u5728\u4f7f\u7528pg\u6a21\u5757\u5728PostgreSQL\u6570\u636e\u5e93\u4e2d\u8fdb\u884c\u8bbf\u95ee\u3002\u7701\u7565\u4e86\u4f7f\u7528\u5b50\u8fdb\u7a0b\u5c06\u6570\u636e\u4f20\u8f93\u5230\u77e2\u91cf\u74e6\u7247\u8f6c\u6362\u5de5\u5177\u4ee5\u53ca\u4f7f\u7528better-queue\u8fdb\u884c\u5904\u7406\u6570\u91cf\u63a7\u5236\u7684\u90e8\u5206\u3002<\/p>\n<h2>\u5b9e\u9a8c\u73af\u5883<\/h2>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Windows 10<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Windows PowerShell<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">nodejs version 18.12.1<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">npm version 8.19.2<\/ul>\n<h1>\u8fdb\u884c\u5b9e\u9a8c<\/h1>\n<p>\u6211\u521b\u5efa\u4e86\u4e00\u4e2a\u4ee3\u7801\u5e93\u3002\u5982\u524d\u6240\u8ff0\uff0c\u5b83\u4f4d\u4e8e https:\/\/github.com\/ubukawa\/ex-postgis\u3002<br \/>\n\u8bf7\u5b89\u88c5\u6240\u9700\u7684npm\u6a21\u5757\u3002<\/p>\n<pre class=\"post-pre\"><code>npm init -y\r\nnpm install --save config pg hjson\r\n<\/code><\/pre>\n<h2>\u5c1d\u8bd5\u8bbf\u95eePostgresql\u6570\u636e\u5e93<\/h2>\n<p>\u9996\u5148\uff0c\u6211\u4eec\u7b80\u5355\u5730\u8bbf\u95ee\u4e86\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u7f16\u5199\u7684\u5173\u7cfb\u56fe\u5c42\uff08relatiosn\uff09\u3002\u6211\u4eec\u9700\u8981\u6309\u7167\u4ee5\u4e0b\u65b9\u5f0f\u51c6\u5907konfig.default.hjson\u548ctest001.js\u6587\u4ef6\uff0c\u7136\u540e\u6267\u884c\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/14-0.png\" alt=\"image.png\" \/><\/div>\n<pre class=\"post-pre\"><code><span class=\"kd\">const<\/span> <span class=\"nx\">config<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">config<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"p\">{<\/span> <span class=\"nx\">Pool<\/span><span class=\"p\">,<\/span> <span class=\"nx\">Query<\/span> <span class=\"p\">}<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">pg<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"c1\">\/\/ config constants<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">host<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">host<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">port<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">port<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">dbUSer<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">dbUser<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">dbPassword<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">dbPassword<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">relations<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">relations<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"kd\">let<\/span> <span class=\"nx\">pools<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{}<\/span>\r\n\r\n<span class=\"k\">for <\/span><span class=\"p\">(<\/span><span class=\"nx\">relation<\/span> <span class=\"k\">of<\/span> <span class=\"nx\">relations<\/span><span class=\"p\">){<\/span>\r\n    <span class=\"kd\">const<\/span> <span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">,<\/span> <span class=\"nx\">schema<\/span><span class=\"p\">,<\/span> <span class=\"nx\">view<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">relation<\/span><span class=\"p\">.<\/span><span class=\"nf\">split<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">::<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"k\">if<\/span><span class=\"p\">(<\/span><span class=\"o\">!<\/span><span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">]){<\/span>\r\n        <span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Pool<\/span><span class=\"p\">({<\/span>\r\n            <span class=\"na\">host<\/span><span class=\"p\">:<\/span> <span class=\"nx\">host<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">user<\/span><span class=\"p\">:<\/span> <span class=\"nx\">dbUSer<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">port<\/span><span class=\"p\">:<\/span> <span class=\"nx\">port<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">password<\/span><span class=\"p\">:<\/span> <span class=\"nx\">dbPassword<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">database<\/span><span class=\"p\">:<\/span> <span class=\"nx\">database<\/span>\r\n        <span class=\"p\">})<\/span>\r\n    <span class=\"p\">}<\/span>\r\n    <span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">].<\/span><span class=\"nf\">connect<\/span><span class=\"p\">(<\/span><span class=\"k\">async <\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">,<\/span> <span class=\"nx\">client<\/span><span class=\"p\">,<\/span> <span class=\"nx\">release<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">if <\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">)<\/span> <span class=\"k\">throw<\/span> <span class=\"nx\">err<\/span>\r\n        <span class=\"c1\">\/\/let sql = `SELECT count(*) FROM ${schema}.${view} `<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">sql<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">`SELECT * FROM <\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">.<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\"> limit 1`<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">res<\/span> <span class=\"o\">=<\/span> <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"nx\">sql<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"nx\">res<\/span><span class=\"p\">.<\/span><span class=\"nx\">rows<\/span><span class=\"p\">)<\/span> <span class=\"c1\">\/\/rows contains sql response<\/span>\r\n        <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">end<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"nf\">release<\/span><span class=\"p\">()<\/span>\r\n    <span class=\"p\">})<\/span>    \r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<p>\u7531\u4e8egeom\u4e0d\u662f\u6587\u672c\u683c\u5f0f\uff0c\u56e0\u6b64\u5373\u4f7f\u770b\u5230\u5b83\u4e5f\u65e0\u6cd5\u7406\u89e3\u5176\u542b\u4e49\uff0c\u4f46\u6570\u636e\u5df2\u7ecf\u88ab\u6b63\u786e\u8bfb\u53d6\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/17-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u6709\u5173test001.js\u7684\u8981\u70b9\u5982\u4e0b\uff1a<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Pool\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u30a2\u30af\u30bb\u30b9\u60c5\u5831\u3092\u542b\u3093\u3060\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u308c\u308b\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Pool\u30af\u30e9\u30b9\u306econnect\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u306e\u5fdc\u7b54\uff08client\uff09\u306b\u5bfe\u3059\u308b\u51e6\u7406\u3092\u6c7a\u3081\u3066\u3044\u304f\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">connect\u3092\u975e\u540c\u671f\u51e6\u7406\u3067\u3084\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u3046\u307e\u304fawait\u3092\u4f7f\u3063\u305f\u308a\u3059\u308b\u3002pg\u306e\u8aac\u660e\u5206\u3092\u8aad\u3080\u3068\u3001promise\u3067\u3082\u51e6\u7406\u304c\u3067\u304d\u308b\u305d\u3046\u3060\u3002<\/ul>\n<h2>\u9605\u8bfb\u4e13\u680f\u540d\u79f0\uff08\u5c5e\u6027\u5217\u8868\uff09\uff0c\u63d0\u53d6\u5176\u4fe1\u606f\u3002<\/h2>\n<p>\u6211\u5c06\u8c03\u67e5\u4e13\u680f\u540d\u79f0\uff0c\u5e76\u53d6\u5f97\u76f8\u5173\u8bb0\u5f55\u3002\u5e76\u4e14\uff0c\u6211\u4f1a\u7a0d\u5fae\u5904\u7406\u4f4d\u7f6e\u4fe1\u606f\u7684geom\uff08\u4ee5St_AsGeoJSON\u7684\u5f62\u5f0f\u8bfb\u53d6\uff09\u5e76\u53d6\u5f97\u5b83\u3002<\/p>\n<p>test002.js\u7684\u5185\u5bb9\u5982\u4e0b\u6240\u793a\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"kd\">const<\/span> <span class=\"nx\">config<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">config<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"p\">{<\/span> <span class=\"nx\">Pool<\/span><span class=\"p\">,<\/span> <span class=\"nx\">Query<\/span> <span class=\"p\">}<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">pg<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"c1\">\/\/ config constants<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">host<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">host<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">port<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">port<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">dbUSer<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">dbUser<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">dbPassword<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">dbPassword<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">relations<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">relations<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"kd\">let<\/span> <span class=\"nx\">pools<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{}<\/span>\r\n\r\n<span class=\"k\">for <\/span><span class=\"p\">(<\/span><span class=\"nx\">relation<\/span> <span class=\"k\">of<\/span> <span class=\"nx\">relations<\/span><span class=\"p\">){<\/span>\r\n    <span class=\"kd\">const<\/span> <span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">,<\/span> <span class=\"nx\">schema<\/span><span class=\"p\">,<\/span> <span class=\"nx\">view<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">relation<\/span><span class=\"p\">.<\/span><span class=\"nf\">split<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">::<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"k\">if<\/span><span class=\"p\">(<\/span><span class=\"o\">!<\/span><span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">]){<\/span>\r\n        <span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Pool<\/span><span class=\"p\">({<\/span>\r\n            <span class=\"na\">host<\/span><span class=\"p\">:<\/span> <span class=\"nx\">host<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">user<\/span><span class=\"p\">:<\/span> <span class=\"nx\">dbUSer<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">port<\/span><span class=\"p\">:<\/span> <span class=\"nx\">port<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">password<\/span><span class=\"p\">:<\/span> <span class=\"nx\">dbPassword<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">database<\/span><span class=\"p\">:<\/span> <span class=\"nx\">database<\/span>\r\n        <span class=\"p\">})<\/span>\r\n    <span class=\"p\">}<\/span>\r\n    <span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">].<\/span><span class=\"nf\">connect<\/span><span class=\"p\">(<\/span><span class=\"k\">async <\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">,<\/span> <span class=\"nx\">client<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">if <\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">)<\/span> <span class=\"k\">throw<\/span> <span class=\"nx\">err<\/span>\r\n        <span class=\"c1\">\/\/Getting the list of columns, then adjust it<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">sql<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">`SELECT column_name FROM information_schema.columns WHERE table_schema = '<\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">' AND table_name = '<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\">' ORDER BY ordinal_position`<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">cols<\/span> <span class=\"o\">=<\/span> <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"nx\">sql<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nx\">cols<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">cols<\/span><span class=\"p\">.<\/span><span class=\"nx\">rows<\/span><span class=\"p\">.<\/span><span class=\"nf\">map<\/span><span class=\"p\">(<\/span><span class=\"nx\">r<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"nx\">r<\/span><span class=\"p\">.<\/span><span class=\"nx\">column_name<\/span><span class=\"p\">).<\/span><span class=\"nf\">filter<\/span><span class=\"p\">(<\/span><span class=\"nx\">r<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"nx\">r<\/span> <span class=\"o\">!==<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">geom<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span> <span class=\"c1\">\/\/choose \"rows\", then its colum_names are listed, and geom is removed.<\/span>\r\n        <span class=\"c1\">\/\/we will add filter if needed<\/span>\r\n        <span class=\"nx\">cols<\/span><span class=\"p\">.<\/span><span class=\"nf\">push<\/span><span class=\"p\">(<\/span><span class=\"s2\">`ST_AsGeoJSON(<\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">.<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\">.geom)`<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"c1\">\/\/console.log(`columns used: ${cols}`)<\/span>\r\n        <span class=\"c1\">\/\/ Then, we will get feature record.<\/span>\r\n        <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">BEGIN<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nx\">sql<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">`SELECT <\/span><span class=\"p\">${<\/span><span class=\"nx\">cols<\/span><span class=\"p\">.<\/span><span class=\"nf\">toString<\/span><span class=\"p\">()}<\/span><span class=\"s2\"> FROM <\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">.<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\">`<\/span>\r\n        <span class=\"nx\">cols<\/span> <span class=\"o\">=<\/span> <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"nx\">sql<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"nx\">cols<\/span><span class=\"p\">.<\/span><span class=\"nx\">rows<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">COMMIT<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">end<\/span><span class=\"p\">()<\/span>\r\n    <span class=\"p\">})<\/span>    \r\n<span class=\"p\">}<\/span>\r\n\r\n<\/code><\/pre>\n<p>test002.js \u7684\u8981\u70b9\u662f\uff1a<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u6700\u521d\u306esql\u3067\u306f\u5730\u7269\u3067\u306f\u306a\u304f\u3066\u3001information_schema.columns\u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u30d3\u30e5\u30fc\u306e\u6301\u3063\u3066\u3044\u308b\u5c5e\u6027\u3092\u8abf\u3079\u3066\u3044\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">client.query\u3067\u5e30\u3063\u3066\u304d\u305f\u5024\u306erows\u3092map\u3057\u3066\u3001column_name\u3092\u30a2\u30ec\u30fc\u306b\u3057\u3066\u3044\u307e\u3059\u3002\u305d\u3057\u3066\u305d\u3053\u304b\u3089geom\u3092\u53d6\u308a\u9664\u304d\u3001ST_AsGeoJSON\u3068\u3057\u3066\u8ffd\u52a0\u3057\u3066\u3044\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\u305d\u3046\u3057\u3066\u3068\u3063\u3066\u304d\u305f\u5c5e\u6027\u30ea\u30b9\u30c8\u3092\u4f7f\u3063\u3066\u3001client.query(`BEGIN`)\u3092\u307e\u3063\u3066\u3001\u5730\u7269\u3092SELECT\u3057\u3066\u3044\u304d\u307e\u3059\u3002\u3053\u3053\u306eawait client.query(&#8216;BEGIN&#8217;)\u3068\u304b\u3001await client.query(&#8216;COMMIT&#8217;)\u306f\u3001\u4f8b\u3048\u3070\u3053\u3053\u306e\u30da\u30fc\u30b8\uff08 https:\/\/node-postgres.com\/features\/transactions \uff09\u306a\u3069\u306b\u8aac\u660e\u304c\u3042\u308a\u307e\u3059\u3002<\/ul>\n<p>test002.js\u7684\u95ee\u9898\u662f\u6ca1\u6709\u4f7f\u7528\u6e38\u6807\u4ecePostgresql\u670d\u52a1\u5668\u83b7\u53d6\u6570\u636e\uff0c\u56e0\u6b64\u5f53\u6570\u636e\u91cf\u8f83\u5927\u65f6\uff0c\u4f1a\u4e00\u6b21\u6027\u8f93\u51fa\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/27-0.png\" alt=\"image.png\" \/><\/div>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/28-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u6211\u60f3\u7528\u9f20\u6807\u8fdb\u884c\u64cd\u4f5c\uff0c\u6240\u4ee5\u4e0b\u4e00\u6b65\u6211\u4eec\u6765\u7ec3\u4e60\u4f7f\u7528\u9f20\u6807\u3002<\/p>\n<h2>\u5728\u4f7f\u7528SELECT\u4e4b\u524d\u4f7f\u7528CUR\u3002<\/h2>\n<p>\u6211\u521b\u5efa\u4e86test003.js\u6587\u4ef6\u3002\u91cd\u70b9\u5982\u4e0b\u6240\u8ff0\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Postgresql\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078sql\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u3059\u308b\u524d\u306bcur\u3068\u3044\u3046cursor\u3092\u5ba3\u8a00\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u51fa\u3057\u306f\u3001FETCH ${fetchSize} FROM cur\u3067\u30ab\u30fc\u30bd\u30eb\u304b\u3089\u53d6\u308a\u51fa\u3059\u5f62\u3068\u306a\u308a\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">fetchSize\u306f\u30b3\u30f3\u30d5\u30a3\u30b0\u30d5\u30a1\u30a4\u30eb\u3067\u4e0e\u3048\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">\u30c7\u30fc\u30bf\u306e\u3068\u308a\u3060\u3059\u305f\u3081\u306e\u30d5\u30a1\u30f3\u30af\u30b7\u30e7\u30f3\uff08fetch\uff09\u306f\u5225\u9014\u72ec\u7acb\u3057\u3066\u4f5c\u3063\u3066\u304a\u304d\u3001\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u51fa\u3057\u3068\u540c\u6642\u306bGeoJSONSeq\u306b\u306a\u308b\u3088\u3046\u306a\u6574\u5f62\u3092\u3057\u3066\u304a\u304d\u307e\u3059<\/ul>\n<\/li>\n<\/ul>\n<p>\u5b9f\u969b\u306e\u5b9f\u88c5\u306e\u73fe\u5834\u3067\u306f\u3001modify.js\u3082\u4f7f\u3063\u3066\u30d9\u30af\u30c8\u30eb\u30bf\u30a4\u30eb\u5909\u63db\u7528\u306e\u60c5\u5831\uff08f.tippecanoe\uff09\u3082\u4ed8\u4e0e\u3057\u307e\u3059\u3002<br \/>\n\u308f\u308c\u308f\u308c\u304cPostGIS\u304b\u3089\u76f4\u63a5ST_AsMVT\u3092\u4f7f\u3063\u3066\u3044\u306a\u3044\u7406\u7531\u304c\u3053\u3053\u3067\u3059\u3002\u30d3\u30e5\u30fc\u3084\u305d\u306e\u5c5e\u6027\u306b\u5fdc\u3058\u3066\u6700\u5927\u30fb\u6700\u5c0f\u30ba\u30fc\u30e0\u30ec\u30d9\u30eb\u306e\u8a2d\u5b9a\u3084\u3001\u30d9\u30af\u30c8\u30eb\u30bf\u30a4\u30eb\u306e\u30ec\u30a4\u30e4\u540d\u3092\u4ed8\u3051\u305f\u3044\u3002\u3042\u308b\u3044\u306f\u3001\u5c5e\u6027\u306b\u5fdc\u3058\u3066\u65b0\u3057\u3044\u5c5e\u6027\u3092\u4e0e\u3048\u308b\u3068\u304b\u3001\u30bd\u30fc\u30b9\u3068\u306a\u308bPostGIS\u3067\u8abf\u6574\u3059\u308b\u306e\u3067\u306f\u306a\u304f\u3066\u3001\u5909\u63db\u306e\u9014\u4e2d\u3067\u67d4\u8edf\u306b\u30d9\u30af\u30c8\u30eb\u30bf\u30a4\u30eb\u3092\u4f5c\u3063\u3066\u3044\u304d\u305f\u3044\u3068\u601d\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>connect\u306e\u6700\u5f8c\u306b\u63a5\u7d9a\u3092\u7d42\u308f\u308a\u306b\u3059\u308b\u3068\u304d\u3001connect\u306erelease()\u3060\u3051\u3067\u3088\u3044\u306e\u304b\u3001client.end()\u306b\u3057\u305f\u65b9\u304c\u3088\u3044\u306e\u304b\u3088\u304f\u308f\u304b\u3089\u306a\u3044\u3002client.end()\u3092\u5165\u308c\u305f\u65b9\u304c\u30c7\u30fc\u30bf\u5909\u63db\u5f8c\u306b\u65e9\u304f\u30d7\u30ed\u30f3\u30d7\u30c8\u753b\u9762\u306b\u623b\u308b\u6c17\u304c\u3059\u308b\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/33-0.png\" alt=\"image.png\" \/><\/div>\n<pre class=\"post-pre\"><code><span class=\"kd\">const<\/span> <span class=\"nx\">config<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">config<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"p\">{<\/span> <span class=\"nx\">Pool<\/span><span class=\"p\">,<\/span> <span class=\"nx\">Query<\/span> <span class=\"p\">}<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">pg<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"c1\">\/\/ config constants<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">host<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">host<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">port<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">port<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">dbUSer<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">dbUser<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">dbPassword<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">dbPassword<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">relations<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">relations<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">fetchSize<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">fetchSize<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"kd\">let<\/span> <span class=\"nx\">pools<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{}<\/span>\r\n\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">fetch<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"nx\">client<\/span><span class=\"p\">,<\/span> <span class=\"nx\">database<\/span><span class=\"p\">,<\/span> <span class=\"nx\">view<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span><span class=\"p\">{<\/span>\r\n    <span class=\"k\">return<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Promise<\/span><span class=\"p\">((<\/span><span class=\"nx\">resolve<\/span><span class=\"p\">,<\/span> <span class=\"nx\">reject<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">count<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">0<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">features<\/span> <span class=\"o\">=<\/span> <span class=\"p\">[]<\/span>\r\n        <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"k\">new<\/span> <span class=\"nc\">Query<\/span><span class=\"p\">(<\/span><span class=\"s2\">`FETCH <\/span><span class=\"p\">${<\/span><span class=\"nx\">fetchSize<\/span><span class=\"p\">}<\/span><span class=\"s2\"> FROM cur`<\/span><span class=\"p\">))<\/span>\r\n        <span class=\"p\">.<\/span><span class=\"nf\">on<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">row<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"nx\">row<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"kd\">let<\/span> <span class=\"nx\">f<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\r\n                <span class=\"na\">type<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">Feature<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\r\n                <span class=\"na\">properties<\/span><span class=\"p\">:<\/span> <span class=\"nx\">row<\/span><span class=\"p\">,<\/span>\r\n                <span class=\"na\">geometry<\/span><span class=\"p\">:<\/span> <span class=\"nx\">JSON<\/span><span class=\"p\">.<\/span><span class=\"nf\">parse<\/span><span class=\"p\">(<\/span><span class=\"nx\">row<\/span><span class=\"p\">.<\/span><span class=\"nx\">st_asgeojson<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"p\">}<\/span>\r\n            <span class=\"k\">delete<\/span> <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">properties<\/span><span class=\"p\">.<\/span><span class=\"nx\">st_asgeojson<\/span>\r\n            <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">properties<\/span><span class=\"p\">.<\/span><span class=\"nx\">_database<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">database<\/span>\r\n            <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">properties<\/span><span class=\"p\">.<\/span><span class=\"nx\">_view<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">view<\/span>\r\n            <span class=\"nx\">count<\/span><span class=\"o\">++<\/span>\r\n            <span class=\"c1\">\/\/f = modify(f)<\/span>\r\n            <span class=\"k\">if <\/span><span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)<\/span> <span class=\"nx\">features<\/span><span class=\"p\">.<\/span><span class=\"nf\">push<\/span><span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"p\">})<\/span>\r\n        <span class=\"p\">.<\/span><span class=\"nf\">on<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">error<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"nx\">err<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">error<\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">.<\/span><span class=\"nx\">stack<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">reject<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"p\">})<\/span>\r\n        <span class=\"p\">.<\/span><span class=\"nf\">on<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">end<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"k\">async <\/span><span class=\"p\">()<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"k\">for <\/span><span class=\"p\">(<\/span><span class=\"nx\">f<\/span> <span class=\"k\">of<\/span> <span class=\"nx\">features<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n                <span class=\"k\">try<\/span> <span class=\"p\">{<\/span>\r\n                    <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)<\/span>\r\n                <span class=\"p\">}<\/span> <span class=\"k\">catch <\/span><span class=\"p\">(<\/span><span class=\"nx\">e<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n                    <span class=\"k\">throw<\/span> <span class=\"nx\">e<\/span>\r\n                <span class=\"p\">}<\/span>                \r\n            <span class=\"p\">}<\/span> \r\n            <span class=\"nf\">resolve<\/span><span class=\"p\">(<\/span><span class=\"nx\">count<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"p\">})<\/span>\r\n    <span class=\"p\">})<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"k\">for <\/span><span class=\"p\">(<\/span><span class=\"nx\">relation<\/span> <span class=\"k\">of<\/span> <span class=\"nx\">relations<\/span><span class=\"p\">){<\/span>\r\n    <span class=\"kd\">var<\/span> <span class=\"nx\">startTime<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Date<\/span><span class=\"p\">()<\/span>\r\n    <span class=\"kd\">const<\/span> <span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">,<\/span> <span class=\"nx\">schema<\/span><span class=\"p\">,<\/span> <span class=\"nx\">view<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">relation<\/span><span class=\"p\">.<\/span><span class=\"nf\">split<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">::<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"k\">if<\/span><span class=\"p\">(<\/span><span class=\"o\">!<\/span><span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">]){<\/span>\r\n        <span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Pool<\/span><span class=\"p\">({<\/span>\r\n            <span class=\"na\">host<\/span><span class=\"p\">:<\/span> <span class=\"nx\">host<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">user<\/span><span class=\"p\">:<\/span> <span class=\"nx\">dbUSer<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">port<\/span><span class=\"p\">:<\/span> <span class=\"nx\">port<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">password<\/span><span class=\"p\">:<\/span> <span class=\"nx\">dbPassword<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">database<\/span><span class=\"p\">:<\/span> <span class=\"nx\">database<\/span>\r\n        <span class=\"p\">})<\/span>\r\n    <span class=\"p\">}<\/span>\r\n    <span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">].<\/span><span class=\"nf\">connect<\/span><span class=\"p\">(<\/span><span class=\"k\">async <\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">,<\/span> <span class=\"nx\">client<\/span><span class=\"p\">,<\/span><span class=\"nx\">release<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">if <\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">)<\/span> <span class=\"k\">throw<\/span> <span class=\"nx\">err<\/span>\r\n        <span class=\"c1\">\/\/Getting the list of columns, then adjust it<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">sql<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">`SELECT column_name FROM information_schema.columns WHERE table_schema = '<\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">' AND table_name = '<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\">' ORDER BY ordinal_position`<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">cols<\/span> <span class=\"o\">=<\/span> <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"nx\">sql<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nx\">cols<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">cols<\/span><span class=\"p\">.<\/span><span class=\"nx\">rows<\/span><span class=\"p\">.<\/span><span class=\"nf\">map<\/span><span class=\"p\">(<\/span><span class=\"nx\">r<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"nx\">r<\/span><span class=\"p\">.<\/span><span class=\"nx\">column_name<\/span><span class=\"p\">).<\/span><span class=\"nf\">filter<\/span><span class=\"p\">(<\/span><span class=\"nx\">r<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"nx\">r<\/span> <span class=\"o\">!==<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">geom<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span> <span class=\"c1\">\/\/choose \"rows\", then its colum_names are listed, and geom is removed.<\/span>\r\n        <span class=\"c1\">\/\/we will add filter if needed<\/span>\r\n        <span class=\"nx\">cols<\/span><span class=\"p\">.<\/span><span class=\"nf\">push<\/span><span class=\"p\">(<\/span><span class=\"s2\">`ST_AsGeoJSON(<\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">.<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\">.geom)`<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"c1\">\/\/console.log(`columns used: ${cols}`)<\/span>\r\n        <span class=\"c1\">\/\/ Then, we will get feature record.<\/span>\r\n        <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">BEGIN<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nx\">sql<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">`\r\n        DECLARE cur CURSOR FOR \r\n        SELECT <\/span><span class=\"p\">${<\/span><span class=\"nx\">cols<\/span><span class=\"p\">.<\/span><span class=\"nf\">toString<\/span><span class=\"p\">()}<\/span><span class=\"s2\"> FROM <\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">.<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\">`<\/span>\r\n        <span class=\"nx\">cols<\/span> <span class=\"o\">=<\/span> <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"nx\">sql<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"c1\">\/\/console.log(cols.rows)<\/span>\r\n        <span class=\"k\">try<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"k\">while <\/span><span class=\"p\">(<\/span><span class=\"k\">await<\/span> <span class=\"nf\">fetch<\/span><span class=\"p\">(<\/span><span class=\"nx\">client<\/span><span class=\"p\">,<\/span> <span class=\"nx\">database<\/span><span class=\"p\">,<\/span> <span class=\"nx\">view<\/span><span class=\"p\">)<\/span> <span class=\"o\">!==<\/span> <span class=\"mi\">0<\/span><span class=\"p\">)<\/span> <span class=\"p\">{}<\/span>\r\n        <span class=\"p\">}<\/span> <span class=\"k\">catch <\/span><span class=\"p\">(<\/span><span class=\"nx\">e<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span> <span class=\"k\">throw<\/span> <span class=\"nx\">e<\/span> <span class=\"p\">}<\/span>\r\n        <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"s2\">`COMMIT`<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"c1\">\/\/await client.end()  <\/span>\r\n        <span class=\"kd\">const<\/span> <span class=\"nx\">endTime<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Date<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"kd\">var<\/span> <span class=\"nx\">diff<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">endTime<\/span><span class=\"p\">.<\/span><span class=\"nf\">getTime<\/span><span class=\"p\">()<\/span> <span class=\"o\">-<\/span> <span class=\"nx\">startTime<\/span><span class=\"p\">.<\/span><span class=\"nf\">getTime<\/span><span class=\"p\">();<\/span>\r\n        <span class=\"kd\">var<\/span> <span class=\"nx\">workTime<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">diff<\/span> <span class=\"o\">\/<\/span> <span class=\"mi\">1000<\/span>\r\n        <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"s2\">`workingTime for <\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">.<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\"> in <\/span><span class=\"p\">${<\/span><span class=\"nx\">database<\/span><span class=\"p\">}<\/span><span class=\"s2\"> is <\/span><span class=\"p\">${<\/span><span class=\"nx\">workTime<\/span><span class=\"p\">}<\/span><span class=\"s2\"> (sec). End`<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nf\">release<\/span><span class=\"p\">()<\/span>\r\n    <span class=\"p\">})<\/span>    \r\n<span class=\"p\">}<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u6b64\u5916\uff0c\u6211\u5011\u5728\u9014\u4e2d\u8a08\u7b97\u4e86\u6642\u9593\uff0c\u4ee5\u4e86\u89e3\u55ae\u500b\u5c64\u9762\uff08\u8996\u5716\uff09\u7684\u8b80\u53d6\u5927\u5c0f\u5c0d\u5176\u7522\u751f\u7684\u5f71\u97ff\u3002\u8a72\u8cc7\u6599\u5305\u542b10,510\u7b46\u8a18\u9304\uff08\u7dda\u6027\u6578\u64da\uff09\u3002<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/36-0.png\" alt=\"image.png\" \/><\/div>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/37-3.png\" alt=\"image.png\" \/><\/div>\n<p>\u4e00\u822c\u800c\u8a00\uff0c\u5982\u679c\u83b7\u53d6\u6570\u636e\u5927\u5c0f\u8f83\u5c0f\uff0c\u5219\u6d41\u91cf\u4f1a\u9010\u6e10\u589e\u52a0\uff1b\u5982\u679c\u83b7\u53d6\u6570\u636e\u5927\u5c0f\u8f83\u5927\uff0c\u5219\u4f1a\u8fc5\u901f\u8bfb\u53d6\u3002\u76ee\u524d\uff0c\u6211\u5728\u5b9e\u73b0\u4e2d\u5c06fetch\u5927\u5c0f\u8bbe\u7f6e\u4e3a30,000\u3002<\/p>\n<h2>\u4f7f\u7528modify.js\u5bf9\u4ecePostgreSQL\u4e2d\u8bfb\u53d6\u7684\u6570\u636e\u8fdb\u884c\u52a0\u5de5\u5904\u7406<\/h2>\n<p>\u6211\u4f1a\u521b\u5efa\u4ee5\u4e0b\u7684modify.js\u3002\u4e3a\u4e86\u7b80\u5355\u8d77\u89c1\uff0cmodify.js\u5df2\u7ecf\u88ab\u7b80\u5316\u4e86\uff0c\u4f46\u5728\u5b9e\u9645\u5b9e\u73b0\u65f6\u53ef\u4ee5\u6839\u636e\u6bcf\u4e2a\u5c42\u548c\u6761\u4ef6\u8fdb\u884c\u4fee\u6539\u3002\u5c06test003.js\u590d\u5236\u4e3atest004.js\uff0c\u5e76\u5728\u4e2d\u95f4\u6dfb\u52a0\u4e00\u884cf = modify(f)\u6765\u5f15\u7528modify\u6a21\u5757\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"kd\">const<\/span> <span class=\"nx\">preProcess<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">tippecanoe<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"na\">layer<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">other<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"na\">minzoom<\/span><span class=\"p\">:<\/span> <span class=\"mi\">15<\/span><span class=\"p\">,<\/span>\r\n        <span class=\"na\">maxzoom<\/span><span class=\"p\">:<\/span> <span class=\"mi\">15<\/span>\r\n    <span class=\"p\">}<\/span>\r\n    <span class=\"k\">return<\/span> <span class=\"nx\">f<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">postProcess<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">delete<\/span> <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">properties<\/span><span class=\"p\">[<\/span><span class=\"dl\">'<\/span><span class=\"s1\">_database<\/span><span class=\"dl\">'<\/span><span class=\"p\">]<\/span>\r\n    <span class=\"k\">delete<\/span> <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">properties<\/span><span class=\"p\">[<\/span><span class=\"dl\">'<\/span><span class=\"s1\">_view<\/span><span class=\"dl\">'<\/span><span class=\"p\">]<\/span>\r\n    <span class=\"k\">return<\/span> <span class=\"nx\">f<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">layerEdit<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"na\">unmap_popp_p<\/span><span class=\"p\">:<\/span> <span class=\"nx\">f<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">tippecanoe<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"na\">layer<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">testLayer1-point<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">minzoom<\/span><span class=\"p\">:<\/span> <span class=\"mi\">3<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">maxzoom<\/span><span class=\"p\">:<\/span> <span class=\"mi\">6<\/span>\r\n        <span class=\"p\">}<\/span>\r\n        <span class=\"c1\">\/\/write someting to adjust properties, if needed<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"nx\">f<\/span>\r\n    <span class=\"p\">},<\/span>\r\n    <span class=\"na\">unmap_bndl25_l<\/span><span class=\"p\">:<\/span> <span class=\"nx\">f<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">tippecanoe<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"na\">layer<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">testLayer2-line<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">minzoom<\/span><span class=\"p\">:<\/span> <span class=\"mi\">4<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">maxzoom<\/span><span class=\"p\">:<\/span> <span class=\"mi\">5<\/span>\r\n        <span class=\"p\">}<\/span>\r\n        <span class=\"c1\">\/\/write someting to adjust properties, if needed<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"nx\">f<\/span>\r\n    <span class=\"p\">}<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"nx\">module<\/span><span class=\"p\">.<\/span><span class=\"nx\">exports<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">return<\/span> <span class=\"nf\">postProcess<\/span><span class=\"p\">(<\/span><span class=\"nx\">layerEdit<\/span><span class=\"p\">[<\/span><span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">properties<\/span><span class=\"p\">.<\/span><span class=\"nx\">_view<\/span><span class=\"p\">](<\/span><span class=\"nf\">preProcess<\/span><span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)))<\/span>\r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/42-0.png\" alt=\"image.png\" \/><\/div>\n<h2>\u5c06\u6570\u636e\u5199\u5165\u6587\u4ef6<\/h2>\n<p>\u5728\u5b9e\u9645\u7684\u5b9e\u73b0\u4e2d\uff0c\u4ecePostgreSQL\u4e2d\u8bfb\u53d6\u7684\u4fe1\u606f\u5c06\u76f4\u63a5\u4f20\u9012\u7ed9\u77e2\u91cf\u56fe\u8f6c\u6362\u5de5\u5177tippecanoe\uff0c\u800c\u4e0d\u9700\u8981\u5c06\u5176\u8bb0\u5f55\u4e3a\u4e2d\u95f4\u6587\u4ef6\u3002\u5728\u8fd9\u91cc\uff0c\u4e3a\u4e86Downstream\u7684\u7ec3\u4e60\uff0c\u6211\u4eec\u5c06\u4f7f\u7528fs\u6a21\u5757\u5c06\u4fe1\u606f\u5199\u5165\u6587\u4ef6\u8fdb\u884c\u7ec3\u4e60\u3002\u5c06test004.js\u590d\u5236\u4e3atest005.js\u7136\u540e\u8fdb\u884c\u7f16\u8f91\u3002\u5728config\/default.hjson\u4e2d\u6307\u5b9a\u8f93\u51fa\u6587\u4ef6\u5939\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"n\">npm<\/span> <span class=\"nx\">install<\/span> <span class=\"nt\">--save<\/span> <span class=\"nx\">fs<\/span>\r\n<span class=\"n\">mkdir<\/span> <span class=\"nx\">outText<\/span> \r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"kd\">const<\/span> <span class=\"nx\">config<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">config<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"p\">{<\/span> <span class=\"nx\">Pool<\/span><span class=\"p\">,<\/span> <span class=\"nx\">Query<\/span> <span class=\"p\">}<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">pg<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">modify<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">.\/modify.js<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">fs<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">require<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">fs<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"c1\">\/\/ config constants<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">host<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">host<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">port<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">port<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">dbUSer<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">dbUser<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">dbPassword<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">dbPassword<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">relations<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">relations<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">fetchSize<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">fetchSize<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">outTextDir<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">config<\/span><span class=\"p\">.<\/span><span class=\"nf\">get<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">outTextDir<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n\r\n<span class=\"kd\">let<\/span> <span class=\"nx\">pools<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{}<\/span>\r\n\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">noPressureWrite<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"nx\">stream<\/span><span class=\"p\">,<\/span> <span class=\"nx\">f<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n    <span class=\"k\">return<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Promise<\/span><span class=\"p\">((<\/span><span class=\"nx\">res<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">if <\/span><span class=\"p\">(<\/span><span class=\"nx\">stream<\/span><span class=\"p\">.<\/span><span class=\"nf\">write<\/span><span class=\"p\">(<\/span><span class=\"s2\">`\\x1e<\/span><span class=\"p\">${<\/span><span class=\"nx\">JSON<\/span><span class=\"p\">.<\/span><span class=\"nf\">stringify<\/span><span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)}<\/span><span class=\"s2\">\\n`<\/span><span class=\"p\">)){<\/span>\r\n            <span class=\"nf\">res<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"p\">}<\/span> <span class=\"k\">else<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"nx\">stream<\/span><span class=\"p\">.<\/span><span class=\"nf\">once<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">drain<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"p\">()<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n                <span class=\"nf\">res<\/span><span class=\"p\">()<\/span>\r\n            <span class=\"p\">})<\/span>\r\n        <span class=\"p\">}<\/span>\r\n    <span class=\"p\">})<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n<span class=\"kd\">const<\/span> <span class=\"nx\">fetch<\/span> <span class=\"o\">=<\/span> <span class=\"p\">(<\/span><span class=\"nx\">client<\/span><span class=\"p\">,<\/span> <span class=\"nx\">database<\/span><span class=\"p\">,<\/span> <span class=\"nx\">view<\/span><span class=\"p\">,<\/span> <span class=\"nx\">stream<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span><span class=\"p\">{<\/span>\r\n    <span class=\"k\">return<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Promise<\/span><span class=\"p\">((<\/span><span class=\"nx\">resolve<\/span><span class=\"p\">,<\/span> <span class=\"nx\">reject<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">count<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">0<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">features<\/span> <span class=\"o\">=<\/span> <span class=\"p\">[]<\/span>\r\n        <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"k\">new<\/span> <span class=\"nc\">Query<\/span><span class=\"p\">(<\/span><span class=\"s2\">`FETCH <\/span><span class=\"p\">${<\/span><span class=\"nx\">fetchSize<\/span><span class=\"p\">}<\/span><span class=\"s2\"> FROM cur`<\/span><span class=\"p\">))<\/span>\r\n        <span class=\"p\">.<\/span><span class=\"nf\">on<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">row<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"nx\">row<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"kd\">let<\/span> <span class=\"nx\">f<\/span> <span class=\"o\">=<\/span> <span class=\"p\">{<\/span>\r\n                <span class=\"na\">type<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">Feature<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span>\r\n                <span class=\"na\">properties<\/span><span class=\"p\">:<\/span> <span class=\"nx\">row<\/span><span class=\"p\">,<\/span>\r\n                <span class=\"na\">geometry<\/span><span class=\"p\">:<\/span> <span class=\"nx\">JSON<\/span><span class=\"p\">.<\/span><span class=\"nf\">parse<\/span><span class=\"p\">(<\/span><span class=\"nx\">row<\/span><span class=\"p\">.<\/span><span class=\"nx\">st_asgeojson<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"p\">}<\/span>\r\n            <span class=\"k\">delete<\/span> <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">properties<\/span><span class=\"p\">.<\/span><span class=\"nx\">st_asgeojson<\/span>\r\n            <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">properties<\/span><span class=\"p\">.<\/span><span class=\"nx\">_database<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">database<\/span>\r\n            <span class=\"nx\">f<\/span><span class=\"p\">.<\/span><span class=\"nx\">properties<\/span><span class=\"p\">.<\/span><span class=\"nx\">_view<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">view<\/span>\r\n            <span class=\"nx\">count<\/span><span class=\"o\">++<\/span>\r\n            <span class=\"nx\">f<\/span> <span class=\"o\">=<\/span> <span class=\"nf\">modify<\/span><span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"k\">if <\/span><span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)<\/span> <span class=\"nx\">features<\/span><span class=\"p\">.<\/span><span class=\"nf\">push<\/span><span class=\"p\">(<\/span><span class=\"nx\">f<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"p\">})<\/span>\r\n        <span class=\"p\">.<\/span><span class=\"nf\">on<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">error<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"nx\">err<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">error<\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">.<\/span><span class=\"nx\">stack<\/span><span class=\"p\">)<\/span>\r\n            <span class=\"nf\">reject<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"p\">})<\/span>\r\n        <span class=\"p\">.<\/span><span class=\"nf\">on<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">end<\/span><span class=\"dl\">'<\/span><span class=\"p\">,<\/span> <span class=\"k\">async <\/span><span class=\"p\">()<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"k\">for <\/span><span class=\"p\">(<\/span><span class=\"nx\">f<\/span> <span class=\"k\">of<\/span> <span class=\"nx\">features<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n                <span class=\"k\">try<\/span> <span class=\"p\">{<\/span>\r\n                    <span class=\"c1\">\/\/console.log(f)<\/span>\r\n                    <span class=\"k\">await<\/span> <span class=\"nf\">noPressureWrite<\/span><span class=\"p\">(<\/span><span class=\"nx\">stream<\/span><span class=\"p\">,<\/span> <span class=\"nx\">f<\/span><span class=\"p\">)<\/span>\r\n                <span class=\"p\">}<\/span> <span class=\"k\">catch <\/span><span class=\"p\">(<\/span><span class=\"nx\">e<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span>\r\n                    <span class=\"k\">throw<\/span> <span class=\"nx\">e<\/span>\r\n                <span class=\"p\">}<\/span>                \r\n            <span class=\"p\">}<\/span> \r\n            <span class=\"nx\">stream<\/span><span class=\"p\">.<\/span><span class=\"nf\">end<\/span><span class=\"p\">()<\/span>\r\n            <span class=\"nf\">resolve<\/span><span class=\"p\">(<\/span><span class=\"nx\">count<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"p\">})<\/span>\r\n    <span class=\"p\">})<\/span>\r\n<span class=\"p\">}<\/span>\r\n\r\n\r\n\r\n<span class=\"k\">for <\/span><span class=\"p\">(<\/span><span class=\"nx\">relation<\/span> <span class=\"k\">of<\/span> <span class=\"nx\">relations<\/span><span class=\"p\">){<\/span>\r\n    <span class=\"kd\">var<\/span> <span class=\"nx\">startTime<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Date<\/span><span class=\"p\">()<\/span>\r\n    <span class=\"kd\">const<\/span> <span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">,<\/span> <span class=\"nx\">schema<\/span><span class=\"p\">,<\/span> <span class=\"nx\">view<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">relation<\/span><span class=\"p\">.<\/span><span class=\"nf\">split<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">::<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"kd\">const<\/span> <span class=\"nx\">stream<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">fs<\/span><span class=\"p\">.<\/span><span class=\"nf\">createWriteStream<\/span><span class=\"p\">(<\/span><span class=\"s2\">`<\/span><span class=\"p\">${<\/span><span class=\"nx\">outTextDir<\/span><span class=\"p\">}<\/span><span class=\"s2\">\/<\/span><span class=\"p\">${<\/span><span class=\"nx\">database<\/span><span class=\"p\">}<\/span><span class=\"s2\">-<\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">-<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\">.txt`<\/span><span class=\"p\">)<\/span>\r\n    <span class=\"k\">if<\/span><span class=\"p\">(<\/span><span class=\"o\">!<\/span><span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">]){<\/span>\r\n        <span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Pool<\/span><span class=\"p\">({<\/span>\r\n            <span class=\"na\">host<\/span><span class=\"p\">:<\/span> <span class=\"nx\">host<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">user<\/span><span class=\"p\">:<\/span> <span class=\"nx\">dbUSer<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">port<\/span><span class=\"p\">:<\/span> <span class=\"nx\">port<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">password<\/span><span class=\"p\">:<\/span> <span class=\"nx\">dbPassword<\/span><span class=\"p\">,<\/span>\r\n            <span class=\"na\">database<\/span><span class=\"p\">:<\/span> <span class=\"nx\">database<\/span>\r\n        <span class=\"p\">})<\/span>\r\n    <span class=\"p\">}<\/span>\r\n    <span class=\"nx\">pools<\/span><span class=\"p\">[<\/span><span class=\"nx\">database<\/span><span class=\"p\">].<\/span><span class=\"nf\">connect<\/span><span class=\"p\">(<\/span><span class=\"k\">async <\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">,<\/span> <span class=\"nx\">client<\/span><span class=\"p\">,<\/span><span class=\"nx\">release<\/span><span class=\"p\">)<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"p\">{<\/span>\r\n        <span class=\"k\">if <\/span><span class=\"p\">(<\/span><span class=\"nx\">err<\/span><span class=\"p\">)<\/span> <span class=\"k\">throw<\/span> <span class=\"nx\">err<\/span>\r\n        <span class=\"c1\">\/\/Getting the list of columns, then adjust it<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">sql<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">`SELECT column_name FROM information_schema.columns WHERE table_schema = '<\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">' AND table_name = '<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\">' ORDER BY ordinal_position`<\/span>\r\n        <span class=\"kd\">let<\/span> <span class=\"nx\">cols<\/span> <span class=\"o\">=<\/span> <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"nx\">sql<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nx\">cols<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">cols<\/span><span class=\"p\">.<\/span><span class=\"nx\">rows<\/span><span class=\"p\">.<\/span><span class=\"nf\">map<\/span><span class=\"p\">(<\/span><span class=\"nx\">r<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"nx\">r<\/span><span class=\"p\">.<\/span><span class=\"nx\">column_name<\/span><span class=\"p\">).<\/span><span class=\"nf\">filter<\/span><span class=\"p\">(<\/span><span class=\"nx\">r<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"nx\">r<\/span> <span class=\"o\">!==<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">geom<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span> <span class=\"c1\">\/\/choose \"rows\", then its colum_names are listed, and geom is removed.<\/span>\r\n        <span class=\"c1\">\/\/we will add filter if needed<\/span>\r\n        <span class=\"nx\">cols<\/span><span class=\"p\">.<\/span><span class=\"nf\">push<\/span><span class=\"p\">(<\/span><span class=\"s2\">`ST_AsGeoJSON(<\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">.<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\">.geom)`<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"c1\">\/\/console.log(`columns used: ${cols}`)<\/span>\r\n        <span class=\"c1\">\/\/ Then, we will get feature record.<\/span>\r\n        <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"dl\">'<\/span><span class=\"s1\">BEGIN<\/span><span class=\"dl\">'<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nx\">sql<\/span> <span class=\"o\">=<\/span> <span class=\"s2\">`\r\n        DECLARE cur CURSOR FOR \r\n        SELECT <\/span><span class=\"p\">${<\/span><span class=\"nx\">cols<\/span><span class=\"p\">.<\/span><span class=\"nf\">toString<\/span><span class=\"p\">()}<\/span><span class=\"s2\"> FROM <\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">.<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\">`<\/span>\r\n        <span class=\"nx\">cols<\/span> <span class=\"o\">=<\/span> <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"nx\">sql<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"c1\">\/\/console.log(cols.rows)<\/span>\r\n        <span class=\"k\">try<\/span> <span class=\"p\">{<\/span>\r\n            <span class=\"k\">while <\/span><span class=\"p\">(<\/span><span class=\"k\">await<\/span> <span class=\"nf\">fetch<\/span><span class=\"p\">(<\/span><span class=\"nx\">client<\/span><span class=\"p\">,<\/span> <span class=\"nx\">database<\/span><span class=\"p\">,<\/span> <span class=\"nx\">view<\/span><span class=\"p\">,<\/span> <span class=\"nx\">stream<\/span><span class=\"p\">)<\/span> <span class=\"o\">!==<\/span> <span class=\"mi\">0<\/span><span class=\"p\">)<\/span> <span class=\"p\">{}<\/span>\r\n        <span class=\"p\">}<\/span> <span class=\"k\">catch <\/span><span class=\"p\">(<\/span><span class=\"nx\">e<\/span><span class=\"p\">)<\/span> <span class=\"p\">{<\/span> <span class=\"k\">throw<\/span> <span class=\"nx\">e<\/span> <span class=\"p\">}<\/span>\r\n        <span class=\"k\">await<\/span> <span class=\"nx\">client<\/span><span class=\"p\">.<\/span><span class=\"nf\">query<\/span><span class=\"p\">(<\/span><span class=\"s2\">`COMMIT`<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"c1\">\/\/await client.end()  <\/span>\r\n        <span class=\"kd\">const<\/span> <span class=\"nx\">endTime<\/span> <span class=\"o\">=<\/span> <span class=\"k\">new<\/span> <span class=\"nc\">Date<\/span><span class=\"p\">()<\/span>\r\n        <span class=\"kd\">var<\/span> <span class=\"nx\">diff<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">endTime<\/span><span class=\"p\">.<\/span><span class=\"nf\">getTime<\/span><span class=\"p\">()<\/span> <span class=\"o\">-<\/span> <span class=\"nx\">startTime<\/span><span class=\"p\">.<\/span><span class=\"nf\">getTime<\/span><span class=\"p\">();<\/span>\r\n        <span class=\"kd\">var<\/span> <span class=\"nx\">workTime<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">diff<\/span> <span class=\"o\">\/<\/span> <span class=\"mi\">1000<\/span>\r\n        <span class=\"nx\">console<\/span><span class=\"p\">.<\/span><span class=\"nf\">log<\/span><span class=\"p\">(<\/span><span class=\"s2\">`workingTime for <\/span><span class=\"p\">${<\/span><span class=\"nx\">schema<\/span><span class=\"p\">}<\/span><span class=\"s2\">.<\/span><span class=\"p\">${<\/span><span class=\"nx\">view<\/span><span class=\"p\">}<\/span><span class=\"s2\"> in <\/span><span class=\"p\">${<\/span><span class=\"nx\">database<\/span><span class=\"p\">}<\/span><span class=\"s2\"> is <\/span><span class=\"p\">${<\/span><span class=\"nx\">workTime<\/span><span class=\"p\">}<\/span><span class=\"s2\"> (sec). End`<\/span><span class=\"p\">)<\/span>\r\n        <span class=\"nf\">release<\/span><span class=\"p\">()<\/span>\r\n    <span class=\"p\">})<\/span>    \r\n<span class=\"p\">}<\/span>\r\n<\/code><\/pre>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/47-1.png\" alt=\"image.png\" \/><\/div>\n<h1>\u603b\u7ed3<\/h1>\n<p>\u6211\u5728\u8fd9\u91cc\u8bb0\u5f55\u4e86\u4f7f\u7528npm\u7684pg\u6a21\u5757\u4ecePostgreSQL\u6570\u636e\u5e93\u4e2d\u8bfb\u53d6\u6570\u636e\u7684\u65b9\u6cd5\u3002\u6211\u8fd8\u4f7f\u7528\u4e86\u4e00\u79cd\u5904\u7406\u7531PostGIS\u7ba1\u7406\u7684\u5730\u7406\u4f4d\u7f6e\u4fe1\u606f\u7684\u65b9\u6cd5\uff0c\u5373St_AsGeoJSON\u3002\u6211\u4eec\u8fdb\u884c\u4e86\u4ecetest001.js\u5230test005.js\u7684\u6d4b\u8bd5\uff0c\u6bcf\u4e2a\u90fd\u786e\u8ba4\u53ef\u4ee5\u6b63\u5e38\u8fd0\u884c\u3002<\/p>\n<p>\u5b9e\u9645\u8f6c\u6362\u9700\u8981\u4f7f\u7528child_process\u6216better-queue\u8fdb\u884c\u63a7\u5236\u3002\u6b64\u5916\uff0c\u7531\u4e8e\u5168\u7403\u6570\u636e\u7684\u6279\u91cf\u8f6c\u6362\u5f88\u56f0\u96be\uff0c\u56e0\u6b64\u8fd8\u53ef\u4ee5\u4f7f\u7528PostGIS\u7684&amp;&amp;\u529f\u80fd\uff0c\u6309\u7167\u74e6\u7247\u533a\u5757\u9010\u4e2a\u8bfb\u53d6\u6570\u636e\u3002\u5b66\u4e60\u6bcf\u79cd\u6280\u672f\u662f\u6709\u6548\u7684\u3002\u6211\u5e0c\u671b\u4eca\u540e\u80fd\u518d\u6b21\u8fdb\u884c\u8fd9\u4e9b\u7ec3\u4e60\u3002<\/p>\n<h1>\u8bf7\u63d0\u4f9b\u66f4\u591a\u4e0a\u4e0b\u6587\uff0c\u4ee5\u4fbf\u6211\u53ef\u4ee5\u4e3a\u60a8\u63d0\u4f9b\u51c6\u786e\u7684\u6c49\u8bed\u7ffb\u8bd1\u3002<\/h1>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148 \u5173\u4e8e\u4e4b\u524d\u4f7f\u7528\u7684\u77e2\u91cf\u74e6\u7247\u521b\u5efa\u7a0b\u5e8f\uff0c\u7531\u4e8e\u9700\u8981\u5347\u7ea7nodejs\u7248\u672c\uff0c\u6240\u4ee5\u9700\u8981\u6d4b\u8bd5\u4e3b\u8981\u7684nodejs\u6a21\u5757\u662f\u5426\u80fd\u5728 [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-32198","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecePostgreSQL\/PostGIS\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecepostgresql-postgis\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecePostgreSQL\/PostGIS\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u5173\u4e8e\u4e4b\u524d\u4f7f\u7528\u7684\u77e2\u91cf\u74e6\u7247\u521b\u5efa\u7a0b\u5e8f\uff0c\u7531\u4e8e\u9700\u8981\u5347\u7ea7nodejs\u7248\u672c\uff0c\u6240\u4ee5\u9700\u8981\u6d4b\u8bd5\u4e3b\u8981\u7684nodejs\u6a21\u5757\u662f\u5426\u80fd\u5728 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecepostgresql-postgis\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-18T04:06:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-28T14:41:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/14-0.png\" \/>\n<meta name=\"author\" content=\"\u5b87, \u534e\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5b87, \u534e\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/\",\"name\":\"\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecePostgreSQL\/PostGIS\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-12-18T04:06:21+00:00\",\"dateModified\":\"2024-04-28T14:41:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecePostgreSQL\/PostGIS\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\",\"name\":\"\u5b87, \u534e\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"caption\":\"\u5b87, \u534e\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecePostgreSQL\/PostGIS\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecepostgresql-postgis\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecePostgreSQL\/PostGIS\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e","og_description":"\u9996\u5148 \u5173\u4e8e\u4e4b\u524d\u4f7f\u7528\u7684\u77e2\u91cf\u74e6\u7247\u521b\u5efa\u7a0b\u5e8f\uff0c\u7531\u4e8e\u9700\u8981\u5347\u7ea7nodejs\u7248\u672c\uff0c\u6240\u4ee5\u9700\u8981\u6d4b\u8bd5\u4e3b\u8981\u7684nodejs\u6a21\u5757\u662f\u5426\u80fd\u5728 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecepostgresql-postgis\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-12-18T04:06:21+00:00","article_modified_time":"2024-04-28T14:41:55+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d108437434c4406bf135a\/14-0.png"}],"author":"\u5b87, \u534e","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u5b87, \u534e","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"7 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/","name":"\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecePostgreSQL\/PostGIS\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-12-18T04:06:21+00:00","dateModified":"2024-04-28T14:41:55+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528pg\u6a21\u5757\u5728nodejs\u4e2d\u4ecePostgreSQL\/PostGIS\u6570\u636e\u5e93\u8bfb\u53d6\u6570\u636e"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458","name":"\u5b87, \u534e","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","caption":"\u5b87, \u534e"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8pg%e6%a8%a1%e5%9d%97%e5%9c%a8nodejs%e4%b8%ad%e4%bb%8epostgresql-postgis%e6%95%b0%e6%8d%ae%e5%ba%93%e8%af%bb%e5%8f%96%e6%95%b0%e6%8d%ae%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/32198","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=32198"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/32198\/revisions"}],"predecessor-version":[{"id":62454,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/32198\/revisions\/62454"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=32198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=32198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=32198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}