在Next.js中使用PRISMA将数据从表单发送到SQLITE数据库的错误

发布于 2025-02-10 18:04:36 字数 1288 浏览 1 评论 0原文

我想将数据添加到我的SQLite数据库中。我正在使用Prisma。但是这样做我会遇到错误。

Error: 
Invalid `prisma.doctor.create()` invocation:

{
  data: '{"id":"1","firstName":"ehshan","middleName":"ehhsns","lastName":"khan","gender":"Female","specialization":"Cardiologist","date":"2022-06-10","phoneNumber":"1234456112","address":"vfdgh dhyh ssvg"}'
        
}

Argument data: Got invalid value '{"id":"1","firstName":"ehshan","middleName":"ehhsns","lastName":"khan","gender":"Female","specialization":"Cardiologist","date":"2022-06-10","phoneNumber":"1234456112","address":"vfdgh dhyh ssvg"}' on prisma.createOneDoctor. 

Provided String, expected DoctorCreateInput or DoctorUncheckedCreateInput:
type DoctorCreateInput {
  id: String

  firstName: String

  middleName: String

  lastName: String

  gender: String

  specialization: String

  date: String

  phoneNumber: String

  address: String
}

我保存数据的代码如下所示。

import { PrismaClient,Prisma } from "@prisma/client"

const prisma = new PrismaClient();

export default async function handler(req, res) {
   
    let user = Prisma.DoctorCreateInput 
    user= JSON.stringify(req.body);
    const saveData = await prisma.doctor.create({
        data: user
    })

    res.json(saveData );
    //console.log(data)
}

I want to add data to my sqlite database. I am using Prisma. But doing so I am getting an error.

Error: 
Invalid `prisma.doctor.create()` invocation:

{
  data: '{"id":"1","firstName":"ehshan","middleName":"ehhsns","lastName":"khan","gender":"Female","specialization":"Cardiologist","date":"2022-06-10","phoneNumber":"1234456112","address":"vfdgh dhyh ssvg"}'
        
}

Argument data: Got invalid value '{"id":"1","firstName":"ehshan","middleName":"ehhsns","lastName":"khan","gender":"Female","specialization":"Cardiologist","date":"2022-06-10","phoneNumber":"1234456112","address":"vfdgh dhyh ssvg"}' on prisma.createOneDoctor. 

Provided String, expected DoctorCreateInput or DoctorUncheckedCreateInput:
type DoctorCreateInput {
  id: String

  firstName: String

  middleName: String

  lastName: String

  gender: String

  specialization: String

  date: String

  phoneNumber: String

  address: String
}

My code for saving the data is shown below.

import { PrismaClient,Prisma } from "@prisma/client"

const prisma = new PrismaClient();

export default async function handler(req, res) {
   
    let user = Prisma.DoctorCreateInput 
    user= JSON.stringify(req.body);
    const saveData = await prisma.doctor.create({
        data: user
    })

    res.json(saveData );
    //console.log(data)
}

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文