Prisma #orm-help

Join Slack Communities

Marcus

08/25/2018, 8:07 PM

I had to look under servers => create new server => add existing database (I guess?)

Marcus

08/25/2018, 8:08 PM

Anyways, I have another question about a query:

Copy code

let place = await context.prisma.query.place(
        {
          where: {
            id: args.placeId
          }
        },
        '{owners {id}}',
      );
      if (place.owners.filter(owner => owner.id === userId).length < 1) {
        throw new Error("Place does not belong to User.")
      }

Is there anyway to get the filtering part into the query?

Marcus

08/25/2018, 8:09 PM

Users N N Places

Marcus

08/25/2018, 8:10 PM

what I would like to do is something like

Copy code

where : {
          owners_contains : {
                id: userId
         }
    }

Marcus

08/25/2018, 8:12 PM

Copy code

type Place { 
    ....   
    owners: [User!]!
    ....
}

Marcus

08/25/2018, 8:12 PM

and User vice versa

noahdavis

08/25/2018, 8:21 PM

Has anyone here figured out a good work around for multi-column sorts?

Entrepreneur3

08/26/2018, 12:29 PM

Hey guys, nevertheless of the nice page of prisma.io I still don't know what its value proposition really is. I am new to developing backend, I am usually a iOS App-Developer using Swift and have no idea about NodeJS etc. I am just getting started. What is it to create a GraphQL Server without prisma.io?

catalinmiron

08/26/2018, 12:32 PM

@Entrepreneur3 how did you end up on Prisma website in the first place? 🙂

Entrepreneur3

08/26/2018, 1:00 PM

@catalinmiron I just discovered that there is a different approach for creating APIs which is GraphQL so I researched about GraphQL and there were a lot often blogposts by prisma.io as the first links at google and they were very good. I kept researching until I realised that prisma.io is a service for creating backends with GraphQL but I still don't know why I should use prisma.io I don't even know what the alternative is

catalinmiron

08/26/2018, 1:04 PM

Maybe @nilan can help you out and give you a proper answer:)

Entrepreneur3

08/26/2018, 1:22 PM

Would be awesome! Thanks for answering @catalinmiron In the meantime I am continuing researching more about NodeJS maybe I will then have a clearer understanding since as said I am just getting started with backend development and web development in general(coming from native iOS Development using Swift and a little backend development (REST APIs) but with Vapor which uses Swift )

Nick

08/26/2018, 5:27 PM

TypeScript is the way to write graphql and prisma
Ctrl
+
Space
for auto-suggestions or
Ctrl
+
Click
to see type-definitions

macro_jackson

08/27/2018, 12:25 AM

Hey all, I'm trying to set up

graphql-playground

for local dev and keep getting the attached TS error. Anyone run into it before?

-.txt

Andres Montoya

08/27/2018, 2:13 AM

Hi, someone has some course about workbox and creating PWA application with it? Thanks :)

Gorodov Maksim

08/27/2018, 2:44 PM

How can I subscribe user for model with his id? For example, I have a model `task`:

Copy code

type Task {
  id: ID! @unique
  title: String!
  user: User!
}

Now my subscription looks like this:

Copy code

const taskCreated = {
  subscribe: (_, args, context, info) => {
    return context.prisma.subscription.task({ where: { mutation_in: ['CREATED'] } }, info);
  },
};

Now ALL my users get task when somebody created a task, but only 1 user should get it (the user who created it). How can I do it?

obivan86

08/27/2018, 2:49 PM

@Gorodov Maksim https://github.com/apollographql/graphql-subscriptions#filters

patrick

08/27/2018, 3:13 PM

With the Heroku integration, Prisma Cloud takes care of the SQL DB and Prisma server setup entirely, right?

sdubois

08/27/2018, 3:59 PM

I am looking for a CMS to use with Prisma, would anyone have a suggestion? I posted my question here: https://www.prisma.io/forum/t/using-a-cms-with-prisma/

catalinmiron

08/27/2018, 4:23 PM

@Gorodov Maksim I've answered man https://www.prisma.io/forum/t/filtering-subscription-for-correct-user/4262/2?u=catalinmiron. The problem with your datamodel is that you can't connect the user because there's no specified relation between the Task and the User 👍.

Seba

08/27/2018, 7:56 PM

anyone saw graphql client with subscription written in Python ?

Andres Montoya

08/27/2018, 8:06 PM

Hi, someone knows a "database as a service" for MySQL? Something similar to MLab for example...

johnleider

08/27/2018, 8:09 PM

Is there a location where I can request support?

lancej

08/28/2018, 3:11 AM

I am trying to rebuild the DB from scratch (locally) and apply a modified schema. I have deleted the old SQL docker image but when I do

prisma deploy

prisma deploy --force

it gets stuck with the message

Copy code

Applying changes (1/57) ⣯

. Has anyone come across this issue and/or know of a solution?

Christian Ruff

08/28/2018, 5:55 AM

Hi all! Is here somebody from the sales team?

Marcus

08/28/2018, 9:06 AM

Hi, we just started our first prisma + yoga project and we can say this is great stuff. Thanks! Where is a good place to have tests? Can you recommend a test library for graphql? None of the examples we found had any tests. 😞

nilan

08/28/2018, 9:12 AM

Could you use threads, that helps to keep the overview 🙂

👍 2

Patrik Molnar

08/28/2018, 9:53 AM

hi everyone, I have a question inside the #deployment channel regarding the deployment of the s3-file-handling example using UP

Cprogs

08/28/2018, 11:03 AM

Was anyone able to deploy Prisma to Zeit cloud 2 ? I get hit by the platform 100MB image size limit ... Any hints on how to reduce the prisma image size ?

mehdyouras

08/28/2018, 11:58 AM

Does anybody know how to create a new service programmatically in prisma cloud ?