Video store technical assessment

Overview

This project is a simple Spring Boot application that uses an H2 in-memory database. It includes a data.sql file for initial data loading. The project currently contains a basic class and hierarchy, which serves as a starting point for further development.

Project Structure

• src/main/java: Contains the Java source files.
  • tv.alphanetworks.traning: The base package for the project.
    • VideoStoreApplication.java: The main application class.
    • controller: Package for REST controllers.
    • service: Package for service layer classes.
    • repository: Package for repository interfaces.
    • model: Package for entity classes.
    • configuration: Package for configuration class.
• src/main/resources: Contains the application properties and initial data script.
  • application.yaml: Configuration file for Spring Boot.
  • data.sql: SQL script to load initial data into the H2 database.

Getting Started

Prerequisites

• JDK 21
• Maven

Setup

1. Clone the repository

   git clone https://github.com/your-username/your-repo-name.git
   cd your-repo-name

2. Build the project

   Using Maven:

   mvn clean install

3. Run the application

   Using Maven:

   mvn spring-boot:run

Configuration

The application is configured to use an H2 in-memory database. You can find the configuration in the application.yaml file:

spring:
  application:
    name: "video_store"
  datasource:
    url: jdbc:h2:mem:video_store
    driver-class-name: org.h2.Driver
    username: h2
    password: password
  jpa:
    database-platform: org.hibernate.dialect.H2Dialect
    defer-datasource-initialization: true

custom:
  max_duration: 14
  vat : 21.0d

Assessment

Context:

Since the opening of my video store in the 90s, I have been managing rentals using a notebook and a pencil. Over time, it has become increasingly difficult to find DVDs/VHS tapes that are already rented out and those that are still in stock. I also do not have the ability to know the return date of my products without having to flip through the pages of previous days/weeks.

Objective:

I want a program (REST API) that allows me to manage the rental of my DVDs/VHS, where I could find the following information:

- Title
- Category (a category can belong to another category)
- Release Date
- Language
- Type (VHS, DVD)
- For VHS: format (VHS, S-VHS, S-VHS-C)
- For DVDs: number of discs per box

Bonus Features:

At least one of the following features would be interesting:

- A client who is more than a week late on their rental return should not be able to make a new rental.
- If the movie is available in multiple copies, I want to know the number of copies remaining for rental.
- During my movie search, I should be able to find the name of the movie in any language (e.g., "La mémoire dans la peau" -> "The Bourne Identity").