const express = require("express");
const router = express.Router();

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

/* 1.获取所有数据 */
router.post("/getList", function (req, res) {
    let tableName = req.body.tableName
    //直接拼接
    let sql = `select * from ${tableName}`;

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

/* 2.添加数据 */
router.post("/addData", function (req, res) {
    let tableName = req.body.tableName;
    let name = req.body.name;
    let password = req.body.password;
    //直接拼接
    let sql = `insert into ${tableName}  ("name","password") values ('${name}','${password}')`;
    console.log(sql);
    /* 执行-并把值返回前端 */
    pgClient.query(sql).then(data => {
        res.send(data)
    });
});

module.exports = router;