Question: Can instrospection change table names to something else? like camelCased?

[hcharley]

Hi,

I'm wondering specifically about tableNames -> modelNames. I'd prefer pascal case or camel case to snake case (what i write table names in).

I'd also extend this to column names as well.

[pantharshit00]

Yes, you can change the introspected table names using the @@map directive.

Example:

model User {
  id   String @id @default(cuid())
  name String
  @@map("user")
}

[nikolasburk]

@Charlex we have a dedicated docs page for that in the new docs (which will be published soon)

[hcharley]

I see, thank you!

I'm wondering how hard it would be to transform the model names to pascal case automatically as part of the introspection.

Part of my goal is to simply have the Prisma2 schema be an always-generated output of the database.

I suppose I could write a script that would just help me do what the docs suggest to do manually.

I almost wonder if introspection should do this by default to help users conform to Prisma's naming conventions.

[nikolasburk]

This will be possible in the future! 🙂 We are already working on a spec for that 🙌

[nikolasburk]

(Note that the casing isn't yet part of the spec, but this will be enabled by the introspection configuration that's described there).

[hcharley]

Nice, then I will probably pause on my own implementation. Thanks for pointing me in the right direction on that!

[nikolasburk]

Actually would be great if you could create a feature request with your exact use case and requirements (just so we can make sure to consider this when we design that feature). 🙂

[hcharley]

Done: #1934