Prisma introspect is deleting models I created for database views

[jacky-lam]

Bug description

Action:
I have create a simple database view in Postgres and then manually add the model for the view as instructed here:

• https://www.prisma.io/docs/guides/general-guides/database-workflows/sql-views-postgres

Bug:

• If I run prisma generate it works perfectly fine.
• However, if run prisma introspect, it deletes all my models that I had setup for the database views.

How to reproduce

1. Create a simple database table.
2. Create a simple database view (for that table).
3. In the schema.prisma manually add the model for that database view.
4. Run yarn prisma introspect.
5. Check schema.prisma file, the model for that database view is gone.

Expected behavior

After running yarn prisma introspect, it would not delete the model for the database view.

Prisma information

Environment & setup

• OS: Mac OS
• Database: Postgres
• Node.js version: 12.20.*
• Prisma: 2.15

[janpio]

This will solve your problem: https://www.prisma.io/docs/concepts/components/preview-features/native-types/native-types-mappings#ignore-and-ignore Note this is currently just a preview feature that needs to be explicitly enabled.

[jacky-lam]

thank you @janpio. i will try to use this.

[jacky-lam]

hi @janpio ,

I just updated my prisma version to 2.16.1 and put the @@ignore tag at the bottom of the model definition as shown in the link you sent.

When i ran yarn prisma introspect it still deleted my model definition. Was that an expected behaviour?

[pantharshit00]

That is unexpected. I will try to reproduce this.

[pantharshit00]

Hey @jacky-lam

Looks like this hasn't been implemented in reintrospection yet: #5331

Please wait on that here.

[pantharshit00]

I suggest you also not use @@ignore in first place as models marked with that gets removed from the client API. The real solution here is having views supported in the schema: #678

[janpio]

I suggest you also not use @@ignore in first place as models marked with that gets removed from the client API.

That is actually true. So although you would keep the models, you would still not be able to use them. My bad, sorry.

[janpio]

Closing this issue as #678 is the only way to make this nicer.