我目前正在尝试使用express、node、postgresql 和react 创建一个简单的todo。我试图通过邮递员发布基本描述,但在“-”处或附近出现语法错误
这是我的代码:
//db.js
const Pool = require("pg").Pool;
const pool = new Pool({
user: 'postgres',
host: 'localhost',
port: 5432,
database: 'crud',
password: 'password'
});
module.exports = pool
//索引.js
const express = require("express")
const app = express()
const cors = require("cors")
const pool = require("./db")
//middleware
app.use(cors());
app.use(express.json())
//routes
app.post("/todos", async (req, res) => {
try {
const { description } = req.body
const newTodo = await pool.query(
`INSERT INTO todo-list (description) VALUES($1) RETURNING *`,
[description]
);
res.json(newTodo.rows[0])
} catch (err) {
console.error(err.message)
}
})
//get all todos
app.get("/todos", async (req, res) => {
try {
const allTodos = await pool.query("SELECT * FROM todo-list")
res.json(allTodos.rows)
} catch (err) {
console.log(err.message)
}
})
app.listen(8001, () => {
console.log("server is running on port 8001")
})
//.env
DATABASE_URL=postgres://postgres:password@localhost:5432/crud