https://www.prisma.io/ logo
Join Slack
Powered by
# orm-help
  • t
    Hey guys!!!
  • t
    Anyone know why in production environment I'm getting "SyntaxError: Failed to construct 'WebSocket': The URL 'undefined' is invalid." with Prisma subscriptions set-up
    j
    • 2
    • 6
  • d
    hey guys! does anyone know if that's an expected behaviour for prisma client? we have a DateTime field in schema and when we query the object - the field is not actually date, but a plain iso string i.e. when used with *.getTime() it fails with getTime is not a function
    r
    • 2
    • 1
  • b
    Hello guys. Can anyone help me resolve this.
    j
    • 2
    • 2
  • v
    How would you structure a tree structure with prisma? Planing to build a todo app with N-depth. So the depth is not known before. There is no limit on how many levels. So: • Task ◦ Task ◦ task ▪︎ Task • task • task • task Probably will use sqlite for database.
    r
    • 2
    • 2
  • p
    hi, do I need to install VirtualBox to install the Prisma 1 client?
    r
    • 2
    • 18
  • j
    if I have two models Project and Task and want to fetch projects but order them based on the most recently updated task in each project, is this possible?
    d
    r
    • 3
    • 12
  • m
    Hi. I get this warning when i run prisma generate 
    warn Versions of prisma@2.23.0 and @prisma/client@2.22.1 don't match.
    but i dont have 2.23 installed. My npm lock file is 
    "@prisma/client": "^2.22.1",
    and i use 
    npm ci
    I cant find prisma 2.23 anywhere in my package lock file. Anyone have any idea why would be getting this warning?
    r
    • 2
    • 13
  • m
    i deleted my node_modules and reran 
    npm ci
  • m
    nm… found the answer.. its the prisma `*“peerDependencies”: {* *“prisma”: “*”* },`
  • m
    🤦‍♂️
  • m
    any idea why the client doesnt lock its version to the compatible one instead of * ? (ooc)
  • n
    First edition of our new meetup, Connect Dev Africa, is starting in 5 minutes! fast parrot Tune in here:

    https://www.youtube.com/watch?v=7Hs2D8V0uvk▾

    🌍 5
    🦜 5
  • m
    Hello Are u planing add 
    upsertMany
    method in future?
    r
    • 2
    • 1
  • b
    Is there any way for prisma to report the details when a drift is detected? It seems to me if prisma has an issue it should be able to report the problems so I can fix them. 
    Drift detected: Your database schema is not in sync with your migration history.
    Is just doing a schema diff in my db the best way to resolve this?
    r
    • 2
    • 2
  • n
    Does prisma 
    $queryRaw
    not support 
    CREATE TEMPORARY TABLE
    statements yet? Received this and was wondering if it was not supported or if it was me and I have to get creative (For MySQL)
    Copy code
    {
  "code": "P2010",
  "clientVersion": "2.22.0",
  "meta": {
    "code": "1295",
    "message": "This command is not supported in the prepared statement protocol yet"
  }
}
    n
    • 2
    • 1
  • p
    Hi, when I change my datamodel do I need to do anything else besides deploy and generate? Because my changes aren't being reflected in http://localhost:4466/_admin
    r
    f
    j
    • 4
    • 14
  • p
    (prisma 1)
  • j
    set the channel topic: General Discussions about Prisma (2) [Looking for Prisma 1? Join the #prisma1 channel!]
    prisma rainbow 2
    🚀 4
  • v
    when overriding programmatically the data source url, do i need to delete the datasource in 
    schema.prisma
    ? If i do so, migrations are not working, even if i leave that the env var does not exist
    j
    m
    • 3
    • 15
  • j
    What is prisma’s DateTime type in Javascript? How do I post a new value into that field
    g
    r
    • 3
    • 6
  • t
    Prisma does not seem to detect when we rename a reverse relationship field name
    j
    • 2
    • 30
  • t
    Any idea why this might happen?
  • s
    This message was deleted.
    j
    c
    • 3
    • 2
  • k
    is there a way to hook into generated prisma types to customize them? in a way similar to nexus source types? link: https://nexusjs.org/docs/guides/source-types
    r
    • 2
    • 5
  • y
    Hi ! How do you argument validation check when developing graphql api with nexus ? can you recommend a library ?
    a
    • 2
    • 2
  • v
    How to mention what type of joins to be used in relation queries? Let's say i want a left join here
    Copy code
    const getUser = await prisma.user.findUnique({
  where: {
    id: 19,
  },
  include: {
    posts: true,
  },
})
    r
    • 2
    • 2
  • i
    Hi 👋 I have a use case in which I want average rating of each user in my db. I have three models : • User • Post • Rating A user have multiple posts and each post have multiple ratings given by many users. I want to gather average rating of each user. I have user_id in Post model and post_id in Rating model. How is it possible to do so? I was using 
    groupBy
    but it only involves a single model & gives the average of a particular field. But in my case the situation is little different. Anyone who can guide me.
    c
    • 2
    • 1
  • p
    Hey all. Is there any plans for Scalar list filters for mysql?
  • p
    I could have sworn something like:
    Copy code
    where: {
  foo: {
    in: ["abc", "def"]
  }
}
    Was possible.
1...435436437...637Latest