Hello all.
Does anyone have any experience convert...
# orm-helpc
Cody Moore
02/08/2022, 3:47 PMHello all.
Does anyone have any experience converting SQL Server Column names from Pascalcase to Camelcase? It is an existing DB that cannot be modified. I have done some searching online and can't seem to find an efficient solution. Any help would be greatly appreciated.
a
Austin Zentz
02/08/2022, 3:50 PMThere's a thread just above about renaming database columns within Prisma
Austin Zentz
02/08/2022, 3:50 PMThis doesn't actually change your database but does mean the userland code you write can use whatever names and cases you prefer
c
Cody Moore
02/08/2022, 3:51 PMThank you for the quick reply!
Cody Moore
02/08/2022, 3:52 PMI went down that road but the changes did not seem to have any effect. I will try again.
Cody Moore
02/08/2022, 3:54 PMIs there a way to change them automatically? Rather than putting
@map('string')a
Austin Zentz
02/08/2022, 3:57 PMyou may need to run prisma generate after you make schema changes
👍 1
Austin Zentz
02/08/2022, 3:57 PMno -- no way to automatically make things! Unless you make some kind of script that modifies your schema programmatically
c
Cody Moore
02/08/2022, 4:00 PMThank you for responding. I will go the script route found here. https://github.com/prisma/prisma/issues/1934
Cody Moore
02/09/2022, 6:38 PMI cannot get
@map()Cody Moore
02/09/2022, 6:39 PMschema file
Cody Moore
02/09/2022, 6:39 PMThen I run
yarn prisma generateCody Moore
02/09/2022, 6:41 PMThen a
.prisma/clientCody Moore
02/09/2022, 6:41 PMAny ideas?
Cody Moore
02/09/2022, 6:42 PMSeems like
prisma generate2 Views