在尝试为“新用户”插入信息之前检查用户是否已在数据库中的实用方法是什么
这是我的ID和插入功能获取用户:
const getUserById = (request,response) => {
const id = parseInt(request.params.attuid)
pg.query('SELECT * FROM geodate.users WHERE attuid = $1',[attuid],(err,res) => {
if (err) {
return next(err)
}
response.status(200).json(results.rows)
})
}
const createUser = (request,response) => {
const attuid = request.body[0].attuid
pg.query('INSERT INTO geodata.users (attuid,num_queries,created_date,modified_date) VALUES ($1,$2,$3,$4) RETURNING *',[attuid,moment(new Date()),moment(new Date())],(error,results) => {
if (error) {
throw error
}
response.status(201).send(`User added with ID: ${results.rows[0].attuid}`)
})
}
谢谢