Hi, is there any documentation on how to deploy a locally prisma server? The docs I found online were to old, and with the prisma cloud it creates a new service, I couldn’t find how to use the one I already have locally

Anybody knows when prisma helm chart for prisma 1.3x will be available? thanks.

Hello everyone, I am new to prisma, I created a service on prisma’s demo server. I have created email type too for user type in graphql, using prisma playground I can mutate or query “email” also but its not on my MySql db record. Do I have to config something. Thanks.

Hi guys, can anyone help me with this? Having this simple schema

type Group {
    id: ID!
    name: String!
    rule: [Rule!]
}
type Rule {
   id: ID!
   name: String!
   group: Group
   logs: [Log]
}
type Log {
   id: ID!
   text: String
   rule: Rule!
}

The rules resolver just uses the prisma client

rules: (parent, args, ctx) => {
    return ctx.prisma.rules(args);
  }

And then I have the group and the logs resolver for the Rule

group: async (parent, args, { prisma }) => {
    const [group] = await prisma.rulesGroups({
      where: { rules_some: { id: parent.id } },
    });
    return group;
  },
  logs: async (parent, args, { prisma, logLoader }) => {
    const logs = await prisma.logs({
      where: { rule: { id: parent.id } },
    });
    return logs;
  }

The problem I see here is that in the group resolver, I don’t have the groupId from the parent rule, so I need to query all groups that has that rule id that is always going to be 1. Same apply for the logs Another problem without having this is if I want to implement a dataloader because I’m seeing a lot of request to the DB. (I’m not sure if I need it for the prisma client as I read at the docs that prisma includes a Dataloader I wasn’t sure if that’s internally or if I still need to do it myself on the server) But in case I needed to, I would still need the ids

anyone looking at this issue https://github.com/prisma/prisma-templates/issues/28?

hi people, I have a question: If I have a resolver, lets say "deletePost", I want only can delete by the author, I know I can use a conditional, but is there something like policies in laravel or something like that?

Hi, could anyone give me some pointers to how I can add something like likes, liked, follows, and followers to datamodel.prisma in terms of creating a social media app? For example I have a user model like below: I have newly added likes, follows, and followers, but prisma asks me to add relationship.

type User {
    id: ID! @unique
    username: String! @unique
    likes: [Item!]!
    follows: [User!]!
    followers: [User!]!
    categories: [Category!]! @relation(name: "CategoryToUser", onDelete: CASCADE)
    items: [Item!]! @relation(name: "ItemToUser", onDelete: CASCADE)
    comments: [Comment!]! @relation(name: "CommentToUser", onDelete: CASCADE)
    ...
}

What is the best way to set up relations for likes, follows, followers as the items do not usually belong to the user him/herself? or better to do like below? (just keep user or item ids).

likes: [ID!]!
 follows: [ID!]!
 followers: [ID!]!

and add some logic in the node server?

After setting up a new prisma server via the heroku prisma cloud integration (which has the managementApiSecret set), why is my prisma server endpoint supposed to be publically accessible? My expectation was that it would not be publically accessible when the

managementApiSecret

is set..

anyone knows how to prevent my prisma endpoint from requiring an authorization token? or at least how to prevent it from expiring… I’m still on the dev phase so I’m not concerned about security at this point

I think you can remove the

managementApiSecret

from

docker-compose.yml

?

Anyone has

java.lang.RuntimeException: Encountered unknown SQL type timestamptz with column created_at. IntrospectedColumn(created_at,timestamptz,null,false)

problem?

I have extracted the methods I'm using for authentication in all of my Prisma projects in a package: https://github.com/kitze/graphql-user

Hey guys, how can I access the

server

mutations from the seeding script? I want to access the mutations and resolvers we created as opposed to using the

database

ones. Example of accessing the

db

ones:

const db: Prisma = new Prisma({
  endpoint: '<http://localhost:4466>',
})

await db.mutation.createUser(...)

could someone provide me with relevant code for accessing the

server

? Do I need

apollo-client

??

Hi Guys, is there anyway to expose

createdAt

and

updatedAt

as the query result as well?

just add it to your schema.graphql

I created a user model

type User {
  id: ID!
  first_name: String!
  last_name: String!
  email_address: String!
}

and would like to group

first_name

and

last_name

into a

name

object that, when the user is queried, nests the two names like

name: { first, last }

so I can do a

name.first

etc. Can this be done without creating a 'name' table in the database? I.e. Simply at the Prisma interpretation level, not database. Thanks for any advice for converting my current (flat) structure.

Hi guys I need some help, i have model with 15 attributes, but can i dynamically set the attributes in query. What can i do to make this query dynamically if i want to get only top five attributes or more or less

I should only pass the attributes and get result of respective attributes like agentId, agentStatus, FirstName, team_id

yo when using prisma cloud to create a heroku server - where does the managementApiSecret come from?

atm I have to look it up in heroku and set it locally manually, then deploy

it would be nicer if it would be part of the setup

Hello 👋 I see that there isn’t much activity in the #graphqlgen channel, the last post before mine being from April 8th. Is there a better place to ask questions about

graphqlgen

?

hi guys. i’m trying to understand how to impl relay-style connection pagination with the

graphql-schema

generated schema.graphql… say I have User -> [MessageThread] -> [Message] model, and I want both MessageThread, and Message to respond with the connection types, can/should I not use the generated schema file?

any ETA on when usage metrics can be disabled? I'm not a fan of our production servers sending data to Prisma: https://www.prisma.io/docs/faq/usage-tracking-fq10/#how-to-opt-out-of-usage-tracking

can anyone recommend good resources on

jest

Integration Testing of APIs built with Prisma?

how to migrate graphcool server-side subscriptions in graphcool.yml to prisma ?

Hey I have a question. I'm looking at this doc under database properties: https://www.prisma.io/docs/prisma-server/deployment-environments/docker-rty1/ Im trying to set another database name for my mysql database where it says the default value is prisma. Regardless of what I set there prisma creates a database called "prisma".

couldn’t find answer for it anywhere: I want subscription for deleted nodes and I have a query for

previousValues {
        id
      }

this is the response:

"previousValues": { "id": "StringIdGCValue(ID)"}

is it wanted behavior? why not return

id

only?