ccccccickcjbijdjtirncdidihrigchklvnchlcrrckv

I was following the tutorial from this docs ForeignKeyDemo but when i run

npx prisma introspect

i get extra file with sth like this ..

also i was asked these questions when i run that command.

Hi all, I'm having several errors on docker logs after running prisma(1.34 image) I have copied it all into this pastebin: https://pastebin.com/y0e7CbpL I'm having the impression it's something related to java 1.8 sdk on my machine (there is a print of my java info on this pastebin just before the docker logs) I have recently upgraded my pc to install ubuntu 20.04 and this started happening, so I guess I messed up my java install but cannot find where since other things work ok on java here but at the same time, I had no such problems in my previous PC running the exact same project but on ubuntu 18.04 I believe this problem could be something very basic on the java setup but I really cannot figure out, it's probably right there on the logs but I cannot see it If someone could give me some tips on how to start looking for this problem on the right track I'd really appreciate. Thanks!

Hi. Seems like this channel is the most active. I have a question regarding graphql nexus and prisma. I'm thinking of using graphql nexus for my personal project. I am stuck with this error for quite a while and I would appreciate if anyone has any idea.

The change you are trying to make would violate the required relation 'DrinkingLocationsToUser' between the `DrinkingLocations` and `User` models.

The entities are as follows:

model User {
  id               String            @default(cuid()) @id
  username         String
  password         String
  drinkingLocation DrinkingLocations
  profile          Profile
}

model DrinkingLocations {
  id           String   @default(cuid()) @id
  locationName String
  longtitude   Float
  latitude     Float
  createdAt    DateTime @default(now())
  user         User     @relation(fields: [userId], references: [id])
  userId       String
}

For the nexus code I wrote this

schema.objectType({
  name: 'User',
  definition(t) {
    t.string('id', { description: 'Id of the user' });
    t.string('username', { description: 'Name of the user' });
    t.string('password', { description: 'Encrypted password' });
    t.field('DrinkingLocations', {
      type: 'DrinkingLocations',
    });
    t.field('Profile', {
      type: 'Profile',
    });
  },
});

schema.objectType({
  name: 'DrinkingLocations',
  definition(t) {
    t.string('id', { description: 'Id of the Drinking location' });
    t.string('locationName', { description: 'Name of the Drinking Location' });
    t.float('longtitude', { description: 'Longtitude of the Drinking ' });
    t.float('latitude', { description: 'Latitude of the Drinking Location' });
    t.date('createdAt', { description: 'Time when the user started drinking' });
    t.string('userId', { description: 'Foreign key to User' });
    t.field('user', {
      type: 'User',
    });
  },
});

schema.mutationType({
  definition(t) {
    t.crud.createOneUser();
    t.crud.createOneDrinkingLocations();
    t.crud.createOneProfile();
  },
});

But when I try to test it out on Graphql Playground I get that error when executing the mutation query:

mutation {
  createOneDrinkingLocations(
    data: {
      locationName: "ORCHARD GINZA"
      latitude : 35.672422
      longtitude: 139.763155
      user: {
        connect: {
          id: "ckf0gb3wb0000gfzyoen9psbr"
        }
      }
    }
  ){
    id
    locationName
    latitude
    longtitude
    createdAt
  }
}

I'd really appreciate if someone has any clue about this

What are the upcoming features for the next release of prisma?

Also is prisma considering supporting custom migrations? For example if I want to run some sql to change all emails in the db to lowercase?

We just pushed a new article to Prisma's Data Guide on filtering data in PostgreSQL And to tie it all back together, here's how Prisma client handles some of the topics discussed within: • Filtering • Aggregations • Pagination

👋 Join us at week’s events that are featuring or organised by Prisma: • September 15, 3:40PM CEST - Tightening the Full-Stack Development Loop with Nexus and Prisma - A talk by Ryan Chenkie at Geekle React Summit; • September 16, 6PM CEST - Modern backend with TypeScript, PostgreSQL and Prisma - Part 4: Deployment -  • September 17, 5PM CEST - What’s new in Prisma (v2.7.0) -  Looking forward to having you there! 🤗

hey guys, I have a developer complaining about prisma and I'm not sure if he's making any sense

The

prisma migrate save --experimental

command stopped working. I am running v2.6

