pray Hi I lost 24 hours with this problem Can you make any Prisma #orm-help

:pray: Hi. I lost 24 hours with this problem. Can ...

Yiğit Rüzgar

12/10/2020, 10:41 AM

🙏 Hi. I lost 24 hours with this problem. Can you make any suggestions? When I run createDraft2 mutation, I get error. I show the problem in this video: t.ly/f2wd

Ryan

12/10/2020, 10:45 AM

Hey @Yiğit Rüzgar 👋 Could you share the resolver of your

createDraft2

mutation? It seems that

findUnique

cannot get the argument in

where

Yiğit Rüzgar

12/10/2020, 10:50 AM

Thanks a lot. You are ultra speed.

Yiğit Rüzgar

12/10/2020, 10:53 AM

This is second video for you: t.ly/pp8f

Yiğit Rüzgar

12/10/2020, 10:55 AM

Gorevlendirmeler.ts - Mutations

Yiğit Rüzgar

12/10/2020, 10:55 AM

Gorevlendirmeler.ts - Queries

Yiğit Rüzgar

12/10/2020, 10:57 AM

models.ts @Ryan

Yiğit Rüzgar

12/10/2020, 10:58 AM

types.ts

Yiğit Rüzgar

12/10/2020, 11:00 AM

mutation($xxx: Int) { createDraft2( data: { surec_numara: 2 gorev_numara: 2 ana_gorev_numara: 4 ana_gorev: "6" baslik: "assda" tarih: "12/12/2020" saat: "145500" termin_dk: 2 termin_gun: 2 termin_saat: 6 eklenme_tarihi: "12/12/2020" eklenme_saati: "141414" aktif: "1" bitirilmesi_gereken_tarih: "12/12/2020" bitirilmesi_gereken_saat: "141412" bitirme_tarihi: "12/12/2020" bitirme_saati: "161616" bitirme_notu: "asd" ekleyen_numara: 6 opsiyonel: "6" gorevlipersonel: { connect: { numara: $xxx } } } ) { baslik } } ---------------->>>>>>>>>>>>>> { "errors": [ { "message": "\nInvalid

prisma.yonetim.findUnique()

invocation:\n\n{\n where: {\n? numara?: Int\n },\n select: {\n gorevlipersonel: true\n }\n}\n\nArgument where of type GorevlendirmelerWhereUniqueInput needs at least one argument. Available args are listed in green.\n\nNote: Lines with ? are optional.\n", "locations": [ { "line": 2, "column": 3 } ], "path": [ "createDraft2" ], "extensions": { "code": "INTERNAL_SERVER_ERROR", "exception": { "clientVersion": "2.12.1", "stacktrace": [ "Error: ", "Invalid

prisma.yonetim.findUnique()

invocation:", "", "{", " where: {", "? numara?: Int", " },", " select: {", " gorevlipersonel: true", " }", "}", "", "Argument where of type GorevlendirmelerWhereUniqueInput needs at least one argument. Available args are listed in green.", "", "Note: Lines with ? are optional.", "", " at Document.validate (/var/www/vhosts/developer3.xyz/next.developer3.xyz/next-auth/node_modules/@prisma/client/runtime/index.js7741319)", " at NewPrismaClient._executeRequest (/var/www/vhosts/developer3.xyz/next.developer3.xyz/next-auth/node_modules/@prisma/client/runtime/index.js7906517)", " at /var/www/vhosts/developer3.xyz/next.developer3.xyz/next-auth/node_modules/@prisma/client/runtime/index.js7900252", " at AsyncResource.runInAsyncScope (async_hooks.js1869)", " at NewPrismaClient._request (/var/www/vhosts/developer3.xyz/next.developer3.xyz/next-auth/node_modules/@prisma/client/runtime/index.js7900225)", " at Object.then (/var/www/vhosts/developer3.xyz/next.developer3.xyz/next-auth/node_modules/@prisma/client/runtime/index.js7911939)", " at processTicksAndRejections (internal/process/task_queues.js975)" ] } } } ], "data": null }

Ryan

12/10/2020, 11:04 AM

ctx.userId

available? Because in your query you are passing it via a variable:

Copy code

gorevlipersonel: { connect: { numara: $xxx } }

And in the resolver you are using

ctx.userId

Copy code

gorevliPersonel: { connect: { numara: ctx.userId } }

Ryan

12/10/2020, 11:05 AM

I would suggest removing the

connect

and checking if it works. If it does, it means there could be an issue that the

userId

is not defined in the context.

Yiğit Rüzgar

12/10/2020, 11:05 AM

https://github.com/adnanfuat/next-auth-test This is git repo..

Yiğit Rüzgar

12/10/2020, 11:06 AM

When ı change ctx.userId with static number, type safe propery doesnt allow execute query.

Ryan

12/10/2020, 11:08 AM

What the error or message you get when you replace it with a number?

Ryan

12/10/2020, 11:16 AM

Also your

schema.prisma

doesn’t contain all the models that you have specified here. Could you add them to the repo so that I can reproduce?

Yiğit Rüzgar

12/10/2020, 11:52 AM

Sorry for late.. I added repo..

Yiğit Rüzgar

12/10/2020, 11:53 AM

Third Video:

https://www.youtube.com/watch?v=tCO4GL5mreM▾

Yiğit Rüzgar

12/10/2020, 12:00 PM

UserId is avaliable in token

Ryan

12/10/2020, 12:00 PM

But is it available in the resolver?

Yiğit Rüzgar

12/10/2020, 12:10 PM

I can't get a solution after this point. Give me help, please..

Ryan

12/10/2020, 12:36 PM

Checking your repo locally, it seems like there's an issue in the permissions you specified in the

rules.ts

file. I'll check what's the issue in the rule of

createDraft2

Yiğit Rüzgar

12/10/2020, 12:36 PM

thanks.

Ryan

12/10/2020, 12:50 PM

This is causing an issue in `rules.ts`:

Copy code

isGorevlendirmelerOwner: rule({ cache: 'contextual' })(
    async (_parent, { numara }, ctx: Context) => {
      try {
        const gorevli = await ctx.prisma.gorevlendirmeler
          .findUnique({
            where: {
              numara,
            },
          })
          .gorevlipersonel()
        console.log('bayrak2')
        return ctx?.userId === gorevli?.numara
      } catch (e) {
        return e
      }
    }
  ),

There’s no such variable as

numara

in the args.

Yiğit Rüzgar

12/10/2020, 12:55 PM

what must be ? * And, ı didnt understand that, where from, args passed here..

Ryan

12/10/2020, 12:58 PM

args

are you passed in

createDraft2

like the

data

Copy code

createDraft2(
    data: {
      surec_numara: 2
      gorev_numara: 2
      ana_gorev_numara: 4
      ana_gorev: "6"
      baslik: "assda"
      tarih: "12/12/2020"
      saat: "14:55:00"
      termin_dk: 2
      termin_gun: 2
      termin_saat: 6
      eklenme_tarihi: "12/12/2020"
      eklenme_saati: "14:14:14"
      aktif: "1"
      bitirilmesi_gereken_tarih: "12/12/2020"
      bitirilmesi_gereken_saat: "14:14:12"
      bitirme_tarihi: "12/12/2020"
      bitirme_saati: "16:16:16"
      bitirme_notu: "asd"
      ekleyen_numara: 6
      opsiyonel: "6"
      gorevlipersonel: { connect: { numara: $xxx } }
    }
  ) {
    baslik
  }
}

Here the

data

is the args. that you have passed.

Yiğit Rüzgar

12/10/2020, 12:59 PM

Ok, ı understood args. Now, what must I do ?

Ryan

12/10/2020, 1:01 PM

What are you trying to check in the rule above?

Yiğit Rüzgar

12/10/2020, 1:03 PM

The user with the "userId" number in the token can add with the "createDraft" mutation.

Ryan

12/10/2020, 1:05 PM

Then it would better to add it this way:

Copy code

isGorevlendirmelerOwner: rule({ cache: 'contextual' })(
    async (_parent, _args, ctx: Context) => {
      try {
        const gorevli = await ctx.prisma.yonetim.findUnique({
          where: {
            numara: ctx.userId,
          },
        })
        console.log('bayrak2')
        return ctx?.userId === gorevli?.numara
      } catch (e) {
        return e
      }
    }
  ),

Yiğit Rüzgar

12/10/2020, 1:47 PM

Thanks. I am examining the new codes. I will return to you 🙏

💯 1

Yiğit Rüzgar

12/10/2020, 2:15 PM

is there a short way cancel graphql-shield temporary for look the mutations and queries work correctly

Ryan

12/10/2020, 2:26 PM

Comment out the rules in the

rules.ts

Yiğit Rüzgar

12/10/2020, 4:48 PM

Thanks a lot.. I passed to other steps of your helps. Now, I get some errors with date and time fields.. How can I integrate my database date and time fields with Schema Datetime fields ? I suppose that converto isoString, but how ? /// Lastly I insert this values, and problem is solved. ( 2020-05-05T163444.719+03:00 ) What is the best way, for the Datetime fields.

💯 1

Ryan

12/11/2020, 5:34 AM

Yes that's correct you would need to pass an ISO string. So if you have a Date object, you can pass:

date.toISOString()

Yiğit Rüzgar

12/11/2020, 2:07 PM

thank you..

🙌 2

4 Views

Open in Slack

Previous Next