Question- I'm learning prisma/graphql et al, and have a question regarding many to many relationships with join tables that have additional data

Is that possible in graphql?

for example- I have a ingredients and a recipe

the ingredients can be in multiple recipes, and a recipe has multiple ingredients

however, the order of the ingredients matters

Do I just define the join table as its own type and build it out that way?

@Neill Kapron from what I've read, I don't think you can add data to a join table natively in prisma. You could probably hack it on, but I'd wager it's easier to add a

ingredientOrder

json field to your

Recipe

Something like

{ingredientId: ORDER}

so you can do

ingredients.sort_by(ing => recipe.ingredientOrder[ing.id])

(on the client)

@Christian Genco Thanks, that makes sense

Is it possible to link two types with an ID that is shared? I have several types that represent REST endpoints. One endpoint returns a person_id, but not the whole person

How can I create a hook, so that during an insert, for example, a bunch of other items are initialized. For example, a user is created, so after it s crested, create a new "Organization" a new "Profile", etc. Can that be done with the functions hooks?

I'm working with the email-password auth template, and I'm wondering what the best way to reset a user's password is. I found some "outdated" templates that appear to do what I want, but in the README it says very explicitly: "outdated templates are not officially supported". Indeed, after adding this template from the CLI, non of these mutations are accessible. Is there some other feature I'm missing? https://github.com/graphcool/templates/tree/master/outdated/auth/email-user-management/functions/reset-password

What is a typical workflow for deployment of a dynamic graphcool site? Do you push frontend code to AWS or somewhere and then all the backend stuff stays at graphcool? If so, what kinds of places do you guys recommend for the hosting of the front-end code. I see that Surge was used in the howToGraphQL example, but the site I'm building is dynamic (a CRM type application) so I assume Surge won't work for my purposes.

I'm still getting this after following Digital Ocean manual tutorial for prisma deploy. It has never worked for me 😞

Hi there, can graphcool recognize "onDelete: CASCADE" ?

I'm getting occasional

A unique constraint would be violated on Order. Details: Sorry, no more details available.

when sending a mutation to graph.cool - but when I manually run the mutation (in the playground), the mutation is fine.

Is there some intermittent bug that I should be wary of?

Who knows, how to make a resolver function for Query request in graphcool and how to invoke it ? http://prntscr.com/iy13vf

Anyone knows how to have a computed property in Prisma? E.g. , my datamodel looks something like:

type Quotation {
  id: ID! @unique
  costs: [Cost!]!
  prices: [Float!]!  // Sum of costs
}

type Cost {
 ...
 values: [Float!]!
 currency: String!
}

I'd expect to have my own resolver, so this works:

export const Quotation = {
    prices: async (parent, args, ctx: Context, info) => {
        return [1,2,3]
    },
}

Yet how do I rerieve the costs? I don't have a `quotation id`/`cost ids` somewhere...

I have a question about the serverless functions. Does the complete event always ends up in the logs?

I looked at the password-auth template and even if I remove the first console.log(event). The whole event + cleartext passwords are getting logged in the function log

I do believe there's a configuration for that. One second.

Oh you're talking lambda event

not sure there

or, serverless event

yeah I am talking about the graph.cool cloud functions. Not prisma.

sorry, my bad

Okay, it seems there is an issue https://github.com/graphcool/graphcool-framework/issues/463 And as far as I understand this is not possible right now? Which makes the auth-template unuseable, as it leaks user password. Which is imo critical.