Rest API & Expres handling various requets

[petrvecera]

Get all POSTs for users. The route can have optional parameter published.

So we need to handle 3 states:
http://localhost:3000/users/1/posts?published=true
http://localhost:3000/users/1/posts?published=false
http://localhost:3000/users/1/posts

app.get('/users/:id/posts', async (req, res) => {
  const published = req.query.published === 'true' ? true : false

  try{
    const posts = await prisma.post.findMany({
      where: {
        authorId: parseInt(req.params.id),
        ...(req.query.published && { published: published  }),        
      }
    })

    if(posts.length === 0){
      return res.status(404).json({error: "No posts found"})
    }

    return res.json(posts)
  }catch(e){
    console.error(e)
    return res.status(500).json({error: "Internal Server Error"})
  }
})

Ideal error handling:

app.get('/users/:id', async (req, res) => {

    // We could add here more validation of the incoming request params if we wanted
    // and return status code 400 (bas request) with some error. (For example parseInt is dangeours)

    try{
        const user = await prisma.user.findUnique({
            where: {
                id: parseInt(req.params.id)
            }
        })
    
        if (user) {
            // If everything is OK, we return status 200 (default) and user object
            return res.status(200).json(user)
        } else {
            // If we don't have user with that ID, we could theoretically return 
            // error 400 (bad request) or 404 (not found) based on the API design.
            return res.status(400).json({ error: "We don't have user with that ID" })
        }
    }
    catch (e) {
        // It's crutical to console.error every error, so we can debug it later
        // Also usually don't want to send to the user stack trace (security reasons)
        console.error(e)
        // If we catched any other problem, we return status 500 (internal server error)
       return res.status(500).json({ error: "We have a problem with our database" })
    }

})

Create user with POST request

app.post('/users/', async (req, res) => {

  try{
    const {name, email} = req.body

    if(!name || !email){
      return res.status(400).json({error: "Name and email are required"})
    }

    const user = await prisma.user.create({
      data: {
        name,
        email
      }
    })

    return res.status(201).json(user)
  }catch(e){
    console.error(e)
    return res.status(500).json({error: "Internal Server Error"})
  }

})