我正在开发带有PostgreSQL-DB的NodeJS项目。我创建了一个名为" Userasanas"的表。它肯定在那里,我已经检查并重新检查了。
但是,当我尝试多排时,它会告诉我以下几点:
错误:关系" Userasanas"不存在
const cs = pgp.helpers.ColumnSet(['UserID', 'AsanaID', 'RoutineID'], { table: 'UserAsanas' });
const values = [{UserID: 1, AsanaID: 2,RoutineID: 1}, {UserID: 1, AsanaID: 33,RoutineID: 1}];
const multi = pgp.helpers.insert(values, cs)+ ' RETURNING id';
// INSERT INTO "UserAsanas"("UserID","AsanaID","RoutineID") VALUES(1,2,1),(1,33,1) RETURNING id
db.none(multi).then(data=> {
res.status(201)
})
.catch( err => {
return next(err)
})
是的。所有的小字母,它就像零食一样工作!
const single = pgp.helpers.insert({userid: 1, asanaid: 2,routineid: 1}, null, 'userasanas' );
const multi = pgp.helpers.insert([{userid: 1, asanaid: 5,routineid: 1}, {userid: 1, asanaid: 4,routineid: 1}], ['userid', 'asanaid', 'routineid'], 'userasanas' );