With the new nativeTypes preview, does it mean we can use postgres types like Interval?

Are there any new updates with how to test with Prisma? 1. Currently I mock each response (I suppose thats unit testing) 2. Is it possible to start a global transaction and cancel it after the test? (This would be more like integration testing I guess but thats how Rails/Django do it) 3. Any plans for factories?

Hello Guys We use prisma 1 at where i work and we ran into an issue which we find hard to resolve. we added a new field to a model we running the yarn deploy command we had this error which prevents the field from beign added. Any help will be appreciated

ERROR: Variable "$input" got invalid value {"workspaceSlug":null,"clusterName":"default","serviceName":"new-leaders","stageName":"develop"}; Expected non-nullable type String! not to be null at value.workspaceSlug.
{
  "errors": [
    {
      "message": "Variable \"$input\" got invalid value {\"workspaceSlug\":null,\"clusterName\":\"default\",\"serviceName\":\"new-leaders\",\"stageName\":\"develop\"}; Expected non-nullable type String! not to be null at value.workspaceSlug.",
      "locations": [
        {
          "line": 2,
          "column": 17
        }
      ],
      "code": 222
    }
  ],
  "status": 400
}

Hey Is there any way to perform this query? I have seen atomic operations on the update, does that exist on findMany?

await prisma.offers.findMany({
        where: {
            status: {
                lt: offers.statusValue //based on any other field on that table
            }
        }
    })

hi, i wonder what's the best way now to integrate prisma with graphql? i know that prisma 2 is just a query engine now and not like the old days and some graphql operation is offloaded to something like nexus but it just feels unnatural

i really liked that prisma SDL -> graphql API direct design

it was because prisma go away from this model i changed to hasura, but hasura is also somewhat limiting as well (e.g. websocket is actually live refresh which is not strictly pubsub)

anyone here deploy their prisma API via Google Cloud Services? I'm attempting to get running on the App Engine and am hitting an error. I'm wondering if I should move to Cloud Engine to boot up a VM.

Updating service [default] (this may take several minutes)...failed.
ERROR: (gcloud.app.deploy) Error Response: [9]
Application startup error! Code: APP_CONTAINER_CRASHED
> med-planner-server@1.0.0 start /app
> node ./graphql/index.js
/app/node_modules/.prisma/client/index.js:3
    throw new Error(
    ^
Error: @prisma/client did not initialize yet. Please run "prisma generate" and try to import it again.

hi everyone, I have a weird behavior on my query that returns a list of Albums, with an artist relation. I got null on artist field : here is my query and the schema :

// query 
query {
  allAlbums {
    name
    artist {
      id
      lastName
    }
  }
}

// schema
model Artist {
  id        String  @id @default(cuid())
  firstName String
  lastName  String
  stageName String
  cover     String
  age       Int?
  biography String?
  song      Song[]
  album     Album[]
}

model Album {
  id       String  @id @default(cuid())
  name     String
  cover    String
  genre    Genre?  @default(POP)
  artistId String?
  artist   Artist? @relation(fields: [artistId], references: [id])
}

the query returns a list of albums but Artist is null, knowing that I have the artistId in the albums table in db… anyone can help please ?

I am trying set up prisma with a remote MySQL database, connection and credentials are verified through mysql-client. Nevertheless, I get the error message: _java.sql.SQLSyntaxErrorException: (conn=1446758) Access denied for user 'maraxaic_graphql'@'87.187.51.%' to database 'prisma'_. I assigned all available permissions to this user through my host provider. I notice that the error message mentions the database 'prisma' but my database name is maraxaic_graphql. 'prisma' does not exist on my host. Any help is greatly appreciated, thanks in advance.

Hello I’ve upgraded to the latest prisma and now when I tried to migrate I get this .. what should I do. Thanks

prismo gif “What’s new in Prisma (v2.11.0)” live stream is starts in less than 10 minutes! Once again, Ryan and Niko from Prisma talk about new releases, planned features and other interesting bits from the Prisma world - this time they are also joined by a surprise guest! 

Tune in here▾

! prisma cool

A new guide on managing privileges in MySQL using roles is up on Prisma's Data Guide: https://www.prisma.io/dataguide/mysql/authentication-and-authorization/role-management

I have a postgres database on heroku and want to try out the new

prisma migrate

. When I run it, I get a "permission denied to create database" error. Sounds reasonable for me because the database isn't mine but why wants prisma to create a new database instead of the tables?

any idea?

Hey, is there any way I can do something like this:

# schema.prisma

datasource db {
    provider = "postgresql"
    url      = "file:./test.db"
}

For postgres? I need to create a mock db for tests in order to not pollute production database. Right now I am getting this error (which is clear):

Error validating datasource `db`: The URL for datasource `db` must start with the protocol `postgresql://`

Prisma2 warns that installing globally can cause trouble. Well, that happened to me. While experimenting with different installations of v1 and v2, somehow my system got messed up. Now, when I install a version with npm, the installation is successfully completed, the nodes_modules are created and the package.json list the version but I cannot initialize a project. When I run 'prisma -v' or 'prisma2 -v' no installation is recognized. What can I do?

Facing a problem with Prisma vscode plugin, auto formatting doesn't working and shows error: The prisma language server crashed 5 times.... Both are latest version. Any solution?

Anybody have any success with implementing a timestamp using custom data type into prisma using postgresql?

How "experimental" is the Transaction API? Is it solid enough to rely on? I don't need to do complex things with it, just creations.

🙌 Tomorrow at 6PM CET you can catch Jason Kuhrt, Software Developer at Prisma, giving a talk titled Introduction to Nexus Schema at the Node.js Wroclaw Meetup! You can here or RSVP to the event on Meetup. graphqlfast parrotprisma cool

hey yall, i'm trying to boot up prisma studio on a container instance on google cloud platform and im having some issues getting it to run

Does anyone know what’s the best approach to reset everything (migrations, tables, prisma generated schemas, etc) ?

Can anyone please tell me what is wrong with this query?

_const_ _user = await _prisma_.user.findMany({
        where: {
          OR: [
            { email: {equals: _email_} },
            { phone: {equals: _phone_} }
          ]
        },
take: 1

for some reason result that don't satisfy either conditions

fast parrot Jason is ON in 15 minutes with his Introduction to Nexus Schema - at the Node.js Wroclaw Meetup. . graphqlnode parrot

How do the following two old-type-datamodel type definitions translate to the new datamodel (prisma 1.34.10)?

author: User! @relation(name: "UserToPost", onDelete: SET_NULL)

 

comments: [Comment!]! @relation(name: "CommentsToPost", onDelete: CASCADE)

Hey! How would you save the connection/relation between the old & new model when changing a model's name? I know it's not possible with Prisma to do that kind of things but when I would implement that on my own, how could I do that? I have an idea to store the table names in a migration-like database table, any thoughts on this? Would be cool to hear some opinions/feedback. 🙂

Greetings all 🙂 I am experimenting with SQL Server and Prisma using the preview connector. I was able to follow the tutorial and introspect the db and generate... All is well there. Now I want to use that connection as part of docker-compose (

prismagraphql/prisma:1.34

image) so I can use the playground with SQL Server, but it fails for

unknown connector

when running

docker-compose up -d

(I tried 'sqlserver'). Is this supported, and if not, does anyone know of a way to create a GraphQL playground?

Hi Everyone. Has anyone experienced an error with the playground with "could not find config" ? It's a really odd error, that some of my users experience. I'm unable to reproduce it, and it's only a few people who gets it, but it's blocking those users comepletely.