Currently, I am immersed in my inaugural full-stack app development project, which is aligning with an online course. Unfortunately, I have encountered a major stumbling block that has persisted despite hours of troubleshooting. The issue arises when I try to add a new user to a Postgres DB using the command line interface.
import bcrypt from 'bcrypt'
import jwt from 'jsonwebtoken'
import cookie from 'cookie'
import { NextApiRequest, NextApiResponse } from 'next'
import prisma from '../../lib/prisma'
export default async (req: NextApiRequest, res: NextApiResponse) => {
const salt = bcrypt.genSaltSync()
const { email, password } = req.body
let user
try {
user = await prisma.user.create({
data: {
email,
password: bcrypt.hashSync(password, salt),
},
})
} catch (e) {
res.status(401)
res.json({ error: 'User already exists' })
return
}
const token = jwt.sign(
{
email: user.email,
id: user.id,
time: Date.now(),
},
'hello',
{ expiresIn: '8h' }
)
res.setHeader(
'Set-Cookie',
cookie.serialize('TRAX_ACCESS_TOKEN', token, {
httpOnly: true,
maxAge: 8 * 60 * 60,
path: '/',
sameSite: 'lax',
secure: process.env.NODE_ENV === 'production',
})
)
res.json(user)
}
To attempt adding the user, I used the following command through HTTPie:
http POST :3000/api/signup <a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="7a1f171b131647123a1254191517">[email protected]</a> password=abcabc
Initially, there was an error regarding the data attribute, which got resolved post-running 'prisma generate'.
Now, the persistent error message states: User already exists.
However, upon checking the Prisma Studio in the Users table, it's clear that there isn't any newly created user present.
Response received:
HTTP/1.1 401 Unauthorized
Connection: keep-alive
Content-Length: 31
Content-Type: application/json; charset=utf-8
Date: Sun, 05 Jun 2022 19:57:59 GMT
ETag: "1f-lFUySNKwX3L5eGEwGcNcUoVKWhE"
Keep-Alive: timeout=5
Vary: Accept-Encoding
{
"error": "User already exists"
}
This excerpt shows my schema.prisma file structure:
// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
shadowDatabaseUrl = env("SHADOW_DATABASE_URL")
}
model User {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
email String @unique
firstName String?
lastName String?
password String
playlists Playlist[]
}
model Song {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
name String
artist Artist @relation(fields: [artistId], references: [id])
artistId Int
playlists Playlist[]
duration Int
url String
}
model Artist {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
songs Song[]
name String @unique
}
model Playlist {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
name String
songs Song[]
user User @relation(fields: [userId], references: [id])
userId Int
}