vpjm
PPrisma
•Created by vpjm on 1/3/2025 in #help-and-questions
prisma generate --sql and seeding
The error came from the SQL file I provided: misplaced quotation marks were the cause. In general, the errors returned by Prisma do not always correspond to those you might encounter when executing the SQL code directly in a terminal, which makes debugging more difficult
10 replies
PPrisma
•Created by vpjm on 1/3/2025 in #help-and-questions
prisma generate --sql and seeding
:prismagrimace:
10 replies
PPrisma
•Created by vpjm on 1/3/2025 in #help-and-questions
prisma generate --sql and seeding
I still haven't found the solution.
10 replies
PPrisma
•Created by vpjm on 1/3/2025 in #help-and-questions
prisma generate --sql and seeding
:prisma_xmas:
10 replies
PPrisma
•Created by vpjm on 1/3/2025 in #help-and-questions
prisma generate --sql and seeding
If you have any information/advice (on raw SQL) , feel free to ping me on the channel. Thank you very much for taking the time to read this. I wish you a happy 2025 ! 🎊
10 replies
PPrisma
•Created by vpjm on 1/3/2025 in #help-and-questions
prisma generate --sql and seeding
Unfortunately, I can't find the documentation for prisma generate --sql.
10 replies
PPrisma
•Created by vpjm on 1/3/2025 in #help-and-questions
prisma generate --sql and seeding
Steps:
I exported my seeding script into a .sql file and ran it with executeRawUnsafe, which caused the error:
"cannot insert multiple commands into a prepared statement."
Then, I tried splitting each "statement" by parsing the file with a regex, but now I am encountering the error: "control reached end of trigger procedure without RETURN." This is happening because, once read and stored in a string, the file seems to be invalid.
Eventually, I manually split the statements and placed them in a folder structure under /sql, but I now realize that prisma generate --sql does not pick up files that are not in the root directory.10 replies
PPrisma
•Created by vpjm on 1/3/2025 in #help-and-questions
prisma generate --sql and seeding
Thanks for your help and your time
10 replies