Prisma #orm-help

Join Slack

martin

05/05/2018, 1:28 PM

Nice UI update over at prisma-cloud graphcool ✨ Very cool…

🦜 3

picosam

05/05/2018, 4:02 PM

Hello! I’m getting this after a successful `prisma deploy`:

Copy code

post-deploy:
Running graphql get-schema --project prisma !
 ▸    'ENOENT': spawn graphql ENOENT

Get in touch if you need help: <https://www.graph.cool/forum>
To get more detailed output, run $ export DEBUG="*"

I’m using yarn workspaces, so my GraphQL API is in a folder called

api

that is at the same level as my

prisma

folder. The former contains my

.graphqlconfig.yml

file and the latter contains my

prisma.yml

file.

zonofthor

05/05/2018, 7:34 PM

Trying to understand mutation.refetchQueries... ui component is seperate from component doing the mutation... so how on earth does refetchQueries pass the signal "hey other component you should now render this data from my query after I mutated our store" ?

veksen

05/05/2018, 7:44 PM

I think the graphql HOC + query component handles this

max

05/06/2018, 5:45 AM

Sorry if this has been asked a million times already, but any idea if/when https://github.com/graphcool/graphcool-framework/issues/256 (non-scalar types in resolvers) will be implemented?

damylen

05/06/2018, 7:21 PM

I have successfully created a GraphQL server using Prisma and have a generated/prisma.ts, now I'm looking for an example how to use Typescript on the client side for invoking queries on my endpoint. I'm using Vue, but a plain typescript example using the generated definitions would be nice. Are there already examples online?

danielrasmuson

05/06/2018, 9:08 PM

Quick Question. Why are row mappings in their own underscore table?

Copy code

mysql> show tables;
+---------------------------------------+
| Tables_in_default@default             |
+---------------------------------------+
| CheckedOutDataRow                     |
| DataRow                               |
| Dataset                               |
| Function                              |
| FunctionRun                           |
| Label                                 |
| LabelReservation                      |
| LabelingFrontend                      |
| LabelingFrontendOptions               |
| Organization                          |
| OrganizationInvite                    |
| Permission                            |
| Post                                  |
| Project                               |
| Task                                  |
| Team                                  |
| Type                                  |
| User                                  |
| _AgreementFunction                    |
| _AssignedFunctionRun                  |
| _CheckedOutRows                       |
| _CreatedDataRow                       |
| _CreatedDatasets                      |
| _CreatedFrontends                     |
| _CreatedFunctions                     |
| _CreatedInvites                       |
| _CreatedLabels                        |
| _CreatedProjects                      |
| _CreatedTasks                         |
| _CreatedTeams                         |
| _DataInDataset                        |
| _DataRowLabels                        |
| _FunctionRuns                         |
| _LabelReservations                    |
| _LabelType                            |
| _LabelingFrontendCustomizationOptions |
| _OrganizationCheckedOutDataRows       |
| _OrganizationDataRows                 |
| _OrganizationDatasets                 |
| _OrganizationFunctionRuns             |
| _OrganizationInvites                  |
| _OrganizationLabelReservations        |
| _OrganizationLabelingFrontends        |
| _OrganizationLabelingFrontendsOptions |
| _OrganizationLabels                   |
| _OrganizationPermissions              |
| _OrganizationProjects                 |
| _OrganizationTeams                    |
| _OrganizationTypes                    |
| _OrganizationUsers                    |
| _ProjectCheckedOutDataRows            |
| _ProjectDatasets                      |
| _ProjectLabelReservations             |
| _ProjectLabelingFrontend              |
| _ProjectLabelingFrontendOptions       |
| _ProjectLabels                        |
| _RanFunctions                         |
| _RelayId                              |
| _SkippedRows                          |
| _Tasks                                |
| _TeamMember                           |
| _UserCheckedOutDataRows               |
| _UserLabelReservations                |
| _WhitlistedProjects                   |
+---------------------------------------+
64 rows in set (0.00 sec)

mysql> select * from _OrganizationUsers limit 1;
+---------------------------+---------------------------+---------------------------+
| id                        | A                         | B                         |
+---------------------------+---------------------------+---------------------------+
| cjgv79dicfh9i0876b5c2w0ts | cjccycyq6hpje0134aktmtshq | cjccyczdih7lb0161ujq9q1ml |
+---------------------------+---------------------------+---------------------------+
1 row in set (0.00 sec)

danielrasmuson

05/06/2018, 9:09 PM

And if I'm planning on writing raw SQL against my prisma database should I be aware of any gotchas?

Jim

05/07/2018, 2:55 AM

Does anyone know what version of create-react-app the fullstack React boilerplate is based off of? https://github.com/graphql-boilerplates/react-fullstack-graphql I have some largish assets that are imported in multiple bundles (code split with React Loadable). Im trying to work out if they will be downloaded multiple times.

Jim

05/07/2018, 4:28 AM

