ptrxyz Comments - Answer Overflow

ptrxyz

Explore posts from servers

•Created by ptrxyz on 3/12/2025 in #help-and-questions

n:m relations between tables and view

Do you know if there will be added a bit more love to views in the future? I found that the view preview feature is on the agenda for March/25 -> August/25. So there might still be improvements?

11 replies

PPrisma

•Created by ptrxyz on 3/12/2025 in #help-and-questions

n:m relations between tables and view

Further it seems that prisma doesn't check the validity of column types. I could use "String" instead of "Int" for example and I wouldn't get any "compile time" errors, only failures during runtime :/

11 replies

PPrisma

•Created by ptrxyz on 3/12/2025 in #help-and-questions

n:m relations between tables and view

However i then it is a bit cumbersome to maintain the tables:

model FooToBar {
 A Int
 B Int
 @@ignore
 @@map(....)
 @@index([ ... ])
}

model FooToBar {
 A Int
 B Int
 @@ignore
 @@map(....)
 @@index([ ... ])
}

This would probably be fine for a single relation, but it doesn't scale well. :/

11 replies

PPrisma

•Created by ptrxyz on 3/12/2025 in #help-and-questions

n:m relations between tables and view

I figured that when i create the tables manually with the names prisma expects, then i can use them in the 'normal' way: prisma.myview.findMany({ include: { ... }})

11 replies

PPrisma

•Created by ptrxyz on 3/12/2025 in #help-and-questions

n:m relations between tables and view

Does anyone know more about this?

11 replies

PPrisma

•Created by ptrxyz on 3/12/2025 in #help-and-questions

n:m relations between tables and view

I don't get what the problem is, can someone shed some light?

11 replies

PPrisma

•Created by ptrxyz on 3/12/2025 in #help-and-questions

n:m relations between tables and view

to add context:

// this schema adds relation tables
model User {
    id Int @id
    departments Department[]
}

model Department {
    id Int @id
    users User[]
}

// this schema adds relation tables
model User {
    id Int @id
    departments Department[]
}

model Department {
    id Int @id
    users User[]
}

// this schema DOES NOT add relation tables
model User {
    id Int @id
    departments Department[]
}

view Department {
    id Int @id
    users User[]
}

// this schema DOES NOT add relation tables
model User {
    id Int @id
    departments Department[]
}

view Department {
    id Int @id
    users User[]
}

11 replies

PPrisma

•Created by ptrxyz on 1/28/2025 in #help-and-questions

type-safely wrapping `findMany`

Thanks a bunch!

10 replies

PPrisma

•Created by ptrxyz on 1/28/2025 in #help-and-questions

type-safely wrapping `findMany`

yes, this seems to be what i need. one thing about the args, i had to change SelectSubset to Prisma.Exact to make it work, but it does what it should now!

10 replies

PPrisma

•Created by ptrxyz on 1/28/2025 in #help-and-questions

type-safely wrapping `findMany`

let me see if it works

10 replies

PPrisma

•Created by ptrxyz on 1/28/2025 in #help-and-questions

type-safely wrapping `findMany`

thanks so far

10 replies

PPrisma