https://www.prisma.io/ logo
Join Slack
Powered by
# orm-help
  • a
    can anyone help me with PRISMA tool capabilities for configuration management
  • a
    Copy code
    why I am getting this error on while I tried to read user table?
user is already created but I can't read it from prisma studio.
    r
    • 2
    • 4
  • m
    Hello all, I have a question about the graphql-node subscription section from howtographql.com. Essentially, I’m trying to understand the .node() and why it needs parentheses, and return payload/ what is the payload? function newLinkSubscribe(parent, args, context, info) { return context.prisma.$subscribe.link({ mutation_in: ['CREATED'] }).node() } const newLink = { subscribe: newLinkSubscribe, resolve: payload => { return payload
    r
    • 2
    • 6
  • a
    Does 
    @prisma/client
    silently generate a client, the same as 
    prisma generate
    , after getting installed via 
    npm install @prisma/client
    j
    • 2
    • 2
  • a
    What is 
    @prisma/client
    if you install it over npm and not via the cli
    j
    • 2
    • 2
  • c
    Hey all! Anyone willing to give some guidance on seeing where I'm going wrong on the Vercel deployment guide. I've feel like I've followed it to a t several times through using Heroku as my PostgreSQL db, I get all the right feedback from the checkpoint tests, but consistently getting 
    502
    errors when I try to seed the data or fetch it using the client, here's my final URL https://prisma-vercel-test10.coopermor.vercel.app/
    d
    • 2
    • 10
  • t
    Hi folks! I was curious regarding the difference between using 
    generate
    and 
    post deploy
    hook while generating the prisma graphql schema file and want to know if there are any different use cases to this. I thought to add the question to stackoverflow coz I didn't find any particular explanation on this topic so it'd be helpful if you give that a look. Here's the link to question. Thank you 💙
  • r
    Have the links to stream the talks on Prisma Day on Friday not been released yet? I received the links to join the Zoom for the workshops, but I don't see a way to get the links to join the talks.
    j
    • 2
    • 2
  • h
    Hello! Would anyone know how to connect prisma to an existing mssql database? Is this connection currently supported?
    j
    • 2
    • 5
  • s
    Hey, is there any way to have an auto-incrementing number? Like for example, I have Projects, and each project can have Tickets. I need the Ticker number to automatically increment for that project. Like GitHub issues / repository.
    r
    • 2
    • 1
  • j
    @nikolasburk for the Prisma Day workshop can anyone let me if it will be ok to record workshop given that I have a clash between next.js and nexus talk tomorrow would like some clarity on this or will the workshop videos be available for later viewing for those that registered ?
    a
    • 2
    • 2
  • a
    Hello, is there an issue with Prisma generating enum queries. When I run prisma generate command, the generated file does not contain queries related to enum in mu model. I am using the following versions
    Copy code
    "dependencies": {
  "apollo-server-express": "^2.15.0",
  "babel-preset-env": "^1.7.0",
  "graphql": "^0.13.2",
  "graphql-cli": "^2.17.0",
  "graphql-yoga": "1.18.3",
  "prisma": "^1.34.10",
  "prisma-binding": "^2.3.16"
},
    can someone please help? 🙂 thanks
    r
    • 2
    • 7
  • k
    Hello, has anyone been able to find a workaround to order by a field in a relationship?. For example, I have a Job model that has an "author" field of the type User and the user has an email address. I'm trying to sort the jobs alphabetically by the email of the author without having to fetch all of the jobs at once and sort them manually.
    r
    • 2
    • 1
  • d
    hey people! does anybody know if the workshops that were hosted today will be available online - missed them but want to watch badly 😞
    ⬆️ 1
  • v
    they were actually recorded so i would guess it's a matter of time they will be available
    👍 3
  • m
    Hey Prisma/Nexus peeps. I saw that the post workshop surveys from Prisma Day today were done in Typeform. Coincidentally, our marketing team suggesting Typeform as a potential tool for gathering customer information in the app we're building. Have the Prisma team peeps, or anyone else for that matter, used Typeform to gather data and used an API to push that data into their db?
    j
    j
    • 3
    • 3
  • r
    Are there any good references/ideas around writing unit tests against prisma? Anyone got good mocking advice there? Ideally I want to test my resolver functions in my app but provide mock in-memory data.
    r
    • 2
    • 2
  • a
    I just tried out two prisma examples, and in both, after I changed the database schema and ran 
    npx prisma introspect
    and 
    npx prisma generate
    , the 
    schema.graphql
    file remained unchanged, even after trying also to run 
    npm run generate
    . Is this intended behavior? The two examples I tried: https://github.com/prisma/prisma-examples/tree/master/typescript/graphql-nextjs and https://github.com/prisma/prisma-examples/tree/master/typescript/graphql-apollo-server
    r
    • 2
    • 3
  • l
    hello everyone, anyone have experience in deploying on heroku?
    j
    j
    • 3
    • 7
  • l
    hey guys I’m trying to deploy on heroku but when I run locally
    Copy code
    prisma deploy
    I’m getting an exception:
    Copy code
    ERROR: GraphQL Error (Code: 404)

{
  "error": "<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n<meta charset=\"utf-8\">\n<title>Error</title>\n</head>\n<body>\n<pre>Cannot POST /management</pre>\n</body>\n</html>\n",
  "status": 404
}
    I’m not getting this because I set the secret key both on prisma.yml than on docker-compose.yml
  • l
    Am I missing something?
  • g
    Hey, guys! Will you post the workshops videos from Prisma Day on some YouTube channel?
    ➕ 1
    n
    • 2
    • 1
  • j
    Hey everyone <!here>, quick reminder: In a few seconds our second Prisma Day will start. Join us over in #prismaday S and watch on https://www.prisma.io/day/ 📺
    prisma green 6
    🇳🇬 3
    fast parrot 14
  • k
    daebak !!!!
    🇳🇬 1
  • s
    awesome
  • k
    Nice background music by the way
    ❤️ 4
    prisma cool 3
  • s
    prisma rainbow 5
  • j
  • m
    I'm trying to make a simple migration tool that runs migrations from .sql scripts using:
    Copy code
    const sql = fs.readFileSync(path.join(basePath, fileName), {
  encoding: 'utf8'
});

await db.executeRaw(sql);
    But I get:
    Copy code
    PrismaClientKnownRequestError: Raw query failed. Code: `1064`. Message: `You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `IndustrySector` (
  `id` int NOT NULL AUTO_INCREMEN' at line 31`
    at PrismaClientFetcher.request (D:\dev\perimetre\export-connect-backend\node_modules\@prisma\client\src\runtime\getPrismaClient.ts:902:15)
    at processTicksAndRejections (internal/process/task_queues.js:97:5) {
  code: 'P2010',
  meta: {
    code: '1064',
    message: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `IndustrySector` (\r\n" +
      "  `id` int NOT NULL AUTO_INCREMEN' at line 31"
  }
}
    Even though if I copy the contents of the sql file and use it with something like Mysql Workbench oh php my admin it works fine. Is 
    executeRaw
    not suited for that? Is there other way that I can do this?
    j
    • 2
    • 3
  • m
    Also is there any updates when the 
    prisma migrate
    command will be released as not experimental features? Not exactly launch dates but whether it is soon-ish?
    j
    h
    a
    • 4
    • 10
1...383384385...637Latest