如何在 nodejs 中将其转换为 postgresql 存储过程-解网

问：

我想将 postgresql 查询更改为 Nodejs 中的存储过程。

app.post("/add", async(req, res) => {
try {
    const { name, email, hobby } = req.body;
    const newStudent = await pool.query("INSERT INTO student (name, email, hobby) VALUES ($1, $2, $3) RETURNING *", [name, email, hobby]);
    res.json(newStudent.rows);
} catch (err) {
    console.error(err.message);
}

})

节点 .js PostgreSQL 过程存储函数

-- Create a stored procedure to insert a new student

CREATE OR REPLACE FUNCTION add_student (name VARCHAR, email VARCHAR, hobby VARCHAR)
RETURNS TABLE(id INT, name VARCHAR, email VARCHAR, hobby VARCHAR)
AS $$
BEGIN
    INSERT INTO student (name, email, hobby) VALUES (name, email, hobby) RETURNING *;
    RETURN QUERY SELECT * FROM student;
END;
$$ LANGUAGE plpgsql;

-- Execute the stored procedure to add a new student

SELECT add_student('John Doe', '[email protected]', 'Gardening');

如何在 nodejs 中将其转换为 postgresql 存储过程

How to convert this into postgresql stored procedures in nodejs

评论

评论