Prisma not creating records

Question

I'm trying to run a simple seed function to generate some test data for an application. The app is built on NextJS 14 which utilizes server actions. The function is being called and no errors are being thrown, but there are new rows generated when I check the database.

Client code:

import { useEffect } from "react"
import { seedGuests } from "./actions"

export default function Welcome() {
  useEffect(() => {
    seedGuests()
  }, [])

Actions code:

"use server"
import { prisma } from "@/prisma/client"

export async function seedGuests() {
  try {
    prisma.guest.create({
      data: {
        name: "John Doe",
        can_bring_guest: true,
      },
    })
    prisma.guest.create({
      data: {
        name: "Billy Sparks",
        can_bring_guest: false,
      },
    })
    console.log("guests created")
  } catch (e) {
    console.log(e)
  }
}

prisma/client.ts code:

import { PrismaClient } from "@prisma/client"
export const prisma = new PrismaClient()

prisma.schema:

model guest {
  id              Int      @id @default(autoincrement())
  name            String
  attending       Boolean?
  guest_count     Int?
  can_bring_guest Boolean
}

I see the "guests created" console log in the terminal and no errors are logged. However, no new rows are created in the database.

did u create the tables first. npx prisma migrate dev

Yilmaz
– Yilmaz

2023-12-21 20:36:03 +00:00
Commented Dec 21, 2023 at 20:36 — Yilmaz
– Yilmaz, Commented Dec 21, 2023 at 20:36
@Yilmaz Yes I did

juju
– juju

2023-12-21 20:40:27 +00:00
Commented Dec 21, 2023 at 20:40 — juju
– juju, Commented Dec 21, 2023 at 20:40

Hoopra · Accepted Answer · 2023-12-21 20:39:57Z

1

You need to await prisma queries:

    await prisma.guest.create({
      data: {
        name: "John Doe",
        can_bring_guest: true,
      },
    })
    await prisma.guest.create({
      data: {
        name: "Billy Sparks",
        can_bring_guest: false,
      },
    })

Your code starts the executions, then logs the message, but doesn't wait for the seed data to be inserted.

answered Dec 21, 2023 at 20:39

Hoopra

8631 gold badge7 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Prisma not creating records

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related