'npx prisma db seed' not responding

anyone have this issue where seeding the db does nothing and gets stuck? screenshot at the bottom of this post

this is my seed.ts

import { PrismaClient } from "@prisma/client";
import { hash } from "bcrypt";
const prisma = new PrismaClient();


export async function main(){
  const password = await hash('test', 123)
  const user = await prisma.user.upsert({
    where: {
      email: 'test@test.com'
    },
    update:{},
    create:{
      email: 'test@test.com',
      name: 'Test User',
      password: password
    }
  })

  console.log(user)
}

main()
  .then(() => prisma.$disconnect())
  .catch(async (e) => {
    console.error(e)
    await prisma.$disconnect()
    process.exit(1)
  })

import { PrismaClient } from "@prisma/client";
import { hash } from "bcrypt";
const prisma = new PrismaClient();


export async function main(){
  const password = await hash('test', 123)
  const user = await prisma.user.upsert({
    where: {
      email: 'test@test.com'
    },
    update:{},
    create:{
      email: 'test@test.com',
      name: 'Test User',
      password: password
    }
  })

  console.log(user)
}

main()
  .then(() => prisma.$disconnect())
  .catch(async (e) => {
    console.error(e)
    await prisma.$disconnect()
    process.exit(1)
  })

import { PrismaClient } from "@prisma/client";
import { hash } from "bcrypt";
const prisma = new PrismaClient();


export async function main(){
  const password = await hash('test', 123)
  const user = await prisma.user.upsert({
    where: {
      email: 'test@test.com'
    },
    update:{},
    create:{
      email: 'test@test.com',
      name: 'Test User',
      password: password
    }
  })

  console.log(user)
}

main()
  .then(() => prisma.$disconnect())
  .catch(async (e) => {
    console.error(e)
    await prisma.$disconnect()
    process.exit(1)
  })

import { PrismaClient } from "@prisma/client";
import { hash } from "bcrypt";
const prisma = new PrismaClient();


export async function main(){
  const password = await hash('test', 123)
  const user = await prisma.user.upsert({
    where: {
      email: 'test@test.com'
    },
    update:{},
    create:{
      email: 'test@test.com',
      name: 'Test User',
      password: password
    }
  })

  console.log(user)
}

main()
  .then(() => prisma.$disconnect())
  .catch(async (e) => {
    console.error(e)
    await prisma.$disconnect()
    process.exit(1)
  })

Solution

oh i figured it out, you don't set the schema to password: password, you just say password

Jump to solution

Machina0OP•8/11/23, 2:06 AM

also, when i change the seeding file to:

Machina0OP•8/11/23, 2:06 AM

import { PrismaClient } from "@prisma/client";
import { hash } from "bcrypt";
const prisma = new PrismaClient();


export async function main(){
  
  const user = await prisma.user.upsert({
    where: {
      email: 'test@test.com'
    },
    update:{},
    create:{
      email: 'test@test.com',
      name: 'Test User',
      password: "password"
    }
  })

  console.log(user)
}

main()
  .then(() => prisma.$disconnect())
  .catch(async (e) => {
    console.error(e)
    await prisma.$disconnect()
    process.exit(1)
  })

import { PrismaClient } from "@prisma/client";
import { hash } from "bcrypt";
const prisma = new PrismaClient();


export async function main(){
  
  const user = await prisma.user.upsert({
    where: {
      email: 'test@test.com'
    },
    update:{},
    create:{
      email: 'test@test.com',
      name: 'Test User',
      password: "password"
    }
  })

  console.log(user)
}

main()
  .then(() => prisma.$disconnect())
  .catch(async (e) => {
    console.error(e)
    await prisma.$disconnect()
    process.exit(1)
  })

Machina0OP•8/11/23, 2:06 AM

it now works

Machina0OP•8/11/23, 2:10 AM

so it seems like the seed.ts file doesn't like me using bcrypt.hash() in the way i'm using it

Solution

Machina0•8/11/23, 2:22 AM

oh i figured it out, you don't set the schema to password: password, you just say password

MMachina0 oh i figured it out, you don't set the schema to password: password, you just sa...

Mocha•8/11/23, 3:17 AM

Isn't that just an ESLint rule? { password }{ password } is equivalent to { password : password }{ password : password }

MMocha Isn't that just an ESLint rule? `{ password }` is equivalent to `{ password : pa...

Machina0OP•8/11/23, 3:18 AM

yeah on second thought it might have been the hash('test', 123)

Machina0OP•8/11/23, 3:18 AM

i think thats an invalid second argument

Machina0OP•8/11/23, 3:18 AM

but i changed both at the same time before running npx prisma db seednpx prisma db seed again

Machina0OP•8/11/23, 3:19 AM

and after that it worked. I think maybe 12 is a specific thing and not an random seed to a hash function

Mocha•8/11/23, 3:23 AM

from their README, argument 2 is:

salt - [REQUIRED] - the salt to be used to hash the password. if specified as a number then a salt will be generated with the specified number of rounds and used

https://github.com/kelektiv/node.bcrypt.js#api

GitHub

GitHub - kelektiv/node.bcrypt.js: bcrypt for NodeJs

bcrypt for NodeJs. Contribute to kelektiv/node.bcrypt.js development by creating an account on GitHub.

'npx prisma db seed' not responding

Similar Threads

Similar Threads

Similar Threads