Hi team! I'm trying to port a ruby codebase over to node + prisma. I'm having trouble replicating this functionality though

ActiveRecord::Base.connection.execute(
      <<-SQL
        SET "hasura.user" = '#someuser'
      SQL
    )

How can I inject this sort of behaviour into prisma? Or is it just not possible?

Hey Prisma Team, Do you why does prisma rawquery not work when I'm passing a variable. This wokrs if the variable is a number, but anything inside quotes is not working. Example from docs

const email = '<mailto:emelie@prisma.io|emelie@prisma.io>'
const result = await prisma.$queryRaw`SELECT * FROM User WHERE email = ${email}`

This would not work as

email

is enclosed in qoutes. It would work if

const email = 2

for example DB : mySql

hi, why does findMany disappear from the client API for my model when I add a multiple field @@unique?

@@unique([user_id, auth_type])

neither user_id or auth_type is unique on their own

Prisma is silently crashing when it tries to connect to the database. (

prisma.$connect()

or any primsa query) Commands like

prisma db push

work perfectly fine in the same environment.

logs when

DEBUG=*

env is set

This crashes my entire application with no errors in console.

any ideas on how to debug this issue?

Anyone?

I tried searching this channel but haven't found any good solutions to dealing with vercel's preview branches & having multiple databases. Do y'all set up staging database branches and force push to staging branches in order to test out changes in a QA environment? Otherwise, multiple devs with different branches pushing to the preview

DATABASE_URL

will all have migration errors. Anyone have a solid creative solution to this besides force pushing to staging branches w/ specific `DATABASE_URL`s defined to them?

Hi guys, I’m trying to update two tables at once. Except when I add the linked table: user --> update, I’m getting a type error that roleId should be undefined. However, if I remove the update to the linked table, the type error disappears and roleId correctly expects a string. Does anyone know what I’m doing wrong here?

data: {
        roleId: 'UEET',
        user: {
          update: {
            ...rest,
          },
        },
      },

Hi, I cannot find in documentation how to connect to AWS database using secrets?

Hello , i have a little question so, is it possible to add data when i create table (npx db push)

Hi 🤘 I have follow this article to be able to use multiple .env files, but that doesn't works. https://www.prisma.io/docs/guides/development-environment/environment-variables/using-multiple-env-files i use prisma with nestjs.

"start:dev": "dotenv -e ./.env.local -- nest start --watch",

When lauching

npm start run:dev

I have the following error

Error: error: Environment variable not found: DATABASE_URL.
  -->  schema.prisma:10
   | 
 9 |   provider = "postgresql"
10 |   url      = env("DATABASE_URL")
   |

Working solution :

dotenv -e .env.local -- npm start run:dev

Do you have an idea ?

hello guys!! can anyone help me with this problem? please!!! https://stackoverflow.com/questions/73389837/prisma-not-assignable-to-type-error-on-trying-to-update-a-field

This message was deleted.

When creating models, I want all my models to have certain fields such as

createdAt

,

updatedAt

,

deletedAt

, etc. Do I have to manually create them on every field or is there a place in prisma I can add it once, and have it add on every model?

Posting in general, I am getting the following error on AWS lambda deploy.

{
  "errorType": "Error",
  "errorMessage": "@prisma/client did not initialize yet. Please run \"prisma generate\" and try to import it again.\nIn case this error is unexpected for you, please report it in <https://github.com/prisma/prisma/issues>",
  "stack": [
    "Error: @prisma/client did not initialize yet. Please run \"prisma generate\" and try to import it again.",
    "In case this error is unexpected for you, please report it in <https://github.com/prisma/prisma/issues>",
    "    at new PrismaClient (/var/task/node_modules/.prisma/client/index.js:3:11)",
    "    at Object.<anonymous> (/var/task/index.js:90:10)",
    "    at Module._compile (internal/modules/cjs/loader.js:1085:14)",
    "    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1114:10)",
    "    at Module.load (internal/modules/cjs/loader.js:950:32)",
    "    at Function.Module._load (internal/modules/cjs/loader.js:790:12)",
    "    at Module.require (internal/modules/cjs/loader.js:974:19)",
    "    at require (internal/modules/cjs/helpers.js:101:18)",
    "    at _tryRequireFile (/var/runtime/UserFunction.js:71:32)",
    "    at _tryRequire (/var/runtime/UserFunction.js:159:20)"
  ]
}

