This message was deleted.
# prisma-clients
Slackbot
02/04/2022, 2:35 PMThis message was deleted.
m
Mischa
02/04/2022, 2:37 PMIt generates
Copy code
-- first query: upsert all Skills
INSERT INTO "Skill"
$1 -- columns
VALUES ($2,$3)
ON CONFLICT ("name") DO UPDATE SET "name"=EXCLUDED."name"
RETURNING *; Copy code
Raw query failed. Code: `42601`. Message: `db error: ERROR: syntax error at or near "$1"`a
Austin Zentz
02/04/2022, 2:44 PMI think the syntax for values is incorrect --
Austin Zentz
02/04/2022, 2:44 PMif you're entering multiple, it's generally something like:
Austin Zentz
02/04/2022, 2:44 PM Copy code
VALUES
('SkillName', true, 'SkillDescription'),
('SkillName', true, 'SkillDescription'),
('SkillName', true, 'SkillDescription'),Austin Zentz
02/04/2022, 2:45 PMthough candidly i've had a really hard time coming up with the syntax for a similar upsert need
Austin Zentz
02/04/2022, 2:46 PM(I believe there are a handful of open issues requesting this without having to resort to queryRaw -- I'm actually using knex in addition to Prisma when dealing with batch inserts because it's easier for batch stuff in a project of mine
m
Mischa
02/04/2022, 3:11 PM Copy code
-- first query: upsert all Skills
INSERT INTO "Skill"
(name)
VALUES $1,$2
ON CONFLICT ("name") DO UPDATE SET "name"=EXCLUDED."name"
RETURNING *;42601db error: ERROR: syntax error at or near “$1”Mischa
02/04/2022, 3:12 PMwas trying
Copy code
const skillsUpsertResult = await this.prisma.$queryRaw<Skill[]>`
-- first query: upsert all Skills
INSERT INTO "Skill"
(name)
VALUES ${Prisma.join(skillNames.map((s) => `(${s})`))}
ON CONFLICT ("name") DO UPDATE SET "name"=EXCLUDED."name"
RETURNING *;`Mischa
02/04/2022, 3:13 PMok I think I got that solved:
Copy code
const skillsUpsertResult = await this.prisma.$queryRaw<Skill[]>`
-- first query: upsert all Skills
INSERT INTO "Skill"
(name)
VALUES ${Prisma.join(skillNames.map((s) => Prisma.sql`(${s})`))}
ON CONFLICT ("name") DO UPDATE SET "name"=EXCLUDED."name"
RETURNING *;`🙌 1