sanwei_server/Source/public/PgBase/pgBaseRouter.js

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


/* 获取某个表的所有数据 */
router.get("/list", function (req, res) {

    let sql = `select * from ${table_name};`

    /* 执行-并把值返回前端 */
    pgClient.query(sql).then(data => {
        res.send(data.rows)
    })

})


/* sql语句直接执行 */
router.get("/doQuery", function (req, res) {

    let sql = req.query.sql;

    pgClient.query(sql).then(restlt => {
        res.send(restlt);
    })

})

/* ...依次编写其他功能 */


module.exports = router