I can see my CI/CD generates prisma client.

Hi all, I am trying to make the sum of some culmns but without success, here is the idea:

const customers = await prisma.employee.findMany({
    include: {
        workingHours: true,
    },
})

output:

[
    {
        "id": 1,
        "name": "beth",
        "surname": "halvorson",
        "gender": "Female",
        "email": "<mailto:bethhalvorson@gmail.com|bethhalvorson@gmail.com>",
        "phone": "501-945-084",
        "code": "kn7v6",
        "points": 12941,
        "workingHours": [
            {
                "id": 1,
                "normalTime": 7,
                "overTime": 1,
                "doubleTime": 1,
                "vacationTime": 0,
                "sickTime": 0,
                "employeeId": 1,
            },
            {
                "id": 2,
                "normalTime": 4,
                "overTime": 3,
                "doubleTime": 1,
                "vacationTime": 0,
                "sickTime": 0,
                "employeeId": 1,
            },
        ]
    },
]

I want to change the query to receive smth like this:

[
    {
        "id": 1,
        "name": "beth",
        "surname": "halvorson",
        "gender": "Female",
        "email": "<mailto:bethhalvorson@gmail.com|bethhalvorson@gmail.com>",
        "phone": "501-945-084",
        "code": "kn7v6",
        "points": 12941,
        "_sum": {
            "totalHours": 18,
        },
    },
]

where _sum: is the total of all columns(normalTime, overTime, vacationTime, sickTime) I didn't want to use javascript methods to achieve that

Hello Prisma, Any idea why the args of mongodb raw queries operations are under

outputObjectTypes

and not under

inputObjectTypes

like all other operations?

Hello, I get an error like this `Unique constraint failed on the constraint: `PersonalData_userId_key`` but I don’t know why. It is the current relationship.

_model_ User {

personalData _PersonalData_?

}

model PersonalData {

user   _User_ @relation(_fields_: [userId], _references_: [id], _onDelete_: Cascade, _onUpdate_: Cascade)

userId _Int_  @unique

}

Hey everyone! I have this issue with many to many relationship. My question is why when implicit, it creates only 1 relation if the tables are named survey and question the created table is _SurveyToQuestion but I don't see the _QuestionToSurvey table. Is there something I'm confusing? In that case sorry for my ignorance, but in my specific scenario a survey can have many questions and a question can be in many surveys. Thanks for your help

I’ve been reading the softdelete middleware example. It’s great! See https://www.prisma.io/docs/concepts/components/prisma-client/middleware/soft-delete-middleware I have a follow up question someone here may know the answer too: Would this also block a query like

prisma.user.findMany({ select: { posts: true } })

from returning a soft-delete post?

Hey everyone, do you guys know hot to use Full text search with Spanish language ?

Hi all! Is there any way to convert a

Prisma.ProductWhereInput

into a raw WHERE statement? Or to get the SQL for a call like

prisma.product.find_many({ where })

?

Hey folks, I'm using prism search, for the search in 2 columns of my table, firstName and lastName, but it gives me an error when I search for the same string in both fields.

where: {
        firstName: { search: 'word' },
        lastName: { search: 'word' },
      } // this is an error

but when I try to use differents string in the firstName and lastname is correct the function

Hi, how can I use a custom query for the Where clause?

I need to do some manipulation on the field before comparison:

SELECT <fields> FROM <db.table> WHERE regexp_replace(mobile_phone, '[^\w]', 'g') = <value>