prisma | A Slim 3 based skeleton project

I'm trying to apply some SQL optimization for GraphQL queries containing relations. I use Prisma (v. 2.24.1), Nexus (v. 1.0.0), nexus-plugin-prisma (v. 0.35.0) and graphql (v. 15.5.0).

schema.prisma:

I am trying to insert a row into database provided that - number of rows satisfying some condition already in the table is less than certain threshold, say 10. For example, in below model, I don't want to have a project to have more than 10 users; so count(projectId) should be less than 10:

How can I Run node.js project in UTC instead of local timezone? and How can I use UTC, when I want to define a model with prisma.js?

So I have an Express / TypeGraphql backend running at localhost:5000 and Next / React app running at localhost:3000. I decided to use apollo-server for graphql API and apollo-client for the front end. After a successful login, I store httpOnly cookies in web browser.

What I want to do is, get cookies in every request and authorize the user if oauth2 tokens are valid. Even though requests are valid, and I get the query, cookies are shown as null. Also, I got no error in the console.

Here I save cookies =>

I have these 3 prisma models,

I've used prisma.js as an ORM in my project.

After executing the npx prisma migrate dev --name rename_and_add_some_columns, I got this error:

We found changes that cannot be executed

Error Details:

Step 1 Added the required column CategoryId to the Post table without a default value. There are 2 rows in this table, it is not possible to execute this step. • Step 1 Added the required column ModifiedDate to the Post table without a default value. There are 2 rows in this table, it is not possible to execute this step. • Step 2 Added the required column ModifiedDate to the Profile table without a default value. There are 1 rows in this table, it is not possible to execute this step. • Step 4 Added the required column ModifiedDate to the User table without a default value. There are 2 rows in this table, it is not possible to execute this step.

You can use prisma migrate dev --create-only to create the migration file, and manually modify it to address the underlying issue(s). Then run prisma migrate dev to apply it and verify it works.

How can I solve it?

// This is my Prisma schema file,

I am trying to generate user id using uuid npm package for the id field in the user type. I am not sure where and how should I write it.

In my createUser mutation I am only asking the user to put in values for the name and email but not the id, as I wanted it to be generated by the uuid package, which is what I believe I have done it correctly in the createUser mutation.

Here is what I have in my schema.graphql file

I'm currently undergoing a rewrite of my Discord bot, and in this process I need to rewrite all of my SQL queries and convert them into Prisma queries.

SQL query I', trying to convert into Prisma: connection.query('SELECT inviterId, count(*) as count FROM invites where serverId = ? AND valid = 1 GROUP BY inviterId ORDER BY count DESC')

I currently have this:

I am getting this error message from prisma when I am running the graphql query. Environment variable not found: DATABASE_URL.\n --> schema.prisma:6\n | \n 5 | provider = "postgresql"\n 6 | url = env("DATABASE_URL")\n | \n\nValidation Error Count: 1",

At first I didn't have the .env file in any of my project folders, then I added it with the link to the database url, still not working. Here is folder structure

**This is what I have inside of my .env file -

DATABASE_URL="postgres://postgres:mypassword@db.pqtgawtgpfhpqxpgidrn.supabase.co:5432/postgres"**

Please help.

Thank you all.