sanwei_server/Source/module/DingDei/DingWeiRouter.js

// 倾斜数据管理模块
const express = require("express");
const router = express.Router();

const pgClient = require("../../core/pgClient/pgClient.js");

const sqlUtil = require("./sql.js");

/* 1.获取所有数据 */
// get、post都行
router.get("/listXiang", function(req, res) {
    let sqlstr = `select name from public.qinshui_xiang`
    // 执行sql
    pgClient.query(sqlstr).then((data) => {
        res.send(data);
    });
});

//获取乡的所有信息
router.get("/listXiang1", function(req, res) {
    let sqlstr = `select name, information, st_asgeojson(geom), st_asgeojson(ST_Centroid(geom)) as center from public.qinshui_xiang_dqw`
    // 执行sql
    pgClient.query(sqlstr).then((data) => {
        res.send(data);
    });
});

// 查询乡 by Name
router.get("/getXiangByName", function(req, res) {
    let sqlstr = `select name,st_asgeojson(geom) from public.qinshui_xiang where name = '${req.query.xiang}'  `
    // 执行sql
    pgClient.query(sqlstr).then((data) => {
        res.send(data);
    });
});
module.exports = router;