movie.controller.java

package com.holnor.moviedatabase.controller;

import com.holnor.moviedatabase.dto.CreateMovieCommand;
import com.holnor.moviedatabase.dto.MovieDetailsItem;
import com.holnor.moviedatabase.dto.MovieListItem;
import com.holnor.moviedatabase.service.MovieService;
import jakarta.validation.Valid;
import org.springframework.dao.DataIntegrityViolationException;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@RestController
@RequestMapping("/api/movies")
public class MovieController {
    private MovieService movieService;

    public MovieController(MovieService movieService) {
        this.movieService = movieService;
    }

    ...
      
    @PostMapping
    public ResponseEntity createMovie(@RequestBody @Valid CreateMovieCommand createMovieCommand) {
        try {
            movieService.createMovie(createMovieCommand);
        } catch (DataIntegrityViolationException de) {
            return new ResponseEntity(de.getLocalizedMessage(), HttpStatus.BAD_REQUEST);
        }

        return new ResponseEntity(HttpStatus.CREATED);
    }
  
    ...
}

movie.model.java

package com.holnor.moviedatabase.domain;

import jakarta.persistence.*;

@Entity
@Table(name = "movie")
public class Movie {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "movie_id")
    private Long id;

    @Column(name = "title", unique = true)
    private String title;

    ...
}