What does “Upgrading local cluster” mean? https://www.prisma.io/docs/tutorials/cluster-deployment/local-(docker)-meemaesh3k#upgrading-local-cluster

Jim

05/07/2018, 5:34 AM

What’s the longest downloading the Docker container should take before it might have just frozen? Been about an hour so far…

Copy code

$ prisma local start
Booting local development cluster... ⣟

the-simian

05/07/2018, 7:44 AM

prisma is forcing me to create a relation and I'm not 100% sure why. The schemas are arranged like this

Copy code

type MyDossier {
  me: Person
  friendsList: [Person!]!
  someProperty: String
}

type Person {
  id: ID! @unique
  name: String
  age: Int
}

the errors are that

me

and

myFriends

must specify a

@relation

directive:

@relation(name: "MyRelation")

. I read through the unit test file here: https://github.com/graphcool/prisma/blob/762da0cf711abb595a2e743b40d191a54714e535/server/integration-tests/integration-tests-mysql/src/test/scala/com/prisma/integration/SeveralRelationsBetweenSameModelsIntegrationSpec.scala but I'm not immediately seeing why these fields MUST have relationships, because there isnt a necessary back relation

the-simian

05/07/2018, 7:46 AM

I'm using the latest builds of everything, but I suspect this is expected, and I'm overlooking something obvious.

Jim

05/07/2018, 9:12 AM

I’ve deployed my server with Zeit. When I run

prisma info

I can see Im still on the shared Prisma cluster: https://us1.prisma.sh/public-plumpchill-275/my-app/dev Do I need to update the settings in my project to use Zeit’s servers instead? Or is Zeit for the busienss logic and should I still be using the shared Prisma cluster for the GraphQL CRUD API?

gregor

05/07/2018, 10:10 AM

How's it going everyone? I once again have a problem with the Graphcool Console. I have two types,

Market

and

Product

with a many-to-many relationship. I'm trying to find out how many product are in the database for one specific market and the Console gives me a different number than my query. If I find the market in the console and click on the products column, it selects all products with this market or am I missing something critical here?

john

05/07/2018, 11:01 AM

I got a "must have a sub selection" error in my project. I called an 'app' based query from playground to save the passing data through the prisma query. But it says an error like "must have a sub selection".

Mike

05/07/2018, 11:20 AM

is it possible to insert data into another model-table than the model being modfied when using hooks,

operationBefore

for example?

yolen

05/07/2018, 3:14 PM

Dear all. Is it really correct that you can do a nested update and create mutation on one to many relation but not on many-to-many?

yolen

05/07/2018, 3:15 PM

This works

Copy code

mutation{
  createJens( abesMany:[{navn:"henning"}]){id}
}

yolen

05/07/2018, 3:16 PM

# version: 10 type Abe @model { id: ID! @isUnique navn: String! jens: Jens @relation(name: "JensOnAbe") } type Jens @model { abes: [Abe!]! @relation(name: "JensonAbe") id: ID! @isUnique } ```

yolen

05/07/2018, 3:16 PM

But this does not work

yolen

05/07/2018, 3:17 PM

Copy code

mutation{
  createJens(abesManys:[{navn:"henning"}]){id}
}

yolen

05/07/2018, 3:18 PM

does not with the schema

yolen

05/07/2018, 3:19 PM

Copy code

# version: 10

type Abe @model {
  id: ID! @isUnique
  navn: String!
  jensMany: [Jens!]! @relation(name: "JensOnAbe1")
}

type Jens @model {
 abesMany: [Abe!]! @relation(name: "JensOnAbe1")
  id: ID! @isUnique
}

yolen

05/07/2018, 3:19 PM

error message :

"Unknown argument 'abesManys' on field 'createJens' of type 'Mutation'. Did you mean 'abesMany', 'abesManyIds' or 'abesIds'? (line 2, column 28):\n  createJens( abesManys:[{navn:\"henning\"}]){id}\n

sunrising

05/07/2018, 3:42 PM

hi, I am making some test because I am going to transform my project from a standard one managed by graphcool UI to a CLI one but I cannot understand where to write my auth0 clientId and stuff in order to be used inside my graphcool.yml and inside the auth0Authentication.js script [looking and modifying this project: https://github.com/graphcool/templates/tree/master/auth/auth0]

noahdavis

05/07/2018, 5:04 PM

Anyone know how to regenerate the entire prisma generated schema?

nilan

05/07/2018, 5:23 PM

Welcome 👋

nilan

05/07/2018, 7:01 PM

We have a lot of interesting tasks for open source contributors, let me know if you're interested! https://dev.to/marktani/comment/39gk 🙂

prisma 3

👍 3

Emil Johansen

05/07/2018, 7:49 PM

Hi all. In the "Get Started Section" when I press "Get GraphQL Endpoint" the loading animation just hangs and I get a bunch of error messages. Anyone else experienced this? Tried in several browsers.