Hi everyone, so I’m attempting to query a type and I want all instances where a field of that type is null. Is there a proper way to do this? I can think of a solution, however I suspect that solution might create problems elsewhere.

Prisma engine for windows won't go past 75% downloading... while upgrading to 2.7.0 on Windows 10. Version: eaade828a21d8ee3f4940f0af7da3ae0922db4df> Downloading Prisma engines for windows [=============== ] 75%

guys are there any tutorials regarding Prisma2 with POstgresql & Nodejs, express I've looked at docs and grasp basic concept regarding prisma but can't start the project basically I used to use ORM like mongoose in my past projects so are there any video tutorials or blog post regardng this ?

I’ll be doing the final live stream of the modern backend series in 15 minutes. In this episode: continuous integration and deployment of the backed REST API to Heroku with GitHub actions and a small surprise. Join in 😀

will prisma ever support active record pattern in the future?

I'm using V2.7.0 and still have issues with

migrate save

. Error is no such table `_migration' when I do

migrate up

. I delete the database. Re-create it do

migrate save

. But once I do up i get the same the same error

🤗 “What’s new in Prisma (v2.7.0)” live stream is on now!*  *to learn about new releases, planned features, and other interesting bits from the Prisma world.

Hey folks, I was wondering if anyone has an opinionated way of implementing an audit trail type of feature. Is this something you would use prisma for, with say a database trigger or some sort? Or more an API layer concern mostly?

how to upgrade graphql package to 15.3.0 ?

We just published a new article on Prisma’s Data Guide: Top 11 Node.js ORMs, Query Builders & Database Libraries in 2020 Would love to hear what you think. We hope that this will be useful across the board, not just for Prisma users 😄

Hey there, I’m using the typescript graphql-auth example and trying to deploy it to Heroku however I have been having this error during the deployment. The api works fine locally and everything. Any help would be great! Thanks alot 🙂 My repo/code is here: https://github.com/southojere/modern-graphql-api-template

Hi ! I have a problem with my application (Yoga Server + Prisma + GraphQL). I want to deploy my new Schema (3 months of Dev), with "prisma deploy" but I have this error :

>prisma deploy

!    'UNABLE_TO_VERIFY_LEAF_SIGNATURE':

!    request to <https://api.cloud.prisma.sh/>

!    failed, reason: unable to verify the first

!    certificate

Get in touch if you need help: <https://slack.prisma.io>

To get more detailed output, run $ export DEBUG="*"

(node:19452) [DEP0066] DeprecationWarning: OutgoingMessage.prototype._headers is deprecated

raven@2.6.4 alert: failed to send exception to sentry: unable to verify the first certificate

I changed my computer. My application is deployed on Heroku and I paid a Dyno for my backend part, I do not know if the problem comes from the change of computer or the SSL that has been activated on Heroku. thank you

Is there a way to rename an existing field in the

schema.prisma

file and keep the data on migration? I thought

@map("oldFieldName")

should work for that but it doesn't.

The 'Ask a Question' link on the GreetBot is broken. It takes to : https://github.com/prisma/prisma/discussions/new, which gives 'Page Not Found' error, the link should be : https://github.com/prisma/prisma/discussions Hope this helps 😄

Any way to create the migrations without the new experimental feature prisma migrate ?

hi there, wondering if it is idiomatic to deploy prisma as a serverless function or better to keep the node process alive? is there a recommended deployment (containerized process) or function or no recommendation as startup overhead is minimal and the application dictates the runtime requirements? worth pointing out i'm just getting started with prisma but didn't want to lose any runtime caching or other performance benefits by opting into functions by default

Anyone here learning

GraphQL

now ? I'n going to start from scratch to learn core concept with advanced topics too 🔜

How can I insert a new row and connect to an existing relation given a field that is not unique. I would use

connectOrCreate

but I don't want to create and the fields I'm searching on are not unique

Hi folks, technical question here. (Using version 2.6) I'd like to use an environmental variable in heroku to assign my prisma uri to the apollo client. I see in the docs that /graphql is appended to the url I give it and I need to know how to turn this off. I am running graphql on xyz.heroku.com not xyz.heroku.com/graphql. If I hard code the uri in (without the /graphql) it works as expected. Any suggestions are much appreciated 🙂 Here's a related (unanswered) SO post: https://stackoverflow.com/questions/54934559/heroku-config-var-undefined-during-server-side-rendering-with-next-js-apollo-c