Prisma #orm-help

Andrei Bacescu

05/14/2019, 5:41 AM

Hi guys! I want to use prisma introspect command for MySQL database, but I'm totally confused because I'm not sure if that feature is available or not. Prisma docs say it is available (1.32 vers) https://www.prisma.io/docs/datamodel-and-migrations/introspection-MYSQL-soi2/#introspecting-a-mysql-database. But this thread from prisma forum says it is not yet available (last reply): https://www.prisma.io/forum/t/connecting-to-an-existing-mysql-db-issues/5955. Thanks!

Bruce He

05/14/2019, 7:29 AM

I just realized subscription won't working if graphql+prisma hosted on heroku server. Any one knows how to deal with it? { "error": "Could not connect to websocket endpoint wss://graphql-chatroom.herokuapp.com/. Please check if the endpoint url is correct." }

Bruce He

05/14/2019, 7:30 AM

Or switching to mongodb from prisma in order to get subscription working on heroku server?

impowski

05/14/2019, 11:03 AM

Is there a Prisma microservices example available?

Lars-Jørgen Kristiansen

05/14/2019, 11:07 AM

Anyone having problems with prisma admin?

Lars-Jørgen Kristiansen

05/14/2019, 11:07 AM

It just loads forever..

nik

05/14/2019, 12:58 PM

Hey there, i want to upgrade my project to the latest version of prisma. This includes changing to the new datamodel. I did this on my dev environment (which is on the same server, so the server is already upgraded) and it works fine. Now I want to make a copy of my production env to test and see if everything works fine. But I can’t find any way to do this. When I try to deploy a new service with the old datamodel file the server complains, that it’s invalid When I just copy the prod database and act like this is a new service my deployment says everything is up to date Any idea how I can do this?

Osman Benlioğlu

05/14/2019, 1:33 PM

hey there, when "prisma token" gives us a token. what is the expire time?

kitze

05/14/2019, 2:06 PM

nexus-prisma-generate

is suddenly complaining about duplicate

graphql

module

mark

05/14/2019, 2:27 PM

Hi guys i’m using prisma bindings (similar to prisma client). I need to add extra data to the response that has nothing to do with the queried data, how can i achieve this? eg: when i do this in the resolver:

Copy code

return { ...(await prisma.query.user({ where: { id } }, info), metadata }

metadata isn’t in the reponse if i take a look at it... Ideally i would love to have an extra key in the JSON reponse next to “data”

Tomasz

05/14/2019, 3:27 PM

hey, quick question, can I make resolver while not using graphql-yoga, just a generated prisma client?

nuno

05/14/2019, 4:05 PM

I switched from prisma-binding to prisma-client-lib and came across this issue: https://github.com/prisma/http-link-dataloader/issues/18. The recommended solution is to add "dom" to "lib" in tsconfig?

Luca

05/14/2019, 4:13 PM

Why is a connection query resulting in this SQL query?

Copy code

query usersConnection {
  usersConnection(first: 2, after: "a") {
    edges {
      node {
        id
        name
      }
      cursor
    }
  }
}

Copy code

2019-05-14 16:07:19.230 UTC [778] LOG:  execute <unnamed>: select 
	  "Alias"."id", 
	  "Alias"."name"
	from "local$dev"."User" as "Alias"
	where (
	  (
	    "Alias"."id" = (
	      select "local$dev"."User"."id"
	      from "local$dev"."User"
	      where "local$dev"."User"."id" = $1
	    )
	    and "Alias"."id" > $2
	  )
	  or "Alias"."id" > (
	    select "local$dev"."User"."id"
	    from "local$dev"."User"
	    where "local$dev"."User"."id" = $3
	  )
	)
	order by "Alias"."id" asc
	limit $4
	offset $5
2019-05-14 16:07:19.230 UTC [778] DETAIL:  parameters: $1 = 'a', $2 = 'a', $3 = 'a', $4 = '3', $5 = '0'

Luca

05/14/2019, 4:14 PM

Why is there an extra query for the "id" field when it just will return the same value as provided?

👍 1

Luca

05/14/2019, 4:42 PM

Ah, it makes sense when you use orderBy with something different then ID+asc

nuno

05/14/2019, 5:10 PM

Is anyone reviewing pull requests? I have a small documentation PR (https://github.com/prisma/prisma/pull/4273) that would be nice to merge or get feedback on. And there are other PRs that should also be considered.

captaindaylight

05/14/2019, 10:02 PM

when I try to do

prisma deploy

I get:

Copy code

ERROR: GraphQL Error (Code: 503)

{
  "error": "<html>\r\n<head><title>503 Service Temporarily Unavailable</title></head>\r\n<body bgcolor=\"white\">\r\n<center><h1>503 Service Temporarily Unavailable</h1></center>\r\n</body>\r\n</html>\r\n",
  "status": 503
}

captaindaylight

05/14/2019, 10:03 PM

is anyone else experiencing this?

Mohamed Khalil

05/14/2019, 10:08 PM

Hello every one!

Mohamed Khalil

05/14/2019, 10:09 PM

dose anyone deployed prisma graphql server on now version 2 successfully?

gem

05/15/2019, 8:41 AM

looking for advice from someone who did migration from graphcool to prisma, did you use a boilerplate or something that would help me ?

gem

05/15/2019, 8:41 AM

along with the documentation on prisma

Olaf

05/15/2019, 10:23 AM

I'm new to Prisma/GraphQL and want to know how I create an association through another table? In my case, Users belong to many Accounts through Memberships, each of these memberships has a role for the user (eg. they could be an admin for one account and a normal user for another). Could someone please help me out?

Andrei Bacescu

05/15/2019, 10:35 AM

Hello everyone! I've used prisma init on an existing mysql database with existing data - selected these in the wizard - and during introspection I get the message: *"Cannot read property 'type' of undefined". * Prisma version: 1.32.2 Thanks!

bkstorm

05/15/2019, 11:26 AM

I'm using nexus prisma. I want my Angular app to subscribe notification events so it can show notifications on UI to users real time. Here is my code:

Copy code

import { prismaObjectType } from 'nexus-prisma'

export const Subscription = prismaObjectType({
  name: 'Subscription',
  definition(t) {
    t.prismaFields(['notification'])
  },
})

But the server can't start.

[ERROR] 18:21:34 Error: Subscription are not supported yet

. What is the problem? I think Prisma already supports Subscription, right?

CMcAboy

05/15/2019, 11:29 AM

o damn

taikn

05/15/2019, 12:36 PM

Will latest beta (1.34.0) also land on dev servers?

csamu

05/15/2019, 12:39 PM

Does anyone know if its possible to check all active auth tokens generated for a Graphcool project?

Fran Dios

05/15/2019, 4:16 PM

Hi everyone. Does anybody know how to create numeric IDs that increase 1 by 1 with the new data model? I’ve tried but failed, perhaps I’m doing it wrong.

Joseph

05/15/2019, 9:46 PM

Hey, i'm using GraphQLServer and just trying to have socket-io listen on the same port. You can see my server/index.js and server.js here https://gist.github.com/baconcheese113/edbc738379a53792dd3cce0f4c8ad5ba#file-server-index-js According to this post it seems like it's very easy with express + socket-io https://stackoverflow.com/questions/12235406/how-to-use-expressjs-and-socket-io-on-a-same-port Any idea how i can do this with GraphQLServer or do I need to switch to ApolloServer? This question is here as well now https://stackoverflow.com/questions/56159532/graphqlserver-socket-io-on-same-port

snippet.js